Senior PostgreSQL Engineer — OpenShift, HA & Security

General Dynamics Information Technology, Inc.; St. Louis (MO); Vor Ort; USD 120.000 - 180.000; Vollzeit

Zusammenfassung

General Dynamics Information Technology, Inc. seeks a Senior PostgreSQL Database Engineer to support mission-critical systems, combining PostgreSQL administration with database engineering and architecture.

You will be the team’s primary database SME, partnering with software developers and systems engineers to ensure reliable operations while improving performance, security, and maintainability. The role focuses on OpenShift deployments, schema design, backups, high availability, monitoring,

Qualifikationen

• Active TS/SCI security clearance and ability to obtain and maintain a polygraph.
• Bachelor's degree in Computer Science, Information Technology, or related discipline, or equivalent education/training.
• Five+ years of experience in database administration/engineering/architecture.
• Hands-on experience administering PostgreSQL databases.
• Experience with relational database design, SQL, indexing, and query optimization.
• Experience with backups, restores, upgrades, and maintenance.
• Knowledge of high availability, replication, and disaster recovery.

Aufgaben

• Administer PostgreSQL databases: configuration, users, roles, maintenance, patching, upgrades, troubleshooting.
• Design and improve database architectures: schemas, data models, indexing, data access patterns.
• Optimize performance: analyze queries, adjust configs, indexes, resources.
• Support deployments in OpenShift: connectivity, monitoring, integration with OpenShift systems.
• Maintain reliability and recoverability: backups, recovery testing, DR capabilities.
• Monitor database health: logging, alerting, capacity, reporting.
• Collaborate with developers on schema design, SQL development, and data access patterns.
• Drive continuous improvement: performance, reliability, scalability, maintainability.
• Lifecycle management: upgrades, migrations, and modernization with minimal disruption.
• Establish and maintain standards: architecture, configurations, security controls, procedures.
• Maintain security: access controls, auditing, least-privilege.

Kenntnisse

PostgreSQL administration

OpenShift experience

SQL performance tuning

Data modeling

Security clearance TS/SCI

Team collaboration

Ausbildung

Bachelor's degree in Computer Science or related

Tools

OpenShift

Oracle

Kubernetes

Linux

Jobbeschreibung

General Dynamics Information Technology, Inc. seeks a Senior PostgreSQL Database Engineer to support mission-critical systems, combining PostgreSQL administration with database engineering and architecture.

You will be the team’s primary database SME, partnering with software developers and systems engineers to ensure reliable operations while improving performance, security, and maintainability. The role focuses on OpenShift deployments, schema design, backups, high availability, monitoring,