Compunnel

Sql DBA

  • Washington, DC
  • Posted yesterday
  • Staffing / consulting
Apply on Compunnel's site ↗Checked today on the employer's career site. We never take applications.

Job Summary:
The SQL DBA will be responsible for performing physical infrastructure administration activities for on-premises SQL Server, MySQL, and Azure and AWS cloud databases. The role involves installing, configuring, patching, and maintaining on-premises and cloud database resources. Responsibilities include managing Microsoft clustering, high availability (HA), disaster recovery (DR), mirroring, and resiliency technologies. The DBA will also manage database performance, assist development teams and logical DBAs in identifying and resolving performance issues, provide backup and restore functionality, implement database failover technologies, and ensure compliance with database security standards.

Key Responsibilities:
• Install, configure, and maintain MS SQL Server on Windows servers.
• Manage and maintain MS SQL Server using available clustering technologies to support high availability and disaster recovery readiness.
• Provide continuous monitoring, troubleshooting, and historical and real-time performance monitoring of MS SQL Server environments.
• Provide backup and restore functions for MS SQL Server databases.
• Execute upgrade activities with minimal downtime while ensuring optimal performance of upgraded systems.
• Manage and support cloud-native databases, including Azure SQL, SQL MI, AWS SQL, and MySQL databases.
• Integrate cloud services with on-premises systems and other cloud services.
• Assist developers and logical DBAs in detecting performance problems, including analysis of SQL, client tools, and drivers.
• Tune database parameters for optimal system performance.
• Ensure proper configuration of system parameters for optimal database operations in collaboration with system administrators.
• Follow ITIL processes for incident management, change management, and problem management.
• Develop and maintain Azure DevOps CI/CD pipelines for database infrastructure deployment and follow-up.
• Collaborate with cross-functional teams to ensure efficient service delivery.
• Follow and implement security controls and processes in accordance with on-premises and cloud database security standards.

Required Qualifications:
• Bachelor's degree in Computer Science or Information Technology.
• 5+ years of relevant experience as a DBA in SQL Server cluster infrastructure and cloud databases.
• Level III: 7+ years of experience.
• Extensive experience in SQL Server infrastructure operations and administration, including cluster management.
• Strong production experience with Microsoft clustering, HA, DR, mirroring, and other resiliency technologies.
• Strong production experience in backup, recovery, and data refresh management activities.
• Proven operational support capabilities and expertise in SQL Server upgrade activities.
• Extensive experience with Azure SQL, SQL MI, MySQL, and AWS SQL provisioning and administration.
• Relevant experience with data migration into cloud databases.
• Relevant experience with backup and recovery services in Azure and AWS.
• Familiarity with cloud services integration.
• Familiarity with Infrastructure as Code (IaC) development using Terraform or ARM templates.
• Experience with AWS and Azure cloud-native databases and services.
• Experience with Azure DevOps and shell scripting for process automation.
• Relevant experience using ITIL processes.
• Relevant experience with Sarbanes-Oxley (SOX)/ICFR compliance for critical financial systems.
• Excellent problem-solving skills and the ability to work in a fast-paced, dynamic environment.

Preferred Qualifications:
• Experience developing Terraform Cloud (TFC) modules for cloud resource provisioning and implementation.
• MS SQL Server, Azure, or AWS DBA certification.
• Experience with Kubernetes, Docker, and containers for database deployments.
• Experience with Agile methodologies and Site Reliability Engineering (SRE) practices.
• Good technical documentation skills.

Similar open jobs