SUMMARY

• 11+ years of experience as a Database Administrator providing 24x7 Support for critical Oracle Production Databases.
• Comfortable working in dynamic enterprise environments consisting of over 1000+ Oracle databases.
• Strong experience in Managing and Administering Oracle Database Appliance machines like performance tuning, patching and contacting Oracle support for troubleshooting cell issues.
• Thorough understanding of Oracle EXADATA architecture.
• Worked on EXADATA machines where Oracle RAC, Dataguard and standalone databases are running.
• Used Oracle ASM/ACFS for GOLDENGATE to minimize downtime by reducing dependency on storage teams.
• Hands on experience in MS SQL Server 2008 database administration.
• Hands on experience in Cloud services managing databases on EC2 instances.
• Hands on experience in Amazon Cloud services like EC2, DBMS, Creating storage and database Installations.
• Hands on experience in creating different accounts and assigning ROLES to them and managing users under Identity Access Management (IAM) in Amazon Cloud.
• Hands on Experience in GRID Control 12c (OEM) and deploying agents and troubleshooting agent issues.
• Experience in Migrating databases from Oracle Internet Directory to Oracle Unified Directory.
• Hands on experience in Implementing Oracle Unified Directory (12c OUD) to use as Directory server to manage all database users centrally.
• Experience in Migrating database from oracle 11gR2 RAC to oracle 12cR1.
• Strong experience in preparing Installation Qualifications which will be useful to other DBA’s to perform the activities using this document.
• Strong Experience in Implementing and troubleshooting GoldenGate.
• Experience in Uni - Directional setup of GoldenGate.
• Handled various issues and fixed it in GoldenGate like abending of EXTRACT & REPLICAT processes.
• DB Upgrade experience from 8i, 9i to 11g and 12c versions.
• Used Veridata tool to identify any data mismatch between source and target databases when using GoldenGate.
• Strong experience in Performance tuning of database and SQL code.
• Utilized tools like SQLT, Tracing, AWR &ADDM reports to tune instance level and SQL code.
• Used SQL Tuning Advisor to get oracle suggestions on poor performing queries and understand them before implementing the Profiles.
• Strong experience in Migration of databases from HPUX to Solaris X-86 and X-64 bit OS.
• Hands on experience in all flavors of UNIX and Windows (Solaris x-86, x-64) in administering oracle databases.
• Hands on in data encryption of critical data in production databases.
• Used to generate EXPLAIN Plan and analyze them for bad queries.
• Experience in managing the production databases where the number of application user’s connection to database is around 10000.
• Working experience with multi terabyte production databases using Oracle 9i/10g/11g/12c RAC 3+ Nodes.
• Having hands on experience in tuning the RAC database.
• Experience in Implementing Physical standby & Maintenance.
• Experience in setting up and maintaining of Grid control for both stand alone and RAC databases.
• Experience in tuning the backups of database to disk and tape using RMAN.
• Performed Recovery Procedures including block level recovery.

TECHNICAL SKILLS

Databases: Oracle 8i/9i/10g/11g/12c, SQL Server 2012/2008R2/2008/2005, MySQL, EXADATA x3-8

Operating Systems: HP-UX 10.x, 11.x itanium, TRU64, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, and Windows 2005.

Languages: SQL, PL/SQL, UNIX Shell, Perl, JAVA.

Oracle Tools: RMAN, OAM, OEM, GRID Control, GoldenGate, DB Vault, TOAD, SQL*Loader, ASM, TNS, OID, OUD, ACFS/ASM

Hardware/Storage: SUN E4500, SUN E10k, HP9000, RS6000, EMC, BCV, VERITAS Net Backup, Tivoli Storage Manager (TSM), NetApp Filers (Snap Mirror), AUTOSYS

Cloud Services: Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle DBA

Responsibilities:

• Manage oracle databases which maintain critical and sensitive data
• Implement Oracle Unified Directory 12c so that users in all databases can be managed centrally in OUD which will simplify the user management.
• Use Oracle Data Masking through Oracle Enterprise Manager (OEM) to mask PII data.
• Supported On call 24x7 to address any production outages or performance issues.
• Setup 12c RAC database and test application connectivity and fix any issues.
• Support development teams in tuning the PL/SQL code if facing any performance issues during deployments.
• Setup Dataguard to maintain high availability of databases during datacenter shutdown.
• Hands on experience in tuning databases based on the application requirement.
• Generate oracle AWR/ADDM reports to understand problematic SQL and fix them.
• Guide other team members in installations and performance issues.

