Oracle EBS System Administrator Resume

SUMMARY:

Oracle Database Administrator/ Developer and Oracle Applications System Administrator - - 17 years of experience with Oracle database administration, backup strategy planning and implementation, performance tuning, database design, PL/SQL development, BI development, interface development (in php and pl/sql) and 3 years of experience with Oracle Applications System Administration

PROFESSIONAL EXPERIENCE:

Confidential

Oracle EBS System Administrator

Core team member for Oracle EBS implementation project—full ERP suite implementation including financials (GL, AP, AR, Cash, Cost, Tax), manufacturing, customer service, engineering, inventory, and procurement
Oracle EBS System Administration- Security management, concurrent program development and administration
XML Publisher report development
Interface development in pl/sql and php for Global Warranty, Bravo, JP Morgan Supply Chain Finance, and Khalix
EIS (Enterprise Integration Solutions) Administration, report development, and training development and deployment to developers and users
Incident and issue troubleshooting management with users and vendors (Oracle, EIS, Hitachi)
Data extracting, cleansing and uploading from Mapics ERP to Oracle EBS

Confidential

Database Engineer/ Developer

Installed, configured, upgraded, patched Oracle 11g databases on Windows
Developed automated Oracle install and database creation process for software install/ implementation
Developed in SQL and PL/SQL including views, packages, procedures, functions, triggers
Developed Disaster Recovery Fail Over procedure as an RMAN scripted/ automated process
Designed data models for functionality implementation and scalability
Developed and Delivered training on Oracle Database Administration, disaster recovery, and performance tuning

Confidential

Oracle Database Administrator

Installed, configured, upgraded Oracle 10g databases on Windows and IBM AIX platforms
Administered Oracle 10g production and test databases on Windows and IBM AIX platforms
Developed scripts, queries, and reports in SQL and PL/SQL for data extraction and manipulation
Developed integration procedures and processes for integrating acquired companies ERP data structures and history into the Mapics Point.Man ERP environment
Configured, scripted and managed database backups using RMAN—including developing and testing restore procedures
Created new databases, users, roles, tables, views, triggers, packages, procedures, functions, materialized views, directories
Maintained test database environments using rman replicate and datapump export/import
Monitored performance and tuned environments using AWR and SQL
Developed scripts for data uploads and scrubbing using SQL*Loader
Installed, configured, and managed Oracle Client environments on all Windows environments including Windows 7 with ODBC install and configuration
Installed and configured Oracle 11i in testing environments on Windows
Provided database interface assistance for integration with Cognos, Vertex, Optio, Business Intelligence, Crystal Reports, Warranty Central, EM-Web, and various web applications
Created and managed Oracle 10g databases with ASM diskgroups

Confidential

Applications Developer/ Consultant

Developed training courses and manuals and provided training instruction for MarkView with Oracle Applications Work flow
Developed MarkView to Oracle Applications Workflow interfaces in PL/SQL
Provided customer site implementation technical support and development consulting

Confidential

Systems Services Consultant

Installed and configured Oracle Database Software on Windows - versions 7.3.3, 8.1, 8i, 10g
Created oracle databases and set up for production, testing, implementation
Replicated and refreshed databases using export/ import and scripting
Installed and configured Oracle Client software on Interface servers, local PC’s, Terminal Servers
Provided technical support for Oracle database issues, data corruption, disaster recovery
Developed and delivered training on Oracle Database Administration for Point.Man ERP, Business Intelligence Query and Report Development, Point.Man Data Modeling, and SQL scripting