PL/SQL Developer
Location: Pittsburgh, PA, us
Company 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.
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
Qualifications
Bachelors in Computer Science, MIS or related field of study.
Additional Information
Local candidates preferred. Immediate interview and placement!
There are more than 50,000 engineering jobs:
Subscribe to membership and unlock all jobs
Engineering Jobs
60,000+ jobs from 4,500+ well-funded companies
Updated Daily
New jobs are added every day as companies post them
Refined Search
Use filters like skill, location, etc to narrow results
Become a member
🥳🥳🥳 452 happy customers and counting...
Overall, over 80% of customers chose to renew their subscriptions after the initial sign-up.
To try it out
For active job seekers
For those who are passive looking
Cancel anytime
Frequently Asked Questions
- We prioritize job seekers as our customers, unlike bigger job sites, by charging a small fee to provide them with curated access to the best companies and up-to-date jobs. This focus allows us to deliver a more personalized and effective job search experience.
- We've got over 200,000 jobs from 15,000+ vetted companies. No fake or sleazy jobs here!
- We aggregate jobs from 15,000+ companies' career pages, so you can be sure that you're getting the most up-to-date and relevant jobs.
- We're the only job board *for* software engineers, *by* software engineers… in case you needed a reminder! We add thousands of new jobs daily and offer powerful search filters just for you. 🛠️
- Every single hour! We add 2,000-3,000 new jobs daily, so you'll always have fresh opportunities. 🚀
- Typically, job searches take 3-6 months. EchoJobs helps you spend more time applying and less time hunting. 🎯
- Check daily! We're always updating with new jobs. Set up job alerts for even quicker access. 📅
What Fellow Engineers Say