PL/SQL Developer

Job Title

PL/SQL Developer

Work Location

Pittsburgh PA

Duration

06-12 month contract

Job Responsibilities

This is an application development role within the Enterprise Applications Record to Report (R2R) Forecasting and Analytics (FA) application support area of the USS Business Service Center (BSC). This position will work with the R2R FA team at the Muriel Street location primarily focused on developing and maintaining backend SQL and PL/SQL code for an Oracle Operational Data Store. This ODS is a component of USS’s Hyperion Costing Analytics (HYC) solution. R2R FA needs expert level SQL and PL/SQL skills to support and develop changes to the Oracle ODS. Though not a DBA role, assignments would also include creating and modifying Oracle table, view and index structures.

Major responsibilities

Analyze, design, develop, test, and implement solutions as part of the R2R FA systems development team.

Develop and maintain complex and optimized Oracle SQL, PL/SQL packages, stored procedures and functions.

Develop and maintain logical design of Oracle tables, views, indexes.

Work with R2R Application Architects and other team members to understand the application’s functional needs and requirements

Provide feedback on and adhere to delivery dates.

Identify potential process improvements and provide technical recommendations where appropriate.

Candidate Qualifications

College degree

Yes - Bachelors in Computer Science, MIS or related field of study.

Years of Work Experience

The candidate must have a minimum of 6 years of progressively more complex development experience with Oracle SQL and PL/SQL in a large scale information system environment.

Technical Skills Required

Proven experience and expertise in designing and developing complex and optimized Oracle PL/SQL packages, stored procedures and functions is a must.

Proven experience and expertise in designing and developing complex and optimized SQL code.

Proven experience and expertise in logical design and modification of Oracle database tables, views, indexes.

Proven experience and expertise in large volume, batch processing environment.

Ability to work independently from both detailed technical specifications and broader functional specifications depending upon the scale and complexity of assignment.

Prepare documentation of program development, modifications to code, testing in compliance with standard operating procedures and SOX requirements.

Personal Skills Required

Develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing to ensure overall functionality and technical quality of deliverables

Troubleshoot and debug technical issues and problems, monitor progress against plan, and communicate status to Leads

Must be able to communicate effectively, work in a team environment and think analytically.

Additional Skills not required but would be a plus:

Strong SQL tuning skills

Knowledge of Data Warehousing concepts

Familiarity with Oracle Data Integrator (ODI) or similar ETL tool

Familiarity with Hyperion Essbase or other multidimensional OLAP processing

Bachelors in Computer Science, MIS or related field of study.

Local candidates preferred. Immediate interview and placement!