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
• SQL and Scripting Language (R, Python) knowledge will be a plus.
• Proficiency in business intelligence tools (Tableau, Power BI) is a plus
• Experience with Big Data tools a plus