Database Administrator - Amazon RDS

Responsibilities :

- 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.

- 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.

- 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.

- 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.

Requirements :

- 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.

- B. Tech M. Tech (Dual), B. E., B. Tech.