Senior SQL Server DBA – Cloud (Azure & AWS)
Summary
We are looking for a highly skilled Senior SQL Server DBA with strong experience in Azure and AWS. This role involves managing, optimizing, and securing SQL Server workloads in cloud and hybrid environments, ensuring high availability, performance, and cost efficiency. The candidate should also bring development-oriented skills to support automation, Dev Ops, and modern data engineering practices.
Key Responsibilities
- Administer Azure SQL Database, Azure Managed Instance, AWS RDS, and EC2-hosted SQL Server.
- Design, build, and maintain ADF pipelines and SSIS packages for ETL / ELT workloads.
- Implement HA / DR solutions (Always on Availability Groups, geo-replication, backups, log shipping, clustering).
- Perform query tuning, indexing, partitioning, and statistics management for optimal performance.
- Automate routine DBA tasks, deployments, patching, and monitoring using T-SQL, Power Shell, Python, or cloud-native automation tools (Azure CLI, AWS CLI, SDKs).
- Develop CI / CD database deployment scripts using Git Hub Actions, Azure Dev Ops, or Jenkins.
- Apply security best practices, encryption, RBAC, and ensure compliance with data governance standards.
- Troubleshoot production issues, analyze wait types, blocking, and participate in on-call rotations.
- Collaborate with developers to improve data access patterns, stored procedures, and ORM efficiency.
- Integrate SQL Server with Dev Ops pipelines for automated testing and deployments.
- Plan and execute migrations from on-prem to cloud (lift-and-shift, re-platforming, refactoring).
- Build monitoring dashboards using Azure Monitor, AWS Cloud Watch, Datadog, or Grafana.
- Provide guidance on data architecture, schema design, and cloud-native best practices.
Requirements
6+ years SQL Server DBA experience, with 3+ years in Azure & AWS.Strong experience with T-SQL development (stored procedures, triggers, functions).Must have experience on support and performance activities.Proven expertise in ADF / SSIS, query optimization, and cloud cost optimization.Knowledge of Always On, clustering, replication, and cloud-native HA solutions.Skilled in Power Shell, Python, T-SQL, and automation frameworks.Experience with Git, CI / CD, Infrastructure as Code (Terraform, Cloud Formation).Nice to Have (Added Advantage) :
Postgre SQL / Mongo DB : schema design, replication, backup / restore, security, monitoring, performance tuning.Familiarity with AWS Aurora, DMS (Database Migration Service), and Azure DMS.Exposure to Python for developing utilities, database wrappers, or automation scripts.Soft Skills
Strong troubleshooting & analytical skills.Excellent communication and documentation abilities.Ability to work cross-functionally with developers, architects, and cloud engineers.Proactive mindset for performance, reliability, and cost efficiency improvements.