Database Engineer III

About Us

eSimplicity is modern digital services company that work across government, partnering with our clients to improve the lives and ensure the security of all Americans—from soldiers and veteran to kids and the elderly, and defend national interests on the battlefield. Our engineers, designers and strategist cut through complexity to create intuitive products and services that equip Federal agencies with solutions to courageously transform today for a better tomorrow for all Americans.

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, andoperate 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-baseddata 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