Senior Azure Database Administrator (8-10 yrs)

Notice Period : 0-30 Days

- Elastic Pool management

- Vcore upgrade and degrade based on request

- Querying database based on support requests

- Audit log management

- User management

- Storage account management

- Stagging DB refresh during deployment

- Table Migration

- Patching activity

- Data management and migration

- DB Archival and restore

Key Responsibilities :

Elastic Pool Management :

- Create, manage, and optimize Azure SQL Elastic Pools to ensure the efficient allocation of resources.

- Monitor the performance of databases within the pools and scale resources based on workload requirements.

Vcore Upgrade/Degrade :

- Perform vCore upgrades and downgrades for Azure SQL databases based on application performance and cost optimization requests.

- Ensure seamless transitions and minimal downtime during scaling activities.

Database Querying & Support :

- Troubleshoot and resolve database-related issues raised by support teams or end- users.

- Analyze query performance and optimize SQL queries for high performance.

Audit Log Management :

- Monitor and maintain Azure database audit logs to ensure compliance and security.

- Implement and track policies to safeguard sensitive data and activities within the environment.

User & Access Management :

- Manage user roles, permissions, and access control for Azure SQL databases.

- Maintain secure database environments by configuring firewalls, encryption, and role-based access controls.

Storage Account Management :

- Oversee storage account configurations for databases and manage backups, file shares, and data transfers.

- Ensure data storage solutions meet performance, availability, and disaster recovery requirements.

Staging Database Refresh :

- Manage staging database refresh activities during deployment cycles to ensure up-to-date test data for applications.

- Collaborate with developers and QA teams to facilitate smooth staging refreshes and troubleshoot any issues.

Table Migration & Data Movement :

- Execute and oversee large-scale data migrations between tables, databases, and environments (e.g., on-premise to Azure or cross-cloud).

- Design and implement strategies for efficient and reliable data movement.

Patching & Version Updates :

- Perform regular patching and database updates to maintain the latest security fixes and performance improvements.

- Ensure minimal disruption during patching processes and maintain compatibility with other systems.

DB Archival & Restore :

- Implement and manage database archival processes to maintain long-term data retention.

- Perform database restores and data recovery in compliance with company policies and SLAs.

Skills & Qualifications :

Mandatory Skills :

- 8+ years of experience as an Azure DBA or in a similar database administration role, with a focus on Azure SQL Database, Elastic Pools, and cloud-based database management.

- Strong knowledge of database architecture, design, performance tuning, and troubleshooting.

- Expertise in managing Azure SQL instances, including database migration, backup, restore, and high availability configurations.

- Proficiency in SQL Server management, querying, and optimization in a cloud environment.

- Solid understanding of security practices, including access control, encryption, and audit logging.

- Experience with scripting tools (PowerShell, Azure CLI) to automate and streamline DBA tasks.

Desirable Skills :

- Certification in Azure Database Administration (e.g., Microsoft Certified: Azure Database Administrator Associate).

- Knowledge of other Azure services (e.g., Azure Data Factory, Azure Logic Apps) is a plus.

- Familiarity with DevOps practices, CI/CD pipelines, and database automation.

- Experience with database performance tuning, clustering, replication, and disaster recovery solutions in Azure.