SUMMARY:

• Oracle certified DBA, Trained on DataStax Cassandra 5.1.3.
• Worked in the capacity of Oracle DBA for 15+ years.
• Managed very large Production databases over 20+ Terabytes.
• Worked in a Production as well as Development DBA role.
• Worked on Exadata x3 - 8, x2-8, x4-2, x3-2 and ODA database machines.
• Upgraded Grid Infrastructure from 11g to 12c on Exadata and non-exadata RAC.
• Upgraded databases from 11g to 12c (CDB & non-CDB) on Exadata and non-exadata RAC.
• Created multiple snap clone databases on ZFS filesystem for reporting purposes.
• Extensively worked on Oracle 12c in a Multitenant architecture.
• Converted Databases from non-CDB to CDB.
• Patched Grid Infrastructure and Oracle database using opatch.
• Patched Cell servers using patch manager (patchmgr)
• Setup and configured several 12c / 11g Active Data Guards on Exadata and ODA database machines.
• Setup, configured and managed Oracle 12c/11gR2/10gR2/9i Data Guard on HP-UX 11.31/AIX 6.1/Linux 6/5.
• Installed and Configured Oracle Golden Gate 12c, 11gR2 on AIX 6.1 and Linux 5.0
• Setup 12c / 11g Golden Gate replication between Oracle to Oracle and SQL Server to Oracle.
• Installed and configured various 12c/11gR2/10gR2 multi node RAC with ASM on AIX 7.1/6.1, HP-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, HP-UX 11.31/11/10.20 , Solaris 10/8/7/2.6/2.5 , Linux 6/5 and Windows servers.
• Installed, configured OEM 12c Cloud Control and 11gR2/10gR2 Grid control on Linux 5.0/ 2.4, Solaris 10, Windows server.
• Migrated OEM 12c from old host to new host.
• Performed various RAC and Database upgrades from 8i to 9i / 9i to 10g / 10g to 11g / 11g to 12c.
• 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, TEST using Oracle 12c, 11g, 10g RMAN cloning technology.
• Expertise in database backup and recovery using RMAN and 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, Foglight & DBArtisan.
• Implemented database security and auditing.
• Installed database vault and implemented Fine Grain Auditing.
• Worked on Transparent Data Encryption (TDE) and data masking.
• Implemented data redaction for PII and PHI data using OEM12c and PL/SQL package
• Provided physical DBA support to Data Warehouse / Data Mart, Oracle Financials, Peoplesoft, Siebel and Peregrine databases.
• Installed ODI Studio and Created master and work repository using RCU.
• 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 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.
• Exposer to Amazon AWS, have a personal account with AWS .
• Provided DBA support to MY SQL, MS SQL Server 2012/2008/20005/2000/7 databases.
• Installed MY SQL, SQL Server and SQL Server Management Studio.
• Performed MY SQL, SQL Server database and transaction log backup and restores.
• Setup SQL Server 2012 clustering.
• Converted SQL Server databases to Oracle using DTS.
• Did capacity planning and space management for various production databases.
• Provided 24 x 7 support to production databases.
• Self-motivated, self-managed and hard working.

TECHNICAL SKILLS:

Softwares: Exadata x3-8, x2-8, x3-2, ODA, Oracle 12c/11gR2 Grid Infrastructure, DataStax Cassandra 5.1.3 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, MY SQL, MS SQL Server 2012/2008/2005/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, 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 7.5/6.0/5.0, Linux Advance Server, Linux 2.4 / 2.2 / 2.1Windows 10/8.1/8/7/Vista/Windows-xp, Windows NT4.0, Windows 2000, Windows 98 / 95VAX-VMS, MVS, MS-DOS, Novell, Windows 3.11 & Windows 3.0

Hardwares: Exadata x3-8, X2-8, X4-2, X3-2, ODA, IBM p7 series, p570 / p650, HP Itanium 9500, HP 9000Sun 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, Seattle, WA

Senior Database Engineer

Responsibilities:

• Created, configured and managed many Oracle 12c databases in a RAC / non-RAC / VMWare environments including installation of Grid Infrastructure and Oracle binaries.
• Migrated databases from 11g to 12c in new hardware RAC.
• Setup and configured Oracle 12c Golden Gate replication from datacentre to datacentre for active-active environments.
• Trained on Datastax Cassandra 5.1.3 distributed database.
• Installed and configured Cassandra, created keyspaces and migrated data to new schemas.
• Added / removed nodes in and out of the cluster.
• Performed read-repair periodically, monitoring activities. Setup OEM alerts for Oracle databases.
• Managed SQL Server 2012 databases.
• Performed backup/restore, day-to-day administration.

Environment: OEM 13c / 12c, Oracle 12c RAC, 12c Active Data Guard, Oracle 12c Golden Gate, RMAN, TOAD, SQL Developer, SQL Server 2012, DataStax Cassandra 5.1.3, Red hat 7.5 / 6.5, Google Cloud, Windows 7.

Confidential, Los Angeles, CA

Sr Oracle DBA

Responsibilities:

• 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.
• 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 ). Golden Gate replication established from SQL Server to Oracle 12c.
• Installed and configured BP Protect security software. Have exposer to AWS.

Environment: OEM 12c, Oracle 12c RAC, 12c Active Data Guard, Oracle 12c Golden Gate, DB Protect, RMAN, AWS, TOAD, SQL Developer, SQL Server 2012/2008, MY SQL, 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 J D Edward databases as well. Have exposer to AWS.

Environment: Exadata x4-2, x3-2, OEM 13c / 12c, Oracle 12cRAC, 11gR2 RAC, 11gR2 Active Data Guard, RMAN, AWS, TOAD, SQL Developer, SQL Server 2012/2008, MY SQL, 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 LRS project. Worked as a production as well as development DBA support.
• Provided support to DataWarehouse 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 transperant 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 replicat.
• 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.

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 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 clustesr 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:

• 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, Pasadena, CA

Sr. Oracle DBA

Responsibilities:

• 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.
• Implemented data redaction for PII and PHI data using PL/SQL packages.

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, Monrovia, CA

Sr. Oracle DBA

Responsibilities:

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

Sr. Project DBA

Responsibilities:

• 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).
• 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, HP-UX 11.11, HP 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, HP-UX 11 / 10.20, Linux 2.4, Windows 2000.

Confidential, Overland Park, KS / Irvine, CA

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 HP 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, HP-UX 11, Sun Solaris 8 / 7, Sun Cluster 3.2, AIX 4.3.3, Linux Advance Server, Linux 2.4, Windows NT4 / 2000.