SQL DBA

No C2C Must live in Charlotte NC In office 5 days a week. Microsoft SQL Server Database Administrator Position Type: Full-time About Us: 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. Responsibilities: 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. 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. 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. 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. 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. 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. 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: Bachelor's degree in Computer Science, Information Technology, or related field. Proven experience as a Microsoft SQL Server Database Administrator. In-depth knowledge of Always-On Availability Groups. Experience managing TB-sized databases in a production environment. Strong SQL scripting skills and expertise in performance tuning. Familiarity with database security best practices. Azure certifications and experience deploying SQL Server databases on Azure are a plus. Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are a plus. #J-18808-Ljbffr 6AM City, LLC