Summary:

• Worked in the capacity of Oracle DBA for 16 years.
• Managed very large Production databases over 20 Terabytes.
• Installed and Configured Oracle Golden Gate 11g on AIX 6.1 and Linux 5.0
• Installed and configured 11gR2 RAC with ASM on AIX 7.1/6.1, HP-UX 11.31, Linux 5.0
• Setup and configured Oracle 11g Active Data Guard on HP-UX 11.31/AIX 6.1/Linux 5.0
• Installed Oracle 12c Databases on Linux and Windows server.
• Installed and configured Oracle Cloud Control 12c on Linux 5.0/ Windows server
• Installed Oracle 11gR2 Database and 11g Grid Control on Linux RH5.0
• Installed and configured 10gR2 Grid control on Solaris 10 and Linux 2.4.
• Installed and Configured 10g RAC with ASM on Solaris 10 and Linux 2.4.
• Setup and managed Oracle Data Guard environments in Oracle 9i, 10g and 11g.
• Upgraded 10gR2 RAC to 11gR2 RAC.
• Upgraded database from 10g and 11gR1 to 11gR2.
• Upgraded databases from 8i and 9i to 10gR2.
• Expertise in Database Performance Tuning.
• Performed database tuning SGA I/O on various production Databases.
• Performed SQL tuning using Explain Plan and tkprof utility.
• Cloned various production databases to QA, DEV, TEST using Oracle 11g, 10g cloning technology.
• Expertise in database backup and recovery using RMAN.
• Wrote various shell scripts for managing and monitoring production databases.
• Worked on SQL Backtrack for database backup and recovery.
• Performed disaster recovery testing for Ameriquest Mortgage Co. using EMC SRDF.
• Performed disaster recovery testing at COMDISCO site for Washington Mutual Bank.
• Worked on Transportable Tablespaces.
• Setup and managed oracle 10g streams replication.
• Setup and managed Shareplex 4.5 replication.
• Setup, managed and monitored Multimaster and snapshot replications.
• Extensively worked on Oracle Enterprise Manager, TOAD, Spotlight, Foglight DBArtisan.
• Implemented database security and auditing.
• Did capacity planning and space management for various production databases.
• Experienced in Data Warehouse and Data Mart databases.
• Provided physical DBA support to Data Warehouse, Oracle Financials and Peoplesoft databases.
• Provided physical DBA support to Siebel and Peregrine Databases.
• Did data modelling using Toad Data Modeller, ERwin 3.5 tools and Designer 2000.
• Wrote PL/SQL procedures, functions and database triggers.
• Created various schema objects tables, views, indexes, snapshots, db links, and sequences .
• Installed Oracle 9i Enterprise edition on Sun Solaris 8.
• Installed Oracle 8i, 8, and 7. X on Sun Solaris 7/2.6/2.5, HP-UX 11/10.20 and on NT4.
• Installed various Oracle patch sets.
• Upgraded databases from Oracle 8 to 8i and 8i to 9i using upgrade script.
• Migrated databases from Oracle 7 to Oracle 8 using migration utility.
• Migrated databases from NT to Unix and HP to SUN Servers using export/import.
• Expertise in data conversion from Non-Oracle platform to Oracle.
• Extensively used SQL Loader for large data load using direct path and parallel loading.
• Worked on HP Service Guard, BCV, and EMC SRDF.
• Exposure to MS SQL Server 2000 / 7.
• Converted SQL Server databases to Oracle using DTS.
• Provided 24 x 7 support to production databases.
• Self-motivated, self-managed and hard working.

Technical Skills:

