PROFESSIONAL SUMMARY:

• An experienced Oracle database administrator with more than 25 years hands - on experience in building, managing and supporting Oracle databases starting from 6 to 11 versions and on various OS platforms with different high availability configuration including Disaster Recovery;
• Extensive experience in installation, upgrades and patching in Oracle Application R10 to 12
• Experienced in Installation and configuration of Fusion middleware.
• Experienced in Siebel, OBIEE database maintenance.
• Ready, willing, and able to deliver either independently or collaboratively
• Proven fast learner, resourceful and excellent troubleshooting skills
• Extensive DBA support provided to business - critical applications and had established commendable working relationships with internal and external clients
• Demonstrated timely project completions;
• Mentored younger DBAs contributing to team efficiency
• Implemented Disaster Recovery for all Oracle Databases and applications.
• More than 25 years of total experience in administration, analysis, design, development and implementation of software applications using Oracle and its different tools.
• Over 20 years of extensive experience as an Oracle Database Administrator and 12 years as Oracle Applications Database Administrator.
• Very strong in database creation, performance tuning of logical and physical design, disk space management, database tuning, Parallel server configurations and security management, backup & disaster recovery activities, installation and upgrade of database/Application as well as managing the object and system privileges.
• Well conversant in Oracle Applications installation, upgrades, patching and maintenance.
• Exposed to GL, AP, AR, INV, FA, MRP, WIP, OE and PO modules.

TECHNICAL SKILLS:

TOOLS: OEM, SQL Server Manager, Shareplex Replication Tool

RDBMS: Oracle, 11.x,10.x,9.x,8.x/7.x/6.0, progress, MSQL Server

LANGUAGES: SQL, PL/SQL, RPGII, RPG400

SOFTWARE: Fusion Release 10 and 11, Oracle Finance Applications Release 11.x, 12.x & 10.7, Smart Client 16.1, NCA, Release 11& 12, Oracle Applications Server, HP OpenView, Net 8, Forms, Reports SQL*Loader, SQL*Report Writer,SQL*DBA/SVRMGR, Export/Import, OEM, SQL*Net2,Oracle Terminal Mapping, Designer 2000, Developer2000, Oracle Application Server

O/S: Solaris, Red Hat Linux, Windows NT 4, Windows 95, 98 & XP, DOS, SSP, OS400, AIX, NCR SVR4 Unix, DOS, HPUX11.0 and 11.23, Windows 2000

HARDWARE: Sun Spark Servers, Confidential Blade Server, COMPAQ Prosignia 500, COMPAQ Proliant 5000/5500/6000 , IBM S/34, S/36, AS/400, RS/6000, NCR 4000, PC”s, IBM Netfinity, HP9000 Servers

EXPERIENCE:

Confidential

Senior Database Administrator (Oracle DBA/Oracle Applications DBA)

Responsibilities:

• Responsible for Oracle Systems and UNIX Servers
• Experienced on Oracle technology architecture Oracle E-Business Suite/ Oracle Application DBA.
• Installation and Configuration of FUSION Middleware.
• Communicating Between Vendors Users & Management
• Working with Oracle Support and writing tars and solve the problems
• Installation, configuration and support, upgrade of Oracle Applications
• Management of Production database systems, migration of Database and Disaster Recovery
• Performance monitoring, Instance tuning, SQL tuning
• Hot/Cold backup mechanisms for weekly and daily backup
• Oracle Concurrent Managers Configuration and management
• Oracle Apps Patch Management and Patch Migration Process
• Unix Administration, Instance cloning
• Provide future direction and guidance on application deployment/support plans
• Porting of Oracle Database across different OS Platforms

Environment: Solaris, RH Linux, PCs Clients, Win XP, Widows, Oracle Applications 11 & 12, Fusion 10 & 11, OEM

Confidential

Senior Business Systems Administrator (Oracle DBA/Oracle Applications DBA)

Responsibilities:

