PL/SQL Developer / Data Analyst

Job Details

Role: PL/SQL Developer / Data Analyst

Location: Hybrid (Annapolis, MD) ; 3 days remote ; 2 days onsite

Duration: 12-month contract

SCOPE 

Analyzing, testing, debugging and repairing PL/SQL based applications & packaging and configuring Oracle object components for deployment

Required Skills 

• Active Oracle PL/SQL certification
• Twelve (12) or more years of SQL programming experience
• Twelve (12) or more years of PL/SQL programming experience
• 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.
     

TASKS
 

• 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 & 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