SUMMARY

• Experience with implementation of disaster recovery (DR) and strategy planning.
• Experience with Data Guard, and Oracle Standby databases
• Experience with implementation of backup and recovery using RMAN.
• Experience with Installation and management of multi - terabyte production Oracle 10G, 11G, 12C and 18c RAC, ASM on UNIX and Windows systems
• Proficient in logical and physical database modeling
• Experience with setup and administration of IBM DB2 LUW Database Security environments using Profiles, database Privileges and Roles, LDAP, Active Directory, Kerberos.
• Proficient in using Oracle data guard to synchronize Primary with standby databases
• Strong in creating and Oracle Packages, stored procedures and functions using PL/SQL
• Experience in implementation and execution of DATAPUMP export and import on oracle databases and SQLLOADER
• Experience managing Oracle databases on versions 9i, 10g, 11g and 12c
• Experience upgrading from major versions (9i to 10g, 10g to 11g, 11g to 12c)
• Experience patching Oracle/DB2 DB patches(OPatch, minor patching, etc.).
• Experience with backing up and recovering with RMAN.
• Experience with Oracle/DB2 performance tuning
• Experience with Golden Gate
• Experience with backing up and restoring with Oracle DataPump(Export and Import)
• Experience working with Exadata - Installed / Created Oracle 18c 3 Nodes RAC on Exadata Machine
• Experience with network connection tuning using Oracle Shared Servers, Connection pooling and multiplexing
• Experience in Database support (SQL, Pl/SQL tuning, Application tuning etc)
• Proficient in database cloning
• Expertise in Oracle RAC, Replication, Data Guard for High Availability (HA)
• Proficient in data conversions, scrubbing and ETL
• Experience with database site, server and instance consolidation
• Strong database design/implementation skills and capacity planning
• Expertise in Production support of 160+ (Oracle 8i, 9i, 10g,11g) instances running on Sun and Linux.

TECHNICAL SKILLS

Programming languages: XSL, XSLT, HTML, XML, ASP, JSP, SQL, PLSQL, JAVASCRIPT, UNIX SHELL SCRIPT, BATCH SCRIPT, BASIC, VISUAL BASIC, J2EE

RDBMS: ORACLE 7.x/8.x/9i/10g/11g/12c; DB2 UDB 6.1/7.2/8.2/9.7/10 ; MS SQL SERVER 7/2000/2005/2008/2012 ;

Operating systems: Unix(Hp,Sun,Aix,Linux);Windows NT/2000/2003/Xp/Vista;Os/2

Hardware profiles: IBM pSeries Server & zSeries 800-990 server, MS PIII XEON,SUN FIRE V490-V1280,E2900-E6900, E25K,PRIMEPOWER 2500,,SUN SPARC64,HP RP2470,HP 9000.

APPLICATIONS : Siebel 4.8/99/2000/7.5/8.1 , SAP, JACADA, Genesys,InterVoice, Documentum,Informatica

PROFESSIONAL EXPERIENCE

Confidential

SR. ORACLE DBA

Responsibilities:

