Database Engineer/ Database Administrator

General Dynamics Information Technology•USA MD Home Office (MDHOME), MD

20h•$102,000 - $138,000•Remote

About The Position

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.

Requirements

Bachelors Degree in Computer Science, Data Science, or Information Systems or related field
5+ years of related experience
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.

Nice To Haves

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)

Responsibilities

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.

Benefits

Comprehensive benefits and wellness packages
401K with company match
Competitive pay
Paid time off
Full flex work week
Variety of medical plan options, some with Health Savings Accounts
Dental plan options
Vision plan
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.
Variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave.
15 days of paid leave per calendar year to be used for vacations, personal business, and illness
10 paid holidays per year
Paid leave and paid holidays are prorated based on the employee’s date of hire.
Paid Family Leave program provides a total of up to 160 hours of paid leave in a rolling 12 month period for eligible employees.
Short and long-term disability benefits
Life insurance
Accidental death and dismemberment insurance
Personal accident insurance
Critical illness insurance
Business travel and accident insurance