OBJECTIVE:

To obtain a position as Lead Oracle Core/Apps DBA or IT Infrastructure Architect

SUMMARY:

I have worked total 27 years out which initial 7 years I worked as Merchant Marine Officer onboard Ship and the other 20 years I worked in the Information Technology field. In the 20 years of my IT field I have worked as Lead Oracle Core DBA/Apps DBA for about 10 years and then as Oracle Apps DBA Team Lead/Oracle Apps DBA Manager/Director/IT Infrastructure Architect for about 10 years. In the course of my work I have developed tremendous expertise in problem solving skills, project management skills, people management skills and have saved lot of money for my clients, improved client relations, and have successfully implemented many projects both locally and globally. I have demonstrated skills of organizing the Database Systems and the DBAs to improve security, efficiency and performance, thereby reducing the system outages.

EXPERIENCE:

Lead Oracle Apps DBA (Consultant)

Confidential, San Antonio, TX

Responsibilities:

• Upgraded oracle ebs 11i, R12.1 to R12.2.6 and R12.2.3, R12.2.4, R12.2.5 to R12.2.6 and the database from 11.2.0.4 to 12.1.0.2 DB, ASM and RAC.
• Migrated Oracle Dbs and Applications from Physical Data centers to Cloud Computing environment on Amazon AWS Cloud, Microsoft Azure Cloud, SunGard Cloud, Oracle Cloud
• Implemented and supported Oracle ATG Web Commerce on OEL 6.3 & 10.3.6 (web logic Server) & 11.2.0.3 (database) with Oracle Business Intelligence 11.1.1.16.12
• Upgraded Oracle Enterprise Linux from version 4,5 to 6,7
• Did Oracle EBS 11i to R12 upgrade, Databases ver 7,8i, 9i, 10g to 11g,12c upgrade.
• Did Cross Platform Migrations of oracle databases 9i, 10g, 11g and Ebusiness suite application 11i and R12
• Did Installation and configuration of Oracle Fusion Middleware Applications SOA 11g, OBIEE 11g, 12c, OIM, OAM, OID 11g,12c and WebLogic servers 10.3.5, 10.3.6, 12.1.3(12c), Oracle Apex, Oracle ADF.
• Installed, configured and administered Oracle Application Express(APEX) version 2 to version 5
• Installed and Configured Oracle Enterprise Manager 12c, 13c with Oracle AMP for EBS and setup High Availability Cluster for OEM
• Did installation, configuration and administration Oracle RMS 13.2, Oracle GRC 5.5.1, Oracle AACG 8.6.3, Hyperion Essbase 11.1.1.4, 11.1.2.4, EPM FDM 11.1.2.2, 11.1.2.4, ATG & Endecca 11i
• Supported Oracle Databases and Ebusiness Suite Hosting Services, Supported Oracle Ebusiness Modules AP, GL, FA, HR, CRM, BILLING, BOM, OM, PO, HCM, INV, AR, Advanced Supply Chain Planning, Demand Planning, Global Order Promising, Inventory Optimization, Production Scheduling, MRP, Demantra, iExpense, Projects
• Installed, Configured and Administered Oracle Ebusiness suite R12.1.3, R12.2.6 on Oracle ASM 11.2.0.4, 12.1.0.2 and Real Application Cluster (RAC) db 11.2.0.4, 12.1.0.2
• Upgraded 9i RAC database to 11g, 12c RAC database and Migrated Oracle EBS R12 from one data center to another datacenter. Did RAT(Real application Testing) for oracle ebs envs
• Installed, Configured and Administered Oracle Golden Gate 11g.
• Upgraded oracle iLearning 5 to 6 and implemented Oracle UPK and integrated it with R12
• Implemented Oracle eBusiness Suite Single Sign on(SSO) with OAM 11.1.2, OID 11g, and eBusiness Gate 11g using Kerberos
• Installed, configured and administered Oracle Virtual Manager version 2.2, 3.03, 3.24
• Installed, configured and administered Oracle Enterprise Linux 4 32 bit, 5, 6 64 bit and 32 bit.
• Installed, Configured, Administered Oracle Enterprise Manager (OEM) Cloud control 12c, 13c
• Installed, Configured, Administered Oracle Exadata, did course on Oracle Exadata and provided support to env where oracle exadata was installed
• Did backup and crash recovery of OEL Servers and OVM servers
• Installed, configured and provided production support for ASCP and Demantra for 11i and R12.
• Did Setup of High Availability and Disaster Recovery for Oracle Applications like EBS, OBIEE, Hyperion, SOA, Identity Management and Databases for 99.9999% uptime.
• Migrated Oracle EBS R12 and other oracle databases and applications from Client’s Physical Datacenter to Amazon Cloud Workspace(AWS).
• Hands on Lead Oracle Core/Apps DBA, performing all Oracle Core and Apps DBA job functions which includes OBIEE, SOA and OIM

Environment: IBM AIX 64 bit 64 bit, 12 - core IBM Power 730, IBM System Z using Oracle Linux, EMC SAN (DMX & CX), IBM Linux 2.6, Windows XP, Vista, 2007, OBIEE 10g, 11g, Quest Stat, Quest foglight, TOAD 9.0, Discoverer 10g, Oracle 9i,10g,11g RAC db, Oracle OEM 10g, 11g, APEX, Microsoft Project, Visio, Oracle Apps 11.5.9, 11.5.10.2, 12.0.6, 12.1.3, Oracle AS10g, Oracle Fusion Applications SOA Suite 10g & 11g, OBIEE 11g, OIM 10g & 11g, VERITAS Cluster, Sun SPARC 64 bit, Exadata, Oracle EBS 12.2.5 and DB 12.1.0.2

Lead Oracle Apps DBA

Confidential, San Antonio, TX

Responsibilities:

• Did the upgrade and migration of Oracle 11i applications to R12 from Amstelveen in EMEA to San Antonio US Datacenter. Did the upgrade and migration lifecell Oracle 11i applications to R12 from New jersey Datacenter to San Antonio TX Datacenter.
• Provided support for 9i,10g, 11g Oracle Databases, upgraded from 9i to 10g to 11g databases
• Planned and upgraded the 11i oracle applications with 9i database to R12 Oracle Applications and Oracle RMS(Retail Merchandising System) R12.0 with 10g database in 24 hours, with HACMP failover and dataguard.
• Lead the dba team for failover to DR site during disaster recovery .
• Did project management and architecture design for moving the databases to ASM, RAC, moving the 11i Oracle apps to Oracle R12 apps and for implementing the Database security solution to be in compliance with SOX.
• Managed capacity planning and dealt with external vendors in purchases for database related software licenses and hardware
• Done R12 upgrades and Implemented migrations procedures and scripts from Test to QC and then from QC to Production to reduce manual effort and time spent on migrations.
• Designed, created and implemented Scripts to clone R12 Production to R12 QC, Dev and Test environments automatically without manual intervention.
• Installed, configured and administered Hyperion Essbase 11.1.1.2, EPM FDM 11.1.2.0
• Designed, created and implemented script to backup using BCV snaps and RMAN for Oracle Databases
• Installed and configured OEM to monitor and send critical paging alerts for Oracle Databases and Oracle R12 Applications.
• Modules supported, AR, AP, GL, OM, INV,CRM, Billing, ASCP, Demantra, PO, HCM
• Managed the OBI Team and performed the Installation and support of Oracle Business Intelligence 10g on 11g RAC database and supported it.

Environment: IBM AIX 64 bit 6.1, EMC SAN (DMX & CX), IBM Linux 2.6, Windows XP, Vista, TOAD 9.0, Discoverer 10g, Oracle 9i,10g,11g, MS SQL Server, DB2, Oracle OEM, APRO, APPWORKX, Microsoft Project, Visio, Oracle Apps 11.5.9, 11.5.10.2, 12.0.6, 12.1.3, Oracle AS10g, SOA

Lead Oracle Apps DBA

Confidential, Fairfield, New Jersey

Responsibilities:

