SQL Server DBA

Note: All candidates must be able to work as a W2 employee for any employer in the US. (The role is not eligible for Corp to Corps or those requiring sponsorships now or potentially in the future. Relocation assistance is not offered for this role.)

Title: Microsoft SQL Server Database Administrator

Location: Southend Charlotte

Type: Direct-hire/Full-time (Hybrid – Candidates are able to work from home 3 days/month)

Industry: Software Development

Target base salary: $100K - $145K (Based on relevant experience)

Our client’s seeking a highly skilled and motivated Microsoft SQL Server Database Administrator to join their talented IT team.

Responsibilities:

1. Database Administration:

• Manage, monitor, and maintain Microsoft SQL Server databases, ensuring high availability and performance.

• Implement and manage Always-On AG to provide fault tolerance and high availability.

• Handle TB-sized databases, optimizing performance and resource utilization.

2. Sharding or Partitioning Experience:

• Design and implement database sharding strategies for efficient horizontal scaling.

• Monitor and manage sharded databases to ensure even distribution of data and optimal query performance.

3. Azure SQL Server:

• Experience in handling VM’s in Azure, Manage SQL Instances, and SQL Databases in Azure.

• Utilize Azure services for scalability, security, and performance enhancements.

4. Backup and Recovery:

• Develop and maintain robust backup and recovery strategies for large databases.

• Perform regular database backups and conduct periodic recovery tests to ensure data integrity.

5. Performance Tuning:

• Analyze and optimize query performance, indexing, and database configuration.

• Proactively identify and resolve performance bottlenecks to ensure optimal database responsiveness.

• Query Store experience required.

6. Security:

• Implement and enforce database security measures to protect sensitive data.

• Stay current with industry best practices and security trends to ensure databases are protected against potential threats.

7. Collaboration:

• Collaborate with cross-functional teams, including developers and system administrators, to address database-related issues and ensure smooth operations.

• Participate in the planning and execution of database-related projects.

Qualifications:

1. Bachelor's degree in Computer Science, Information Technology, or related field.

2. Proven experience as a Microsoft SQL Server Database Administrator.

3. In-depth knowledge of Always-On Availability Groups.

4. Experience managing TB-sized databases in a production environment.

5. Strong SQL scripting skills and expertise in performance tuning.

6. Familiarity with database security best practices.

7. Azure certifications and experience deploying SQL Server databases on Azure are a plus.

8. Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus.