Senior Database Administrator: HA/DR, NoSQL & Cloud

General Dynamics Information Technology, Inc.; Northern (KY); On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

401K with company match

Paid time off

Job summary

General Dynamics Information Technology, Inc. seeks a Senior Database Administrator to support OCSPP/ EPA, overseeing installation, configuration, and management of MySQL, PostgreSQL and MongoDB clusters with HAProxy-based load balancing across multiple nodes.

You will ensure security, backups, disaster recovery, and performance monitoring while collaborating with EPA product teams and developers. You will lead architectural discussions, drive high-availability strategies, and mentor peers in

Qualifications

• 3+ years of related experience.
• Experience working in Linux environments.
• Strong command-line experience including Unix shell scripting, PowerShell, and AWS CLI for cloud storage management.
• Experience with Administering SQL (e.g., PostgreSQL, MySQL, Oracle, etc.) and NoSQL (e.g., MongoDB) technologies.
• Experience configuring and managing HAProxy/Keepalived for database load balancing, connection pooling, and automated failover routing.
• Experience managing automated database backups, repositories (e.g., pgBackRest), and backup retention strategies utilizing AWS S3 object storage.
• Ability to perform complex command-line scripts and SQL queries.
• Ability to thrive in an environment without a managed database service.
• Advanced knowledge of database security, backup and recovery, and performance monitoring standards.

Responsibilities

• Provide expert level DBA services for production, stage, and development databases across all platforms.
• Support automated and ad-hoc report generation as well as existing ETL processes and data pipelines across enterprise platforms.
• Mentor peers and cross-train team members in domain and technical knowledge.
• Analyze user experience of Agency IT programs and recommend design changes for better performance.
• Maintain knowledge of security, backup and recovery, and performance monitoring standards.

Skills

Linux

Unix shell scripting

PowerShell

AWS CLI

Database performance monitoring

Troubleshooting PL/SQL

Oracle database

MySQL

PostgreSQL

Education

Technical Training/Certification/Degree

Tools

HAProxy

Keepalived

MongoDB

pgBackRest

AWS S3

SQL tooling

Job description

General Dynamics Information Technology, Inc. seeks a Senior Database Administrator to support OCSPP/ EPA, overseeing installation, configuration, and management of MySQL, PostgreSQL and MongoDB clusters with HAProxy-based load balancing across multiple nodes.

You will ensure security, backups, disaster recovery, and performance monitoring while collaborating with EPA product teams and developers. You will lead architectural discussions, drive high-availability strategies, and mentor peers in