• Implemented procedures for backup, recovery and disaster recovery of the Oracle databases. Planned and implemented security auditing policies and procedures for all database activity. Developed the on call DBA procedures and policies including service level agreements for support and response times.
• Worked with the operations manager in the creation of change control procedures and policies for the production environment. Worked with account services, release management staff and data center staff to insure availability of the application and database
• In addition did the normal dba duties of performance tuning, production support 24x7, backup, restore using RMAN, installing and upgrading various oracle softwares, working with oracle TARs
• Implemented 10G RAC Database on 4 node IBM AIX Servers with IBM SAN env using 10g ASM Feature
• Implemented RAC on Oracle Service Oriented Architecture (SOA). Implemented RAC on Oracle Identity Management Servers (OIM) for Order tracing system
• Implemented RAC 10g Database on 2 node Linux Servers.
• Implemented RAC in Oracle eBusiness suite 11.5.10.2 and Parallel Concurrent Processing (PCP)
• Upgraded RAC Database from 9.2.0.5 to 10.2.0.3, Oracle eBusiness suite from 11.5.9 to 11.5.10 and 12i
• Supported Oracle Ebusiness Modules AP, GL, FA, HR, CRM, BILLING, BOM, HCM,PO,OM, INV, AR, Supported Oracle Ebusiness Modules AP, GL, FA, HR, CRM, BILLING, BOM, OM, INV, AR, Advanced Supply Chain Planning, Demand Planning, Global Order Promising, Inventory Optimization, Production Scheduling, MRP, Demantra
• Supported almost 75 to 100 Global Databases of size 2 terra byte in multiple language environments.

Environment: IBM AIX 64 bit, IBM SAN, Linux, Windows XP, Vista, TOAD 9.0, Discoverer 10g, Oracle 10g, MS SQL Server, DB2, Oracle OEM, Clearorbit, Microsoft Project, Visio, Oracle Apps 11.5.9, 11.5.10.2, 12i, Oracle AS10g, Veritas

Oracle Apps DBA Lead (Consultant)

Confidential, Mahwah, New Jersey

Responsibilities:

• Managing Oracle ERP with Terra Byte Size RAC Oracle Database Running Applications 11i with Parallel concurrent processing on HP Unix on EMC SAN Raw Devices
• Providing Monthly team status report, organizing the team for better performance
• Managing Problem Tickets and their quick resolving using Unix and DBA Team
• Managing system Administration of Oracle ERP Systems using DBA Team
• Managing BCV Cloning of Production to Reporting Daily basis using the DBA Team both onshore and offshore
• Managed 9i RAC Databases, Upgraded 9i RAC Database to 10g RAC Database

Environment: HP-UX 64 bit, EMC, Linux, Sun Solaris V5.9, Windows 2003, TOAD 8.5,Shareplex 4.0, Discoverer 9i, Oracle 9ias 10g, MS SQL Server, Oracle 9i

Oracle Apps DBA Lead (Consultant)

Confidential, Fairfield, New Jersey

Responsibilities:

• Managed Upgrading of Oracle Applications from 11.5.8 to 11.5.9 and Databases from 8.1.7.4 to 9.2.0.5
• Managed System Administration of 11.5.9 Applications, Resolving performance issues and resource conflicts using the DBA Team
• Lead the Team for the implementation of Custom Interfaces, Conversions, extensions and Reports for HR, GL, PO, AP, FA, CRM, BILLING mobile foundation application, Supported Oracle Ebusiness Modules AP, GL, FA, HR, CRM, BILLING, HCM, PO, BOM, OM, INV, AR, Advanced Supply Chain Planning, Demand Planning, Global Order Promising, Inventory Optimization, Production Scheduling, MRP
• Managed Implementation of Oracle iLearning, iAS 10g (9.0.4), oracle database 10g for Quest Stat Application, Applications Desktop Integrator 7.1.35, oracle workflow mailer with lotus email system, Multiple Language Support (English, Spanish, French)
• Managed Implementation and Support of Oracle Real Application Cluster (RAC) 9i Database for Oracle Apps 11i on IBM-AIX and EMC SAN
• Saved more than a million dollar in designing the server architecture and workload distribution.
• Managed projects that are time based and material based for oracle 11i implementation adding new modules within the stipulated budget

Environment: IBM-AIX 5.2, 5.3 64 bit, Linux, Sun Solaris V5.9, Windows 2000, TOAD 8.0,Shareplex 4.0, Discoverer 9i, SQL Server, DB2 database

Oracle Apps DBA Lead (Consultant)

