PostgreSQL Database Administrator (DBA)

Synechron; St. Louis (MO); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Highly competitive compensation

10 days of paid annual leave

Comprehensive insurance plan

Retirement savings plans

Extensive training opportunities

Job summary

A global consulting firm is seeking an experienced PostgreSQL Database Administrator (DBA) in St. Louis. The role involves managing mission-critical PostgreSQL databases, ensuring high availability, performance, and security. Candidates should have extensive experience in database administration, performance tuning, and optimizing database environments. Successful applicants will enjoy a competitive compensation package, extensive training opportunities, and the chance to work with top-tier financial institutions.

Qualifications

• 5+ years of hands-on experience as a PostgreSQL DBA in large-scale enterprise environments.
• Strong knowledge of PostgreSQL architecture, including WAL, replication, and partitioning.
• Experience with performance tuning, query optimization, and index management.
• Working knowledge of database monitoring and alerting tools (e.g., Prometheus, Grafana, Datadog).

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL database servers.
• Monitor database performance, identify bottlenecks, and implement tuning strategies.
• Design and manage database backup and recovery strategies.
• Implement replication, clustering, and failover mechanisms for high availability.

Skills

PostgreSQL architecture

performance tuning

query optimization

index management

PL/pgSQL

Linux/Unix environments

problem-solving

Tools

pgAdmin

pgBackRest

Patroni

pgBouncer

pgPool-II

AWS RDS/Aurora PostgreSQL

Azure Database for PostgreSQL

GCP Cloud SQL

Job description

Overview

At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 58 offices in 21 countries within key global markets.

We are seeking an experienced PostgreSQL Database Administrator (DBA) to manage, maintain, and optimize mission-critical PostgreSQL databases. The ideal candidate will ensure high availability, performance, and security while supporting development and production environments across multiple systems.

The Role

Responsibilities

• Install, configure, upgrade, and maintain PostgreSQL database servers in production and non-production environments.
• Monitor database performance, identify bottlenecks, and implement tuning strategies (query optimization, indexing, partitioning, etc.).
• Design and manage database backup and recovery strategies, ensuring minimal downtime and data integrity.
• Implement replication, clustering, and failover mechanisms for high availability and disaster recovery.
• Manage user access, security policies, and encryption to maintain compliance standards.
• Collaborate with development and DevOps teams to support schema design, query optimization, and database deployment automation.
• Troubleshoot database-related issues and provide 24x7 on-call support when required.
• Develop and maintain documentation related to database architecture, processes, and procedures.

Qualifications

• 5+ years of hands-on experience as a PostgreSQL DBA in large-scale enterprise environments.
• Strong knowledge of PostgreSQL architecture, including WAL, replication, and partitioning.
• Experience with performance tuning, query optimization, and index management.
• Proficiency with PL/pgSQL, functions, stored procedures, and triggers.
• Familiarity with tools such as pgAdmin, pgBackRest, Patroni, pgBouncer, or pgPool-II.
• Experience managing databases on AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, or GCP Cloud SQL (preferred).
• Proficient in Linux/Unix environments and shell scripting.
• Working knowledge of database monitoring and alerting tools (e.g., Prometheus, Grafana, Datadog).
• Strong problem-solving and analytical skills.

Preferred Qualifications

• Experience with migration from Oracle/MySQL to PostgreSQL.
• Familiarity with CI/CD pipelines and infrastructure-as-code (Terraform, Ansible).
• Certifications in PostgreSQL or cloud database administration.

We offer

• A highly competitive compensation and benefits package.
• A multinational organization with 58 offices in 21 countries and the possibility to work abroad.
• 10 days of paid annual leave (plus sick leave and national holidays).
• Maternity & paternity leave plans.
• A comprehensive insurance plan including medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region).
• Retirement savings plans.
• A higher education certification policy.
• Commuter benefits (varies by region).
• Extensive training opportunities, focused on skills, substantive knowledge, and personal development.
• On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
• Coaching opportunities with experienced colleagues from our FinLabs and Center of Excellences (CoE) groups.
• Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms.
• A flat and approachable organization.
• A truly diverse, fun-loving, and global work culture.

SYNECHRON’S DIVERSITY & INCLUSION STATEMENT

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.