Description
We are seeking a highly skilled and experienced Senior Azure Database Administrator (Sr Azure DBA) to join our team. The ideal candidate will have 8-18 years of experience in Azure database administration and be able to handle complex database management tasks. The Sr Azure DBA will be responsible for the management, maintenance, and optimization of our Azure database infrastructure to ensure optimal performance, availability, and security.
Responsibilities
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.
