Talent.com
Meridian Systematics
PostgreSQL Database ArchitectMeridian Systematics • St. Louis, MO, US
No longer accepting applications
PostgreSQL Database Architect

PostgreSQL Database Architect

Meridian Systematics • St. Louis, MO, US
19 days ago
Salary
$118,000.00 yearly
Job type
  • Full-time
Job description
Benefits:
  • Company parties
  • Dental insurance
  • Health insurance
  • Paid time off
  • Parental leave
  • Training & development

PostgreSQL Database Architect (TS/SCI)
Location: St. Louis, MO


Clearance Required: TS/SCI

Position Summary


The PostgreSQL Database Architect provides technical leadership in the design, implementation, administration, and modernization of enterprise database environments supporting Department of War and Intelligence Community mission objectives. The incumbent architects and maintains secure, scalable, and highly available PostgreSQL database solutions while supporting database performance, security, disaster recovery, and modernization initiatives. Working collaboratively with software developers, system administrators, and mission stakeholders, this position ensures enterprise database environments are optimized for reliability, scalability, and operational performance.



Essential Duties and Responsibilities


  • Architect, design, implement, administer, and sustain enterprise PostgreSQL database environments supporting mission-critical applications.
  • Develop and maintain secure, highly available, and scalable database architectures, including clustering, replication, backup, recovery, and disaster recovery solutions.
  • Monitor, analyze, and optimize database performance through capacity planning, query optimization, indexing strategies, and performance tuning.
  • Plan and execute database upgrades, patching, migrations, and modernization initiatives while minimizing operational impact.
  • Design and implement database security controls, including Role-Based Access Control (RBAC), administrative account management, auditing, and compliance with organizational cybersecurity policies.
  • Collaborate with software developers and system engineers on database schema design, stored procedures, query optimization, and application integration.
  • Develop and maintain database standards, configuration baselines, operational procedures, and technical documentation.
  • Implement and validate database backup, recovery, snapshot, and business continuity strategies to ensure system resiliency.
  • Evaluate commercial and open-source database technologies and provide technical recommendations supporting enterprise modernization efforts.
  • Develop and execute database testing strategies to validate performance, availability, scalability, and security.
  • Provide technical guidance, troubleshooting, and performance optimization recommendations to development teams and database users.
  • Ensure compliance with enterprise security requirements, configuration management practices, and applicable regulatory and organizational standards.


Required Qualifications


  • Active Top Secret/Sensitive Compartmented Information (TS/SCI) security clearance.
  • U.S. Citizenship.
  • Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related technical discipline; or an equivalent combination of education, military service, and relevant professional experience.
  • Minimum of 5 years of experience designing, administering, and supporting enterprise database environments.
  • Demonstrated experience administering and architecting PostgreSQL database environments.
  • Experience implementing PostgreSQL high-availability, replication, backup, recovery, and disaster recovery solutions.
  • Experience monitoring, tuning, and optimizing PostgreSQL database performance.
  • Experience configuring and managing PostgreSQL server monitoring, alerts, and operational health.
  • Experience with database backup, restore, migration, and snapshot technologies.
  • Experience designing efficient database schemas supporting transactional and data warehouse environments.
  • Experience performing database migrations involving PostgreSQL, Oracle, and MySQL.
  • Experience implementing database security, Role-Based Access Control (RBAC), and administrative account management.
  • Strong analytical, troubleshooting, documentation, and communication skills.

Preferred Qualifications


  • Experience administering Oracle database environments.
  • CompTIA Security+ or equivalent DoD 8570/8140 certification.
  • Experience supporting Department of War or Intelligence Community enterprise systems.
  • Experience with database automation, scripting, and Infrastructure as Code.
  • Experience supporting cloud-hosted or hybrid database environments.
  • Experience with database monitoring, performance analytics, and enterprise management tools.

Knowledge, Skills, and Abilities


  • Expert knowledge of PostgreSQL architecture, administration, and performance optimization.
  • Knowledge of database high-availability, clustering, replication, disaster recovery, and backup strategies.
  • Knowledge of SQL optimization, database design principles, and enterprise data architecture.
  • Knowledge of database security, RBAC, auditing, and cybersecurity best practices.
  • Ability to design, implement, and support highly available enterprise database environments.
  • Ability to analyze and resolve complex database performance and operational issues.
  • Ability to collaborate effectively with software developers, system administrators, cybersecurity personnel, and government stakeholders.
  • Ability to prepare technical documentation, database standards, implementation guides, and operational procedures.
  • Ability to evaluate emerging database technologies and recommend solutions supporting enterprise modernization initiatives.


Create a job alert for this search

PostgreSQL Database Architect • St. Louis, MO, US

Similar jobs

Restaurant Delivery - Sign Up and Start Earning

DoorDashBarnhart, MO, United States

DoorDash is the #1 category leader in food delivery, food pickup, and convenience store delivery in the US, trusted by millions of customers every day.As a Dasher, you’ll stay busy with a var... Show more

 • Promoted

