Oracle - PL/SQL Engineer
Integral Federal1 day ago
Tysons, VA, USAMid Level / Senior
Base Salary
$130k - $140k/yr
Responsibilities
- Maintain, debug, enhance, and tune Oracle SQL/PLSQL packages, procedures, triggers, views, queries, and database components.
- Diagnose production incidents involving Oracle logic, data integrity, batch jobs, application interfaces, and reports, coordinating fixes with Java engineers and system administrators.
- Reverse engineer legacy database relationships and undocumented business rules, then document validated findings for VA-EISS development teams.
- Support source-to-target mapping, data profiling, cleansing, ETL, reconciliation, and repeatable migration rehearsals from Oracle legacy sources to VA-EISS targets.
- Preserve historical relationships, auditability, authorization controls, and records-retention requirements.
- Develop version-controlled and tested database fixes and migration scripts, contributing to regression, integration, security, and deployment evidence.
- Support coexistence, case-attrition data transfers, duplicate-detection lookups, and authorized legacy retirement activities.
Requirements
- Bachelor’s degree in computer science or an IT-related degree and 4–7 years of experience; additional years of experience may substitute for the degree for the right candidate.
- Ability to analyze and modify stored procedures, packages, triggers, SQL queries, and relational schemas without compromising data integrity.
- Experience diagnosing application and database defects, Oracle performance issues, and dependencies on services or scheduled data exchanges.
- Experience with source-to-target mapping, data validation, and reconciliation for legacy-system modernization.
- Working knowledge of Git/source control, regression testing, secure SDLC, and documented production change procedures.
- Public Trust eligibility or suitability is listed as a qualification.
- Preferred experience includes Oracle Forms, Java/JDBC, WebLogic or related enterprise interfaces, Oracle Data Integrator, GoldenGate, AWS DMS/Glue, SQL Server/T-SQL or comparable migration tools, federal records or case-processing systems, and VA-approved cloud, DevSecOps, and AI-assisted analysis tools subject to human review.
Benefits
- Medical, dental, and vision insurance.
- Flexible spending accounts.
- Short-term and long-term disability insurance.
- Life insurance.
- Paid time off and holidays.
- Paid parental leave.
- Immediate vesting in the 401(k).
- Earned bonuses and awards.
- Professional training reimbursement.
- Employee assistance program.
About Integral Federal
Integral Federal provides IT and mission support services to U.S. defense, intelligence, and civilian agencies, with offerings in cybersecurity, identity intelligence/biometrics, cloud, and systems engineering. Headquartered in McLean, Virginia and privately held, it operates on government contracts and task orders, including work supporting U.S. Army biometric systems and fielding activities.