PROFESSIONAL SUMMARY

• I.T. Professional with over 8 years of Senior Oracle Database Administration Experience
• Experience functioning as Team Lead/Database Manager for over 5 years managing up to 22 onshore/offshore resources
• Possess the following Oracle Certifications: Oracle OCA, Oracle OCP, Oracle 11i, Oracle 10g, and MS SQL Server 2008
• Experience utilizing Oracle Version 8i, 9i, 10g, and 11i
• Highly skilled in implementation of, managing, and maintaining all production and non-production Oracle Databases 9i, 10g and EPBS 11i GL, AR, AP, PO, Assets modules
• Experience managing and leading the initiatives in high availability environments performing performance tuning, capacity planning, RMAN, RAC, load balancing, clustering, backup/recovery, and production support
• Experience performing installations, troubleshooting, maintenance, and 24X7 on multi-platforms
• More than 10 Conversion of databases as following: DB2 to Oracle, MSQL to Oracle, Image DB to Oracle. Image DB to MSQL, MSQL to Oracle, KSAM files to Oracle.
• Conversion of JCL to UNIX korn shell scripts for Linux, HP-UX, Sunsolaris.

TECHNICAL SUMMARY

• SOFTWARE: Oracle 11i, 10g, 8i, 9i, Oracle EPBS Financial Applications AP AR GL PO 11.5.10, 12r, Microsoft SQL Server 2000/2005/2008, OEM, TOAD, RMAN, Erwin, Data Modeling, Plsql, SQL Loader, COBOL, COBOL II, MicroFocus , JCL, Crystal Reports, HP-UX,Linux, VI, MSOffice, MS Access, Statspack, Windows, Reporting Services, Jesta Evision Manufacturing.
• Testing Tools : WinRunner 8.0/7.5/7.0/6.5, LoadRunner 8.0/7.5/7.0 VMWare
• Test Management Tools : Mercury Quality Center, TestDirector 8.0/7.5/7.0/6.0
• Hardware: HP9000, AIX, LINUX, Windows 2000, 2003 HP3000, AS400, IBM/S38, IBM/S36, PC

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Oracle DataBase Administrator/Database Manager

• Managed and maintained all production and non-production Oracle Databases 9i, 10g and EPBS 11i GL, AR, AP, PO, Assets modules
• Served as an Oracle Lead Database Administrator managing 4 other DBA's and 25 instances on 7 different nodes with 215 remote locations spread across the country.
• Served as Technical Project Manager on 200G heavily customized Oracle Financials Database upgrade from 9.4.2 to 10.7.
• Installed 11.5.10, including Financials, Purchasing and Public Sector Financials.
• Upgraded 11.5.9 to 11.5.10.
• Applied Supply Chain Management Family Pack J 11.5.10 , which includes the PO and OPM modules.
• Migrated from a 11.5.9 Windows/Unix environment to 11.5.9 Linux
• Patched 11.5.9 RAC installation, including Financials and OPM modules.
• Installed and patched four 11.5.9 instances, including 9 foreign languages and Discoverer 4.1.48.06.
• Upgraded and supported multi-country, multi-language 11.5.8 to 11.5.9 installation of virtually all financial and discrete manufacturing modules, including DP, ASCP, Call Center and Email Center.
• Performed 11.0.3 to 11.5.8 upgrade with migration from HP-UX to Linux Suse 7 SLES.
• Oracle 11i experience includes, 11.5.5 install and upgrade to 11.5.7 with the Forms, and Web Server running on Windows 2000/NT and the Database, Reports and Concurrent Managers on a second Windows 2000 node.
• Ran 3 instances on a two-node configuration.
• Performed an 11.5.7 install.
• Oracle 11i experience includes, 11.5.5 install and upgrade to 11.5.6 with the Admin, Forms, Reports and Web Server running on Windows 2000/NT and the database on an IBM AIX node.
• Oracle 11i experience includes, 10.7 to 11.5.5 upgrade on IBM AIX.
• This is a 130Gig, heavily customized installation, including modules GL, AP, AR, FA, PO, HR/Payroll and OPM.
• Oracle 11i experience includes, 4 months installing and patching 5 instances of 11.5.4 on a Compaq Tru64 node, supporting 2 developers, 3 functional consultants and 50 users, implementing GL, AP, FA, INV, BOM, MRP, WIP, PO and I Procurement.
• Developed automated process for nightly cloning of the production Oracle 11i instance.
• Oracle 11i experience includes, installing 11.5.2 and then upgrading to 11.5.3, 4 instances run on 3 IBM AIX nodes.
• Performed DBA services on a 24X7 Baan Financials and Manufacturing worldwide installation.
• Performed over 2 dozen restores and time-based recoveries.
• Concurrently managed 7 Baan instances, 5 Oracle HR/Payroll on AIX and 6 custom internet instances running on Windows NT.
• Performed numerous Oracle Database and Tools upgrades from RDBMS version 5 through 9.2.0.4.
• Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems.
• Create test web servers, web listeners, form servers, concurrent managers, and databases from the production environment for 11i.
• Troubleshoot problems with web server, web listener, forms server, concurrent managers, and database on 11i.
• Apply applications patches.
• Make changes to standard Oracle Applications forms and reports using designer/developer for testing purposes as advised by Oracle Support.
• Upgrade from 10g to 11i.
• Upgraded Oracle 9i database to Oracle 10g and implemented sever partitioning with Oracle10g to enable Oracle Applications 11i to work with 10g.
• Create custom concurrent requests to perform database maintenance.
• Write Korn shell scripts to monitor and maintain the Oracle Applications database.
• Write SQL scripts to monitor tablespace and extent growth.

