Sr. SQL Developer

Location: Columbia, MD (Hybrid/Remote – MON & WED in the office)

Residency Requirement: Candidates must have lived in the U.S. for at least 3 of the past 5 years and be authorized to work in the U.S. (Citizen, Permanent Resident, or EAD).

Clearance: Public Trust Clearance (or ability to obtain)

Job Overview:

We are seeking a skilled and motivated Sr. SQL Developer to join our innovative IT team. In this role, you will build, tune, and operate the database processing behind a mission-critical, data-centric financial system supporting the Federal Government in the healthcare domain. The ideal candidate will have deep hands-on experience with Oracle SQL and PL/SQL at scale, large file-based data exchange, and AWS, and will deliver accurate, well-documented results on a recurring production schedule.

Responsibilities:

• Production data delivery: own and execute a portfolio of recurring data validation and reporting processes, delivering accurate results on schedule.
• Hands-on SQL/PL/SQL engineering: design, write, and maintain Oracle PL/SQL packages and procedures that ingest and validate large XML and EDI files, load staging and fact tables, produce outbound data files, and reconcile results across interfacing systems.
• Ad-hoc data analysis: turn ad-hoc client data requests into correct, well-documented query results and extracts under short turnaround, and explain the numbers behind them.
• Performance and reliability: tune queries against very large partitioned tables, diagnose and recover failed batch jobs, and replace manual, spreadsheet-based steps with automated, repeatable processes.
• Release discipline: take changes through a formal release process with documented testing, security review, and approval gates, and support them in production afterward.
• Knowledge transfer: document what you build so others can run it, mentor junior developers, and contribute to the modernization of reporting workloads onto modern cloud data platforms.