Description
Job Description:- Must have strong Oracle PL/SQL application development skills and excellent knowledge of Stored Procedures, Functions, Packages, Triggers, Views, Materialized Views, Cursors, and XML features and writing and tuning complex SQL queries.
- Additionally, experience with Java stored procedures, pipelined functions, autonomous transactions and error handling is highly desirable.
- Experience in Implementing data models and database designs
- Experienced with Stored procedure creation/debugging/optimization/tuning
- Writing and creating data load scripts and stored procedures; ensuring that data is loaded in a timely manner daily
- Working with application developers to assist in database design, query tuning, index assignment, and trigger and procedure creation
- Ability to research and troubleshoot application problems using PL/SQL programming skills
- Ensuring that the integrity of company databases is maintained
- Actively helping our Data Integrity team reconcile data
- Excellent communication skills; works well in a team environment
- No DBA responsibilities, purely a development position
Minimum Required Skills/Competencies:
- 5-8+ years Software Development experience
- 5-8+ years Designing and developing applications on Oracle RDBMS
- 5+ years of experience in complex stored procedure creation and using performance tuning techniques
- 4+ years of experience in creating and maintaining SQL code for medium to large OLTP applications
- Preferred Skills: SQL Server
- PL/SQL, Performance tuning
- Oracle 11 & 12G environment
- Source Control
- Good Communication Skills
- Open to any past industry as long as candidate's developer skills are good
- Seeking 5+ years with OLTP. The more experience, the better.