> Markdown version of [/jobs/ext/2988656-postgresql-database-architect](https://www.wearedevelopers.com/jobs/ext/2988656-postgresql-database-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 Database Architect - **Company:** Meridian - **Location:** St. Louis, MO, United States - **Experience:** Expert - **Salary:** $118,000.0 - $140,000.0 - **Contract:** Permanent contract - **Skills:** CompTIA Security+, Databases, Data Warehousing, Database Analysis, Database Storage Structures, PostgreSQL, MySQL, Open Source Technology, Oracle Databases, Oracle (Applications), Performance Tuning, Query Optimization, Role-Based Access Control, SQL Stored Procedures, Strategies of Testing, Backup and Restore, Database Optimization, Database Migration, Information Technology, Database Backup, Database Tools and Utilities - **Published:** September 18, 2026 - **Apply:** https://www.careerjet.com/job/us6361a37f463c5a38d732010c04121aa9/eaa ## About the Role * Active TS/SCI clearance * 5+ years of database administration and/or database analysis experience * Hands-on PostgreSQL administration and performance-tuning experience * Experience implementing and supporting database high-availability solutions. * Experience with database backup, restore, migration, and snapshot technologies and strategies. * Experience monitoring and managing PostgreSQL database environments and alerts. * Knowledge of database architecture and table structures for transactional and warehouse data. * Bachelor's degree in Computer Science or a related technical discipline, or an equivalent combination of education, technical training, military experience, and/or relevant work experience. * U.S. Citizenship required. Preferred Qualifications * Oracle database administration experience. * Database migration experience involving Oracle, MySQL, and PostgreSQL. * CompTIA Security+ or equivalent certification. * Experience supporting database modernization initiatives within government or Intelligence Community environments. ## Description We are seeking an experienced PostgreSQL Database Architect to support a mission-critical Intelligence Community customer. This position will be responsible for designing, implementing, administering, and optimizing PostgreSQL database environments while ensuring database availability, performance, integrity, and security. The ideal candidate has strong hands-on PostgreSQL administration and performance-tuning experience, including high-availability solutions, database migrations, backup and recovery strategies, and database modernization initiatives., * Design, implement, administer, and support PostgreSQL database environments. * Maintain database availability, integrity, security, and performance. * Configure role-based access control (RBAC), administrator accounts, and service accounts. * Monitor database environments and configure PostgreSQL server alerts. * Perform database performance tuning and troubleshoot database-related issues. * Plan and execute database upgrades, patching, backups, restores, and migrations. * Implement and support database high-availability and recovery solutions. * Collaborate with developers on schema design, query optimization, and stored procedures. * Design and maintain efficient database structures for transactional and data warehouse environments. * Develop testing strategies, execute testing, and document results. * Evaluate open-source and vendor database tools and technologies. * Support database migration and modernization initiatives involving PostgreSQL, Oracle, and MySQL. * Maintain technical documentation, configurations, standards, and procedures. * Ensure database environments comply with applicable security, industry, and regulatory requirements. * Provide technical guidance and database support to users and project teams. ## 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) - [MySQL Protocol Features You Should Be Aware Of](https://www.wearedevelopers.com/videos/100267-mysql-protocol-features-you-should-be-aware-of) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-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) - [Discover the open source trio you didn’t expect: .NET and PostgreSQL on Linux](https://www.wearedevelopers.com/videos/2042-discover-the-open-source-trio-you-didn-t-expect-net-and-postgresql-on-linux) - [Tracking vehicles at scale](https://www.wearedevelopers.com/videos/1999-tracking-vehicles-at-scale) ## 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) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [The Geometry of Incidents: Connecting User Impact to Architecture](https://www.wearedevelopers.com/magazine/764-the-geometry-of-incidents-connecting-user-impact-to-architecture) - [Everything a Developer Needs to Know About MCP with Neo4j](https://www.wearedevelopers.com/magazine/604-everything-a-developer-needs-to-know-about-mcp-with-neo4j) - [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 Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)