Confidential

Senior Oracle DBA/Team Lead

• Functioned as an Oracle Team Lead leading and directing the initiatives for 5 resources 3 in the U.S. 2 in the U.K.
• Utilized database designer, database architecture planning, design and implementation support maintenance for various Oracle HP-UX systems.
• Installed and updated Oracle 8i, 9i ,10g for Windows and HPUX
• Created shell scripts to automate problem determination and notification Oracle 9i databases, and resolved intermittent database problems.
• Setup backup using RMAN
• Completed various migrations of data from a customized database to Oracle 8i, 9i 10g for Global Logistics Supply Chain Management.
• Oracle Apps 11i DBA implementing and supporting Oracle Financials Suite AP AR GL PO 11.15.10 running on AIX and HP-UX
• Reviewed existing databases and made performance tuning recommendations.
• Refined Oracle replication process that extracted, ASCII data files, remote Oracle databases and pushed the data into a data warehouse
• Made performance improvement changes to existing SQL.
• Created shell scripts to monitor various application processes as well as to created Oracle 9i databases and resolved intermittent database problems.
• Reviewed existing databases and made performance tuning recommendations.
• Establish, document, and publish hardware and software specifications, standards and configurations to ensure that the technology stack is maintained and leveraged.
• Engineer and administer tech stack configurations for Windows NT/2000/2003 environment throughout the enterprise.
• Performed analysis, design, coding, and testing of Microfocus COBOL programs and PL/SQL objects.
• Converted mainframe COBOL programs to Oracle PL/SQL programs.
• Conversion and migration of few databasesDB2 to Oracle, MSQL to Oracle, Image DB to Oracle. Image DB to MSQL, MSQL to Oracle, KSAM files to Oracle.
• Experience with Oracle Recovery Manager, UNIX operating systems, database server clustering, UNIX shell scripting, creating new jobs, scheduling jobs, and setting job notifications/alerts. Installed, upgraded, patched and configured a few RAC Servers, defined storage allocation, flash recovery area, enable archiving and flashback database.
• Wrote RMAN scripts to performed Level 0 and Level 1 Incremental backups to the flash recovery area and to restore duplicate databases using RMAN scripts as well.
• Created the RMAN Catalog and register all databases in it.
• Identify performance bottleneck on high volume transaction systems. Analyze SQL statements by using explain plan and tkprof, generate statspack reports and tuned most waited events.
• Provide DBA support for Oracle Application project support includes Cloning, patching
• Performed System Administrator for various Linux OS AIX 5L, RHEL ,HP-UX Financials
• Excellent ability in writing specifications and gathering requirements from the user to develop crystal reports as per the needs of the client and maintain documentation of the reports for future reference.
• Created reports using Crystal Reports with Standard, Summary, Cross Tabs, SQL, Command Objects, Selection Criteria, grouping, sub reports etc.
• Worked with SQL and PL/SQL, Toad to study the data in different systems and to validate reports
• Created Tables, Constraints, Database Triggers, Database Links, Views, Indexes, Synonyms and Sequences using TOAD
• Used TOAD extensively to create and modify procedures, packages, tables, indexes etc.
• Used for session info, tuning, schema browsing etc.
• Evaluated new releases of Oracle Database 10g and 10g R2.

Confidential

Senior Oracle Database Administration/Team Lead