• Softwares : Oracle 11gR2 Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2
• Standalone, Oracle 11gR2 ASM, Oracle 12c Cloud Control, Oracle 11gR2 Grid Control, Oracle Exadata x3-8, Exadata 2-8, 11g Golden Gate, Oracle 10gR2 RAC, Oracle 10gR2 DB, Oracle 10gR2 ASM, Oracle 10g Grid Control, Oracle 9iR2 / 9i / 8.1.7/ 8.1.6 / 8.0.6 / 8.0.5 / 7.3 / 7.1 / 7.0, OEM, Data Guard, Spotlight, DBArtisan 6.0/5.4, TOAD, Oracle 9i RAC, OPS, Oracle Streams, Oracle Advanced Replication, Oracle Snapshot replication, Shareplex 4.5 replication, Oracle Financials, Peoplesoft, SQL Plus 9 / 8 / 3.3 / 3.1, PL/SQL, PL/SQL Developer, SQL Loader, RMAN, SQL Backtrack, Precise, StarTeam, BMC Patrol, MS SQL Server 7 / 2000, DTS, SVRMGRL, SQL DBA, Export / Import, Oracle 9i client, Oracle Net, Net8, SQL Net, Toad Data Modeller, Designer-2000, ERwin 3.5, ODBC, TCP/IP, ssh, Telnet, sftp, ftp, MS-Access, Outlook Express 6, Lotus Notes 5/4.5, MS-Project, Developer-2000, Forms 4.5, Forms 3.0, Report 2.5, Report 1.1, FoxPro, FoxPlus, dbase, Pro C, COBOL, MS-Office.
• OS : AIX 7.1/6.1/5.3/5.2/ 4.3.3, HP-UX 11.31, HP-UX 11 / 10.20, Solaris 10/Solaris 8 / 7 / 2.6 / 2.5, Linux RH 6.0/5.0, Linux Advance Server, Linux 2.4 / 2.2 / 2.1, Windows 7/ Vista/Windows-xp, Windows NT4.0, Windows 2000, Windows 98 / 95, VAX-VMS, MVS, MS-DOS, Novell, Windows 3.11 Windows 3.0
• Hardwares: IBM p7 series, p570 / p650, HP Itanium 9500, HP 9000, Sun Enterprise 4500 / 3000 /
• 420 / 250, RS-6000, Sun Ultra 1, Sun Sparc 1000, Sun SS-20, Compaq Pentium Pro
• 7000, Pentium Servers, VAX-3400, IBM-370, Burroughs B5900, B1900.

Relevant Experiences:

Confidential

Sr. Oracle DBA

Worked as a consultant in a Data Migration project to move databases from HP Superdome-I to new Superdome-II . Migrated all production databases to HP Superdome-II. Created and configured RMAN recovery catalog and registered all databases. Wrote various shell scripts and RMAN scripts to automate both weekly and daily RMAN incremental backups. Setup and configured Oracle 11g Active Data Guard and performed switchover and failover testing. Analysed and resolved database performance issues. Installed and configured Oracle Golden Gate 11g. Configured Extract, Data pump and Replicat processes in a production environment. Installed Oracle 12c Databases and Cloud control 12c to monitor all databases.

Environment:

Oracle 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Oracle 10gR2, Oracle 9i, Active Data Guard, Oracle Golden Gate 11g, RMAN, TOAD, HP-UX 11.31, Linux RH 6.0/5.0, Windows 7

Confidential

Sr. Oracle DBA

Worked as a Sr. Oracle DBA in a Pharmacy implementation project with Kaiser Permanente. Kaiser is replacing their old pharmacy information management system with EPS Enterprise Pharmacy System from PDX Inc. I had been working as a consultant Oracle DBA on that implementation project. Assisting in implementation, testing and production rollout process. Helping other DBAs on various issues related to deployment, migration, performance and Golden Gate issues. Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicat. Installed Oracle 11g RAC with ASM, setup Oracle Active Data Guard etc. Installed and configured OEM 12c cloud control.

Environment:

Oracle 12c, OEM 12c, 11gR2Grid Infrastructure, Oracle 11gR2 RAC, Oracle 11gR2 Standalone, 11gR2 ASM, 11g Grid Control, Golden Gate 11.1, Active Data Guard, RMAN, SQL Developer, PL/SQL Developer, TOAD, AIX 7.1 / 6.1, Linux RH 6.0/5.0, Windows 7

Confidential

Sr. Oracle DBA

Worked as Sr. Oracle DBA for four years. Maintained and administered 3 TB of production, QA and development databases. Supported supply chain management system for stores and warehouses. Setup, installed and configured 11g/10g RAC also installed 11g/10g Oracle Enterprise Manager Grid Control environment for managing all environments. Managed Oracle Data Guard environment. Extensively worked on performance tuning and SQL tuning to resolve various performance issues and stabilized the production environment. Managed other DBAs. Wrote various Unix shell scripts for monitoring and alert notification jobs.

Environment:

Oracle 11gR2, Oracle 10gR2, 11g/10gRAC, ASM, 11g Grid Control, 10gR2 Grid Control, Oracle 9i, Data Guard, RMAN, OEM, Oracle Streams, Oracle Snapshot Replication, Expdp / Impdp, Oracle 10g / 9i client, PL/SQL Developer, SSH, Sftp, AIX 5..3 / 5.2, HACMP, Linux RH 5.0, Shell scripts, Windows xp.

Confidential

Sr. Project DBA

Worked as a Sr. Project DBA to support development and building of a new website called NFL.com. Took the ownership of data model and maintained and managed the data model. Worked closely with application development team and performance team. Installed and setup Oracle 10g RAC with ASM on Sun Solaris 10. Created production, certification, test and development environments. Generated DDL from data model and implemented on various environments. Performed data load from external sources to the new env. Controlled the change management process using Zira. Did database performance tuning and SQL tuning. Provided DBA support to the Documentum team. Helped application development team by setting up Oracle Snapshot Replication OSR