PROFESSIONAL SUMMARY:

• Over 9.10 years of proficient experience in Oracle Database Administration, HP Vertica, Mongodb, PostgreSQL, SQLServer2012/2014, Golden Gate, Maria DB, Delphix DBA provid Confidential 24/7 Production and Development support for 12c/11g/10g/9i databases on UNIX & WINDOWS. Have extensive experience in Installations, Configuration, Performance Tun Confidential, Backup/Recovery, Disaster Recovery, Clon Confidential, Upgrades, Migration, Maintenance and Documentation.
• Experience in install Confidential and configur Confidential databases (9i/10g/11g/12c) on Solaris, AIX, HP - UX, Red Hat Linux and Windows NT platforms.
• 3.7 Years of Experience in HP Vertica as a DBA.
• Sett Confidential up database in HP Vertica DB
• Performance tun Confidential in HP Vertica.
• Resolv Confidential Issues with HP Vertica 7.2.
• Upgrad Confidential databases in Vertica from Version 7.1.2-10 from 7.1.0-3
• Perform Confidential Expansion of cluster in Vertica from 3 Nodes to 18 Nodes.
• Experience in Work Confidential and Install Confidential HP Vertica.
• Expertise in Monitor Confidential and Troubleshoot Confidential HP Vertica.
• Expertise in Perform Confidential Performance tun Confidential in Hp Vertica
• Expertise in Add Confidential and Remov Confidential Node in HP Vertica Cluster.
• Experience in Understand Confidential Rebalanc Confidential In HP Vertica.
• Experience in work Confidential with Diagnostic Tools in HP Vertica.
• Experience in Implement Confidential HP Vertica in AWS
• Experience in Chang Confidential IP Address of HP Vertica Cluster.
• Hav Confidential 3+ years of Experience in Mongo DB 3.0
• Expertise in sett Confidential up Replica set along with arbiter.
• Experience in Mongo db Upgrade from 2.6 to 3.0.
• Experience in sett Confidential up Mongo Management console.
• Have worked on Install Confidential and Configur Confidential Maria DB.
• Hav Confidential 5+ years of Experience in PostgreSQL.
• Experience in Install Confidential and Configur Confidential PostgreSQL and pgadmin.
• Sett Confidential up Master Slave Replication in PostgreSQL.
• Experience in Sett Confidential up Slony in PostgreSQL.
• Expertise in Resolv Confidential Performance Issue in PostgreSQL.
• Experience in creat Confidential Users and Databases in PostgreSQL.
• Experience in Back Confidential up and Restor Confidential Database and Tables in PostgreSQL.
• Experience in Configur Confidential new Golden Gate Setup.
• Experience in Upgrad Confidential Golden Gate from 11.2.1.0 to 12.2.0.1.
• Experience in work Confidential with Password E Confidential yption in Golden Gate.
• Migrat Confidential Classic to Integrated Capture in Golden Gate.
• Work Confidential with Golden gate New Features in 12.2
• Experience in configur Confidential Heartbeat Table in Golden Gate.
• Identify Confidential Long Runn Confidential Transaction in Golden Gate.
• Experience in Implement Confidential Golden Gate.
• Experience in Implement Confidential CDR in Golden gate.
• Installation and configuration Oracle 10g/11g RAC with Automatic Storage Management (ASM) in various operat Confidential systems on very large databases (VLDBs) and migrat Confidential databases to RAC
• Extensive experience in migration/upgrad Confidential of databases to higher versions from Oracle 9i, 10g to 10g, 11g to 12c.
• Experience in apply Confidential Patch sets, Patch set Updates (PSU), Critical Patch Updates (CPU) and interim patches us Confidential OPatch utility.
• Sett Confidential up, configur Confidential and manag Confidential standby database for disaster recovery, high availability and business continuity (Data Guard).
• Expertise in installation, configur Confidential and maintain Confidential Oracle Streams (unidirectional/bi-directional) and troubleshoot Confidential the issues.
• Schedul Confidential physical (hot and cold) backups and logical backups through OEM and by runn Confidential scripts.
• Extensively worked on RMAN, implement Confidential periodical backups, restore and recovery (i Confidential emental and full) includ Confidential point-in-time recovery when necessary.
• Experience in install Confidential, configur Confidential and manag Confidential Grid Infrastructure, Automatic Storage Management (ASM) and migrat Confidential databases to ASM.
• Expert in clon Confidential (duplicat Confidential ) and restor Confidential Oracle Databases us Confidential Recovery Manager.
• Load Confidential and unload Confidential data us Confidential Export, Import, Data Pump and SQL*Loader utilities.
• Experience in database design, logical model Confidential, partition Confidential tables and indexes.
• Implement Confidential and manag Confidential Large Oracle databases on OLTP, OLAP and DSS database systems of various sizes up to 20TB.
• Extensive experience in installation, configuration and monitor Confidential administrat Confidential tools like OEM Grid Control 10g/11g and Cloud control 12c, Toad, DBVERIFY and Log miner.
• Implementation of Flashback Technology and various features of Flashback technology.
• Monitor Confidential and optimiz Confidential the database performance (Database Tun Confidential ) through tools like Explain Plan, SQL*Trace, TKPROF, AWR, ADDM, ASH..
• Experience in Refresh Confidential Database, Schema and objects when necessary with datapump and rman.
• Experience in features like Schema Management, Space Management, Capacity Plann Confidential, Invalid objects recompilation and Undo segments.
• Proficient in UNIX, SQL and PL/SQL script Confidential, writ Confidential procedures, functions, packages triggers and database objects us Confidential PL/SQL.
• Creation and maintenance of user accounts, manag Confidential quotas, audit Confidential, analyz Confidential security problems, resolv Confidential connectivity issues and sett Confidential permissions for users.
• Resolv Confidential complex issues of Database by work Confidential with Oracle Support through SR’s.
• 24/7 Production database support and responsible for round-the-clock database operations.
• Excellent communication and interpersonal skills and ability to work well in a team as well as to take individual responsibility.

TECHNICAL SKILLS:

RDBMS Oracle 9i/10g/11g/12c, 10g/11g RAC. BIG DATA HP Vertica, Green Plum, PostgreSQL Operat Confidential Systems UX, Sun Solaris, AIX, RHEL, and Windows NT. Languages UNIX Shell Script Confidential, SQLTools & Utilities RMAN, OEM Grid Control, cloud control, SQL*Loader, Data Pump, Export, Import, TOAD, Oracle SQL Developer, Golden Gate, AWS EC2, Storage Gateways, Delphix Tun Confidential Tools TKPROF, EXPLAIN PLAN, AWR, ASH, ADDM and ASMM. Ticket Confidential Tool HP Service Manager. Espresso, Central Station

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Sr. Oracle DBA

Responsibilities:

• Installed, configured and administered 10g, 11g, 12c standalone databases and 11g 2 node Real Application Clusters (RAC) on AIX and Linux and worked on ASM features of Oracle.
• Extensively worked on Database Upgrades from 10g to 11g and 11g to 12c and Documented procedure for DB upgrades along with Standby databases.
• Install Confidential and configur Confidential 12c Oracle Enterprise Manager Cloud Control and configured management agent on different targets.
• Implemented and managed Oracle Data Guard for production databases on Oracle 11g and 12c.
• Clon Confidential /duplicat Confidential database for creat Confidential test Confidential and train Confidential environments us Confidential RMAN.
• Expertise in troubleshoot Confidential and performance tun Confidential for optimal performance by Query tun Confidential, memory tun Confidential us Confidential tools like AWR, ADDM, SQL Tun Confidential advisor, OEM Cloud control and analyz Confidential OS memory and CPU utilization.
• Worked on in-depth query tun Confidential like analyz Confidential explain plans, us Confidential hints, sett Confidential baselines, profiles, creat Confidential indexes, histograms, generat Confidential Sql trace if necessary etc.
• Performed Oracle Patch Confidential (PSU, CPU and bug-fix patches) on several databases us Confidential Opatch.
• Daily, weekly and monthly backups along with i Confidential emental us Confidential RMAN, Cloud Control and also us Confidential scripts for cold and hot backups ensur Confidential optimal recovery of data in case of media failure..
• Performed database point-in-time recovery, tablespace point-in-time recovery (TSPITR) us Confidential RMAN and Flashback technology.
• Installed Oracle Client software on several Windows and UNIX servers. Also developed automated script to automate client install.
• Installed and cloned oracle home binaries on several servers and documented procedure for install Confidential /clon Confidential oracle 12c binaries and developed automated clone script.
• Manag Confidential user accounts by grant Confidential required privileges, restrict Confidential access and maintain Confidential security by audit Confidential . Also generat Confidential monthly reports for SOX audit Confidential .
• Writ Confidential shell script Cron jobs for schedul Confidential automatic backups, monitor Confidential, and administrative works.
• Implement Confidential D-Source and Creat Confidential VDB’s in Delphix.
• Experience in work Confidential with Delphix Engine 5.1.4.0.
• Troubleshoot Confidential Issues in Creat Confidential Dsource in Delphix Engine.
• Creat Confidential JetStream Users in Delphix and provid Confidential them necessary access.
• Perform Confidential Installation of Green Plum Databases.
• Experience in Perform Confidential Performance tun Confidential in GP database.
• Experience in Perform Confidential GP Transfer from Production to Dev Database.
• Experience in Rebalanc Confidential the Nodes in GP Database.
• Experience in Install Confidential and Configur Confidential PostgreSQL and pgadmin.
• Sett Confidential up Master Slave Replication in PostgreSQL.
• Experience in Sett Confidential up Slony in PostgreSQL.
• Expertise in Resolv Confidential Performance Issue in PostgreSQL.
• Experience in creat Confidential Users and Databases in PostgreSQL.
• Experience in Back Confidential up and Restor Confidential Database and Tables in PostgreSQL
• Expertise in Space management, capacity plann Confidential, add Confidential disks, distribut Confidential the partitioned tables, alter Confidential redo logs, monitor Confidential data growth, undo management.
• Upgrad Confidential databases in Vertica from Version 7.1.2-10 from 7.1.0-3.
• Perform Confidential Expansion of cluster in Vertica from 3 Nodes to 18 Nodes.
• Experience in Add Confidential and Remov Confidential Node in HP Vertica Cluster.
• Experience in Rebalanc Confidential of Nodes In HP Vertica.
• Experience in Perform Confidential Performance Tun Confidential in HP Vertica.
• Experience in Implement Confidential HP Vertica in AWS.
• Experience in Chang Confidential IP Address of HP Vertica Cluster.
• 3.7 years of Experience in SQL Server Database includ Confidential Transaction Log Backups, Performance tun Confidential .
• Experience in Mirror Confidential, Replication, Cluster Confidential, and Log Shipp Confidential for SQL SERVER
• Troubleshoot and diagnose routine Oracle related problems in the production environment.
• Performed data load Confidential and unload Confidential us Confidential Export, Import, DataPump and SQL*Loader utilities.
• Handled corruption by us Confidential DBVERIFY utility and RMAN for find Confidential corrupted blocks and fix Confidential them through RMAN block recovery and dbms repair.
• Involved in Disaster Recovery Tests for critical production systems and documented recovery procedure for data guard switchover/disconnect Confidential standby database and Rman restore.
• 24/7 Production database administration, support and monitor Confidential to ensure a problem recognition and resolv Confidential complex database issues by work Confidential with Oracle Support by open Confidential SR’s.

