SUMMARY:

• Oracle certified DBA
• Worked in the capacity of Oracle DBA for 15+ years.
• Managed very large Production databases over 20 Terabytes.
• Worked on Exadata x3 - 8, x2-8, x4-2, x3-2 and ODA database machines.
• Upgraded Grid Infrastructure from 11.2.0.3 to 12.1.0.2 on Exadata and non-exadata RAC.
• Upgraded databases from 11.2.0.3 to 11.2.0.4 and then to 12.1.0.2 on Exadata and non-exadata RAC.
• Setup multiple 11gR2 Active Data Guards on Exadata x3-8/x2-8/X4-2/x3-2/ODA database machines.
• Setup, configured and managed Oracle 12c/11gR2/10gR2/9i Data Guard on Confidential -UX 11.31/AIX 6.1/Linux 6/5.
• Managing Data Guard environments since 2007.
• Created multiple snap clone databases on ZFS filesystem for reporting purposes.
• Installed and Configured Oracle Golden Gate 12c, 11gR2 on AIX 6.1 and Linux 5.0
• Installed and configured various 12c/11gR2/10gR2 4/3/2 nodes RAC with ASM on AIX 7.1/6.1, Confidential -UX 11.31, Solaris 10, Linux 6/5/2.4
• Installed various Oracle 12c/11gR2/10gR2/9i/8i/8/7.x Databases on AIX7.1/6.1, Confidential -UX 11.31/11/10.20 , Solaris 10/8/7/2.6/2.5 , Linux 6/5 and Windows servers.
• Installed and configured OEM 12c Cloud Control and 11gR2/10gR2 Grid control on Linux 5.0/ Solaris 10/ Linux 2.4/ Windows server.
• Upgraded 10gR2 Clusterware to 11gR2 Clusterware.
• Upgraded 10gR2 RAC databases to 11gR2 RAC databases and databases from 10g and 11gR1 to 11gR2, 8i and 9i to 10gR2.
• Expertise in Database Performance Tuning including SGA, PGA and complex SQLs.
• Performed SQL tuning using SQL tuning advisor, Explain Plan and tkprof utility.
• Cloned various production databases to QA, DEV, and TEST using Oracle 11g, 10g RMAN cloning technology.
• Expertise in database backup and recovery using RMAN/SQL Backtrack.
• Wrote various shell scripts for database backups/analyze/schema refreshes and monitoring production databases.
• Performed disaster recovery testing for Ameriquest Mortgage Co. using EMC SRDF.
• Performed disaster recovery testing at COMDISCO site for Washington Mutual Bank.
• Migrated databases using Transportable Tablespaces and Data pump.
• 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, Fog light & DBArtisan.
• Implemented database security and auditing.
• Installed database vault and implemented Fine Grain Auditing.
• Worked on Transparent Data Encryption and data masking.
• Implemented data redaction for PII and PHI data using OEM12c and PL/SQL package
• Did capacity planning and space management for various production databases.
• Provided physical DBA support to Data Warehouse/Data Mart, Oracle Financials, PeopleSoft, Siebel and Peregrine databases.
• Did data modelling using Toad Data Modeller, Erwin 3.5 tools and Designer 2000.
• Wrote various PL/SQL procedures, functions, packages and database triggers.
• Migrated databases from Windows to UNIX and Confidential 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 Confidential Service Guard, BCV, and EMC SRDF.
• Exposure to MS SQL Server 2012/2008/20005/2000 / 7.
• Converted SQL Server databases to Oracle using DTS.
• Provided backup support to SQL Server databases.
• Provided 24 x 7 support to production databases.
• Self-motivated, self-managed and hard working.

TECHNICAL SKILLS:

Software’s : Exadata x3-8, x2-8, x3-2, ODA, Oracle 12c/11gR2 Grid Infrastructure, Oracle 11gR2 RAC/Standalone, Oracle 12c/11gR2 ASM, Oracle 12c Cloud Control, Oracle 11gR2 Grid Control, 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 : OEL 6/5, Red Hat 6.5, AIX 7.1/6.1/5.3/5.2/ 4.3.3 , Confidential -UX 11.31, Confidential -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, VM Ware ESX 5.1, Windows 10 / 8.1 /8 /7 /Vista/Windows XP, Windows NT4.0, Windows 2000, Windows 98 / 95, VAX-VMS, MVS, MS-DOS, Novell, Windows 3.11 & Windows 3.0

Hardware’s : Exadata x3-8, X2-8, X4-2, X3-2, ODA, IBM p7 series, p570 / p650, Confidential Itanium 9500, Confidential 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.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Sr Oracle DBA

Responsibilities:

