Job Description
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
