PostgreSQL DBA

Role: PostgreSQL DBA Location: Framingham, MA Fulltime Job Description Extensive hands-on experience with PostgreSQL (v11 and above). Database installation, configuration, and upgrades on Linux/Unix platforms. High Availability (HA) setup using streaming replication, Patroni, repmgr, etc. Backup and recovery strategies using tools like pgBackRest, Barman. Performance tuning and query optimization. Strong knowledge of PL/pgSQL scripting and automation. Experience in database monitoring and alerting tools (e.g., pg_stat_statements, Prometheus, Grafana). Security hardening and compliance (role-based access control, SSL, encryption at rest/in-transit). Disaster Recovery planning and execution. Capacity planning and data growth forecasting. Good understanding of cloud platforms (AWS RDS/Aurora, GCP Cloud SQL, or Azure PostgreSQL). Good communication skills with both technical and management teams. Good-to-Have: Experience with other databases (Oracle, MySQL, or NoSQL like MongoDB). Experience with Kubernetes & PostgreSQL operators (e.g., Zalando, Crunchy). Knowledge of Infrastructure as Code (Terraform, Ansible). Experience with CI/CD pipelines for database changes Experience with Databases (Oracle, DB2 & SQL server). Exposure to PostgreSQL clustering and sharding. Understanding of logical replication and change data capture (CDC). Knowledge of network monitoring and tools Excellent stakeholder management and cross-functional collaboration Certifications (Optional but Preferred): AWS Certified Database - Specialty Expectations from the Role : Database Architecture & Design: Design and maintain complex PostgreSQL database schemas. Performance Tuning & Optimization: Advanced query tuning and index optimization. Analyze and resolve slow queries using EXPLAIN, ANALYZE, and pg_stat views. Backup and Recovery: Implement and manage high-availability backup strategies. Test and document disaster recovery procedures. Replication and High Availability: Set up and maintain replication (physical/logical). Experience with HA tools like Patroni, repmgr, or Pgpool-II. Security Management: Implement role-based access controls, SSL/TLS, and audit logging. Monitor for vulnerabilities and apply patches. Monitoring & Maintenance: Perform routine health checks and maintenance tasks (VACUUM, REINDEX, ANALYZE). Upgrades & Migrations: Plan and execute PostgreSQL version upgrades with minimal downtime. Experience migrating from on-prem to cloud (AWS RDS/Aurora, Azure Database for PostgreSQL, or GCP). Desired Skills: Postgres DBA Thanks & Regards, Shashi Bhushan Diverse Lynx LLC |300 Alexander Park|Suite #200|Princeton , NJ 08540 Office: +732-452-1006 ext:344 Email: shashi.bhushan@ | URL: Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Created: 2026-03-10