Job Brief: A PL/SQL Developer is a specialist in Procedural Language which is a proprietary extension of SQL (Structured Query Language) developed by Oracle.
PL/SQL is designed specifically to work in the Oracle database environment.
A PL/SQL Developer designs, develops, and integrates new software and automation techniques using PL/SQL for Oracle products.
The PL/SQL Developer tests and implements new software and consults with other programmers and developers while supporting end users needs and documenting all database projects and processes.
Responsibilities: 1.
Analyzing, testing, debugging and repairing existing PL/SQL based applications 2.
Analyzing new business rules and interfaces in order to design and implement new Oracle objects 3.
Preparing and maintaining documentation on new and existing data models 4.
Preparing and maintaining documentation for new and existing programming objects 5.
Packaging and configuring Oracle object components for deployment across Development, Test, and Production Database Environments 6.
Working with Architects and Oracle DBA staff to establish standards for developing and deploying Oracle object 7.
Assisting Business Intelligence staff with reporting requirements and solutions 8.
Collaborating with stakeholders across different business units to align data initiatives with business strategies 9.
Evaluating and enhancing SQL performance 10.
Preparing regular and ad hoc reports including weekly project report of progress and status, weekly time and additional reports as requested 11.
Breaking down complex programming concepts into organized and concise units 12.
Understanding relational data concepts and the ability to apply these concepts to concrete solutions 13.
Development skills with Oracle PL/SQL (Packages, Functions, Procedures, Triggers), Materialized Views, DBLinks, and Oracle Jobs 14.
Experience with Reverse Engineering and Refactoring PL/SQL code, Data Warehouse/Data Mart design, Asynchronous event-driven applications 15.
Knowledge of BI publisher, Java syntax, SQL Server Reporting Services (SSRS), XML syntax and parsing, and domain knowledge of court-related concepts and business activities Skills Required: 1.
Active Oracle PL/SQL certification 2.
Twelve (12) or more years of SQL programming experience 3.
Twelve (12) or more years of PL/SQL programming experience 4.
Work in an agile, self-motivated environment with multiple, concurrent priorities 5.
Strong analytical skills for evaluating, documenting, and enhancing existing and new data models #J-18808-Ljbffr