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

Sponsorship: No sponsorship assistance is available for this position now or in the future.

Job Title: Database Developer, Senior

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.

• 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.

• Develop and maintain scalable ETL jobs and data pipelines that extract, transform cleanse, validate, reconcile, and load data from enterprise applications, relational databases, APIs, flat files, cloud platforms, and third‑party data sources.
• Build and support ETL workflows using applicable technologies such as SQL Server Integration Services (SSIS), Azure Data Factory, AWS data‑integration services, Oracle Data Integrator, Python‑based pipelines, scheduling tools, or comparable enterprise ETL platforms.
• Design and maintain secure database links, connectors, and integration patterns across Oracle, SQL Server, MySQL, and other application data sources, enabling reliable distributed data access and near‑real‑time data retrieval.
• Implement and support cross‑system data migrations, ensuring accurate, auditable, secure, and efficient…