SQL Server DBA - Hybrid

MSYS - Lansing, MI

Full-time - Senior

Lansing, MI

Professional, Scientific, and Technical Services

About the position

The SQL Server DBA position is a long-term role focused on providing Infrastructure DBA support for SQL Server applications. This position is a replacement for a Senior Level DBA and is critical for maintaining support for large and complex applications, including Tier 1 level applications in the Bureau of Labs and Cancer Registry. The role involves 24x7 support, high availability, disaster recovery, and adherence to industry standards and development practices.

Responsibilities

• Provide Infrastructure DBA support for all SQL Server applications.
• Participate in 24x7 software and hardware support for complex applications.
• Develop and submit plans for installation, patch management, maintenance, upgrades, and support for database systems.
• Evaluate impacts of change and new technology, recommending solutions to persistent problems.
• Serve as Agency Services liaison to external consultants.
• Follow and enforce database standards, policies, and procedures.
• Monitor space allocation across databases and perform necessary adjustments.
• Calculate disk space requirements for existing and new installations.
• Modify DBMS parameters based on capacity changes.
• Configure and execute database integrity checks.
• Monitor for database integrity checks and troubleshoot backup errors.
• Install database management software and patches for development and test environments.
• Monitor and support clustered database environments and database replication.
• Implement strategies to release unused space or repair fragmentation in test and development environments.
• Execute scripts for creating and modifying database objects.
• Monitor database backups to ensure recoverability and troubleshoot issues.

Requirements

• 7+ years of Database administration experience specifically on SQL Server 16 and upwards.
• Expertise in High Availability (HA) and Disaster Recovery (DR) solutions.
• Experience with Transparent Data Encryption within SQL Server.
• Over 3+ years of experience creating, updating, and maintaining systems documentation.