Tech Stack
AzureCloudETLMS SQL ServerNoSQLPostgresPythonRDBMSSQLTerraform
About the role
- 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 infrastructure-as-code (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 enterprise-scale systems.
- Database Expertise: Advanced knowledge of Microsoft SQL Server and Azure SQL. Familiarity with PostgreSQL or other relational databases is a plus. Moreover, 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, execution 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.