Description
You will design, implement, and manage enterprise-grade database solutions hosted in Azure.
Responsibilities
- Design and maintain Azure SQL databases, including advanced schemas, stored procedures, and indexing strategies.
- Analyze and resolve performance bottlenecks by optimizing query execution plans and storage operations.
- Deploy and manage database solutions using Azure SQL, Azure Managed Instances, and other Azure database services.
- Execute routine maintenance, including backups, restores, and disaster recovery planning to ensure high availability.
- Implement security policies, encryption, and access controls to ensure compliance with organizational standards.
Required Skills
- 7+ years of experience in database engineering with a focus on Azure SQL and cloud environments.
- Strong proficiency in T-SQL and database design principles.
- Hands-on experience with Azure SQL Database, Azure Data Factory, and Azure Managed Instances.
- Expertise in database performance tuning and troubleshooting.
- Experience with CI/CD pipelines and Infrastructure as Code (IaC) for database deployments.
- Knowledge of backup and recovery strategies, high availability, and disaster recovery.
- Proficiency with T-SQL, Database Design, Azure DevOps, Github, and Ci/cd Pipelines.
- Bachelor's degree in Computer Science.
Preferred Skills
- Experience with Apache Spark or Azure Synapse Analytics.
- Knowledge of NoSQL databases or data lakes.