{"schemaVersion":"jobsearcher.job.v1","id":"522987f9d912bc19769fd74f","url":"https://jobsearcher.com/jobs/522987f9d912bc19769fd74f","canonicalUrl":"https://jobsearcher.com/jobs/522987f9d912bc19769fd74f","title":"PostgreSQL Database Administrator","description":"Mode of Work: Hybrid (Dallas-TX)\r\nPosition Overview\r\nIn 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.\r\nRequired Skills & Experience\r\nDatabase Design & Management\r\nStrong knowledge of data design principles and schema management\r\nExpertise in database normalization, indexing strategies, and query optimization\r\nAbility to design and maintain logical and physical database architecture\r\nProficiency in creating and maintaining Entity-Relationship Diagrams (ERDs)\r\n5+ years of hands-on PostgreSQL administration in production environments\r\nProficiency in PostgreSQL tuning and performance optimization\r\nExpertise in maintaining PostgreSQL on AWS RDS, including parameter groups and configuration\r\nStrong understanding of query execution plans, indexing, and SQL optimization\r\nSecurity & Compliance\r\nStrong knowledge of PostgreSQL security management (authentication, authorization, encryption)\r\nExperience with IAM integration and access control policies\r\nUnderstanding of audit logging and compliance requirements\r\nBackup, Recovery & Disaster Recovery\r\nExpertise in backup strategies and point-in-time recovery (PITR)\r\nExperience designing and testing disaster recovery plans\r\nProficiency with AWS RDS backup and snapshot management\r\nData Management & Migration\r\nAbility to understand and document data flow within database systems\r\nProficiency with loading, transforming, and moving data between database environments\r\nExperience with ETL processes and data migration strategies\r\nSQL & Application Development Knowledge\r\nAdvanced SQL expertise including complex queries and optimization\r\nStrong understanding of stored procedures, functions, and triggers\r\nAbility to review and advise on application-level database interactions\r\nJ-18808-Ljbffr","company":"Techgene","rawCompany":"techgene","city":"Dallas","state":"TX","isRemote":false,"isActive":false,"createdAt":"2026-07-16T01:41:59.368Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PostgreSQL Database Administrator","description":"Mode of Work: Hybrid (Dallas-TX)\r\nPosition Overview\r\nIn 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.\r\nRequired Skills & Experience\r\nDatabase Design & Management\r\nStrong knowledge of data design principles and schema management\r\nExpertise in database normalization, indexing strategies, and query optimization\r\nAbility to design and maintain logical and physical database architecture\r\nProficiency in creating and maintaining Entity-Relationship Diagrams (ERDs)\r\n5+ years of hands-on PostgreSQL administration in production environments\r\nProficiency in PostgreSQL tuning and performance optimization\r\nExpertise in maintaining PostgreSQL on AWS RDS, including parameter groups and configuration\r\nStrong understanding of query execution plans, indexing, and SQL optimization\r\nSecurity & Compliance\r\nStrong knowledge of PostgreSQL security management (authentication, authorization, encryption)\r\nExperience with IAM integration and access control policies\r\nUnderstanding of audit logging and compliance requirements\r\nBackup, Recovery & Disaster Recovery\r\nExpertise in backup strategies and point-in-time recovery (PITR)\r\nExperience designing and testing disaster recovery plans\r\nProficiency with AWS RDS backup and snapshot management\r\nData Management & Migration\r\nAbility to understand and document data flow within database systems\r\nProficiency with loading, transforming, and moving data between database environments\r\nExperience with ETL processes and data migration strategies\r\nSQL & Application Development Knowledge\r\nAdvanced SQL expertise including complex queries and optimization\r\nStrong understanding of stored procedures, functions, and triggers\r\nAbility to review and advise on application-level database interactions\r\nJ-18808-Ljbffr","datePosted":"2026-07-16T01:41:59.368Z","dateModified":"2026-07-16T01:41:59.368Z","hiringOrganization":{"@type":"Organization","name":"Techgene","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Dallas","addressRegion":"TX","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"522987f9d912bc19769fd74f"},"url":"https://jobsearcher.com/jobs/522987f9d912bc19769fd74f"}}