Title: SQL Server DBA III

Location: 60% Remote (2 days a week onsite) from within Wisconsin

Duration: 06+ Months

Visa: Citizens/Green Card

Mode of interview: Virtual

Note:- LinkedIn must be 1 year old with profile pic| recent Healthcare exp. required | Need Local with working history | Client location- 101 E. Wilson Street, 6th Floor, Madison, WI 53703

REQUIRED SKILLS: (Need Majority; 8+ Years)

• Advanced knowledge of Microsoft SQL Server (e.g., installation, configuration, support, and troubleshooting)
• SQL database administration (e.g., database security, SQL and/or PL/SQL tuning, report writing, scripting, and task automation)
• Effective and professional communication and interpersonal skills when dealing with a variety of customers, including executives
• Highly self-motivated with the ability to effectively prioritize and execute tasks with strong attention to detail

NICE TO HAVE SKILLS:

• Microsoft SQL Server certification or similar
• ITIL 4 Foundation certification or similar
• CompTIA A+ certification or similar
• PMP certification or similar

DESCRIPTION OF ROLE:

Under the general guidance of the IT Operations Manager, this position is responsible for growing and operating the Information Technology program at the Wisconsin Department of Financial Institutions (DFI). This position serves as an expert resource and relies on extensive experience and judgment to plan and accomplish goals.

This role coordinates physical changes to computer databases; codes, tests, and implements them, applying knowledge of database management systems. It involves designing logical and physical databases, reviewing database design changes to understand impacts on data storage (location, space, access method), and establishing database parameters.

The role includes:

• Coding database descriptions and identifiers,
• Calculating optimal values for parameters (e.g., memory usage),
• Specifying user access permissions (e.g., insert, replace, retrieve, delete),
• Testing and correcting errors,
• Creating production databases,
• Monitoring database performance (e.g., distribution of records, memory usage),
• Directing developers and analysts on changes to DBMS,
• Reviewing and correcting code,
• Answering user questions,
• Coordinating with co-workers on cross-system impacts and cost estimates,
• Performance tuning, and
• Possibly training users.