Database Administrator (SQL & MongoDB)

Job Overview

We are looking for a highly skilled Database Administrator (DBA) to manage maintain and optimize our databases across multiple platforms. The ideal candidate will have extensive experience with AWS RDS Microsoft SQL Server and MongoDB along with a strong understanding of database security performance tuning and high-availability architectures.

This role is crucial in ensuring data integrity security and efficiency for our SaaS applications while meeting HIPAA and other healthcare compliance requirements.

Key Responsibilities

Database Management & Administration

• Design configure and maintain AWS RDS (PostgreSQL MySQL SQL Server) Microsoft SQL Server and MongoDB databases.
• Ensure high availability performance and scalability of all databases.
• Implement backup and disaster recovery strategies including point-in-time recovery (PITR) and failover mechanisms.
• Monitor and optimize database performance using tools like AWS CloudWatch SQL Profiler and MongoDB Atlas Performance Advisor.
• Manage database provisioning patching and version upgrades in production and non-production environments.

Security & Compliance

• Enforce data security best practices including encryption access controls (IAM RBAC) and compliance with HIPAA and other healthcare regulations.
• Perform regular security audits and vulnerability assessments using tools like AWS Security Hub and Tenable.
• Implement and maintain database auditing logging and monitoring to detect and prevent unauthorized access.

Optimization & Automation

• Analyze and optimize query performance indexing strategies and database schema design.
• Automate database maintenance tasks using Terraform AWS Lambda PowerShell or Python scripts.
• Work with DevOps to integrate CI/CD pipelines for database changes (e.g. Flyway Liquibase).
• Optimize storage and resource utilization in AWS to reduce costs while maintaining performance.

Collaboration & Support

• Work closely with DevOps Engineering and Security teams to ensure database reliability and security.
• Provide guidance and best practices to developers on database design indexing and query performance tuning.
• Support application teams with troubleshooting query optimization and data modeling.
• Participate in on-call rotation for database-related incidents and outages.

Required Qualifications & Experience

• 5 years of experience as a Database Administrator in a SaaS or cloud environment.
• Strong expertise in AWS RDS (PostgreSQL MySQL or SQL Server).
• Proficient in Microsoft SQL Server including T-SQL SSMS and high-availability configurations.
• Experience with NoSQL databases like MongoDB (Atlas preferred).
• Deep understanding of performance tuning query optimization indexing strategies and partitioning.
• Familiarity with Terraform AWS CloudFormation or other Infrastructure-as-Code (IaC) tools.
• Experience with backup and disaster recovery strategies in AWS and on-prem environments.
• Knowledge of database replication clustering and high-availability architectures.
• Proficiency in scripting (Python PowerShell Bash) for automation.
• Strong knowledge of security best practices (IAM RBAC data encryption audit logging).
• Familiarity with healthcare compliance requirements (HIPAA HITRUST) is a plus.

Preferred Skills & Certifications

• AWS Certified Database Specialty
• Microsoft Certified: Azure Database Administrator Associate
• MongoDB Certified DBA Associate
• Experience with AI/ML-driven database performance optimization tools
• Exposure to data warehousing and analytics (Redshift Snowflake or BigQuery)
  

Location - Chennai (Hybrid)
Experience - 5 to 10 Years