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

(ref : hirist.tech)