SQL Server DBA

Position Overview:

We are seeking a highly skilled Principal Database Administrator (DBA) to lead our database management efforts across hybrid cloud and on-premises environments. The ideal candidate will have extensive experience with Microsoft SQL Server, advanced database concepts, optimization, debugging, and troubleshooting expertise. This role also requires proficiency in PostgreSQL and MySQL as we transition our applications to a microservices architecture. Additionally, the Principal DBA will provide mentorship and guidance to existing staff members in the DBA group, fostering a culture of continuous learning and development.

Key Responsibilities:

• Database Management: Oversee the installation, configuration, and maintenance of Microsoft SQL Server Enterprise, PostgreSQL, and MySQL databases in cloud and on-premises environments. Manage and optimize database instances to ensure peak performance, including configuring extended events, optimizing indexes, and implementing data compression strategies.
• Optimization and Troubleshooting: Diagnose and resolve complex database issues related to performance, connectivity, and data integrity. Implement best database performance tuning, query optimization, and resource management practices. Utilize extended events and other monitoring tools to identify and resolve issues proactively.
• Manage hybrid cloud environments, ensuring seamless integration and performance between on-premises and cloud-based systems. Develop and implement database backup, recovery, and disaster recovery strategies across diverse environments.
• Collaborate with development teams to design and implement efficient database schemas and stored procedures. Use scripting languages like Python or infrastructure-as-code tools like Terraform to automate database management tasks and deployments.
• Support migrating applications to microservices by designing scalable and resilient database architectures. Ensure databases are optimized for use in containerized and distributed environments.
• Security and Compliance: Ensure databases adhere to security standards and compliance requirements. Implement security measures to protect sensitive data and maintain data privacy.
• Provide mentorship and guidance to existing DBA staff members, fostering their professional growth. Lead training sessions and workshops to enhance the DBA team's skills and knowledge. Encourage a culture of continuous learning and improvement within the team. Offer technical support and advice to DBAs, helping them resolve complex issues and advance their expertise.

Qualifications & Experience:

• Bachelor s degree in computer science, information technology, or a related field; a master s degree is preferred.
• Extensive experience as a Database Administrator with a strong focus on Microsoft SQL Server. Minimum of 5 years hands-on experience
• Proficiency in PostgreSQL and MySQL, with an understanding of their roles in a microservices architecture.
• In-depth knowledge of advanced database concepts, including partitioning, Always Availability Groups, In-Memory OLTP, and transactional replication. Familiarity with extended events, index optimization, compression techniques, and transactional isolation levels.
• Experience with scripting languages (Python) and infrastructure-as-code tools (Terraform) is highly desirable.
• Strong understanding of hybrid cloud environments and on-premises infrastructure management.
• Excellent problem-solving skills and the ability to work collaboratively in a fast-paced environment.
• Strong communication skills to effectively interact with technical and non-technical stakeholders.