LearningMate - Lead Database Administrator - SQL Server

About the Role :

We are seeking an experienced Lead Database Administrator with a strong background in Microsoft SQL Server development and administration. The ideal candidate will have deep expertise in database management, performance tuning, and cloud hosting, specifically within AWS environments. Experience with MongoDB and PostgresDB will be an added advantage.

Key Responsibilities :

• Administer and manage Microsoft SQL Server databases, including installation, configuration, backup, recovery, and proactive monitoring to ensure optimal performance and availability.
• Write, optimize, and maintain complex SQL queries, stored procedures, and T-SQL scripts for efficient data retrieval and processing.
• Design and optimize database schemas and indexes to ensure scalability, high performance, and data integrity.
• Manage SQL Server instances hosted on AWS services, such as EC2, RDS, Amazon FSx for Windows File Server, and VPC configurations.
• Implement and maintain high availability (HA) and disaster recovery (DR) strategies including replication, clustering, and automated failover in cloud environments.
• Monitor database health and performance, diagnose issues, and apply necessary patches or upgrades to maintain security and reliability.
• Support and manage MongoDB and PostgresDB deployments, including tuning, troubleshooting, and operational support.
• Collaborate with development, operations, and security teams to ensure database solutions meet organizational and compliance requirements.
• Document database configurations, procedures, and best practices to support knowledge sharing and team collaboration.

Required Qualifications & Skills :

(ref : hirist.tech)