Oracle PlSQL Developer

Position: Oracle Pl/SQL Developer

Location: Annapolis, MD, 21401 Onsite Hybrid

Duration: 12+ Months Contract

Job Description:

RESOURCE QUALIFICATIONS

• The Offeror shall propose a resource that meets the following minimum 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.

RESOURCE SHALL BE RESPONSIBLE FOR THE FOLLOWING:

• Analyzing, testing, debugging, and repairing existing PL/SQL based applications.
• Analyzing new business rules and interfaces 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.

RESOURCE(S) SKILLS, EXPERIENCE, & CAPABILITIES

Need resource possessing the following preferred skills, experience, and capabilities:

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.

Skills :