PostgreSQL Database Administrator

PostgreSQL Database AdministratorWe are seeking a highly experienced PostgreSQL Database Administrator to design, implement, and maintain robust, scalable, and secure database environments. The ideal candidate will have a strong background in performance tuning, high availability architecture, and enterprise-scale database operations, with the ability to mentor junior team members and drive best practices across the organization.Key Responsibilities:Install, configure, upgrade, and maintain PostgreSQL database instances across production, staging, and development environmentsDesign and implement backup, recovery, and disaster recovery strategiesMonitor database performance, identify bottlenecks, and optimize queries, indexes, and configurationsImplement and manage high availability (HA) and replication solutionsEnsure database security, including access controls, encryption, and compliance with regulatory standardsPlan and execute database migrations, upgrades, and capacity planningAutomate routine DBA tasks using scripting toolsCollaborate with development teams on schema design, query optimization, and data modelingTroubleshoot and resolve production database incidents, often under time-sensitive conditionsMaintain documentation for database architecture, procedures, and runbooksParticipate in on-call rotation for critical production supportMentor junior DBAs and provide technical guidance across teamsMandatory Skills:8+ years of hands-on experience administering PostgreSQL in production environmentsStrong expertise in PostgreSQL architecture, internals, and performance tuningProven experience with replication (streaming, logical), clustering, and high availability solutions (e.g., Patroni, repmgr, Pgpool-II)Deep understanding of backup and recovery tools (pg_dump, pg_basebackup, pg_BackRest, Barman, WAL archiving/PITR)Expertise in query optimization, indexing strategies, and EXPLAIN/ANALYZE plan tuningSolid experience with database security: roles, permissions, SSL/TLS, encryption at rest/in transitStrong scripting skills (Bash, Python, or Perl) for automationExperience with monitoring tools (pgAdmin, pg_stat_statements, Prometheus/Grafana, Datadog, or similar)Solid understanding of SQL and PL/pgSQL for stored procedures, triggers, and functionsExperience with version upgrades and major migration projectsStrong troubleshooting skills for performance, connectivity, and data integrity issuesPreferred Skills:Experience with cloud-managed PostgreSQL services (AWS RDS/Aurora)Experience with Infrastructure as Code tools (Terraform, Ansible)Knowledge of other RDBMS/NoSQL systems (MySQL, MongoDB, Oracle) for cross-platform environmentsExposure to CI/CD pipelines and DevOps practicesPostgreSQL certification (e.g., EDB Certified PostgreSQL Associate/Professional)Familiarity with connection pooling tools (PgBouncer, Pgpool-II)Knowledge of PostGIS or other PostgreSQL extensionsEducation:Bachelor's degree in computer science, Information Systems, or a related field (or equivalent practical experience).*** is an Equal Employment Opportunity employer. We promote and support a diverse workforce at all levels of the company. All qualified applicants will receive consideration for employment without regard to race, religion, color, sex, age, national origin or disability. All applicants will be evaluated solely on the basis of their ability, competence, and performance of the essential functions of their positions with or without reasonable accommodations. Reasonable accommodations also are available in the hiring process for applicants with disabilities. Candidates can request a reasonable accommodation by contacting the company ADA Coordinator.