Senior Associate - Federal Financial Analyst

Blake Wilson GroupArnold, MO, United States
Full-time

Senior Associate - Federal Financial Analyst.Harnessing Technology to Improve Financial Stewardship for the Welfare, Defense, and Security of Our Nation.Blake Willson Group (BWG) unites deep domain... Show more

 • Promoted

Oracle Tech Cloud Manager

DeloitteSaint Louis, MO, United States
Full-time

Oracle Technical Cloud Manager.Today's CFOs and financial leaders face increasing demands to enhance business performance, drive shareholder value, and optimize operational efficiency.As an Oracle... Show more

 • Promoted

Forensics Solutions Architect with AWS - Remote

PerficientSaint Louis, MO, United States
Remote
Permanent

Job DescriptionWe are an IT Management Consulting firm specializing in AI-driven innovation and looking for a Forensics Solutions Architect with hands on AWS experience to join our Data and Analyti... Show more

 • Promoted

Information Technology Professional

US NavyCrystal City, MO, United States
Full-time

Job Title: Information Technology Professional (IT/CTN/IS).Any additional information you require for this job can be found in the below text Make sure to read thoroughly, then apply.Category / Com... Show more

 • Promoted

Consumer Insights Analyst

Earn HausMapaville, Missouri, United States
Part-time

We're currently seeking motivated individuals to participate in online surveys and paid gaming opportunities for well-known national brands.If you're looking for a flexible way to earn extra cash f... Show more

 • Promoted

Church Bookkeeper

Christ Community Lutheran ChurchColumbia, IL, United States
Part-time

Job Title: Church Bookkeeper Employment: Part-time, Hybrid or Fully In person, 12 hours/week Compensation :Hourly Range - $19-$23/Hour _(Commensurate with experience & education)_ POSITION OBJE... Show more

 • Promoted

Market Research Associate - No Experience

Clubshop | USColumbia, Illinois
Full-time

Discover The System Surveoo That’s Helping Newbies Earn Daily.Turn your free time into daily earnings by answering simple surveys.No product or tech skills needed.Join For Free And Start Earn... Show more

Restaurant Manager

Denny'sArnold, MO, United States
Full-time

Denny's, America's Diner, is seeking a talented Restaurant Manager to join our team.At Denny's, we are always open for you to be who you want, with the people you want, over the food you want.We ce... Show more

 • Promoted

Director of Information Technology Full Time

Pony Bird, Inc.Herculaneum, MO, United States
Full-time

The Director of Information Technology (IT) provides strategic and operational leadership related to the organization's IT security, tools, and environment.The Director collaborates with the Leader... Show more

 • Promoted

Branch Manager - 284

Sun LoanFestus, MO, United States
Full-time

Hiring Immediately!For over 30 years, Sun Loan Company has been a trusted financial resource in over 200 communities, across seven states in the US, and seven locations in Mexico.Responsibilities:M... Show more

 • Promoted

Oracle Cloud EPM Implementation - Senior Manager

PwC (US)Saint Louis, MO, United States
Full-time

Oracle Enterprise Performance Management Senior Manager.At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clien... Show more

 • Promoted

Remote - Postgres Engineer

Wise SkullsSaint Louis, MO, United States
Remote
Full-time

Title :Postgres Engineer Location :St.Louis, MO (On-site) Duration :6 months (possibility of extension) Implementation Partner :Infosys End Client :To be disclosed JD :Experience in the design, mai... Show more

 • Promoted

Deputy Lead Software Architect (Senior Level)

BoeingSaint Louis, MO, United States
Permanent +1

Job DescriptionAt Boeing, we innovate and collaborate to make the world a better place.We're committed to fostering an environment for every teammate that's welcoming, respectful and inclusive, wit... Show more

 • Promoted

Teamcenter Architect

GlobalPunditsSaint Louis, MO, US
Full-time

Role: Teamcenter Infrastructure Architect Start Date: ASAP Duration: Long Term Contract Location: Cincinnati / Evandale, OH or St.Louis, MO Certifications: CompTIA Security + is required to start A... Show more

 • Promoted

Branch Office Administrator

Edward JonesFestus, MO, United States
Full-time

You're the kind of person who loves solving problems and building relationships - and that's exactly what makes you essential to our branch teams.As a Branch Office Administrator at Edward Jones, y... Show more

 • Promoted

Architect and Design Specification Representative-Outside Sales

Richelieu Hardware Ltd.Arnold, MO, United States
Full-time

Architecture & Design Specification Representative.Richelieu is a leading North American distributor, importer, and manufacturer of specialty hardware and complementary products.Our products are ta... Show more

 • Promoted

General Manager

Arby'sFESTUS, MO, US
Full-time

Flynn Arby’s joined Flynn Group in 2018 with the acquisition of 300+ restaurants.Today we are the largest Arby’s franchisee in the world and continue grow by building new stores and acquiring other... Show more