Description

PL/SQL Developer/Data Analyst

[Annapolis, MD] |   2023-08-30 15:08:23

Apply Now

Share Job 

Job Code : 2023-MY3TECH0995

PL/SQL Developer/Data Analyst

Annapolis, MD (Hybrid)

2-3 years Contract

 

Qualifications:

  • Active Oracle PL/SQL certification,
  • Twelve (12) or more years of SQL programming experience, and
  • Twelve (12) or more years of PL/SQL programming experience.

 

Scope of Work:

  • 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 report, and
    • Additional reports as requested.

 

Skills Experience & Capability:

  • The ability to:
    • Break down complex programming concepts into organized and concise units.
    • Work in an agile, self-motivated environment with multiple, concurrent priorities.
  • An 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.
  • Strong analytical skills for evaluating, documenting, and enhancing existing and new data models.
  • Experience with:
    • Reverse Engineering and Refactoring PL/SQL code,
    • Extraction, Transform and Load programming,
    • 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.

Key Skills
Education

Any Graduate