Database Engineer/ Database Administrator

General Dynamics Information Technology; Maryland; Hybrid; USD 102,000 - 138,000; Full time

Job summary

General Dynamics Information Technology in the United States is seeking a Data Engineer Senior to own data pipelines, PostgreSQL administration, and performance tuning across AWS RDS/Aurora environments. You’ll design, implement, and optimize data flows for CMS CPI UCM and support real-time data movement and quality initiatives.

The role requires 5+ years of related experience, strong SQL, Python, and AWS skills, and the ability to collaborate with cross-functional teams in a remote, 40-hour

Qualifications

• Education: Bachelors Degree in Computer Science, Data Science, or Information Systems or related field
• Experience: 5+ years of related experience
• Required Technical Skills: AWS RDS/Aurora PostgreSQL administration, advanced SQL, Python for data engineering

Responsibilities

• Administer and support AWS-hosted PostgreSQL environments (RDS/Aurora) including backups and maintenance
• Manage snapshot retention, restoration, and refresh across environments
• Provide database/migration support for major releases with schema changes and rollbacks
• Monitor health, connections, locks, long-running queries, and replication status
• Perform SQL performance tuning and index optimization
• Troubleshoot incidents across databases, pipelines, and connectivity
• Design, build, and maintain data pipelines using Python, SQL, and AWS data services
• Support CDC/streaming architectures with AWS DMS, Kinesis, Debezium, MSK/Kafka
• Enable near real-time movement to reporting schemas, data lakes, Snowflake, Databricks
• Collaborate with cross-functional teams to ensure data quality and reliability

Skills

Database Performance Tuning

PostgreSQL Administration

Python (Programming Language)

Education

Bachelor's Degree in Computer Science or related field

Tools

AWS RDS/Aurora PostgreSQL

Job description

Type of Requisition: Regular Clearance Level Must Currently Possess: None Clearance Level Must Be Able to Obtain: None Public Trust/Other Required: NACI (T1) Job Family: Data Science and Data Engineering Job Qualifications: Skills: Database Performance Tuning, PostgreSQL Administration, Python (Programming Language) Certifications: None Experience: 5 + years of related experience US Citizenship Required: No

Job Description

DATA ENGINEER/DATABASE ADMINISTRATOR Own your opportunity to turn data into measurable outcomes for our customers’ most complex challenges. As a Data Engineer Senior at GDIT, you’ll power innovation to drive mission impact and grow your expertise to power your career forward.

MEANINGFUL WORK AND PERSONAL IMPACT

As a Data Engineer Senior, the work you’ll do at GDIT will be impactful to the mission of the Centers for Medicare & Medicaid Services (CMS) Center for Program Integrity (CPI) on the Unified Case Management (UCM) system. As a PostgreSQL database engineer with administrator experience, you will play a crucial role in supporting the database quality and performance that will enhance the investigative capabilities against fraud, waste, and abuse within CPI.

• Administer and support AWS-hosted PostgreSQL (Amazon RDS/Aurora) environments, including daily monitoring, backups, snapshots, restores, and routine maintenance.
• Manage database snapshot retention, restoration, and refresh processes across production, lower environments, reporting schemas, and test environments.
• Provide database/migration support for major application releases, including schema changes, data fixes, rollback planning, and deployment validation.
• Monitor health, storage, connections, locks, long-running queries, vacuum/analyze activities, and replication status to ensure stability and performance.
• Perform advanced SQL performance tuning (query optimization, indexing strategy, execution plan analysis, table maintenance).
• Troubleshoot incidents and performance bottlenecks across databases, pipelines, and application connectivity.
• Manage database security (role management, access provisioning) and support audits.
• Design, build, and maintain data pipelines using Python, SQL, and AWS data services for ingestion, transformation, migration, and reconciliation.
• Support change data capture (CDC) and streaming architectures using AWS DMS, AWS Kinesis, Debezium, and Amazon MSK/Apache Kafka.
• Enable near real-time movement from PostgreSQL to downstream platforms (e.g., reporting schemas, data lakes, Snowflake, Databricks).
• Develop automation scripts for data movement, validation, reconciliation, and operational support.
• Collaborate with application, DevOps, data platform, reporting/analytics, QA, and business teams to ensure data consistency and reliability; drive root-cause analysis and remediation of data quality issues.

