Senior Database Administrator — Remote, Cloud & HA

General Dynamics Information Technology (GDIT); United States; Remote; USD 98,000 - 130,000; Full time

Job summary

General Dynamics Information Technology (GDIT) seeks an experienced Senior Database Administrator to join the SMAVCS4 team supporting the Environmental Protection Agency. The role entails installing, configuring, and managing MySQL, PostgreSQL, and MongoDB clusters with HAProxy for load balancing and high availability.

You will analyze issues in real time, optimize performance, and mentor peers while helping establish database security and disaster recovery strategies.

Qualifications

• 3+ years of related experience.
• Experience in Linux environments.
• Strong command-line experience including Unix shell scripting, PowerShell, and AWS CLI.
• Experience with administering SQL (PostgreSQL, MySQL, Oracle, etc.) and NoSQL (MongoDB).
• Experience configuring and managing HAProxy/Keepalived for database load balancing, connection pooling, and automated failover routing.
• Experience managing automated database backups, repositories (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.
• Work with senior developers and data modelers to perform physical database design for critical business applications/databases with the largest numbers of interfaces and users.
• Support both automated and ad-hoc report generation as well as existing ETL processes and data pipelines across enterprise platforms.
• Use expert communication and collaboration skills to provide domain and technical expertise, and offer technical mentorship and cross-training to peers and team members.
• Work involves analyzing the user experience of a variety of Agency IT programs and recommending design changes that can enhance the user experience and query performance.
• Maintain advanced knowledge of database security, backup and recovery, and performance monitoring standards

Skills

Database Management

Microsoft SQL Server

Problem Solving

Job description

General Dynamics Information Technology (GDIT) seeks an experienced Senior Database Administrator to join the SMAVCS4 team supporting the Environmental Protection Agency. The role entails installing, configuring, and managing MySQL, PostgreSQL, and MongoDB clusters with HAProxy for load balancing and high availability.

You will analyze issues in real time, optimize performance, and mentor peers while helping establish database security and disaster recovery strategies.