PL SQL Developer/Data Analyst

Tiye Consulting; Annapolis (MD); On-site; USD 110,000 - 140,000; Full time

Job summary

Tiye Consulting in Annapolis, MD is seeking an experienced PL/SQL Developer to design, develop, and integrate Oracle-based solutions.

You will test, document, and optimize PL/SQL objects, collaborate with Architects, DBAs, and BI teams, and help deliver data-driven automations across environments.

Qualifications

• Active Oracle PL/SQL certification.
• 12+ years of SQL programming experience.
• 12+ years of PL/SQL programming experience.
• Experience working in an agile, multi-priority environment.
• Strong analytical skills for data modeling and optimization.

Responsibilities

• Analyze, test, debug and repair PL/SQL based applications.
• Design and implement Oracle objects per new business rules.
• Prepare and maintain data models and documentation for programming objects.
• Package and configure Oracle components for deployment across environments.
• Collaborate with Architects and DBAs to establish development standards.
• Assist BI staff with reporting requirements and solutions.
• Collaborate with stakeholders to align data initiatives with business goals.
• Evaluate and optimize SQL performance.
• Prepare weekly project progress and status reports.
• Translate complex concepts into organized modules.
• Apply relational concepts to concrete solutions.
• Develop PL/SQL with Packages, Functions, Procedures, Triggers, MV, DBLinks and Jobs.
• Reverse engineering and refactoring PL/SQL; DW design; asynchronous events.
• Knowledge of BI Publisher, Java, SSRS, XML syntax; court domain knowledge.

Skills

Active Oracle PL/SQL certification

12+ years SQL programming experience

12+ years PL/SQL programming

Agile methodology experience

Analytical skills

Tools

BI Publisher

Java syntax

SSRS

XML syntax

Job description

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 object

• Assisting Business Intelligence staff with reporting requirements and solutions

• Collaborating with stakeholders across difference 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 agile, self-motivated environment with multiple, concurrent priorities

• Strong analytical skills for evaluating, documenting, and enhancing existing and new data models