• Migrated various Oracle Databases from oracle 10G to 11G and from 11G to 12c, applied latest oracle patches.
• Configure the physical design of Oracle databases by implementing OFA compliance that suites both OLTP and Data warehouse applications.
• Configured various logical database structures such as table spaces to store application objects and rollback segments for transaction processing.
• Migrated various DB2 UDB Instances /databases from db2 v8 to v9.7 and applied latest and greatest fix packs to meet support and certification requirements.
• Migrated various Oracle databases from version 8i and 9i to 10g R2, 11g R2 and now in pre-prep stage to migrate to ground breaking 12c level.
• Created logical and physical design of database schemas for new applications.
• Installed and aided in the design of Oracle RAC databases to meet the business requirements, made all application related database changes requested by the development team.
• Installed and Managed Oracle 10g, 11g 4 NODES RAC and ASM on Solaris, AIX, Linux and windows for failed over process on DEV, CAT, TEST and PRODUCTION environments.
• Designed and developed technology road map for consolidating ABC with DB2 & Oracle databases in distributed platform across several data centers.
• Designed and developed technology for bi-directional disaster recovery sites and provide high availability to meet customer SLA’s requirements
• Lead a team of 5 other Database Administrators, 2 developers and 6 application vendor consultants to ensure quality deliverables to our clients.
• I have successfully engaged in various DR (Disaster Recover) efforts for my customers.
• Make recommendation on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation.
• Organized and co-ordinates daily operations and project delivery meeting to identified all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.
• Develop a leveraged Oracle RMAN backup solution that let ABC customers enhance their backup solution across the enterprise.
• Implementation and execution of DATAPUMP export and import on oracle databases.
• Apply fixes and patches as necessary to IBM DB2 UDB & Oracle database environment to keep track of cutting edge technology.
• Guide ABC customers IT infrastructure team to successfully analyze and implement DB2 UDB & Oracle technology best practices in respect of database and key application deployment.
• Guide ABC customers IT infrastructure by providing valuable inputs into planning, implementation and execution of top notch business applications that runs on DB2 UDB & Oracle database platform in accordance with best practices
• Develop a problem tracking applications that assigned all related systems errors/problems to appropriate database and / or application personnel using remedy.
• Design the backups and recovery strategies for Oracle databases from 7.3 thru 11g and DB2 UDB databases to meet our customer SLA requirements.
• Managed entire project to which assigned in accordance with the Service Level Agreement (SLA) and Statement of Work (SOW) to ensure all departmental related cost and expenses as keep on track with the project schedule.
• Managed the entire database environment visibility and accountable for every database decision made to upper level management.
• Act as a backup to my project managers on occasions they are not available and or too busy to attend to other project needs and requests.
• Managed major resources deployment within departmental budget by assigning DBA personnel according to their skill sets and interest and make proposal for training and professional development.
• Multi-tasked by managing other projects within departmental budget and resources when assign by senior management personnel.
• Installed, configured and managed both OLTP and enterprise Data Warehouse on Oracle 7.3 thru 11g and DB2 UDB environments.
• Installed, setup, configured and manage high availability topology for Oracle and DB2 UDB environment using RAC, DataGuard and DB2 high availability disaster recovery (HADR) respectively.
• Manage and provide steady state support for Oracle database RAC environment after implementation and go-live.
• Installed, setup, configured and manage federated systems using Oracle and DB2 UDB as data sources respectively.
• Installed, upgrade and apply fixpaks on DB2 UDB, Oracle and Sql server databases.
• Setup users and enforced security policies in DB2 UDB, Oracle and Sql server databases modules.
• Setup responsibilities and audit those as assigned.
• Configure linkages between the DB2 UDB databases and its SAP integration.
• Installed, setup and configured DB2 UDB and Oracle databases for SAP proof of concept {POC} and implementation.
• Configured and setup JDBC and ODBC connection layer for SAP interface with DB2 UDB databases.
• Installed and configured MQSI broker and repository application server on top of a DB2 UDB and Oracle databases.
• Installed and configured MQSI config manager and message repository on DB2 UDB and Oracle databases.
• Installed, setup and manage master tax and vertex application server on DB2 UDB and Oracle databases
• ConfiguredProduct lines strategy and setup data-areas on top of DB2 UDB EE/EEE/ESE and oracle databases.
• Perform constant refreshes of various Product lines from Production systems as at when requested by developers, vendors and end users.
• Installed patches on theFinancial application as at when required.
• Managed and setup concurrent jobs on theFinancial Application.
• Installed and configured Mqsi config manager and repository environment on DB2 database and monitor the appropriate flows for steady deployment.
• Monitor MQSI flows and channels on DB2 UDB and Oracle databases that share data with Lason environment.
• Configure the link between Mqseries database applicationsenvironments to exchange data and flows across a secured socket layer.
• Setup the integration interface for Mqsi flows and Ariba application to exchange metadata with oracle 9i database.
• Upgrade Wmqsi and Mqseries to 2.1 and 5.2.1 respectively on a DB2 7.2.5 environment.
• Setup Wmqsi enterprise services to run on multiple machines while serving the users as one logical unit and enables clustering with load balancing and failover.
• Constantly interact with end users and developers to troubleshoot their jobs as at when needed.
• Successfully perform several migration/upgrades of the Oracle and DB2 UDB EE/EEE/ESE RDBMS servers from 7.3.x, 8.0.x to 8.1.x, 9i & 6.1 to 7.1, 7.2 and 8.1 respectively.
• Play a lead role in the migration of oracle 8.1.6 databases in a Sun Solaris environment to 8i and 9i on AIX/RS6000 shop.
• Perform installation of Oracle, DB2 UDB EE/EEE/ESE and Ms Sql Server RDBMS on Aix, Sun Solaris boxes and Windows NT Enterprise server 4.0 and Windows 2000 respectively.