Confidential, Pittsburgh, Pennsylvania

Responsibilities:

• Provided input for projections of hardware/software requirements and professional resources
• Worked with the release manager in implementing database change control procedures, policies, software releases, installs, and implementations
• Worked with account services, release management staff and data center staff to insure availability of the application and database
• Planned and implemented security auditing policies and procedures for all user activity
• Developed the on call procedure’s and policy’s that included service level agreements for support and response times
• Primary functions are planning, upgrading and managing Financial Applications 11.5.8 and Manufacturing version 11.5.8 for Dataware housing projects on Multi Node two tier system
• Installed, Configured and Administered Hyperion Essbase 10g
• Modules supported AR, AP, GL, OM, INV, ASCP lead DBA Team to keep Reporting instance to be sync with the OLTP with SLA Agreement of 30 minutes sync difference using Shreplex as Sync software and keep smooth operations of Discoverer viewer and plus
• Implemented 9i RAC database on Linux Servers and HP Servers

Environment: HP-UX 64 bit, Linux, Sun Solaris V5.9, Windows 2000, TOAD 7.4,Shareplex 4.0, Discoverer 9i, SQL Server, Cobol, DB2, Retek, Oracle 9i

Oracle Apps DBA Lead (Consultant)

Confidential, Atlanta, Georgia

Responsibilities:

• Primary function to access the feasibility of oracle financials implementation, make recommendations and successfully implement Oracle Applications 11i and train staff
• Set up support infrastructure for Oracle Application production and development support
• Prepared Team and Project Status reports, organized meetings between functional & technical personnel.
• Arranged Meetings with team members, provided project plan for each member of the team.
• Managed Oracle Financial Applications version 11.5.2, 11.5.5 on Single Node IBM AIX (RS 6000) Unix Sever version 4.3.3
• Managed Upgrades of Oracle ERP from 10.7 to 11.5.6,and databases from 8.1.6.1.0 to 9.0.1.3.0
• Managed Customizations of workflows for Account Generator using Workflow Builder 2.6, especially using Awards for one of the Accounting Segments.
• Managed Designing, Developing and implementing procedures to transfer Human Resource, Labor Distribution and Cash Management from ADP Payroll system to Oracle Financial 11i using interface tables and Data pumps
• Managed Designing, Developing and implementing procedures to load and update Vendor and vendor site information and invoices from DDI (COBOL System) into Oracle Application 11i
• Gathered and Distributed the requirements of Functional team members in implementing AP, AR, PO, GL, PA, GMS, LD among the DBAs
• Managed Installation, configuration and implementation of Oracle Express Server, Oracle Financial Analyzer Server, Client, Apache Server 1.1, OFA Reports and OFA Web interface
• Managed Installation, configuration and implementation of Oracle Express Server, Oracle Sales Analyzer Server, using OSA thin client, HTTP Apache Server 1.1, OSA Reports and OSA Web interface.
• Managed Creation of custom reports like the Budget, Expense, Encumbrance, commitment, obligation Reports from Oracle Application 11.5.6 using Discoverer

Environment: Sun Solaris V 9, HP V 11, IBM Unix AIX RS 6000, Windows 2000, XP, Oracle db 9i, 9iAS, Discoverer 9i, Designer 6i, Forms 6i, Reports 6i, ERP 11i, workflow 2.6, ADI 7.1, Toad 6.4, OFA 6.4.0, OSA 6.3.4, OES 6.3.4, OEM 2.0, RMAN 9i, EMC 5.0, SQL Server, DB2, MS Project

Oracle Apps DBA Lead (Consultant)

Confidential, LaGrange, Georgia

Responsibilities:

• Mentoring junior staff members
• Managing Oracle licensing, recommending purchases and upgrades to third party software.
• Plan and implement testing/parallel environments for Oracle based applications
• Managed the Production Industry Information Systems which takes the data from heavy machinery monitoring Instruments that downloads the data into Sun Solaris Unix Servers which then is picked up by the VMS Servers using ProC Program and loaded into the Oracle 8.0.5 database.
• Managed EMC Backup Storage systems