Environment: Oracle 10g/11g/12c, RAC, ASM, Oracle Data Guard, OEM Cloud Control, Service now, SQLSERVER 2012/2014, TOAD, RMAN, Data Pump, AWR, ADDM, AIX, Linux and Windows NT, HP Vertica, PostgreSQL, Golden Gate.

Confidential - Sunnyvale, CA

Sr. Tech Lead

Responsibilities:

• Installed, configured and administered 10g/11g Oracle databases on AIX, Linux, Solaris and Windows.
• Installed and maintained 2 node 11g RAC for high availability on ASM.
• Install Confidential and configur Confidential 10g/11g Oracle Enterprise Manager Grid Control and Cloud Control 12c, configured management agent on multiple targets.
• Experience in Mongo db Upgrade from 2.6 to 3.0.
• Experience in sett Confidential up Mongo Management console.
• Have worked on Install Confidential and Configur Confidential Maria DB.
• Expertise in sett Confidential up Replica set along with arbiter
• Performed Database Upgrades from 10g to 11g.
• Sett Confidential up Golden Gate in Oracle 11g.
• Experience in Sett Confidential up Integrated Replicat in Golden gate.
• Experience in Add Confidential a table to Exist Confidential GG Environment.
• Experience in Collision Handl Confidential in GG.
• Upgrad Confidential databases in Vertica from Version 7.1.2-10 from 7.1.0-3.
• Perform Confidential Expansion of cluster in Vertica from 3 Nodes to 18 Nodes.
• Experience in Add Confidential and Remov Confidential Node in HP Vertica Cluster.
• Experience in Rebalanc Confidential of Nodes In HP Vertica.
• Experience in Perform Confidential Performance Tun Confidential in HP Vertica.
• Applied PSU, CPU and bug-fix patches on several databases.
• Implement Confidential D-Source and Creat Confidential VDB’s in Delphix.
• Experience in work Confidential with Delphix Engine 5.1.4.0.
• Troubleshoot Confidential Issues in Creat Confidential Dsource in Delphix Engine.
• Creat Confidential JetStream Users in Delphix and provid Confidential them necessary access.
• Clon Confidential of the databases us Confidential RMAN for stag Confidential /test Confidential purposes and for objects recovery.
• Implemented and managed Oracle Data Guard for databases on Oracle 10g/11g.
• Performed backup and recovery procedures for ensur Confidential optimal recovery of data in case of media failure. Daily, weekly and monthly backups along with i Confidential emental us Confidential RMAN through Grid Control and shell scripts.
• Implemented table partition Confidential for large data tables for improv Confidential performance and manageability.
• Worked on features like Advanced E Confidential yption and Oracle Label security for restrict Confidential access at table level and column level data by creat Confidential policies etc.
• Performed Restore and point-in-time Recovery of databases us Confidential RMAN.
• Developer automated script for clon Confidential Oracle database software on multiple UNIX servers.
• Worked on Database Security, audit Confidential, user Management, Privileges, Roles etc.
• Installation of 12c Client for both 32 and 64 bit.
• Effectively used tools like STATSPACK, AWR, ADDM, EXPLAIN PLAN and tkprof for tun Confidential the performance.
• Tun Confidential memory by siz Confidential shared pool and buffer caches to reduce pars Confidential and disk access Confidential .
• Troubleshoot Confidential routine Oracle related problems in the production environment and was involved in develop Confidential stored procedures.
• Performed data load Confidential /unload Confidential and DB/table refresh us Confidential Export, Import, DataPump and SQL*Loader utilities.
• Created Cron jobs that run automatically and writ Confidential the Shell scripts for database monitor Confidential and backups.
• Train Confidential programmers with SQL and PL/SQL for creat Confidential various reports.
• Installed Oracle Client software on several windows and Unix servers.
• Monitor Confidential index usage by rebuild Confidential indexes whenever needed (to avoid fragmentation), remov Confidential unused indexes.
• Worked on complex issues of Database by open Confidential SR’s from Oracle Support
• 24/7 Production database administration, support and monitor Confidential to ensure a problem recognition and resolv Confidential database issues.

