Integral Federal

Oracle - PL/SQL Engineer

Integral Federal
Apply
1 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.

Tech Stack

AWSGitJavaMicrosoft SQL ServerSQL

Categories

BackendData Engineering
Integral Federal

About Integral Federal

51-200 employees

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.

Contact me