Environment: Unix HP 11.0, Sun Solaris V 8and Windows NT, 95, 98, Oracle 8i, Oracle Enterprise Manager 2.0, RMAN 8i, EMC 4.0,Erwin Data Modeler, Oracle Designer 2000, Oracle Forms 2000, Oracle Reports 2000

Senior Oracle Apps DBA (Consultant)

Confidential, Atlanta, Georgia

Responsibilities:

• Oracle Apps DBA and Financial Apps DBA for Financial Systems which uses Oracle Financials and Oracle Web Application Servers, Functions include, installation and maintenance of 10.7 Oracle Applications, applying patches, installing ADI, Installing and configuring Oracle Financial Analyzer (OFA) and Oracle Sales Analyzer (OSA), creating discoverer reports, adding a customized module and providing on call support during week days and weekends.
• Implemented enterprise web services with webmethods integrations platform.
• Oracle Apps DBA for Human Resource Management Systems, which uses People Soft Application. Functions include creating, duplicating, and recovering databases using RAW devices, Implementing and monitoring Backups, Reorganizing the System and the databases for performance improvements and clarity. Implemented scripts for automatic fault recognition, monitoring and reporting in databases. Provided Technical Support for Emergency and non-Emergency Application user needs.
• Created and Maintained Oracle Financial Databases for Data warehousing Projects
• Published a Manual for Policies and Procedures in Confidential Information Systems with reference to Change Management, Patch Management, Disk and Capacity Management, Y2K Management, Performance Management, System Availability, User Administration, Contact/Escalation Management, Work Flow Process, Incident Management, Kernel Management.
• Provided on the site support and constant monitoring for Year 2000 Database Related Problems during the transition from year 1999 to year 2000
• Installed Oracle Application Server 11.0.3 on HP 11.0 and assisted in configuration. Moved Oracle Databases from ordinary file systems to RAW partition.
• Implemented Oracle Enterprise Manager, Recover Manager (RMAN)
• Installed Oracle 8.1.6 client and server software and created and maintained Oracle 8.1.6 version databases and installed oracle web application server 4.1 created web page using PLSQL procedure and oracle web application server and established client server network
• Designed Entity Relationship, Data flow diagram for the logical design using Designer 2000 for customized Oracle Financials Modules

Environment: Unix HP 11.0, Sun Solaris V 8 and Windows NT, 95, 98, Oracle 8i, Oracle Enterprise Manager 2.0, RMAN 8i, EMC 4.0, Oracle Financials 10.7, Peoplesoft, Oracle Designer 2000, Forms 2000, Reports 2000

Senior Oracle Apps DBA (Consultant)

Confidential, Charlotte, North Carolina

Responsibilities:

• To do upgrades of Oracle Financial application to 10.6 version, patch application, customization of forms and reports and creating interfaces with other legacy systems, trouble shooting problems with General Ledger, Accounts Payable, Purchasing Modules, cloning Oracle Financial Applications
• Implemented Oracle Enterprise Manager, Recover Manager (RMAN)
• To do Oracle Database Administration for Asset Management service Production databases, which includes database tuning and monitoring Tablespace growth and Performance. Upgrading the production databases from Oracle 7.3.3 on HP 10.20 to Oracle 8.0.5 on HP 11.0. Implementing necessary DDL (Data Definition Languages) on the production tables. And migrating objects from other environments to production. Monitor and prevent unauthorized access to production databases.
• Created Snapshots and implemented periodic refresh for the Asset management Databases used for Data ware housing purposes
• Designed Entity Relationship diagram for the data modeling using Designer 4.0 for customized Oracle Financials Modules
• To do Oracle Database Administration for Asset Management Service Stage, Development and Test Databases. Refresh objects in these environments with the ones from the production. Testing and evaluating timing for performance improvements of Batch process. Provide necessary object for developers to do their development efficiently. Upgrading these databases from Oracle 7.3.3 on HP 10.20 to Oracle 8.0.5 on HP 11.0 in addition to monitoring and tuning these databases.

Environment: Unix HP 11.0, Sun Solaris V 7 and Windows NT, 95, 98, Oracle 8.0.3, Oracle Enterprise Manager 2.0, RMAN 8, EMC 3.0, Oracle Financials 10.6, Oracle Designer 4.0, Forms 4.0, Reports 4.0

