Description
Job Description:- 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
- Ensuring that the integrity of company databases is maintained
- Actively helping our Data Integrity team reconcile data
- 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
- Ability to research and troubleshoot application problems using PL/SQL programming skills
- Excellent communication skills; works well in a team environment
- 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
- 6-8 years Application Development Experience.
- 6-8 years experience using 3 or more development languages or tools (eg, C#, ASP.NET, J2EE Application Framework, Siebel, Oblix, etc.)
- 6-8 years experience designing and developing applications
- Wireless industry experience desirable