• Worked in network refresh project as a Sr Oracle DBA for Confidential .
• Setup and configured Active Data Guard for all production databases in the new network and switched over to Data Guard in the new network.
• This way we moved all production databases from old network to new network.
• Later on databases were upgraded from 11g to 12c in a two node cluster.
• OEM 12c also migrated from old network to new network.
• All servers were running on VMWare where ESX 5.1 cluster was running.
• There were 5 physical servers in the cluster. I was involved in setting up RAC and Data Guard from the scratch including installation and patching of 12c Grid Infrastructure as well as 12c and 11g RAC binaries.
• Currently working in a data centre migration project for Confidential .
• All database server here are running on VMWare. All databases are on 12c RAC in a multi-tenant architecture.
• Providing support to day-to-day administration of all 12c RAC databases and Data Guard as well as SQL Server 2012 databases.
• Providing support to 12c Golden Gate as well (12.1.2.1.9 ). ODI 11g to 12c Upgradation. Migrating ODI contents in Dev- Test - Prod model.

Environment: OEM 12c, Oracle 12c RAC, 12c Active Data Guard, RMAN, TOAD, SQL Developer, SQL Server 2012/2008, Red hat 6, Windows 7.

Confidential, Los Angeles, CA

Sr. Oracle DBA

Responsibilities:

• Role was to administer Exadata clusters and various RAC databases on Oracle Exadata x4-2, x3-2 machines.
• Maintained about 32+ RAC databases on a day-to-day basis.
• Participated in various aspect of database administration activities and week end maintenance activities.
• Actively worked on database performance tuning. Setup Active Data guard for multiple prod databases.
• Setup DG Brokers as well.
• Upgraded databases from 11.2.0.3 to 11.2.0.4 and then to 12c, upgraded Grid Infrastructure from 11g to 12c.
• Installed and configured OEM 12c in a high availability level-3 env. Also installed EM13c in a dev env for testing.
• Migrated EM12c from old network to new network. Setup golden gate replication from production to reporting databases.
• Provided day-to-day support for Microsoft SQL Server 2012 and 2008 databases.
• Provided support for Confidential databases as well. Customized ODI knowledge modules to improve the performance of ODI operations

Environment: Exadata x4-2, x3-2, OEM 13c / 12c, Oracle 12cRAC, 11gR2 RAC, 11gR2 Active Data Guard, RMAN, TOAD, SQL Developer, SQL Server 2012/2008, AIX 7.1, Oracle Linux 6.7, Red hat 6, Windows 7.

Confidential, Los Angeles, CA

Sr. Oracle DBA

Responsibilities:

• Worked as Senior Oracle DBA in the Confidential . Worked as a production as well as development DBA support.
• Provided support to Data Warehouse databases as well.
• Role was to administer 3 Exadata clusters and various RAC databases on Oracle Exadata x4-2, x3-2 machines and ODA box.
• There were about 55+ RAC databases in total.
• Participated in day-to-day activities and week end maintenance activities on application deployment.
• Worked on transparent data encryption (TDE), configured wallet, standard auditing, fine grain auditing (FGA) and data masking.
• Worked on SQL tuning on various codes captured from AWR reports. Actively worked on database performance tuning.
• Setup Active Data guard for multiple prod databases.
• Upgraded databases from 11.2.0.3 to 11.2.0.4 and then 12.1.0.2, upgraded GI from 11g to 12c.
• Used ZFS cloning to create various databases for reporting purposes.
• Installed and configured Golden Gate in a prod and non-prod env, configured extract, data pump and replicate.
• Installed and configured Database Vault and Oracle Label Security. Implemented data redaction for PII and PHI data using OEM12c.
• Installed ODI Studio and created repository using RCU.
• Developed ODI (Synopsis) interfaces for loading the source data to stage and in turn to target marts

Environment: Exadata x4-2, x3-2, ZFS Storage, ODA, Oracle OEM 12c, Oracle 12c, 11gR2 RAC, 11gR2 Active Data Guard, RMAN, Golden Gate, TOAD, SQL Developer, ODI Studio, Oracle Linux 2.6, Windows 7.

Confidential, Sacramento, CA

Sr. Oracle DBA

Responsibilities:

• Worked as Senior Oracle DBA in the Confidential project.
• Confidential is a Health Insurance Marketplace where people can buy Health insurance for individuals.
• Worked as production support DBA for health insurance exchange as well as development DBA support for Data Warehouse project.
• Build up new RAC databases and schemas on exadata cluster, setup active Data Guard on Oracle 11gR2 on Oracle Exadata x2-8 machine.
• Migrated production databases from Exadata x2-8 to Exadata x3-8. Did lot of performance tuning and SQL tuning.
• Worked on TDE, configured wallet and data masking. Upgraded clusters from 11.2.0.3 to 11.2.0.4.
• Upgraded RAC databases from Oracle 11.2.0.3 to Oracle 11.2.0.4 on Exadata x2-8.
• Managed databases in ODA boxes.
• Applied quarterly bundle patch on Clusterware and Oracle Home.
• Upgraded RAC 11gR2 database to Oracle 12c (12.1.0.2).
• Installed and configured Audit Vault and Oracle Label Security.
• Configured Fine Grain Auditing as well as standard auditing.
• Implemented data redaction for PII and PHI data using OEM12c.
• Installed ODI Studio and created repository using RCU.

Environment: Exadata x3-8, Exadata x2-8, ZFS Storage, ODA, Oracle OEM 12c, Oracle 12c, 11gR2 RAC, 11gR2 Active Data Guard, RMAN, SQL Developer, ODI Studio, Oracle Linux 2.6, Windows 7.

