Oracle Data Analyst
Technical leadership for a large Oracle ERP installation.
Works on day to day functional support activities relating to Master Data normalization, rationalization, cleansing, loading and validation.
Functions as application administrator for patches, bug fixing, performance tuning and upgrades.
Effectively communicates and guides business users by providing functional knowledge of Oracle EBS R12.
Administer and maintain the performance of Oracle applications including installation, performance tuning, patching, cloning, backups, system administration and upgrades. Administer support and maintain Oracle Data Bases – creation, monitoring, data base tuning / reorganization, troubleshooting, and management of all application programs / updates. Manage and direct 3rd party Database offsite partner.
Provides on-call support at off-hours in case of production issues and work with offshore team for Oracle EBS, Physical Inventory loads, database cleansing.
Provides production support to business users in US and in multiple time zones Executes collateral tasks (data preparation, SQL programming, deployment, etc.) Independently supports various domains (specifically Oracle R12 ERP environment)
Designs, develops and maintains EiS (Reports), Data Services (ETL) and required interfaces
Skills and Abilities:
Experience in PL/SQL, UNIX/Linux scripting, Oracle Forms, RMAN, JAVA,
Experience with Oracle Apps version 12, Demantra & OBIEE
Has strong functional knowledge expertise Oracle and supplemental systems such as Oracle Developer, etc.
Experience with Oracle databases 8i, 9i, 10g & 11g, Understanding of tables & table spaces, Indexes, Views / Materialized views, Triggers, Forms personalization, hardware sizing.
Experience with reporting tools (e.g., Oracle Reports, Discoverer, XML Publisher, Oracle Forms, Apex
Experience developing custom applications extensions using Oracle Developer 10g tool kit and Workflow 2.6.
Excellent organizational skills with the ability to plan, organize, delegate and control work.
Experience with documentation of formal functional and technical design specifications Experience utilizing a structured software development life cycle approach, including a deep understanding of standard software development practices
Experience with documentation of training/user education materials
Development, Functional Design and analysis experience
Extract Transform Load (Etl)
Recovery Manager (Rman)