Database Administrator (DBA) - PostgreSQL and SQL Server

Ample Success HR; Mumbai; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Ample Success HR seeks an experienced Database Administrator (DBA) with strong PostgreSQL and SQL Server expertise to manage and optimize our database environments in Mumbai. You will ensure performance, security, and availability while supporting development teams across multiple platforms.

Responsibilities include installing, tuning, backups, DR planning, and implementing high-availability solutions. You will mentor junior DBAs and automate routine tasks using scripting and monitoring tools.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 6–7 years of hands-on DBA experience with PostgreSQL and SQL Server.
• Strong expertise in PostgreSQL architecture, installation, and administration.
• Experience with performance tuning, backup/recovery, and security management.
• Knowledge of replication, clustering, and high availability solutions.
• Familiarity with Linux/Unix environments.
• Excellent analytical and troubleshooting skills.
• Strong communication and documentation abilities.

Responsibilities

• Install, configure, and upgrade PostgreSQL and SQL Server databases across environments.
• Monitor performance and optimize queries, indexing, and resource usage.
• Perform regular backups and disaster recovery planning for PostgreSQL and SQL Server.
• Design high availability solutions (Replication, Patroni, etc.).
• Ensure security and proper user access management.
• Troubleshoot performance, connectivity, or data integrity issues.
• Automate DBA tasks with scripting (Shell, Python, Ansible).
• Provide root-cause analysis and share best practices with teams.

Skills

PostgreSQL

SQL Server

Performance tuning

Backups & recovery

Security management

Replication & HA

Linux/Unix

Scripting

Documentation

Education

Bachelor's degree in CS/IT

Tools

pgAdmin

Prometheus

Grafana

SQL Server Profiler

Job description

We are seeking an experienced Database Administrator (DBA) with strong expertise in both PostgreSQL and SQL Server to manage, maintain, and optimize our database environments. The ideal candidate will ensure database performance, security, and availability, while supporting business applications and development teams across multiple platforms.

Interested in this role?

Roles & Responsibilities

• Install, configure, and upgrade PostgreSQL and SQL Server databases across development, testing, and production environments
• Monitor database performance and implement tuning solutions to optimize queries, indexing strategies, and resource utilization.
• Perform regular backups and recovery using native PostgreSQL tools (pg_dump, PITR) and SQL Server tools (SSMS, Maintenance Plans)
• Design and implement disaster recovery solutions and high availability setups (Replication, Streaming Replication, Patroni, etc.)
• Ensure database security, user access management, and compliance with organizational standards
• Troubleshoot and resolve database issues related to performance, connectivity, or data integrity
• Automate routine DBA tasks using scripting (Shell, Python, Ansible)
• Implement monitoring solutions using tools like pgAdmin, Prometheus, Grafana, SQL Server Profiler, and third-party monitoring tools
• Provide root cause analysis for incidents and implement preventive measures
• Mentor junior DBAs and share best practices with cross-functional teams

Required Skills & Qualifications

• Bachelor’s degree in computer science, Information Technology, or related field
• 6–7 years of hands-on experience as a DBA with PostgreSQL and SQL Server
• Strong expertise in PostgreSQL architecture, installation, and administration
• Experience with performance tuning, backup/recovery, and security management
• Knowledge of replication, clustering, and high availability solutions
• Familiarity with Linux/Unix environments
• Strong analytical and troubleshooting skills
• Excellent communication and documentation abilities