Job Description

### Key Responsibilities:


• Database Management:
• Install, configure, and maintain Azure SQL Database and other Azure-based database solutions.
• Ensure the availability, performance, and security of all Azure databases.
• Perform routine database maintenance, monitoring, and performance tuning.
• Implement and manage high-availability (HA) and disaster recovery (DR) solutions using Azure services like Azure Site Recovery and Always On availability groups.


• Database Security:
• Implement data encryption, authentication, and authorization solutions to protect sensitive data.
• Manage database security by creating, configuring, and managing roles, users, and permissions.


• Backup & Recovery:
• Design and implement backup and recovery strategies for Azure SQL Databases.
• Regularly test recovery procedures to ensure minimal downtime and data loss during critical failures.


• Performance Optimization:
• Conduct database tuning and performance optimization to enhance query performance.
• Monitor performance trends and proactively address bottlenecks.


• Database Automation:
• Implement automation for routine database operations using Azure automation tools such as PowerShell and Azure Logic Apps.
• Create and maintain database automation scripts for tasks such as backups, restores, and data refreshes.


• Database Upgrades & Patching:
• Apply database patches and upgrades in Azure environments to ensure compliance and performance.
• Plan and execute database migrations and updates with minimal disruption.


• Monitoring & Troubleshooting:
• Use Azure Monitor, Azure Log Analytics, and other tools to monitor the health of databases.
• Diagnose and resolve database-related issues, ensuring high availability.


• Collaboration:
• Work closely with development teams to design and support database solutions for application needs.
• Collaborate with security and network teams to ensure database integrity and compliance with best practices.


• Documentation:
• Maintain up-to-date documentation of all database configurations, processes, and procedures.
• Create detailed incident reports and root cause analyses for major database issues.
Job Requirement

### Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 3+ years of experience as a Database Administrator with Azure SQL Database.
• Proven experience in database backup, recovery, and security in an Azure environment.
• Expertise in Azure database services like Azure SQL Database, Azure Cosmos DB, or Managed Instance.
• Experience with high availability, disaster recovery (HA/DR) planning, and implementation in Azure.
• Proficiency in SQL query optimization and database tuning.
• Strong knowledge of Azure cloud infrastructure and services.

### Desired Skills:

• Strong proficiency in PowerShell scripting or Azure CLI for automation.
• Familiarity with Azure DevOps and CI/CD pipelines for database deployments.
• Knowledge of Azure Data Factory and data integration services.
• Experience with other database systems like MySQL, PostgreSQL in Azure.
• Understanding of data privacy regulations such as GDPR or HIPAA.

### Good to Have Skills:

• Azure certifications such as Azure Database Administrator Associate or Azure Solutions Architect.
• Experience with Azure Synapse Analytics or Data Lake Storage.
• Familiarity with machine learning or artificial intelligence integration into databases.
• Knowledge of infrastructure as code (IaC) tools like Terraform or ARM templates.
• Understanding of Kubernetes or container-based database deployments.