Azure Database Administrator (8-10 yrs)

Job Summary :

The Azure Database Administrator will administer and support various Azure database services, including Azure SQL Database, Azure Database for PostgreSQL, Azure Database for MySQL, and other relevant offerings.

This involves provisioning, configuring, monitoring, optimizing, and securing these services.

A strong understanding of Azure cloud concepts, database administration best practices, and automation is essential.

Responsibilities :

Provisioning and Deployment :

- Deploy and configure Azure database services, including selecting appropriate service tiers, storage options, and networking configurations.

- Automate deployments using Infrastructure-as-Code (IaC) tools like ARM templates or Terraform.

Database Administration :

- Manage and maintain Azure database instances, including creating and managing databases, users, permissions, and other database objects.

Performance Monitoring and Tuning :

- Proactively monitor database performance, identify bottlenecks, and implement optimizations to ensure optimal performance and scalability.

- This includes query tuning, index optimization, and resource allocation.

Backup and Recovery :

- Implement and manage backup and recovery strategies for Azure databases, ensuring business continuity and data availability.

- Utilize Azure's built-in backup and restore capabilities.

Security Management :

- Implement and enforce security policies and procedures for Azure databases, including user access control, network security, and data encryption.

- Ensure compliance with security best practices and regulations.

- High Availability and Disaster Recovery: Design and implement high availability and disaster recovery solutions for Azure databases, leveraging Azure's features like geo-replication and failover groups.

Troubleshooting :

- Diagnose and resolve database-related issues, including performance problems, connectivity issues, and data corruption.

- Provide timely support to application developers and end-users.

Automation :

- Automate routine database administration tasks using scripting languages (e.g , PowerShell, Azure CLI) and Azure automation tools.

Cost Optimization :

- Monitor Azure database costs and implement strategies to optimize spending, such as right-sizing resources and utilizing reserved capacity.

Documentation :

- Maintain accurate and up-to-date documentation of Azure database configurations, procedures, and security settings.

Collaboration :

- Work closely with application developers, system administrators, and other IT staff to ensure seamless integration of database systems with other Azure services.

- Staying Current: Keep up-to-date with the latest Azure database features, updates, and best practices.

Qualifications :

- Bachelor's degree in Computer Science or a related field preferred.

- Proven experience as a Database Administrator, with a focus on cloud-based database services (minimum [Number] years).

- Strong understanding of Azure cloud concepts and services, particularly Azure database offerings (Azure SQL Database, Azure Database for PostgreSQL, Azure Database for MySQL).

- Expertise in T-SQL, PL/pgSQL, or MySQL depending on the specific database services used.

- Experience with database performance tuning and troubleshooting in a cloud environment.

- Solid understanding of backup and recovery strategies for Azure databases.

- Knowledge of Azure security best practices and tools.

- Experience with Infrastructure-as-Code (IaC) tools (ARM templates, Terraform) is highly desirable.

- Familiarity with scripting languages (e.g , PowerShell, Azure CLI).

- Excellent communication and collaboration skills.

- Ability to work independently and as part of a team.

- Strong problem-solving and analytical skills.

- Azure certifications Azure Database Administrator Associate) are a plus