Oracle Engineer
SES Corporation
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
About the role
- The Oracle Engineer supports the VA LGY DevSecOps 2.0 program by developing and optimizing Oracle database solutions and integrations that enable mission-critical home loan systems.
- This role builds and maintains complex PL/SQL and SQL.
- Performs performance tuning and large data set optimization.
- Executes ETL/data migration and reconciliation activities.
- Ensures strong data validation, auditability, and integrity.
- The engineer collaborates with cross-functional teams to troubleshoot production issues in high-volume environments and supports API/integration work, including Salesforce-related integrations.
Requirements
- 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.
- 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.
Benefits
- Medical
- Dental
- Vision
- AD&D
- STD
- LTD
- Company paid Life Insurance
- 401k with employer contribution
- Paid Time Off
- Pet Insurance
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
PL/SQLSQLETLdata migrationdata validationperformance tuningdata integrityanalytic functionsCommon Table Expressionsdatabase optimization
Soft Skills
communication skillsattention to detailanalytical skillsproblem-solving skillsleadershipcollaborationability to manage competing prioritiestroubleshootingdocumentationknowledge sharing
Certifications
Oracle Database SQL Certified AssociateOracle Certified ProfessionalPublic Trust clearance