WHAT YOU’LL NEED TO SUCCEED

Bring your expertise and drive for innovation to GDIT. A successful Data Engineer Senior must have:

• Education: Bachelors Degree in Computer Science, Data Science, or Information Systems or related field
• Experience: 5+ years of related experience
• Required Technical Skills: AWS RDS/Aurora PostgreSQL administration (monitoring, backup/restore, snapshots, environment refreshes). Advanced SQL and performance tuning (query optimization, indexing, execution plans). Python for data engineering, automation, and pipeline development.
• Preferred Experience and Skills: CDC/streaming using AWS DMS, AWS Kinesis, Debezium, Amazon MSK/Apache Kafka; logical replication, WAL, replication slot management. Data pipeline design and operations for ingestion/transform/migrate; near real-time data movement into Snowflake, Databricks, or data lakes. Troubleshooting performance across databases, SQL, pipelines, and integrations; release-related database scripting/support. ETL/ELT tools, orchestration/workflow automation; shell scripting, Git, CI/CD; Agile/Scrum or SAFe environments. Familiarity with data governance, data quality, metadata/lineage, and reconciliation processes. Experience with regulated enterprise systems (e.g., healthcare, government, financial)

Location: Remote

Working Hours: 40 hours per week, available within the core hours of Monday-Friday 9am to 5pm EST.

Residency requirement: Must have lived in the United States at least three (3) out of the last five (5) years.

GDIT IS YOUR PLACE

At GDIT, the mission is our purpose, and our people are at the center of everything we do.

• Growth: AI-powered career tool that identifies career steps and learning opportunities
• Support: An internal mobility team focused on helping you achieve your career goals
• Rewards: Comprehensive benefits and wellness packages, 401K with company match, and competitive pay and paid time off
• Flexibility: Full-flex work week to own your priorities at work and at home
• Community: Award-winning culture of innovation and a military-friendly workplace

OWN YOUR OPPORTUNITY

Explore a career in data science and engineering at GDIT and you’ll find endless opportunities to grow alongside colleagues who share your determination for solving complex data challenges.

The likely salary range for this position is $102,000 - $138,000. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.

Scheduled Weekly Hours: 40

Travel Required: Less than 10%

Telecommuting Options: Remote Work Location: Any Location / Remote

Additional Work Locations:

Total Rewards at GDIT

Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. GDIT typically provides new employees with 15 days of paid leave per calendar year to be used for vacations, personal business, and illness and an additional 10 paid holidays per year. Paid leave and paid holidays are prorated based on the employee’s date of hire. The GDIT Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.

Identity Verification Process

As part of the hiring process, we will ask you to complete an identity verification process that leverages advanced biometrics and artificial intelligence to ensure authenticity and protect against identity fraud. You are expected to be on camera during virtual interviews. We reserve the right to take your picture to verify your identity and prevent fraud. By proceeding, you authorize the collection, processing, and use of your biometric data for identity verification and security purposes.

About Our Work

We are GDIT. A global technology and professional services company that delivers technology solutions and mission services to every major agency across the U.S. government, defense and intelligence community. Our 26,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 50+ countries worldwide, offering leading mission-ready capabilities in AI, cloud, cyber and software development.

Join our Talent Community to stay up to date on our career opportunities and events at gdit.com/tc.

Equal Opportunity Employer / Individuals with Disabilities / Protected Veterans Opportunity Owned From working with technologies like AI, cyber and cloud to careers in intelligence and health, we offer endless opportunities to apply your expertise to create a safer, smarter world.

For more information about GDIT's Privacy Policy, click here: Privacy Policy | GDIT