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