> Markdown version of [/jobs/ext/4165356-postgresql-data-architect](https://www.wearedevelopers.com/jobs/ext/4165356-postgresql-data-architect). 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).

---

# PostgreSQL Data Architect

- **Company:** Tachyon Technologies
- **Location:** Dallas, TX, United States
- **Experience:** Expert
- **Salary:** $145,600.0 - $187,200.0
- **Contract:** Permanent contract
- **Skills:** Amazon Web Services, Bash Shell, Cloud Computing, Databases, Data Architecture, Data Integration, Database Security, DevOps, Digital Architecture, Disaster Recovery, Failover, Python (Programming Language), PostgreSQL, Microsoft SQL Server, SQL Azure, MySQL, Oracle (Applications), PCI Data Security Standards, PostGIS, Ansible, Standard Sql, Runbook, Data Streaming, Scripting, Indexer, Amazon Relational Database Service, Debezium, Kubernetes, Deployment Automation, Performance Monitor, Apache Kafka, Data Management, Restful APIs, Decoding, Terraform, GiST, Docker
- **Published:** October 27, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=9c56a884df2b3207

## About the Role

* 15+ years in database engineering or administration, with 5 years of hands-on PostgreSQL architecture experience
 * Strong PostgreSQL internals knowledge: MVCC, WAL, query planner, indexing types (B-tree, GIN, GiST, BRIN), partitioning
 * Experience with HA/DR tools such as Patroni, repmgr, pgBackRest, or Barman
 * Strong SQL and PL/pgSQL, plus scripting in Python or Bash
 * Experience running PostgreSQL on cloud platforms (AWS RDS/Aurora PostgreSQL, Azure Database for PostgreSQL, or GCP Cloud SQL)
 * Experience with performance tools (pg_stat_statements, EXPLAIN ANALYZE, pgBadger)
 * Proven migration experience from another database platform to PostgreSQL

Preferred Qualifications

 * Experience with PgBouncer, Pgpool-II, or similar connection pooling
 * Experience with Terraform, Ansible, Kubernetes, or Docker
 * Familiarity with extensions such as PostGIS, TimescaleDB, Citus, and pg_partman
 * Experience with CDC and data integration (Debezium, Kafka, logical decoding)
 * Knowledge of compliance frameworks (SOC 2, HIPAA, PCI-DSS)
 * Cloud or PostgreSQL certifications (AWS Database Specialty, EDB, or similar)

Soft Skills

 * Clear communicator who can explain architecture trade-offs to technical and non-technical stakeholders
 * Comfortable owning production systems and working with on-call teams

## Description

* Design and own PostgreSQL architecture for transactional and analytical workloads, including schema design, partitioning, indexing, and data modeling
 * Build high-availability and disaster recovery solutions (streaming and logical replication, failover, backup and PITR)
 * Tune performance by analyzing query plans, tuning configuration, and managing vacuum, bloat, and connection pooling
 * Lead migrations from Oracle, SQL Server, or MySQL to PostgreSQL, and upgrades between major versions with minimal downtime
 * Define database security standards: role-based access, encryption in transit and at rest, auditing, and compliance controls
 * Automate provisioning, patching, and deployments with infrastructure-as-code and CI/CD pipelines
 * Monitor databases with proactive alerting and capacity planning, and lead root-cause analysis for production incidents
 * Set best practices, review designs and code, and mentor DBAs and developers
 * Document architecture, runbooks, and standards