Senior Oracle PL/SQL Analyst

Description

Job Description:

Leidos is seeking an experienced Oracle PL/SQL Analyst with significant experience with Oracle Federal Financial, Delphi and conversion of Oracle Discoverer reports and extractions. 

High Priority qualifications, skills, experience, certifications

• Oracle PL/SQL

• Oracle Federal Financial experience

Role and Responsibilities

• The selected candidate must have advanced skills in programming Procedure Language /Structured Query Language (PL/SQL) and Oracle Federal Financial.  Significant experience with government financial systems such as Delphi or other Government accounting systems is desired, as well as the technical knowledge to investigate and resolve issues with current procedures related to the various Oracle Federal Financial modules. 

• Writing, troubleshooting, and tuning of PL/SQL Procedures with the understanding of Oracle Federal Financial and Delphi system Modules. 

• Leverage JDBC/ODBC connections to Delphi to convert current Oracle Discoverer reports/extractions into scheduled procedures, as Federal agencies like FAA plan to sunset Oracle Discoverer.

• Provide guidance in using RESTful API with current and future software applications to meet current and future system needs.     

• Investigate system problems as they occur, recommend, and implement solutions. Troubleshoot ETL processing issues, offer and/or implement solutions.

• Develop, test, and release system solutions into production in coordination with  the Management Systems department.

• Identify, track, and troubleshoot broader data warehouse issues as they relate to up-stream systems within the Federal Government. Draft system problem reports and submit IT Service Requests through the IT ticketing and tracking system on behalf of Management, as well as track and escalate issues that cannot be resolved internally to FHWA.

• Test changes to existing software made by others to determine if there will be any negative impacts to the existing BI data warehouse.

• Assist in identifying BI system changes required when processes are changed by ESC.

• Assist in implementing changes to Data Warehouse and BI Reporting when processes change.

Qualifications and Education Requirements

• Requires BS and 4 – 8 years of prior relevant experience or Masters with 2 – 6 years of prior relevant experience. Additional 10 plus years of experience may be considered in lieu of a degree.

• 8 Years of relevant experience

Pay Range:

#Remote

About Leidos

Leidos is a Fortune 500® technology, engineering, and science solutions and services leader working to solve the world’s toughest challenges in the defense, intelligence, civil, and health markets. The company’s 45,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $14.4 billion for the fiscal year ended December 30, 2022.  For more information, visit www.Leidos.com.

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here.

Securing Your Data

Beware of fake employment opportunities using Leidos’ name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the Leidos.com automated system – never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other personal information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected].

If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Commitment to Diversity

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.