PostgreSQL Database Administrator

Techgene Solutions; Dallas (TX); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Techgene Solutions in Dallas, TX is seeking a Senior PostgreSQL DBA to co-own and optimize our PostgreSQL infrastructure in AWS RDS, ensuring security, reliability, and performance.

You will collaborate with development teams to design scalable database solutions, implement best practices for backup, PITR, and disaster recovery, and help migrate data across environments. Candidates should have 5+ years of production PostgreSQL experience in AWS.

Qualifications

• 5+ years of hands-on PostgreSQL administration in production environments.
• Expertise in PostgreSQL tuning and performance optimization.
• Experience with AWS RDS parameter groups and configuration.
• Strong knowledge of data design principles and ERDs.
• Knowledge of security management, IAM integration, and audit logging.
• Experience with backup strategies and point-in-time recovery (PITR).
• Ability to understand and document data flow; ETL and data migration strategies.

Skills

PostgreSQL administration

AWS RDS tuning

SQL optimization

Data modeling

Performance tuning

Security & IAM

PITR backup

ETL & data migration

Tools

AWS

Job description

Mode of Work: Hybrid (Dallas-TX)

Position Overview

In this role, you will take co-ownership of PostgreSQL infrastructure, ensuring optimal performance, security, and reliability. You will work closely with development teams to design scalable database solutions and manage production environments in AWS RDS.

Required Skills & Experience

Database Design & Management

• Strong knowledge of data design principles and schema management
• Expertise in database normalization, indexing strategies, and query optimization
• Ability to design and maintain logical and physical database architecture
• Proficiency in creating and maintaining Entity-Relationship Diagrams (ERDs)
• 5+ years of hands‑on PostgreSQL administration in production environments
• Proficiency in PostgreSQL tuning and performance optimization
• Expertise in maintaining PostgreSQL on AWS RDS, including parameter groups and configuration
• Strong understanding of query execution plans, indexing, and SQL optimization

Security & Compliance

• Strong knowledge of PostgreSQL security management (authentication, authorization, encryption)
• Experience with IAM integration and access control policies
• Understanding of audit logging and compliance requirements

Backup, Recovery & Disaster Recovery

• Expertise in backup strategies and point-in-time recovery (PITR)
• Experience designing and testing disaster recovery plans
• Proficiency with AWS RDS backup and snapshot management

Data Management & Migration

• Ability to understand and document data flow within database systems
• Proficiency with loading, transforming, and moving data between database environments
• Experience with ETL processes and data migration strategies

SQL & Application Development Knowledge

• Advanced SQL expertise including complex queries and optimization
• Strong understanding of stored procedures, functions, and triggers
• Ability to review and advise on application-level database interactions