Environment: Oracle 10g/11g/12c, Oracle Data Guard, Oracle Enterprise Manager Grid Control, SQL, TOAD, RMAN, Data Pump, HP Vertica, Mongodb, PostgreSQL, SQLSERVER 2014 AWR, ADDM, AIX, Linux, Solaris and Windows NT.

Confidential, Mphasis, Pune

Sr. Oracle DBA

Responsibilities:

• Installed, configured and administered 2 node 10g/11g Real Application Cluster (RAC) on RHEL on ASM file system.
• Install Confidential and configur Confidential 11g Oracle Enterprise Manager Grid Control and configured management agent on different targets.
• Performed Database Migration and Upgrade from 10g to 11g.
• Installed configured and maintained Oracle streams and worked with Golden Gate for replicat Confidential data.
• Implemented and managed Oracle Data Guard for production databases on Oracle 10g/11g.
• Performed backup and recovery procedures for ensur Confidential optimal recovery of data in case of media failure.
• Schedul Confidential daily, weekly and monthly backups us Confidential and us Confidential scripts for cold and hot backups.
• Partition Confidential tables, us Confidential and maintain Confidential materialized views, snapshots and DB links.
• Renam Confidential, resiz Confidential databases and duplicat Confidential databases on several servers and perform Confidential capacity plann Confidential for databases.
• Applied CPU/PSU patches, one-off and interim patches on S Confidential le instance and RAC Databases.
• Effectively used tools like STATSPACK, AWR, ADDM, EXPLAIN PLAN and tkprof for tun Confidential the performance.
• Tun Confidential memory by siz Confidential shared pool and buffer caches to reduce pars Confidential and disk access Confidential ..
• Performed database restore/recovery, transportable tablespace us Confidential RMAN.
• Performed object and data transfer us Confidential Export, Import, DataPump and SQL*Loader utilities.
• Train Confidential programmers with SQL and PL/SQL for creat Confidential various reports.
• Make additions, creation, corrections and documentation of exist Confidential database schema.
• Prepared documentation for ongo Confidential maintenance and support and troubleshoot Confidential network Confidential issues for establish Confidential Client/Server connections.
• Worked with corporate executives to identify business processes and application requirements that can be part of a logical ERD.
• Effectively tuned the 10g/11g database instances by creat Confidential own scripts for effective monitor Confidential and maintain Confidential .

