DBA ETL Developer, Associate

Location: Bethesda MD (2 Days Onsite May increase as Client needs change)

Position Title: DBA / ETL Developer Associate

Clearance: Public Trust

Job Overview: LCG is seeking a DBA / ETL Developer Associate who will support Clients ITAC by providing enterprise database engineering ETL development and data modernization services across mission-critical applications and data platforms. This role is responsible for maintaining data integrity resolving production data issues developing and optimizing ETL pipelines supporting database modernization and migrations and ensuring compliance with federal data governance security and audit requirements. The DBA / ETL Developer will work closely with application development teams Enterprise Architecture cybersecurity analytics and DevOps stakeholders to ensure reliable performant and traceable data solutions throughout the full SDLC in alignment with ITAC standards and delivery processes.

Key Responsibilities

Database Engineering & Data Integrity

• Provide back-end database fixes for data errors including root cause analysis data correction scripts and validation to restore data accuracy and integrity across environments.
• Design implement and maintain database objects including tables views indexes constraints stored procedures and functions in accordance with ITAC database standards.
• Support auditability and traceability by ensuring database changes are documented versioned and recoverable in alignment with ITAC governance processes.

ETL Development & Data Integration

• Design develop and maintain ETL pipelines and integrations supporting data ingestion transformation and outbound data delivery across internal and external systems.
• Produce and maintain ETL Design Documents describing extract transform and load logic data flows mappings error handling and performance considerations.
• Implement ETL solutions using approved ITAC tooling (e.g. SSIS Azure Data Factory or equivalent) supporting both batch and near-real-time data processing.
• Develop and maintain API-based data integrations ensuring secure reliable data exchange and alignment with enterprise integration patterns.

Performance Optimization & Query Tuning

• Analyze database performance and implement query optimization indexing strategies execution plan tuning and schema improvements to meet performance SLAs.
• Support database performance testing capacity planning and tuning activities as part of release readiness and production validation.

Data Migration and Modernization

• Support data migration and transformation activities for system modernization initiatives legacy system replacements and cloud or platform transitions.
• Assist with data model evolution including conceptual logical and physical data models (CDM LDM PDM) and maintain associated data dictionaries.
• Align database and ETL solutions with ITAC data governance and modernization strategies ensuring consistency with enterprise architecture guidance.

Schema Versioning & Change Management

• Maintain schema versioning and controlled database change management using Liquibase ensuring repeatable auditable deployments across environments.
• Develop and manage DDL scripts stored in ITAC-approved repositories supporting rollback recovery and controlled release execution.

Analytics Reporting & Data Consumption

• Support analytics and reporting needs by delivering clean well-modeled and performant data structures optimized for reporting and downstream consumption.
• Collaborate with reporting and analytics teams to resolve data issues optimize queries and ensure data consistency across dashboards and reports.

Security Compliance & SDLC Participation

• Support cybersecurity and compliance requirements including secure data handling access controls and support for RMF-aligned audit artifacts.
• Participate in Agile/SAFe ceremonies contributing to sprint planning backlog refinement defect resolution and PI execution.
• Maintain database and ETL tasks defects and technical debt in Jira ensuring traceability to user stories and acceptance criteria.

Requirements

NIH Experience preferred.

Experience

• 610 years of hands-on professional experience as a DBA and/or ETL Developer supporting enterprise systems.
• 3 years experience designing and supporting ETL pipelines and data integrations.
• 3 years experience performing database performance tuning and optimization in production environments.
• 2 years experience supporting data migration or modernization initiatives.
• 2 years experience working in a regulated or compliance-driven environment (Federal/Government preferred).

Education: Bachelors degree preferred in Computer Science Information Systems Data Engineering or a related technical discipline (or equivalent professional experience).

Certifications

• Database certifications (e.g. Oracle SQL Server PostgreSQL or equivalent)
• Data or cloud platform certifications (Azure/AWS/GCP)
• Security or data governance certifications (nice to have)

Compensation and Benefits

The projected compensation range for this position is $100000 to $150000 per year benchmarked in the Washington D.C. metropolitan area. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors including but not limited to role location the combination of education/training knowledge skills competencies certifications and work experience.

LCG offers a competitive comprehensive benefits package which includes health insurance options (medical dental vision) life and disability insurance retirement plan contributions as well as paid leave federal holidays professional development and lifestyle benefits.

Devoted to Fair and Inclusive Practices

All qualified applicants will receive consideration for employment without regard to sex race ethnicity age national origin citizenship religion physical or mental disability medical condition genetic information pregnancy family structure marital status ancestry domestic partner status sexual orientation gender identity or expression veteran or military status or any other basis prohibited by law.

If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position contact our Human Resources department by email at.

Securing Your Data

Beware of fraudulent job offers using LCGs name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from oremails not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information contact us immediately at.

If you believe you are the victim of a scam contact your local law enforcement and report the incident to theU.S. Federal Trade Commission.