Provide comprehensive day-to-day support, monitoring, troubleshooting, and administration for multiple MS SQL databases, with a particular focus on high-availability configurations like Availability Groups.
Diagnose and resolve complex performance and availability issues, with in-depth root cause analysis to prevent future occurrences.
Oversee database maintenance processes, including performance tuning, index management, and job automation, ensuring optimal operation.
Develop and enforce policies for backup and recovery, ensuring database resilience and disaster recovery readiness.
Apply security patches, conduct version upgrades, and enforce strict compliance with database security best practices.
Handle support calls and resolve technical issues swiftly, including response to security incidents and operational challenges.
Leverage expertise in alternative database engines like MongoDB and CockroachDB to contribute to cross-functional database projects.
Manage and optimize cloud-based database environments, ensuring scalability, performance, and reliability in cloud infrastructure.
A minimum of 5+ years of hands-on experience in MS SQL Server Database Administration in production environments.
Extensive experience with MS SQL Server database features, including Jobs Scheduling, Monitoring, Patching, Backup/Recovery, Replication, Availability Groups, and Always On configurations.
Proven expertise in diagnosing and resolving performance bottlenecks and availability issues.
Solid understanding of alternative database engines like PostgreSQL, MongoDB and CockroachDB, with practical experience in their administration and troubleshooting.
Proficiency in cloud database administration, with experience in cloud platforms like AWS, Azure, or Google Cloud.
Fluency in English, both written and verbal, with excellent communication skills.
Strong teamwork, analytical thinking, and problem-solving abilities, alongside a proactive approach to continuous learning.
A commitment to mentoring and supporting junior team members.
#J-18808-Ljbffr