Roles & Responsibilities
- Extensive experience with Oracle Object Design and implementation management and deployment of Oracle Packages, Procedures, Function, Triggers, User Defined Types.
- Proficient in writing PL/SQL procedures with experience using Cursors, Collections, Nested Tables, Bulk Processing, etc
- Ability to create and modify all Oracle Data Definition Language (DDL) such as tables, indexes, constraints, packages, procedures, functions, views, synonyms, sequences, etc
- Possess Strong analytic and troubleshooting skills
- Background with optimizing existing jobs using SQL & PL/SQL tuning methodologies and toolkits
- Ability to maintain, troubleshoot, optimize and improve existing database applications and database objects
- Demonstrated experience providing database development support to Web-based applications
- Ability to produce technical documentation per program guidelines and policies
- The ability to understand the application of database design principles
- Experience with Data migration between oracle databases
- Experience with SQL * Loader, database export, import features
- Knowledge in MS SQL Server database
Requirements:
- Minimum Bachelor Degree
- 3-6 years’ experience writing PL/SQL and complex SQL supporting business applications
- Knowledge of Oracle 10g/11i databases
- Experience in logical and physical data modelling in support of a fielded business application
- Experience with UNIX shell scripting a plus
- Experience with Big Data tools a plus