Senior Engineer – Oracle – VA LGY

PhoenixTeam is seeking a Senior Engineer – Oracle to develop and maintain database solutions for the Department of Veterans Affairs Loan Guaranty program. The role involves writing and optimizing PL/SQL stored procedures and SQL queries, diagnosing data issues, and collaborating with cross-functional teams to ensure data accuracy and system reliability.

Responsibilities:

• 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

Requirements:

• 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
• 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