This job offer is no longer available
PostgreSQL Database Administrator
Techgene LLC
- Dallas, Texas, United States
- Dallas, Texas, United States
About
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
#J-18808-Ljbffr
Languages
- English
Notice for Users
This job was posted by one of our partners. You can view the original job source here.