Senior Azure Database Administrator(Sr Azure DBA)

Job Title: Senior Azure Database Administrator (Sr Azure DBA)

Experience: 8+ years

Location: Pan India

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.