Senior Database Consultant (PostgreSQL)

This position is listed on behalf of a partner company, who manages all applications and next steps. Our partner is looking for a Senior Database Consultant (PostgreSQL) based in India.

This role is centered on providing deep technical expertise in PostgreSQL database environments for a diverse set of enterprise clients. You will act as both a consultant and hands-on engineer, ensuring database systems are highly available, secure, and performant across complex infrastructures. The position involves working closely with client teams to design, optimize, and maintain mission-critical database solutions across cloud and hybrid environments. You will play a key role in ensuring operational excellence through proactive monitoring, incident resolution, and continuous improvement initiatives. The environment is highly collaborative and client-facing, requiring strong communication skills and the ability to translate technical challenges into practical solutions. This is an opportunity to work on large-scale database systems while influencing architecture, reliability, and long-term data strategy.

• Design, implement, configure, and maintain PostgreSQL database solutions across on-premises, cloud, and hybrid environments, ensuring high availability and performance.
• Lead database architecture efforts including data modeling, schema design, migration planning, and performance optimization.
• Manage backup, recovery, replication, clustering, and disaster recovery strategies to ensure data integrity and system resilience.
• Monitor database health, troubleshoot incidents, and proactively resolve performance or reliability issues using observability tools.
• Develop and maintain automation scripts and infrastructure-as-code solutions using tools such as Bash, Python, Ansible, or Terraform.
• Support database migrations from legacy systems (Oracle, MySQL, MSSQL) to PostgreSQL with minimal downtime and strong validation processes.
• Collaborate with clients to define requirements, provide recommendations, and ensure alignment with best practices and operational standards.
• Participate in on-call rotations and ensure timely resolution of production issues affecting critical systems.
• Contribute to process improvements, tooling enhancements, and documentation for better service delivery and operational efficiency.

Requirements

• 5+ years of experience in database administration or consulting, with strong hands-on expertise in PostgreSQL.
• Proven experience managing PostgreSQL in cloud environments such as AWS, GCP, or Azure.
• Strong knowledge of high availability and replication solutions (e.g., Patroni, repmgr) and disaster recovery strategies.
• Experience with backup and recovery tools such as pgBackRest, Barman, and pg_basebackup, including PITR and WAL archiving.
• Strong scripting skills in Bash and/or Python, with exposure to automation and infrastructure tools like Ansible, Terraform, Puppet, or Chef.
• Experience with database monitoring and observability tools such as Prometheus, Grafana, Datadog, or similar platforms.
• Hands-on experience with database migration projects across major engines and cloud platforms.
• Strong debugging and troubleshooting skills with the ability to resolve complex production issues.
• Excellent documentation, communication, and client-facing consulting skills.
• Bachelor’s degree in Computer Science, IT, or a related field; relevant certifications are a plus.

Benefits

• Fully remote work with flexibility to operate from anywhere in India.
• Competitive compensation package aligned with experience and expertise.
• Comprehensive health, medical, and wellness support programs.
• Annual training budget and access to professional certifications and learning resources.
• Home office setup support, including equipment and workspace allowance.
• Paid vacation, sick leave, and additional wellness days.
• Opportunities to work on large-scale, global enterprise database environments.
• Strong culture of technical excellence, collaboration, and continuous learning.