> Markdown version of [/jobs/ext/4271256-senior-postgresql-dba-and-engineer](https://www.wearedevelopers.com/jobs/ext/4271256-senior-postgresql-dba-and-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior PostgreSQL DBA and Engineer

- **Company:** Chateck Inc.
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Contract
- **Skills:** Java (Programming Language), Adaptable Database Systems, Application Programming Interfaces (APIs), Microsoft Azure, Backup Devices, Bash Shell, Business Software, Cloud Computing, Cloud Database, Profiling, Databases, Data Integration, Extract Transform Load (ETL), Data Security, Database Design, DevOps, Disaster Recovery, Failover, Github, Monitoring of Systems, Python (Programming Language), PostgreSQL, Meta-Data Management, SQL Azure, Performance Tuning, Query Optimization, Role-Based Access Control, Ansible, Software Engineering, SQL Stored Procedures, SQL Databases, Data Processing, Google Cloud, Sql Optimization, System Availability, Database Optimization, Database Performance, Database Migration, Amazon Relational Database Service, Infrastructure Automation Frameworks, Data Lineage, Integration Frameworks, Apache Kafka, Terraform, GiST, Data Pipelines, Docker, Jenkins, Programming Languages, Microservices
- **Published:** October 20, 2026
- **Apply:** https://www.dice.com/job-detail/aa3d939a-ba0b-4d4a-ac1e-3ca755397393

## About the Role

* 5+ years of hands-on PostgreSQL development and database administration and engineering experience in enterprise-scale environments.
 * Strong expertise in database design and data modeling, including logical/physical modeling, schema design, normalization/denormalization, partitioning, and scalability.
 * Advanced SQL and PL/pgSQL development skills, including stored procedures, views, materialized views, CTEs, window functions, and query optimization.
 * Experience with performance tuning and troubleshooting, including indexing strategies (B-Tree, GIN, GiST, BRIN, Hash), VACUUM optimization, statistics management, and execution plan analysis.
 * Knowledge of high availability and disaster recovery, including replication, failover, backup/recovery, read replicas, and scaling strategies.
 * Experience building and supporting ETL/ELT pipelines, Kafka integrations, CDC, and real-time/batch data processing.
 * Proficiency in at least one programming language such as Python, Java, or Bash, with experience supporting APIs and microservices.
 * Hands-on experience with cloud database platforms such as AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, or Google Cloud SQL.
 * Strong understanding of data security and governance, including RBAC, encryption, auditing, PHI/PII protection, and compliance requirements.

Pluses

 * Healthcare industry experience.
 * Experience leading or supporting database migration initiatives.
 * DevOps and infrastructure automation experience using Terraform, GitHub Actions, Jenkins, Azure DevOps, or Ansible.
 * Experience with Docker and Kubernetes in cloud-native environments.
 * Strong background in metadata management, data lineage, profiling, and reconciliation.
 * Experience with monitoring tools, WAL management, and PostgreSQL migration utilities.

## Description

* Design, develop, and maintain enterprise PostgreSQL databases and scalable data models.
 * Write, optimize, and troubleshoot complex SQL and PL/pgSQL code to support business applications and reporting.
 * Monitor and tune database performance, resolve bottlenecks, and implement indexing and optimization strategies.
 * Manage database availability, replication, backups, recovery processes, and disaster recovery planning.
 * Build and support ETL/ELT pipelines and data integrations using Kafka, CDC, and other integration frameworks.
 * Collaborate with application development teams to support APIs, microservices, and cloud-native solutions.
 * Implement and maintain security controls, governance standards, and compliance requirements.
 * Support cloud database environments and infrastructure automation initiatives.
 * Partner with stakeholders to troubleshoot issues, improve data quality, and ensure reliable database operations.