Sr SQL DBA

Onsite in Charlotte. No C2C Candidates will be accepted for this role. W2 Only

Job Title:

Microsoft SQL Server Database Administrator – with Azure

Position Type:
Full-time

We are seeking a highly skilled and motivated Microsoft SQL Server Database Administrator to join our talented IT team. If you possess strong expertise in managing large-scale databases, and are passionate about ensuring optimal performance and reliability, we want to hear from you.

• 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.
  • 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.
  • 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.

• 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.