Senior Engineer – Oracle – VA LGY
Location
United States
Posted
5 days ago
Salary
$80K - $110K / year
No structured requirement data.
Job Description
Senior Engineer – Oracle – VA LGY
Overview
The Senior Engineer – Oracle – VA LGY develops and maintains database solutions that support mission-critical applications for the Department of Veterans Affairs Loan Guaranty (LGY) program. This role is responsible for writing and optimizing complex PL/SQL stored procedures and packages, and SQL queries, diagnosing and resolving data issues, and supporting the development and execution of comprehensive test plans to ensure data accuracy and system reliability.
The engineer collaborates with cross-functional teams to troubleshoot data problems, analyze database performance, and design efficient queries using analytic functions, Common Table Expressions (CTEs), and other advanced Oracle features. The position requires strong analytical skills, attention to detail, and the ability to work independently while contributing to scalable and secure data solutions. Success in this role requires a bachelor’s degree and 6 years of relevant experience (or equivalent), excellent written and verbal communication skills, and the ability to manage complex technical challenges in a collaborative environment.
Key Functions
Develop and maintain PL/SQL procedures, packages, and complex SQL queries within Oracle databases.
Diagnose, analyze, and resolve data quality or data integrity issues within LGY systems.
Design and execute complex database queries using analytic functions, Common Table Expressions (CTEs), and other advanced SQL constructs.
Create and execute comprehensive test plans to validate database logic, data transformations, and system integrations.
Analyze database performance and optimize queries for efficiency and scalability.
Collaborate with developers, analysts, and stakeholders to troubleshoot issues and support application functionality.
Use database development tools such as TOAD or Oracle SQL Developer to manage queries, analyze performance, and troubleshoot database issues.
Document database processes, queries, and troubleshooting procedures to support maintainability and knowledge sharing.
Prepare and review solution options with technical leads to resolve complex data or system challenges.
Maintain positive working relationships with the client and delivery team while supporting mission-critical systems.
Minimum Qualifications
Bachelor’s degree and 6 years of relevant experience.
An additional 2 years of experience with an Associate’s Degree.
An additional 4 years of experience with a high school diploma.
Strong experience writing complex SQL and PL/SQL in Oracle databases.
Experience diagnosing and analyzing complex data issues in enterprise systems.
Experience designing and executing complex test plans for database logic and data validation.
Strong understanding of analytic SQL functions and when to apply Common Table Expressions (CTEs) in complex queries.
Experience using database development tools such as TOAD or Oracle SQL Developer.
Excellent verbal and written communication skills.
Strong attention to detail with proven analytical and problem-solving skills.
Ability to shift focus between competing priorities in a fast-paced environment.
Demonstrates leadership in the face of ambiguity and works proactively to drive issues to resolution.
Preferred Qualifications or Skills
Oracle Database SQL Certified Associate or Oracle Certified Professional certification.
Existing Public Trust clearance at the Department of Veterans Affairs or other federal agency.
Experience supporting federal government or Department of Veterans Affairs systems.
Experience working within large enterprise data environments.
Familiarity with mortgage or financial services systems.
Experience using JIRA and Confluence.
Position Details
Employment type: Full-Time, W2
Location: 100% Remote (US-based)
Hours: 40 hours/week with availability during core business hours of 8am–5pm ET
Start date: ASAP
Eligibility: Must be eligible to obtain a Public Trust clearance
Salary: $80,000 – $110,000
Location
Arlington, Virginia (Remote)
Employment Type
Full-Time
Minimum Experience
Experienced
Compensation
$80,000 – $110,000
Related Guides
Related Job Pages
More Backend Engineer Jobs
The role involves leading the design and implementation of robust, large-scale web scraping platforms using Python, while also mentoring junior developers and conducting code reviews. Responsibilities include developing sophisticated strategies to handle anti-bot countermeasures and optimizing scrapers for performance and stability.
This role involves providing specialist API support and acting as a subject matter expert for connectivity operations, including conducting analysis and technical troubleshooting to resolve complex issues. Responsibilities also include monitoring key metrics, serving as a technical point of contact for partners, and contributing to knowledge base improvements.
A Senior Middleware Developer is responsible for designing, developing, and maintaining the software infrastructure that ensures seamless communication and data flow between various applications and systems. Key duties involve installing and configuring middleware, building integration solutions, resolving production issues, and implementing necessary security measures.
The Lead Consultant will develop high-quality software solutions while providing technical leadership and mentorship to team members, guiding project execution to align with client needs and best practices. Responsibilities include leading the design and development of solutions using modern .NET technologies, architecting scalable applications, and driving technical decision-making.
