PL/SQL Developer

360 IT Professionals

Pittsburgh (Allegheny County)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

An IT consulting firm is seeking a PL/SQL Developer in Pittsburgh. This role involves developing and maintaining backend SQL and PL/SQL code for an Oracle Operational Data Store. Candidates should have a minimum of 6 years of experience in Oracle SQL and PL/SQL development and a bachelor’s degree in Computer Science or a related field. Local candidates are preferred, with immediate interview and placement available.

Qualifications

Minimum of 6 years of experience with Oracle SQL and PL/SQL.
Expert level skills in developing and maintaining Oracle database structures.

Responsibilities

Develop and maintain backend SQL and PL/SQL code for Oracle ODS.
Analyze and implement solutions for R2R FA systems.
Work with Application Architects to understand functional needs.

Skills

Oracle PL/SQL

SQL

Database design

Documentation skills

Analytical thinking

Education

Bachelors in Computer Science

Job description

360 IT Professionals is a California base Minority Business Enterprise specializing in the field of IT Consulting and Staffing. Since our Inception we have been providing industry leading IT solutions for Staffing and Software Development. We have more than 30 IT Staffing Services contracts across USA and working closely with Fortune 500 Companies and Key Private sector Agencies. We are providing staffing support to more than 10 State Customers across USA and have successfully staffed for more than 260 roles in last 6 months.

Job Description

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.

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