Senior Data Engineer, Azure Synapse
Illumina Technology Solutions
AzureCloudETLPythonSQL
Job Level
Senior
Tech Stack
AzureCloudElasticSearchETLMS SQL ServerPostgresSQL
About the role
- Administer, configure, and maintain SQL Server databases across production, staging, and development environments
- Perform query tuning, performance optimization, and execution plan analysis to ensure efficiency and scalability
- Design, implement, and manage SQL Server Always On Availability Groups for high availability and disaster recovery
- Automate database setup, configuration, and scheduled jobs to reduce manual effort and improve reliability
- Proactively identify and drive improvements in database performance, automation, and processes across the estate
- Monitor and maintain database health, including backups, indexing, statistics, and security controls
- Troubleshoot and resolve database issues, collaborating with developers, infrastructure, and DevOps teams
- Support the adoption and management of Cosmos DB and PostgreSQL environments
- Document database procedures, policies, and best practices, while championing continuous improvement
- Stay current with emerging database technologies and propose innovative solutions
Requirements
- Proven experience as a SQL Server DBA in production environments
- Deep expertise in SQL query tuning, performance analysis, and optimization
- Strong hands-on experience with SQL Server Always On (Availability Groups)
- Solid understanding of database security, backup, and disaster recovery strategies
- Experience with cloud-hosted and on-premises databases
- Skill in Cosmos DB and PostgreSQL (highly desired)
- Strong background in automation (e.g., PowerShell, T-SQL, or other scripting)
- Experience in automating database setup, deployments, and job scheduling
- A self-motivated problem-solver with strong analytical skills and the curiosity to challenge the status quo
- Excellent communication and collaboration skills
- Preferred: Familiarity with Microsoft Fabric and modern data lakehouse concepts
- Preferred: Hands-on experience with Elasticsearch for indexing and search workloads
- Preferred: Exposure to Azure Data Factory or other ETL/ELT orchestration tools
- Preferred: Knowledge of DevOps practices and CI/CD database deployment pipelines
- Preferred: Relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate)