• Overall Responsible for Oracle Systems and UNIX Servers
• Gained Strong knowledge and experience on Oracle technology architecture Oracle E-Business Suite/ Oracle Apps DBA.
• Communicating Between Vendors Users & Management
• Working with Oracle Support and writing tars and solve the problems
• Installation, configuration and support, upgrade of Oracle Applications
• Management of Production database systems, mitigation of Database and Disaster Recovery
• Performance monitoring, Instance tuning, SQL tuning
• Hot/Cold backup mechanisms for weekly and daily backup
• Oracle Concurrent Managers Configuration and management
• Oracle Apps Patch Management and Patch Migration Process
• Unix Administration, Instance cloning
• Oracle Support processes for technical requests with Metalink
• Provide future direction and guidance on application deployment/support plans

Environment: HP 0 & rp3440Server, PC Clients, Win XP, Widows 2000, HPUX & Oracle Applications 11

Confidential

Oracle Database Administration/Oracle Applications DBA

Responsibilities:

• Installation of Oracle Applications Releases 10.7, 10.7 NCA, 11 on three tire architecture Oracle Web Server Configuration to run the Application on the Internet.
• Application of patches for Oracle Application
• Security and Maintenance of Oracle Application
• Oracle Parallel server configurations for Oracle Fail save
• Database tuning and attending to database related problems.
• Used export and import utilities
• Recreation of Rollback segments with Optimal Size.
• Cleaning up of the database (removing unwanted data, tables and freeing space)
• Helping the application programmers in writing Database procedures and triggers.
• Upgrading from Oracle 7.3 to Oracle 8.
• Configuration of Net 8.
• Archival of Information from application Tables Periodically

Confidential

Technical Consultant/Oracle Database Administrator

Responsibilities:

• Installation and maintenance of the client Oracle Application Rel 10.7 database
• Tuning the Production Database
• Upgrade the database as well as Application to the latest versions
• Configuring and setting up the printers
• Implemented the security and disaster recovery procedures
• Created Users, Groups and profiles with restriction to menus and options
• Created Views, procedures, triggers and functions for the developers to customize the forms and reports

Environment: COMPAQ Server, AST Clients, Win NT 4.0/95/98, Oracle 7/8 & Oracle Financial R10.7 & R11

Confidential

Technical Consultant/Oracle Database Administrator

Responsibilities:

• Hardware Configuration prepared by me based on the clients requirements
• Installation of database as parallel server for fail safe
• The application was installed on a three tire architecture
• Web server configuration for the application to be accessed using internet browser
• Maintenance of the Oracle Application Rel. 11.0.5 after the client went on production
• Tuning the Production Database
• Upgrade the database as well the Application to the latest versions
• Configuring and setting up the printers
• Implemented the security and disaster recovery procedures
• Created Users, Groups and profiles with restriction to menus and options
• Recreated RBS for the clients requirements
• Created Views, procedures, triggers and functions for the developers to customize the forms and reports

Environment: COMPAQ Proliant 5500,6000 Servers, Windows NT 4, Windows 95/98, Oracle 8 & Oracle Financial R11.0.5 web server Application with parallel option.

Confidential

Technical Consultant/Oracle Database Administrator

Responsibilities:

• Installation of database as parallel server for fail safe
• The application was installed on a three tire architecture
• Web server configuration for the application to be accessed using internet browser
• Tuning the Database after installation
• Upgrade the database as well the Application to the latest versions
• Configuring and setting up the printers
• Implemented the security and disaster recovery procedures

Environment: NCR 4000 Servers, NCR UNIX 3.2, Windows 95, Windows 98, Oracle 7.3.4.5 & Oracle Financial R10.7 NCA Web server Application with Parallel server option.

Confidential

Technical Consultant/OracleDatabase Administrator

Responsibilities:

• Hardware Configuration prepared by me based on the clients requirements
• Installation of database 8.0.5 for the Oracle Application
• The application was installed on a three tire architecture
• Web server configuration for the application to be accessed using internet browser
• Maintenance of the Oracle Application Rel. 11.0.5 after the client went on production
• Tuning the Production Database
• Upgrade the database as well the Application to the latest versions
• Configuring and setting up the printers
• Implemented the security and disaster recovery procedures
• Created Users, Groups and profiles with restriction to menus and options
• Recreated RBS for the clients requirements
• Created Views, procedures, triggers and functions for developers to customize the forms and reports

