Talent.com
PL SQL Developer / Data Analyst

PL SQL Developer / Data Analyst

Tiye ConsultingAnnapolis, Maryland, United States
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.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
  • APPLY

    serp_jobs.job_alerts.create_a_job

    Analyst • Annapolis, Maryland, United States