Environment: Oracle Enterprise Linux, Oracle 12c/11g RAC Databases, TOAD, JDeveloper, Oracle Grid Control, Data Guard, ASM, RMAN, SAN, ODA 5.x, Data Masking, Oracle Unified Directory

Confidential

Senior Oracle DBA

Responsibilities:

• Worked Majorly in Warehouse environment which are 200+ TB in size.
• Worked in Oracle Database Appliance (ODA boxes) which has 12c running.
• Worked on performance issues of SQL related queries.
• Worked with developments teams in deploying the scrips and making suggestions to the queries.
• Worked in setting up Golden Gate Uni-Directional.
• Experience in troubleshooting replication and Extract issues using Logdump and logs.
• Had setup Oracle 12c Dataguard in RAC environment.
• Involved in troubleshooting of dataguard issues.
• Performed restoration of standby databases when it is out of SYNC from Primary using RMAN incremental backup.
• Worked on Data Masking using Delphix tool.
• Created Virtual environments of Production databases using Delphix.
• Supported On call 24x7.

Environment: Oracle Enterprise Linux, WINDOWS 2005, Oracle 12c/11g/10g, 9i/10g/11g/12c RAC Databases, MS SQL Server 2012/2008, Data Ware House, TOAD, JDeveloper, Oracle Grid Control, Data Guard, GoldenGate, ASM, RMAN, SAN, ODA 5.x, Delphix tool (5.1.9).

Confidential

Oracle DBA

Responsibilities:

• Worked in Engineering team as L4 DBA where I should mentor L3 & L2 DBA’s in installations of RAC & NON-RAC databases of 11g and 12c versions.
• Handled project of migrating all Databases from Oracle Internet Directory (OID) to Oracle Unified Directory (OUD).
• Prepared Installation Qualification documents so that L3 & L2 level DBA’s can follow the document for Installation of RAC and Standalone databases.
• Upgraded Oracle 11gR2 RAC database to 12cR1 RAC.
• Hands on experience in data encryption using Transparent Data Encryption and also restricting access to data using Data Vault.
• Setup Transparent Data Encryption for critical data in production databases so that it is masked for end users.
• Involved in troubleshooting of dataguard issues.
• Performed restoration of standby databases when it is out of SYNC from Primary using RMAN incremental backup.
• Handled performance issues at database level and SQL side also.
• Used to analyze AWR &ADDM reports and implement them to optimize the queries and database performance.
• Managed databases on Amazon Cloud services by creating EC2 instances.
• Worked on EXADATA X3 quarter rack machines.
• Worked on performance tuning and patching of EXADATA machine cells.

Environment: SUN SOLARIS SPARC 9/10 Oracle Enterprise Linux, WINDOWS 2005, Oracle 12c/11g/10g, 9i/10g/11g RAC Databases, MS SQL Server 2012/2008, Data Ware House, TOAD, JDeveloper, Oracle Grid Control, Data Guard, GoldenGate, ASM, RMAN, SAN, EXADATA X3-8

Confidential

Senior Database Specialist/ Oracle DBA

Responsibilities:

• Handled set of applications completely from installations, deployments and performance tuning issues.
• Setup 11gR2 RAC with 10g and 11g database.
• Hands on experience in data encryption using TDE and Vault.
• Setup Transparent Data Encryption for critical data in production databases so that it is masked for end users.
• Upgraded databases from 11g to 12c version in production environments.
• Involved in troubleshooting of dataguard issues.
• Performed restoration of standby databases when it is out of SYNC from Primary using RMAN incremental backup.
• Setup GoldenGate unidirectional within Oracle databases.
• Handled Goldengate abending issues in RAC & NON-RAC databases.
• Handled performance issues at database level and SQL side also.
• Used to analyze AWR &ADDM reports and implement them to optimize the queries and database performance.
• Supported on call on 24x7 basis.
• Experience on batch processing jobs like AUTOSYS to schedule and maintain oracle related jobs.
• Utilized Oracle SQL Plan Stability concepts and tuned queries.
• Provide expect Oracle technical input and support for database upgrade projects and implement these game plans for the upgrades
• Work closely with development DBA teams on trouble-shooting SQL issues impacting database performance and uptime SLAs
• Design and implement High Availability (HA) solutions using Real Application Clusters (RAC) using Automatic Storage Manager (ASM).

