Build, tune, and operate database processing for a mission-critical financial system supporting the Federal Government in healthcare. Design and maintain Oracle PL/SQL packages to ingest large XML/EDI files and automate recurring production data delivery. Requires 5+ years of Oracle experience, expertise in performance tuning, and the ability to pass a U.S. public trust clearance.
Key Highlights
Own and execute a portfolio of recurring data validation and reporting processes on a production schedule
Tune queries against very large partitioned tables with hundreds of millions of rows
Modernize reporting workloads and replace manual spreadsheet processes with automated workflows
Key Responsibilities
Own and execute a portfolio of recurring data validation and reporting processes, delivering accurate results on schedule.
Design, write, and maintain Oracle PL/SQL packages and procedures that ingest and validate large XML and EDI files.
Turn ad-hoc client data requests into correct, well-documented query results and extracts under short turnaround.
Tune queries against very large partitioned tables and diagnose and recover failed batch jobs.
Manage changes through a formal release process with documented testing, security review, and approval gates.
Document builds for knowledge transfer and mentor junior developers.
Interested in remote work opportunities in Development & Programming? Discover Development & Programming Remote Jobs featuring exclusive positions from top companies that offer flexible work arrangements.
Technical Skills Required
Oracle SQL
PL/SQL
Amazon Web Services
Benefits & Perks
Medical, dental, and vision coverage
401(k) retirement benefits
Paid time off
Paid holidays
Life and disability insurance
Wellness and employee support programs
Remote work
Browse our curated collection of remote jobs across all categories and industries, featuring positions from top companies worldwide.
Nice to Have
Experience working in regulated/Government environments, especially in the healthcare domain
Familiarity with healthcare enrollment, claims, or payer financial data
Experience with Databricks, PySpark, or migrating Oracle workloads to a cloud data platform
Experience with analytical and BI tools such as Power BI, Tableau, or Amazon QuickSight
Experience mentoring junior developers
Job Description
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.
Want the full job description?
Read the complete details on LinkedIn, the original posting.
Continue on LinkedIn
This is a short excerpt. All rights to the full description belong to its original publisher.