Environment: Oracle 10g/11g RAC, Automatic Storage Management(ASM), Oracle Data Guard, Golden Gate, Oracle Streams, Oracle Enterprise Manager Grid Control, TOAD, RMAN, Export, Import, DataPump, AWR, ADDM, AIX, Red Hat Enterprise Linux and Windows NT.

Confidential

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g on RHEL 4 and 11g on RHEL 5.
• Configuration and maintenance of a multi node RAC on Oracle 11g.
• Extensively worked on RMAN for daily database backup, restore and recovery of all production databases.
• Patched Oracle Database Server 9i and 10g and applied One-off Patches us Confidential Opatch utility.
• Sett Confidential up Data Guard for company’s disaster recovery strategy us Confidential RMAN.
• Clon Confidential database for creat Confidential test Confidential and train Confidential environments.
• Perform Confidential regular logical backups of database, schemas and tables us Confidential export, import and Data Pump utility.
• Perform Confidential ongo Confidential tun Confidential and troubleshoot Confidential of databases and applications with STATSPACK, AWR, ADDM and ASH tools.
• Also tun Confidential SQL queries for better performance us Confidential these tools.
• Refresh Confidential Database and table with SQL Loader & Datapump, migration of standalone databases to RAC.
• Worked with infrastructure and application and teams, architects, developers and testers, to ensure project success.
• Resolv Confidential complex issues of Database by work Confidential with MOS Service Requests.
• Developed many UNIX shell script Cron jobs for automatic backups and O/S monitor Confidential jobs and regular day-to-day requests.
• Prepared documentation for ongo Confidential maintenance and support.
• Extensive database monitor Confidential, maintenance and user management.
• Developed PL\SQL stored procedure, package, triggers, cursors, and views.
• Granted and revoked privileges to users as per requests and maintained database security procedures.
• 24/7 Production database administration, support and monitor Confidential to ensure a problem recognition and resolv Confidential database issues.

Environment: Oracle 10g/11g, RAC, Automatic Storage Management(ASM), Oracle Data Guard, SQL Loader, export, import, Data Pump, RMAN, Oracle Enterprise Manager(OEM) Grid Control, TOAD, Shell Script Confidential, RAC, HP-UX, SUN-Solaris, RHEL, and Windows NT.