Database Administrator

Job Title     : Database Administrator  
Experience : 7-14 Years
Location     : Chennai      

Job Description : 

  • 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)
  • Other Duties
  • Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job.
  • Duties, responsibilities, and activities may change at any time with or without advance notice. Any changes may be for an indeterminate time frame.
  • EEO Statement

 

Posted Date
2025-05-14 11:36:51
Experience
7 -14 years
Primary Skills
AWS RDS (PostgreSQL, MySQL, or SQL Server), SAAS, T-SQL (Mandatory), NoSQL, Python, PowerShell, Bash, AWS Certified (mandatory), Devops background
Required Documents
Resume
Contact
ashwiny@lorventech.com,recruit@lorventech.com
Bootstrap Example