PL SQL Developer/Data Analyst

Recooty; Oak Court (MD); On-site; USD 100,000 - 130,000; Full time

Job summary

A technology firm is seeking a PL/SQL Developer to design and develop applications using PL/SQL for Oracle products. The role involves analyzing existing applications, collaborating with stakeholders, and maintaining documentation. Ideal candidates will have over 12 years of SQL and PL/SQL experience and an active Oracle certification. This position is located in Maryland, with focus on enhancing database performance and supporting business strategies.

Qualifications

• Experience in SQL and PL/SQL programming for over 12 years.
• Ability to work in an agile, self-motivated environment.
• Strong analytical skills for data model evaluation and enhancement.

Responsibilities

• Analyzing, testing, and debugging PL/SQL applications.
• Designing and implementing new Oracle objects.
• Maintaining documentation for data models and programming objects.
• Collaborating with different business units for alignment on data initiatives.

Skills

Oracle PL/SQL certification

SQL programming (12+ years)

PL/SQL programming (12+ years)

Strong analytical skills

Agile environment experience

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
• AssistingBusiness 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
• Understandingof 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