Environment: SUN SOLARIS SPARC 9/10 Oracle Enterprise Linux, WINDOWS 2005, Oracle 12c/11g/10g, 9i/10g/11g RAC Databases, MS SQL Server 2012/2008, Data Ware House, TOAD, JDeveloper, Oracle Grid Control, Data Guard, GoldenGate, ASM, RMAN, SAN, BMC, ASM/ACFS.

Confidential

DBA Team Lead/Oracle

Responsibilities:

• Worked as a Lead of team 6 members who are Oracle and SQL Server DBA’s.
• Managed database inventory for the client to provide new databases that came up during the year.
• Wrote shell scripts for a newly created database.
• Deployed 11gR2 database to Production.
• Experience in setting up GoldenGate 11g.
• Handled various GoldenGate issues after setting up.
• Performed Maintenance activities like defragmentation of tables and rebuilding indexes.
• Performed restoration of critical databases to staging databases using RMAN.
• Handled performance issues at database level and SQL side also.
• Used to analyze AWR &ADDM reports and implement them to optimize the queries and database performance.
• Used to TRACE sessions using SQL TRACE and understand the execution plan of SQL’s.
• Utilized Oracle SQL Plan Stability concepts and tuned queries.
• Worked on SQL Server 2008 databases and did administration work.
• Manage all primary on-call DBA activities such as checking on tablespace problems, checking for fragmentation of tables and indexes.
• Design, and implement database backup/restore infrastructure using Oracle RMAN and Netbackup tools.
• Applied both regular and critical patches (CPU & PSU) related to the production databases.

Environment: SUN SOLARIS SPARC 9/10 Oracle Enterprise Linux, WINDOWS 2005, Oracle 11g/10g, 9i/10g/11g RAC Databases, MS SQL Server 2008, Data Ware House, TOAD, JDeveloper

Confidential, Boston, MA

SR. DATABASE ADMINISTRATOR

Responsibilities:

• Performed migration from oracle 9i to 10g.
• Experience in using DBUA utility to perform migration.
• Performed migration from 10 to 11g in RAC environment.
• Gained experience in working on Storage Area Network (SAN) by installing stand alone and RAC databases.
• Supported ORACLE 9i/10g RAC 3+ node Databases (Raw devices & ASM); handled migration/upgrades of databases from 10g to 11g manually and with DBCA.
• Oracle database migration from American character set to UTF8
• Oracle RAC software Upgrades to 10g and RAC migration from one server to other.
• Data migration (total Oracle 9i RAC DB restores to different machine).
• Performed Backup/Recovery using RMAN and established testing standards utilizing the advantages of 10g Flashback.
• Performed daily backups of database using RMAN and also used the new features of RMAN to apply incremental backups to full backup to minimize recovery time.

Environment: HP-UX 11i itanium server, Windows 2005, HP TRU64 4.0/5.0, SUN SOLARIS 10, Oracle 9i, 10g, 11g RAC Databases, Data Ware House, TOAD, JDeveloper, Oracle Grid Control, EMC.

Confidential, CA

DATABASE ADMINISTRATOR

Responsibilities:

• Installed, configured and maintained ORACLE 10g Real Application Cluster (RAC).
• Set up and maintained oracle disaster recovery site using DataGuard.
• Performed user and security administration activities, such as enrolling users, granting privileges to users, and maintaining system security.
• Utilized RMAN for backup and recovery strategy.
• Completed export and import of different databases using Oracle Export / Import utilities.
• Table fragmentation tuning, partitioning the large table by date.
• Installed Grid Control along with setting up agents.
• Installed Oracle database 10g, and upgraded Oracle 9i to 10g.

Environment: HP-UX itanium, AIX 5.2, Sun Solaris 9, Red Hat Linux AS4, Oracle 9i/10g/10g RAC, SQL Back-Track, RMAN, Data Guard

Confidential, Redwood City, CA

DATABASE ADMINISTRATOR/Oracle DBA

Responsibilities:

• Monitored applications at the database level and identified problem areas and hot spots, isolated issues and recommended solutions.
• Created disk farm usage report and the data growth pattern reports for management groups.
• Configured Sqlnet, Net8 and Oracle Net services connect failover and application failover (TAF) for RAC 2+ nodes, load balancing, Names server and ODBC.
• Performed physical backup using RMAN and logical database backup using export utility.
• Monitored and tuned production environment when volume of data impacted performance, utilizing OEM SQL Analyze, OEM Top Sessions, OEM Performance Manager, Stats pack, SQL Trace, TKPROF etc.

Environment: Sun Solaris, Red Hat Linux and Windows 2000/XP, Oracle 8i/9i/10g