- Design deploy and maintain secure and scalable database environments primarily in Microsoft SQL Server and Azure SQL.
- Monitor and optimize database performance query efficiency and storage management.
- Manage backup restore high availability (HA) and disaster recovery (DR) strategies.
- Design and build scalable ETL/ELT pipelines using tools such as Azure Data Factory Microsoft Fabric Dataflows or Databricks.
- Work with stakeholders to understand data needs and deliver robust data integration solutions.
- Manage Azure data solutions including Azure SQL Synapse Analytics Cosmos DB Microsoft Fabric and Blob Storage.
- Develop infrastructureascode (IaaC) scripts using Terraform to provision and manage data services.
- Implement automation for monitoring patching and deployment of data infrastructure across cloud environments.
- Enforce data security encryption and access control policies across all data layers.
- Mentor junior DBAs and data engineers sharing knowledge and driving best practices in data architecture and engineering.
Requirements
- Experience: 6 years in a DBA or data engineering role with enterprisescale systems.
- Database Expertise: Advanced knowledge of Microsoft SQL Server and Azure SQL. Familiarity with PostgreSQL or other relational databases is a handson experience with Cosmos DB for globally distributed NoSQL scenarios would be an advantage.
- Data Integration: Strong experience in ETL/ELT design implementation and optimization across both batch and streaming data.
- Cloud & IaC: Handson experience with Azure data services including Azure SQL Cosmos DB Azure Synapse Analytics and Microsoft Fabric.
- Proficiency in infrastructureascode using Terraform.
- Performance Tuning: Deep understanding of query optimization indexing strategies plans and performance tuning in both traditional RDBMS and distributed databases like Cosmos DB.
- Scripting & Automation: Proficiency in TSQL PowerShell and Python for automating database operations data pipelines and monitoring solutions.
- Collaboration: Excellent communication and interpersonal skills with the ability to convey complex data concepts to both technical and nontechnical stakeholders.
- Certifications: Relevant certifications are highly desirable.
Experience: 6+ years in a DBA or data engineering role with enterprise-scale systems. Database Expertise: Advanced knowledge of Microsoft SQL Server and Azure SQL. Familiarity with PostgreSQL or other relational databases is a , hands-on experience with Cosmos DB for globally distributed NoSQL scenarios would be an advantage. Data Integration: Strong experience in ETL/ELT design, implementation, and optimization across both batch and streaming data. Cloud & IaC: Hands-on experience with Azure data services including Azure SQL, Cosmos DB, Azure Synapse Analytics, and Microsoft Fabric. Proficiency in infrastructure-as-code using Terraform. Performance Tuning: Deep understanding of query optimization, indexing strategies, plans, and performance tuning in both traditional RDBMS and distributed databases like Cosmos DB. Scripting & Automation: Proficiency in T-SQL, PowerShell, and Python for automating database operations, data pipelines, and monitoring solutions. Collaboration: Excellent communication and interpersonal skills, with the ability to convey complex data concepts to both technical and non-technical stakeholders. Certifications: Relevant certifications are highly desirable.