Database Developer, Senior - LCG Inc.

OpenTalent; Rockville (MD); Hybrid; USD 110,000 - 160,000; Full time

Job summary

LCG, based in Rockville, MD, seeks a Senior Database Developer to design, implement, and optimize enterprise-scale database and data integration environments. You will work with Oracle, SQL Server, and MySQL, building ETL/ELT pipelines and secure data links across platforms.

You will also develop Power BI datasets and dashboards to provide operational and executive insights, focusing on data quality and performance. 5–7 years of senior experience and cloud familiarity are preferred.

Qualifications

• 5–7 years of senior-level enterprise database development, ETL engineering, analytics reporting, and data integration experience.
• Experience with Oracle, SQL Server, and MySQL including advanced SQL, PL/SQL, T-SQL, stored procedures, and performance tuning.
• Experience applying AI capabilities to database operations, data engineering, data quality, analytics, and SQL development is strongly desired.
• Familiarity with AWS and Azure cloud environments; relevant certifications such as Oracle Certified Professional or Microsoft certifications are preferred.

Responsibilities

• Design, develop, implement, and optimize advanced database scripts and workflows to support ETL/ELT and data integration.
• Tune and troubleshoot complex SQL queries, procedures, and jobs to maximize throughput and minimize latency across large datasets.
• Collaborate with engineering teams to model schemas, optimize data models, and ensure data quality and reporting performance.

Skills

Oracle

Microsoft SQL Server

MySQL

ETL

Data integration

Power BI

Python

Tools

Power BI

AWS

Azure

Job description

Job Title: Database Developer, Senior

Location: Rockville, MD

Work Type: Hybrid Work (Minimum 3 days Onsite - Could extend to 5 days due Client Needs)

Required Clearance: Ability to Obtain Public Trust

Job Overview

LCG is seeking a Senior Database Developer to design, implement, optimize, and support enterprise-scale database, data integration, analytics, and reporting environments. The successful candidate will have deep hands-on expertise with Oracle, Microsoft SQL Server, and MySQL, including advanced SQL, T-SQL, PL/SQL, stored procedures, database performance tuning, ETL development, and cross-platform data integration.

This role will build and maintain scalable ETL/ELT jobs and automated data pipelines that extract, transform, validate, and load data from multiple business applications, databases, APIs, files, and cloud-based systems. The developer will support batch operations, scheduled workflows, near-real-time integrations, data migrations, and secure database links across Oracle, SQL Server, and MySQL environments.

The Senior Database Developer will also develop Power BI datasets, semantic models, reports, and dashboards that consolidate data from multiple application sources and provide actionable operational, programmatic, and executive-level insights. The role requires an ability to design reliable data models, implement data-quality controls, and optimize reporting performance for large and complex datasets.

The ideal candidate brings 5–7 years of senior-level experience in enterprise database development, ETL engineering, performance tuning, analytics reporting, and data integration. Experience applying AI capabilities to database operations, data engineering, data quality, analytics, and SQL development is strongly desired. Familiarity with AWS and Azure cloud environments, as well as professional certifications such as Oracle Certified Professional, Microsoft SQL Server Certification, Microsoft Power BI Data Analyst, or relevant cloud/data certifications, is preferred.

Key Responsibilities

Database Development and Performance Optimization

• Design, develop, implement, and optimize advanced database scripts using SQL, T-SQL, PL/SQL, Python, shell scripting, and automation tools to support batch operations, scheduled jobs, ETL/ELT workloads, and data integration processes.


• Develop, tune, troubleshoot, and optimize high-complexity SQL queries, stored procedures, triggers, views, packages, functions, and database jobs to maximize throughput and reduce query latency across large datasets.


• Collaborate with software engineering and architecture teams to model relational and non-relational schemas; create efficient joins, indexes, partitioning strategies, and data-retention approaches; and support application performance requirements.

ETL/ELT, Data Integration and Migration