Confidential

SR. ORACLE DBA

Responsibilities:

• Migrated various Oracle Databases from oracle 10G to 11G and from 11G to 12c, applied latest oracle patches.
• Configure the physical design of Oracle databases by implementing OFA compliance that suites both OLTP and Data warehouse applications.
• Configured various logical database structures such as table spaces to store application objects and rollback segments for transaction processing.
• Migrated various DB2 UDB Instances /databases from db2 v8 to v9.7 and applied latest and greatest fix packs to meet support and certification requirements.
• Migrated various Oracle databases from version 8i and 9i to 10g R2, 11g R2 and now in pre-prep stage to migrate to ground breaking 12c level.
• Created logical and physical design of database schemas for new applications.
• Installed and aided in the design of Oracle RAC databases to meet the business requirements, made all application related database changes requested by the development team.
• Installed and Managed Oracle 10g, 11g 4 NODES RAC and ASM on Solaris, AIX, Linux and windows for failed over process on DEV, CAT, TEST and PRODUCTION environments.
• Designed and developed technology road map for consolidating ABC with DB2 & Oracle databases in distributed platform across several data centers.
• Designed and developed technology for bi-directional disaster recovery sites and provide high availability to meet customer SLA’s requirements
• Lead a team of 5 other Database Administrators, 2 developers and 6 application vendor consultants to ensure quality deliverables to our clients.
• I have successfully engaged in various DR (Disaster Recover) efforts for my customers.
• Make recommendation on systems hardware and software implementation for management approval and took responsibility for complete and timely implementation.
• Organized and co-ordinates daily operations and project delivery meeting to identified all possible problems and ensure they are rectified to keep project on schedule and report any project variance to the appropriate upper management personnel.
• Develop a leveraged Oracle RMAN backup solution that let ABC customers enhance their backup solution across the enterprise.
• Implementation and execution of DATAPUMP export and import on oracle databases.
• Apply fixes and patches as necessary to IBM DB2 UDB & Oracle database environment to keep track of cutting edge technology.
• Guide ABC customers IT infrastructure team to successfully analyze and implement DB2 UDB & Oracle technology best practices in respect of database and key application deployment.
• Guide ABC customers IT infrastructure by providing valuable inputs into planning, implementation and execution of top notch business applications that runs on DB2 UDB & Oracle database platform in accordance with best practices
• Develop a problem tracking applications that assigned all related systems errors/problems to appropriate database and / or application personnel using remedy.
• Design the backups and recovery strategies for Oracle databases from 7.3 thru 11g and DB2 UDB databases to meet our customer SLA requirements.
• Managed entire project to which assigned in accordance with the Service Level Agreement (SLA) and Statement of Work (SOW) to ensure all departmental related cost and expenses as keep on track with the project schedule.
• Managed the entire database environment visibility and accountable for every database decision made to upper level management.
• Act as a backup to my project managers on occasions they are not available and or too busy to attend to other project needs and requests.
• Managed major resources deployment within departmental budget by assigning DBA personnel according to their skill sets and interest and make proposal for training and professional development.
• Multi-tasked by managing other projects within departmental budget and resources when assign by senior management personnel.
• Installed, configured and managed both OLTP and enterprise Data Warehouse on Oracle 7.3 thru 11g and DB2 UDB environments.
• Installed, setup, configured and manage high availability topology for Oracle and DB2 UDB environment using RAC, DataGuard and DB2 high availability disaster recovery (HADR) respectively.
• Manage and provide steady state support for Oracle database RAC environment after implementation and go-live.
• Installed, setup, configured and manage federated systems using Oracle and DB2 UDB as data sources respectively.
• Installed, upgrade and apply fixpaks on DB2 UDB, Oracle and Sql server databases.
• Setup users and enforced security policies in DB2 UDB, Oracle and Sql server databases modules.
• Setup responsibilities and audit those as assigned.
• Configure linkages between the DB2 UDB databases and its SAP integration.
• Installed, setup and configured DB2 UDB and Oracle databases for SAP proof of concept {POC} and implementation.
• Configured and setup JDBC and ODBC connection layer for SAP interface with DB2 UDB databases.
• Installed and configured MQSI broker and repository application server on top of a DB2 UDB and Oracle databases.
• Installed and configured MQSI config manager and message repository on DB2 UDB and Oracle databases.
• Installed, setup and manage master tax and vertex application server on DB2 UDB and Oracle databases
• ConfiguredProduct lines strategy and setup data-areas on top of DB2 UDB EE/EEE/ESE and oracle databases.
• Perform constant refreshes of various Product lines from Production systems as at when requested by developers, vendors and end users.
• Installed patches on theFinancial application as at when required.
• Managed and setup concurrent jobs on theFinancial Application.
• Installed and configured Mqsi config manager and repository environment on DB2 database and monitor the appropriate flows for steady deployment.
• Monitor MQSI flows and channels on DB2 UDB and Oracle databases that share data with Lason environment.
• Configure the link between Mqseries database applicationsenvironments to exchange data and flows across a secured socket layer.
• Setup the integration interface for Mqsi flows and Ariba application to exchange metadata with oracle 9i database.
• Upgrade Wmqsi and Mqseries to 2.1 and 5.2.1 respectively on a DB2 7.2.5 environment.
• Setup Wmqsi enterprise services to run on multiple machines while serving the users as one logical unit and enables clustering with load balancing and failover.
• Constantly interact with end users and developers to troubleshoot their jobs as at when needed.
• Successfully perform several migration/upgrades of the Oracle and DB2 UDB EE/EEE/ESE RDBMS servers from 7.3.x, 8.0.x to 8.1.x, 9i & 6.1 to 7.1, 7.2 and 8.1 respectively.
• Play a lead role in the migration of oracle 8.1.6 databases in a Sun Solaris environment to 8i and 9i on AIX/RS6000 shop.
• Perform installation of Oracle, DB2 UDB EE/EEE/ESE and Ms Sql Server RDBMS on Aix, Sun Solaris boxes and Windows NT Enterprise server 4.0 and Windows 2000 respectively.

