> Markdown version of [/jobs/ext/158500-sr-postgresql-database-administrator-hybrid](https://www.wearedevelopers.com/jobs/ext/158500-sr-postgresql-database-administrator-hybrid). 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). --- # Sr.PostgreSQL Database Administrator -Hybrid - **Company:** MSYS Inc. - **Location:** Dallas, TX, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Audit Trail, User Authentication, Databases, Data Architecture, Data Infrastructure, Extract Transform Load (ETL), Data Migration, Database Design, Database Queries, Database Security, Disaster Recovery, Document-Oriented Databases, Entity Relationship Models, Monitoring of Systems, Identity and Access Management, PostgreSQL, Performance Tuning, Query Optimization, Software Engineering, SQL Stored Procedures, SQL Databases, Sql Optimization, System Availability, Database Optimization, Database Performance, Indexer, Cloudformation, Amazon Relational Database Service, Performance Monitor, Data Management, Cloudwatch, Terraform, Database Tools and Utilities - **Published:** May 16, 2026 - **Apply:** https://www.juju.com/job/00000000g03i0w ## About the Role 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). PostgreSQL Administration & Performance * 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. Monitoring, Alerting & Incident Response:- * Experience with CloudWatch and AWS RDS monitoring tools * Ability to set up proactive monitoring and alerting * Strong troubleshooting skills for production issues * Experience with on-call support and SLA management Additional Requirements:- * PostgreSQL version upgrade and migration experience * Capacity planning and resource optimization expertise. Nice-to-Have Qualifications:- * Experience with Infrastructure as Code (Terraform, CloudFormation) * Experience with high availability and streaming replication setups * Familiarity with PostgreSQL extensions and advanced features * Database administration tools experience (pgAdmin, DBeaver, etc.) * Strong communication and cross-functional collaboration skills * Ability to work independently and manage database architecture decisions ## Description 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. What You'll Do:- * Design and maintain scalable database architectures * Manage and optimize PostgreSQL production environments on AWS RDS * Implement and maintain comprehensive backup and disaster recovery strategies * Monitor database performance and proactively resolve issues * Collaborate with development teams on database design and optimization * Manage database security, access control, and compliance * Perform capacity planning and cost optimization for database infrastructure * Maintain comprehensive database documentation ## Related Videos - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Infrastructure as Code: The Developer's Secret Weapon](https://www.wearedevelopers.com/videos/1221-infrastructure-as-code-the-developer-s-secret-weapon) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) - [Branch your database like your code: How schema changes and pull requests go hand in hand](https://www.wearedevelopers.com/videos/350-branch-your-database-like-your-code-how-schema-changes-and-pull-requests-go-hand-in-hand) - [We Gave Every Tenant a Postgres Connection String](https://www.wearedevelopers.com/videos/1951-we-gave-every-tenant-a-postgres-connection-string) ## Related Articles - [Dev Digest 168: Hacking Postgres, Blocking Meta and Fixing CSS](https://www.wearedevelopers.com/magazine/588-dev-digest-168-hacking-postgres-blocking-meta-and-fixing-css) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)