Summary:
We are seeking a skilled and motivated SQL Database Administrator to join our 24x7 operations team. In this role, you will be responsible for the health, performance, and availability of our critical SQL Server databases, with a strong emphasis on Always On Availability Groups (AG) and High Availability/Disaster Recovery (HADR) solutions. You will be part of a team ensuring our databases are running optimally and that we can quickly recover from any unforeseen issues.
Responsibilities:
Administer and maintain SQL Server databases on Azure, ensuring optimal performance, security, and availability.
Implement, configure, and manage AlwaysOn Availability Groups (AG) for high availability and disaster recovery.
Troubleshoot and resolve database performance issues, outages, and other incidents in a timely manner.
Participate in a 24x7 on-call rotation, responding to alerts and incidents as needed.
Collaborate with development, infrastructure, and other teams to ensure database solutions meet business requirements.
Develop and maintain documentation for database configurations, procedures, and troubleshooting steps.
Implement and maintain database security measures, including user access controls and data encryption.
Perform database backups and restores.
Monitor database performance and proactively identify potential issues.
Apply database patches and upgrades.
Participate in capacity planning and performance tuning activities.
Qualifications:
3+ years of experience as a SQL Server Database Administrator.
AZ-900 certification would be added advantage
Hands-on experience with Always On Availability Groups (AG) or other High Availability/Disaster Recovery (HADR) solutions.
Strong hands-on experience with SQL Server database administration, including installation, configuration, maintenance, and troubleshooting.
Excellent communication and interpersonal skills, with the ability to effectively communicate technical information to both technical and non-technical audiences.
Ability to work effectively in a fast-paced, 24x7 environment.
Strong problem-solving and analytical skills.
Experience with database monitoring tools (SentryOne/LogicMonitor/AppDynamics).
Experience with SQL Server performance tuning.
Experience with database security best practices.