Environment: COMPAQ Proliant 5500, 6000 Servers, Windows NT 4, Windows 95/98, Oracle 8 & Oracle Financial R11.0.5 web server Application.

Confidential

ORACLE Database Administrator/Systems Analyst

Responsibilities:

• I was involved in the ORACLE Database administration of the twenty-eight databases in depots throughout Gulf including installation, maintenance, disaster recovery, security, tuning and backups.
• As systems analyst I was involved in the project implementation of sales, cash and receivable systems in all twenty-eight depots in Gulf.
• The system is developed using front end SQL windows and the ORACLE 7 database runs on Windows NT and clients ORACLE SQL*NET using TCP/IP.
• The above Database Administration and Systems Analyst work was done to Confidential a leading Dairy manufacturing and Distribution Company in GULF that holds more than fifty percent market share.

Environment: COMPAQ Prosignia 500 and IBM Netfinity Servers, Windows NT and Windows 95.

Confidential

ORACLE Database Administrator

Responsibilities:

• Installing ORACLE server and tools.
• Communicating with ORACLE Corporation when the technical support is needed.
• Maintenance of ORACLE license agreement and reviewing on new products.
• Create or alter tables, views, RBS, table spaces, add data files, stored Procedures on databases and transfer of applications from the development instance to production instance once the developer has completed development, testing and the end user acceptance is signed.
• Creating users, rolls and maintaining the system security including the database and the OS access (RS/6000 AIX).
• Study and prepare capacity requirement planning and recommend on hardware upgrade to hardware personal.
• Monitoring Database and optimizing the performance.
• Performing periodical data archival to an external storage device.
• Planning and executing periodical Database backups.
• Performing periodic disaster recoveries to check the reliability of the backup.

Environment: IBM RS/6000, IBM Power Server, X terminal, PC’s, AIX, Xwindows Emulation Software

Project Manager/Systems Analyst

Confidential

Responsibilities:

• Communicate with management and users regarding ORACLE projects and set-up target dates.
• Plan for new systems and keep management and user informed regarding the progress of design, development and implementation.
• Assign projects to systems analyst, programmers and assist them in designing development and testing. Reviewing weekly progress and report.
• Communicate with other Confidential Companies regarding the new plans and strategies using Lotus Notes and cc: Mail.
• Implemented standard information supply structure at Confidential Limited, which is designed and developed by Confidential London for global data transfer, and global reporting.
• Designed and developed and implemented national payroll system that is used for multiple companies. ( Confidential, Lipton’s Confidential and Walls Confidential ).
• Involved in the wide area network implementation between the customer, sales representative and the company server using the modem and dialup facility.
• Designed and implemented the automated time recording system using SHAHO time recording terminals with integration to national payroll.
• Overall responsible for AS/400 system applications. (FAMAS400 and Online Invoicing system).

Environment: IBM RS/6000-ORACLE/AIX FORMS 3, Reports ver. 1, IBM AS400, OS400, RPG400, DDS, CLP, SQL, RLU, IBM Power Server, X terminal, PC’s

System Analyst

Confidential

Responsibilities:

• Analyzed, designed and developed online National payroll system using ORACLE server and Tools to cater for multiple companies with payroll, loans, taxation, provident fund, budgeting, management reporting and miscellaneous payments modules.
• Analyzed, designed and developed Human Resource system using ORACLE server and Tools which could be used for multiple companies with attendance, leave, training, cadre maintenance and management reporting modules.
• I handled installation and maintenance of ORACLE server and Tools on RS/6000.
• Maintenance of FAMAS400 system handled.
• AS/400 Payroll system maintenance was handled until the ORACLE National payroll was completed the system written using RPG400.
• Maintenance of AS/400 online sales invoicing and statistical reporting system was maintained until the new MFG/PRO distribution module was implemented.
• Involved as a team member in MFG/PRO Raw material/production forecast, inventory and production planning system on RS/6000 using PROGRESS and interfacing with AS400 Sales invoicing and statistical systems.

Environment: RS/6000, AS400, ORACLE, PROGRESS, TCP/IP, AIX, SQL, RPG400