Oracle Engineer

Oracle Engineer *As required by our governmental client, this position requires being a US Citizen or Permanent Resident AND an active VA Public Trust CLEARANCE or the ability to obtain this clearance* The Oracle 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. Compensation & Benefits: Estimated Starting Salary Range for Oracle Engineer: $100-130k Pay commensurate with experience. Full time benefits include Medical, Dental, Vision, 401K, and other possible benefits as provided. Benefits are subject to change with or without notice. Oracle Engineer Responsibilities Include: 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. Performs other job-related duties as assigned Oracle Engineer Experience, Education, Skills, Abilities requested: 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. Must pass pre-employment qualifications of Cherokee Federal Preferred Qualifications: 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. Company Information: HESFP LLC is a part of Cherokee Federal – the division of tribally owned federal contracting companies owned by Cherokee Nation Businesses. As a trusted partner for more than 60 federal clients, Cherokee Federal LLCs are focused on building a brighter future, solving complex challenges, and serving the government’s mission with compassion and heart. To learn more about HESFP, visit cherokee-federal.com. #CherokeeFederal #LI-RG1 #LI-REMOTE Cherokee Federal is a military friendly employer. Veterans and active military transitioning to civilian status are encouraged to apply. Similar searchable job titles: Oracle Database Administrator (Oracle DBA) Oracle Database Engineer Oracle Applications Engineer Oracle Middleware Engineer Oracle E-Business Suite (EBS) Engineer Keywords: Oracle Database (19c/21c) PL/SQL Oracle RAC Oracle Data Guard Oracle GoldenGate Legal Disclaimer: All qualified applicants will receive consideration for employment without regard to protected veteran status, disability or any other status protected under applicable federal, state or local law. Many of our job openings require access to government buildings or military installations. Please Note: This position is pending a contract award. If you are interested in a future with Cherokee Federal, APPLY TODAY! Although this is not an approved position, we are accepting applications for this future and anticipated need. Apply To This Job