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:
* Analyzing, testing, debugging, and repairing existing PL/SQL based applications.
* Analyzing new business rules and interfaces in order to design and implement new Oracle objects.
* Preparing and maintaining documentation on new and existing data models.
* Preparing and maintaining documentation for new and existing programming objects.
* Packaging and configuring Oracle object components for deployment across Development, Test, and Production Database Environments.
* Working with Architects and Oracle DBA staff to establish standards for developing and deploying Oracle objects.
* Assisting Business Intelligence staff with reporting requirements and solutions.
* Collaborating with stakeholders across different business units to align data initiatives with business strategies.
* Evaluating and enhancing SQL performance.
* Preparing regular and ad hoc reports including weekly project report of progress and status, weekly time and additional reports as requested.
* Breaking down complex programming concepts into organized and concise units.
* Understanding of relational data concepts and the ability to apply these concepts to concrete solutions.
* Development skills with Oracle PL/SQL (Packages, Functions, Procedures, Triggers), Materialized Views, DBLinks, and Oracle Jobs.
* Experience with: Reverse Engineering and Refactoring PL/SQL code, Data Warehouse/Data Mart design, Asynchronous event-driven applications.
* Knowledge of the following: BI publisher, Java syntax, SQL Server Reporting Services (SSRS), XML syntax and parsing, Domain knowledge of court-related concepts and business activities.
Skills Required:
* Active Oracle PL/SQL certification.
* Twelve (12) or more years of SQL programming experience.
* Twelve (12) or more years of PL/SQL programming experience.
* Work in an agile, self-motivated environment with multiple, concurrent priorities.
* Strong analytical skills for evaluating, documenting, and enhancing existing and new data models.
#J-18808-Ljbffr