Oracle - PL/SQL Engineer
Integral Federal
·Today
- Salary
- $130k – $140k/yr
- Location
- Tysons Corner, VA, US
- Type
- Full-time
- Department
- IT
- Seniority
- Mid
- Closing date
- Today
- Source
- iCIMS
Description
Overview
An Oracle Application / PL/SQL Sustainment Engineer for the VA Memorials Integration Services and Innovation (MISI) program. The engineer will sustain Oracle-based business logic and data services across assigned legacy National Cemetery Administration (NCA) applications while supporting the controlled transition of capabilities and authoritative records to VA-EISS 2.0.
Responsibilities
- Maintain, debug and enhance Oracle SQL/PLSQL packages, procedures, triggers, views, queries and, where deployed, Oracle Forms supporting assigned applications.
- Diagnose production incidents involving Oracle logic, data integrity, batch jobs, application interfaces or reports; coordinate end-to-end fixes with Java engineers and system administrators.
- Reverse engineer legacy database relationships and undocumented eligibility, interment, scheduling, memorial and reporting rules; document validated findings for VA-EISS development teams.
- Support source-to-target mappings, data profiling, cleansing, ETL, reconciliation and repeatable migration rehearsals from Oracle legacy sources to approved VA-EISS targets.
- Tune SQL and database components; preserve historical relationships, auditability, authorization controls and records-retention requirements.
- Develop version-controlled, tested database fixes and migration scripts; contribute to regression, integration, security and deployment evidence through VA-approved tools.
- Support VA-approved coexistence, case-attrition data transfers, duplicate-detection lookups and eventual legacy retirement when authorized.
Qualifications
Required:
- Bachelor’s Degree in computer science or an IT-related degree with 4-7 years' experience. Additional years of experience can substitute for a 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/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
Preferred:
- Oracle Forms and familiarity with Java/JDBC, WebLogic or related enterprise application interfaces.
- Oracle Data Integrator, GoldenGate, AWS DMS/Glue, SQL Server/T-SQL or comparable migration tools.
- Experience supporting federal records, eligibility/case processing, cemetery or memorial operations.
- Experience with VA-approved cloud, DevSecOps, and AI-assisted analysis tools subject to human review.
Salary range: $130,000-$140,000
This position is in the proposal stage. The above salary range represents a general guideline. Integral Federal considers a number of factors when determining base salary offers, such as the scope and responsibilities of the position and the candidate's experience, education, skills, and current market conditions.
Depending on the position, employees may be eligible for overtime, shift differential, and/or discretionary bonuses in addition to base pay.
Company Overview
Integral partners with federal defense, intelligence, and civilian leaders to tackle their most important challenges and deliver positive outcomes. Since our founding in 1998, we have helped clients leverage existing and emerging technologies to transform their enterprises, empower growth, drive innovation, and build sustainable success. The forward-leaning solutions we deliver are tailored to each mission with a focus on keeping our nation safe and secure.
Integral is headquartered in McLean, VA and serves clients throughout the country.
We offer a comprehensive total rewards package including paid parental leave and immediate vesting in our 401(k). Give us a try and become part of a curated group of professionals at Integral Federal!
Our package also includes:
· Medical, Dental & Vision Insurance
· Flexible Spending Accounts
· Short-Term and Long-Term Disability Insurance
· Life Insurance
· Paid Time Off & Holidays
· Earned Bonuses & Awards
· Professional Training Reimbursement
· Employee Assistance Program
Equal Opportunity Employer/Protected Veteran/Disability