Senior Oracle Apps DBA (Consultant)

Confidential, Charlotte, North Carolina

Responsibilities:

• To do Primary Database Administration for Remedy (used by Help Desk) Production database, Demand side management (used by Marketing Dept) Production and Test databases, ModelMart (used by Data Ware housing Dept)
• To do Secondary Database Administration for Gas Management System, Human Resource and Financials Peoplesoft Application
• Installed Oracle 8.0.3.2 on Unix Platform HP-UX 10.20 and created production database for Demand side Management
• Implemented Oracle Enterprise Manager, Recover Manager (RMAN)
• Improved the performance of Remedy Database by tuning and Reorganizing and made recommendations for the kernel parameters and RAM capacity
• Worked with EMC Backup Storage
• Analyzed and implemented PLSQL procedures for the Gas management systems
• Scheduled many jobs like daily exports through AUTOSYS, CRON and ORACLE
• Estimated Database size taking into consideration future growth and made necessary recommendation for the disk requirements
• Designed Entity Relationship diagram for logical design using Designer 4.0 and Erwin for Peoplesoft HR and Financials Modules
• Implemented and monitored Hot and Cold Backups through OMNI Backup tool
• Established links with DB2 Database from Oracle for the Demand Side Management
• Created and implemented many script for Oracle Database administration

Environment: Unix HP 11.0, Sun Solaris V 7 and Windows NT, 95, 98, Oracle ver 7, 8.0.3, Oracle Enterprise Manager 2.0, RMAN 7, 8, EMC 3.0, Peoplsoft HR and Financials, Designer 4.0, Erwin

Oracle Apps DBA (Consultant)

Confidential, Irving, Texas

Responsibilities:

• Patch application, maintenance of Oracle application 10.4, adding customized modules, creating custom forms and custom reports using forms 4.0 and reports 6.0
• Worked with EMC Backup Storage
• To design, develop and maintain complex oracle 7.3 databases. Duties include maintaining database dictionaries, integrating systems through database design (especially integrating a corporation wide scheduling and tracking system), backup and recovery. Designed and developed relational database management systems (RDBMS) using the Oracle Designer 4.0 in compliance with logical design and data normalization. Converted and migrated other databases to Oracle Databases for the year 2000 Project. Performed routine Optimization and tuning of the databases.
• Implemented Oracle Enterprise Manager, Recover Manager (RMAN)
• To Analyze Oracle PL/SQL Programs, especially commission systems, Bonus Systems and various other systems used in the Human Resource. To Enhance CSS (Capital Savings Service) and the Human Resource applications using PeopleSoft, Reportsmith, SQRW (Structure Query Report Writer)
• Supported as a DBA to the Data warehousing part of the Retek system.
• To Train Users in Forms Building and Reports Generation

Environment: Unix HP 10.0, Sun Solaris V 6 and Windows NT, 95, 98, Oracle ver 7, 8.0.3, Oracle Enterprise Manager 2.0, RMAN 7, 8, EMC 3.0, Peoplsoft HR and Financials, Oracle Designer 4.0, Oracle Forms 4.0, Oracle Reports 4.0

Oracle Apps DBA and Teaching Assistant

Confidential, Richardson, Texas

Responsibilities:

• System Administration of Management Information Systems Computer Lab
• Designed, Created and implemented Students Marks Processing Module using Designer 4.0, Forms 4.0/Reports4.0
• Assisting Decision Science Professor in Teaching Undergraduate Business Majors
• Installed Oracle 7.3.2 and Oracle 8.0.1 Server on windows NT Server
• Establishing Client and server relationships in the MIS Lab for the students to use oracle database for the Database Management Systems class
• Implemented Oracle Enterprise Manager, Recover Manager (RMAN)
• Created and implemented the Security, backup and recovery strategy for the oracle database.
• Installed Designer 2000, Oracle Web server and implemented the plan for students to use Oracle Designer 2000 for the Data ware housing class

Environment: Unix HP 10.0, Sun Solaris V 6 and Windows NT, 95, 98, Oracle ver 7, 8.0.3, Oracle Enterprise Manager 1.0, RMAN 7, 8, Oracle Designer 4.0, Oracle Forms 4.0, Oracle Reports 4.0