jobholds
Senior Oracle PL/SQL Analyst
United States , Portland
•
Posted: 2022-04-08
•
4 Views
Job Overview & Requirements
Summary 100% Remote NJVC is seeking an experienced Senior Oracle PL/SQL Analyst with significant experience with Oracle Federal Financial, Delphi, and conversion of Oracle Discoverer reports and extractions. Responsibilities Write, troubleshoot, and conduct tuning of PL/SQL procedures with an 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. Other duties as assigned Qualifications Bachelor’s degree in computer science or related field or equivalent 4+ years of additional experience can substitute a degree 8+ years of relevant experience Background check with the ability to obtain a public trust clearance The position requires a COVID vaccination or an approved accommodation/exemption for a disability/medical condition or religious belief Knowledge, Skills and Abilities Ability to program Procedure Language/Structured Query Language (PL/SQL) and Oracle Federal Financial. Work with government financial systems, like 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. Ability to work independently and yet be effective within a team setting. Must be capable of managing multiple efforts with time related constraints in a fast-paced contracting environment. Demonstrated ability to effectively communicate and collaborate with diverse internal and external stakeholder groups and individuals. Friendly presence, helpful attitude, good interpersonal skills, and ability to work well with others.Excellent skills in Microsoft Word, Excel, and other Office applications. Experience working in a home office setting as well as the ability to train end users on frequently asked technical issues. Ability to provide technical assistance and support over the phone with good phone skills and a professional demeanor. Previous customer service experience strongly desired. Good problem-solving skills with the ability to visualize a problem or situation and think abstractly to solve it.
NJVC, LLC
NJVC, LLC
Similar Jobs in this Field
ViiV (GSK) US Competitive Intelligence & Market Research Lead
United States
View →
Remote Support Engineer – Night Shift
United Kingdom
View →
Primary Technical Support Engineer
Philippines
View →
Services Partner Deployment Specialist
Philippines
View →
Senior IT Project Manager
Qatar
View →
Senior Manager Quality Assurance
Qatar
View →
IT Project Manager - Consultant
Qatar
View →
D&it Affiliates Advisor
Saudi Arabia
View →
Þmo Site Engineer
United Kingdom
View →
Principal Software Engineer
United States
View →
Job Summary
Category
IT
Country
United States
City
Portland
Employment Type
Full Time
Verified & Trusted Listing
Listing details are verified for a safe and direct job application experience.