Job Description :
Job Requirements:
5-10 years experience in Oracle backend database development utilizing packages, procedures, function, triggers and Oracle user defined types.
2+ years of experience in data warehousing.
Strong Data Warehousing experience, Oracle partitioning, collection objects.
Strong Oracle PL/SQL skills (strong knowledge of Oracle 10g/11g/12c
Strong Oracle Performance tuning skills (SQL tuning
Strong knowledge of common Oracle tools (PL/SQL Developer, TOAD, SQLPlus
Strong ability to use Python scripting for data transfer and manipulation.
Familiarity with Oracle RAC preferred.
Familiarity with VPD (Virtual Private Database) is a plus.
Proficient in working with: Collection objects, Nested Tables, Record types, Cursors, Ref Cursors, Views, Materialized Views, Partitions, FORALL, Bulk Collect, Regular Expressions, Triggers, Instead Of Triggers, Autonomous Transactions.
Ability to build ER Diagrams for new tables.
Ability to write complex stored procedures/triggers, functions using PL/SQL to optimize processes performance with the goal to reduce processing time.
Ability to tune complex queries utilizing Indexes, Hints, and Explain Plan to improve the performance of the application.
Ability to design and maintain data extraction & transformation processes (ETL
Working knowledge with XML, JSON preferred.
Familiarity with NoSQL database (eg. MongoDB) is a plus.
Familiarity with Agile methodology is a plus.
Should possess excellent written and oral communication skills.
Should have data analysis skills to debug, trace and fix problems.
Bachelor’s degree required.
Degree in Management Information Systems or Computer Science preferred.
Oil and Gas Industry experience preferred.
Required to be on-call during work and off-hours as necessary.
May travel when necessary for system implementation and training