Confidential, Los Angeles, CA

Sr. Oracle DBA

Responsibilities:

• Worked as a consultant in a Data Migration project to move databases from Confidential Superdome-I to new Superdome-II.
• Migrated all production databases to Confidential Superdome-II.
• Created and configured RMAN recovery catalogue 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 Replicate 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, Confidential -UX 11.31, Linux RH 6.0/5.0, Windows 7

Confidential, Pasadena, CA

Sr. Oracle DBA

Responsibilities:

• 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. xtensively 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, Culver City, CA

Sr. Project DBA

Responsibilities:

• Installation of Oracle10gR2 RAC on Sun Solaris.
• Creation and configuration of ASM on RAC.
• Creation of RAC databases using DBCA.
• Installation of 10gR2 Grid control and creation of OEM repository.
• Installation of 10gR2 agents on all prod/cert servers.
• Managed and updated the data model in TOAD data modeller
• Generated DDLs from logical model and maintaining them in Subversion (SVN).
• Performed Data load from external source (Elias) to dev, test, cert and prod envs.
• Controlled change management process using Zira.
• Setup RMAN backup.
• Managed, monitored and performance tuned all production databases.

Environment: Oracle 10gR2, 10gR2RAC, ASM, 10gR2 EM Grid Control, RMAN, OEM, Oracle Snapshot Replication, Expdp / Impdp, Oracle 10g client, Toad Data Modeller, Sub Version, Zira, SSH, Sftp, Linux 2.4, Solaris 10, Windows vista, Windows XP, Windows 2000.

Confidential, Orange/Irvine, CA

Sr. Database Administrator

Responsibilities:

• Installation of Oracle10gR2 RAC on Linux.
• Installation and configuration of ASM on RAC.
• Creation of RAC databases using DBCA.
• Installation of Grid control and creation of OEM repository.
• Installation of 10g agents on all production servers.
• Upgrading databases from 8i to Oracle 10gR2.
• Performed disaster recovery testing using EMC SRDF.
• Managing and monitoring all production databases
• Managed EBS databases on production, QA and development
• Setup and managed Shareplex 4.5 replication.
• Production as well as application DBA support.
• Weekend production upload support.
• Applying DST patches, both TZ patch as well as JVM patch

Environment: Oracle 10gR2, Oracle 10gR1, 10gRAC, ASM, 10g Grid Control, EBS, Oracle 9i, Oracle 8i, RMAN, OEM, Oracle Snapshot Replication, Export / Import, Oracle 9i client, PL/SQL Developer, SSH, Sftp, Terminal Server, Confidential -UX 11.11, Confidential Service Guard, EMC SRDF, BCV, Linux 2.4, Windows 2000.

Confidential, Woodland Hills, CA

Oracle DBA

Responsibilities:

• Production as well as development DBA support.
• 24x7 on call support.
• Take part in inPharm application deployment to all pharmacies.
• Building new replication site for new Pharmacies.
• Debugging and fixing any replication issues.
• Monitoring replication jobs in all Pharmacies.
• Monitoring and administering Master site as well as all snapshot sites.
• Scheduling and monitoring backups.

Environment: Oracle 9i, Oracle 8i, RMAN, OEM, Oracle Advanced Replication, Export / Import, SVRMGRL, Oracle 9i client, PL/SQL Developer, StarTeam, Telnet, ftp, Terminal Server, Confidential -UX 11 / 10.20, Linux 2.4, Windows 2000.

Confidential, KS

System Engineer

Responsibilities:

• Provided production as well as development DBA support.
• Managed very large databases over 1.5 terabytes.
• Installed and configured Oracle 9i Real Application Cluster (RAC).
• Did lot of performance Tuning / SQL Tuning and helped the development team.
• Performed hot backups using SQL Backtrack & RMAN.
• Implemented Production Schema changes for new application release.
• Refreshed staging database from 1.5 terabyte of production database from time to time.
• Setup, managed and monitored multimaster and snapshot replication.
• Installed Oracle 9i Release2 (9.2.0.1) Enterprise Edition.
• Configured Oracle 9iAS.
• Provided DBA support to Oracle Financials Databases.
• Provided support to Standby databases.
• Worked on Confidential failover server.
• Upgraded databases from oracle8 to 8i and 8i to 9i.
• Converted SQL Server databases into Oracle using DTS package.
• Worked on SQL Server 2000 / 7.
• Provided 24 x 7 on call support.

Environment: Oracle 9iR2, Oracle 9i RAC, 9iAS, Oracle 8i, OEM, DBArtisan 6.0 / 5.4, Export /Import, RMAN, SQL Backtrack, Spotlight, TOAD, Precise, DGMGRL, SVRMGRL, PL/SQL, Oracle 9i client, SQL Server 2000 / 7, DTS, GIS, Oracle Financials, Oracle Spatial, Outlook Express 6 / 98, ssh, Telnet, sftp, ftp, Confidential -UX 11, Sun Solaris 8 / 7, Sun Cluster 3.2, AIX 4.3.3, Linux Advance Server, Linux 2.4, Windows NT4 / 2000.