• Functioned in a Team Lead role leading and directing the initiatives for up to 22 resources onshore and offshore
• Created Oracle 9i, 10g databases and resolved intermittent database problems.
• Reviewed existing databases and made performance tuning recommendations.
• Converted mainframe COBOL programs to Oracle PL/SQL programs.
• Refined Oracle replication process that extracted data from remote HP3000 to Oracle databases and pushed the data into a data warehouse.
• Made performance improvement changes to existing SQL. Migration of various Image DB to Oracle 9i to be use for SAP applications.
• Participated in the team than migrate the Supply Chain Management from HP3000 to Oracle 9i 11i on HP-UX.
• Refined Oracle replication process that extracted , ASCII data files, remote Oracle databases and pushed the data into a data warehouse.
• Identify performance bottleneck on high volume transaction systems.
• Analyze SQL statements by using explain plan and tkprof, generate Statspack reports and tuned most waited events.
• Conversion and migration of few databases: Image DB to Oracle, Image DB to MSQL, MSQL to Oracle, KSAM files to Oracle.
• Experience with Oracle Recovery Manager, Oracle Parallel Server/RAC, UNIX operating systems, database server clustering, UNIX shell scripting, creating new jobs, scheduling jobs, and setting job notifications/alerts.
• Installed, upgraded, patched and configured a few RAC Servers,
• Defined storage allocation, flash recovery area, enable archiving and flashback database.
• Establish, document, and publish hardware and software specifications, standards and configurations to ensure that the technology stack is maintained and leveraged.
• Engineer and administer tech stack configurations for Windows NT/2000/2003 environment throughout the enterprise.
• Wrote RMAN scripts to performed Level 0 and Level 1 Incremental backups to the flash recovery area and to restore duplicate databases using RMAN scripts as well.
• Created the RMAN Catalog and register all databases in it.
• Develop thorough understanding Distribution/Logistics, Finance, and Manufacturing modules, system and its interfaces using HP 3000 COBOL/COBOLII PowerHouse COGNOS , IMAGE, RDBMS, KSAM/, ALLBASE , SQL, SUPERTOOL, MPEX, Maestro, QUERY, Oracle 9.1.
• Provided ongoing maintenance services for production applications, Schedule and monitor the production of periodic files/reports for outside organizations and regulatory agencies on HP3000, HP9000, Oracle 9.1.
• Participated on various legacy application migrations to Unix, NT, WIN2K and Oracle 9i.
• Use UltraEdit as developer tools to edit, modify and change text , batch, HTML ,Java, XML and SQL files
• Displayed excellent search ability in writing specifications and gathering requirements from the user to develop crystal reports as per the needs of the client and maintain documentation of the reports for future reference.
• Developed Crystal Reports for Invoices for all us, Canada and Latin American regions.
• Worked with the end users and higher management to gather requirements for reports and data analysis.
• Worked with SQL and PL/SQL, Toad to study the data in different systems and to validate reports.
• Created Tables, Constraints, Database Triggers, Database Links, Views, Indexes, Synonyms and Sequences using TOAD
• Used TOAD extensively to create and modify procedures, packages, tables, indexes etc.
• Used for session info, tuning, schema browsing etc.

Confidential

Programmer Analyst

• Create and maintain of COBOL, Powerhouse COGNOS , Transact HP3000. SQL, SUPRTOOL, Oracle, MPEX, QUERY, VPLUS, PowerHouse Quick, Quiz, QTP , including extensive JCL, POS System.
• Developed on-line programs which reduce process line and save time for the accounting department GL, AR, Invoicing, Buyers,
• Act as project leader for the development of various project Purchase order, Inventory, sales, receiving, Picking Packing, Delivery tickets, shipping .
• Team leader in various project, investigate alternatives to identify/recommend best design prepare flowcharts, wrote detailed specifications, developed practical solutions to problems, Y2K conversion.

Confidential

Programmer/Analyst

• Designed and implemented a new system enhancements
• developed on-line message system for user
• Develop and executive information system on the mainframe using COBOL/AS400, SQL, JCL
• Team Leader in various project assign become very familiar with mainframe production environment.
• Maintained and supported the existing COBOL mainframe on-line and batch systems
• Design and implementation of new system enhancements
• Maintained/Expanded client base
• Responsible for network administration Windows NT , word processing, mailing process, financial packages, programming debugging.

Confidential

Junior Programmer

• Created or changed programs COBOL S/36 AS400, CICS, JCL.
• Responsible of system administration, create and change JCL.
• Designed and maintained screen menus programs for all departments as requested.
• Maintained and monitored tape drives, back-ups, microcomputers, process.
• Assisted senior programmer on projects, design flowchart and write program documentations.
• Wrote all JCL from NCR to IBM/36 conversion project.