jobholds

Senior Oracle PL/SQL Analyst

الولايات المتحدة , • تاريخ النشر: 2022-04-08 • 5 مشاهدة

تفاصيل ومتطلبات الوظيفة

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
شارك هذه الوظيفة مع زملائك ومجموعاتك:

ملخص الوظيفة

المجال / التصنيف تكنولوجيا المعلومات
الدولة الولايات المتحدة
المدينة
نوع الدوام دوام كامل
إعلان وظيفة موثوق ومعتمد تم التحقق من بيانات الإعلان لضمان تجربة تقديم آمنة ومباشرة للباحثين عن عمل.