Confidential

ORACLE/DB2 DBA

Responsibilities:

• Implementation of Oracle replication using Oracle 10g Streams
• Ability to manage high availability solution centers using Oracle Real Application Clusters (RAC) with several nodes.
• Experienced in using databases features such Data pump, Flash-Back Recovery, AWR, ADDM
• Installation and configuration of Oracle 9i/10g/11g Real Application Clusters (RAC).
• Install and configure Oracle cold failover on 11g2R using Automatic Storage Management (ASM)
• Designed and implemented logical and physical database architecture
• Performed online table space redefinition on a 24/7 system.
• Cloned databases using RMAN, DBCA and manual copy
• Experience in cross-platform database migration
• Performed database maintenance such as upgrades and patches
• Performed disaster recovery using Oracle Recovery Manager
• Experience working with Exadata
• Managed database security using Oracle and third party tools such as kerberos, biometric data
• Networked Oracle databases Servers and Client applications using Oracle*Net.
• Migrated SQL SERVER databases to Oracle using Oracle Migration Workbench
• Setup and managed the security layer between master tax and vertex application server running on DB2 UDB and Oracle databases.
• Configure the connections and network linkages between the Oracle 8i database and Ariba Buyer/Tibco Active enterprise.
• Involve in the capacity planning of various databases application design and architecture for Ariba,and SAP implementations.
• Install7.2.3, 7.3.3 and 8.x on Oracle 8i and 9i databases for the Financial Module implementation.
• Set up entire environment to interface with Oracle and DB2 UDB databases.
• Setup environment to interface and share data with Ariba buyer for shared services reporting using tibco integration exchange.
• Manage user security setup through the application to interface with Oracle 8i, 9i and 10g databases.
• Performed upgrade of the financials environments from 9.5.0 to 9.7.3 and 10.x to ensure client is always at the cutting edge of technology innovations.
• Constantly monitor application performance both at the database level and application server side.
• Load data into applications and monitor transaction resources consumed at the server side.