SUMMARY

• Over 10+years of experience as an Oracle Database Administrator having hands - on experience in database administration and performed different tasks like installation, configuration, Migrations, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security, implementing TDE, writing stored procedures and providing 24*7 support for multiple OLTP database and data warehousing environments on various platforms Experience on high volume databases with sizes varying from 50 GB to 200+ TBs of data on various version of ORACLE 12c/11g/10g/9i.
• Providing DBA support to multiple Cluster, Non-cluster, and ASM Database in production, development and Testing Servers on UNIX, Linux, and Solaris Environments.
• Experience in Installation, Configuration and Monitoring of Oracle ASM on UNIX, Linux, AIX and Windows Environments.
• Extensive experience with Oracle database administration of Oracle 10g, 11g & 12cRAC with multiple nodes covered all aspects of administration like installations, configurations, migration, Patches, Critical Patch Updates (CPU), Upgrades, replication, sizing and space management.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g and 12c database with experience in very large-scale database environment and mission-critical large OLTP and OLAP systems.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (as), TOAD, Oracle SQL Developer in various versions.
• Installation, Configuration, and Maintenance of Logical/Physical standby databases in Data Guard.
• Having good experience in configuring OEM 12C cloud control and monitoring databases using OEM 10g/11g/12c/13c, Configuration, and Management of Data Guard 10g/11g/12c on RHEL, OEL, and Sun-Solaris for Disaster Recovery.
• Expertise in setup/implementation/maintenance of Real-Application-Cluster (RAC) of 2/3/4 Node RAC on 10g/11g/12c.
• Experience in Installation and Configuring of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid).
• Experience in taking logical backup of the database using DATAPUMP (Expdp/Impdp).
• Installed and configured GoldenGatev11 and 12c on AIX 6.1 and RHEL 5.8,6.7 platform and Performed Cross-platform migration and used Oracle Golden Gate to migrate databases from AIX to Linux as a part of u12 Cloud migration project.
• Installed and Configured GoldenGate components for transaction-level DDL, DML, Uni-directional and Bi-directional replication between heterogeneous environments and maintain data synchronization using GoldenGate v 10, v11 and 12c .
• Configured Oracle GoldenGate for bi-directional replication and migrated databases with ZERO downtime.
• Extensive troubleshooting of typical Oracle GoldenGate technical issues: such as differences in the rows count from source to target, column mismatch errors, unique key violation by using ggsci / log dump/discard file & ggserr.log analysis.
• Migration of databases to EXADATA's (cross-platform), Patching, RE-IP & EXADATA maintenance activities.
• Worked on EXADATAX5, X3-2, Quarter RACK Half RACK. X2-2 half RACK & X2-8 Full RACK.
• Performance tuning of databases using AWR, ASH reports, ADDM reports, provided instance-level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage, Oracle 11g new partition techniques Interval partitioning, system partitioning, Creating Views &Materialized Views, Implementing SQL profiles and Migrating SQL BASELINES, Creating and rebuilding Index's, re-organizing tables.
• Applied PSU quarterly on 11g/12c GRID & RDBMS homes using patch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN.
• Identified and fixed the logical block corruption using RMAN& PERFORMED logical backup using Datapump Expdp and Impdp Utility.
• Configured Physical Standby databases using data guard for maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business.
• Supported development teams by providing SQL statement Tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Proficient in SQL, PL/SQL, Perl Script, Shell Script, ERwin Data modeling, OLAP, Oracle Data Dictionary - metadata, Logical and Physical Database Design.
• Expertise in developing various Database objects like Triggers, Stored procedures, Functions, Sequences, Views, etc.
• Worked on MS SQL 2000 / 2005 /2008 , creating backup strategies, Maintenance plans, and Job Scheduling and User maintenance.
• Working closely with clients, business analysts, server administrators, systems programmers, and application developers to define and resolve information flow and content issues - helping to transform business requirements into environment specific databases.

TECHNICAL SKILLS

Operating System: HP-UX 10.x/11.x, IBM AIX 4.x/5L, Sun Solaris 2.6/8/9/10, Linux 2.x/3.x/4.x/5.x and Exadata X3-2, X2-2, X3-5

RDBMS: Oracle 9i, 10g, 11g, 12C, oracle 10g/11gR2/12c RAC and MS SQL server

Database Servers: Oracle Application Server 10g, HP 700 Series, HP Superdome, Sun Enterprise 450 &880, Sun 3500, 3800, 6800, Sun fire 4800, V1280, Dell PowerEdge.

Languages: SQL, SQL *Plus, PL/SQL, C, C++, UNIX Shell Scripting

Tools: Exadata, Golden gate,RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, Shareplex.

Tuning tools: TK PROF, EXPLAIN PLAIN, STATSPACK, SQL*TRACE, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential

Sr. Database Architect/ Exadata Lead

Responsibilities:

• Experience in Oracle (12c & 11g) Multi-tenancy, Data Guard, ASM, RAC database, Grid, OEM, CPU patches, Oracle installation, database Upgrades, Migration, Backup, Recovery, troubleshooting, SR (TAR) support, GoldenGate setup.
• Installation and use of High Availability and Disaster Recovery components; Oracle GRID Infrastructure /Cluster ware, Oracle 12c two-node RAC for the database tier.
• Configure the Data Guard Broker and used for switchover and Stopping and Starting Media recovery process.
• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 12C/13C for monitoring databases.
• Applied database patches using Opatch utility & building Clone instances for Development and Test teams.
• Implemented Data Guard with maximum availability and performance configurations for production databases.
• Administered and managed OCR (Oracle Cluster Registry) including manual backup of OCR and design the recovery strategy of OCR and monitoring of OCR daemons like CSSD, CRSD, EVMD, and EVM.
• Storage Migrations: Solely responsible for migrating the Prod/Test/Dev Databases from NetApp to HNAS and to block-level storage. (Migrating the databases from Non-ASM to ASM)
• Expertise in Querying RDBMS such as Oracle and MYSQL by using SQL for Data integrity and used My cluster manager for administrating MYSQLNDB cluster.
• Solid experience in disaster recovery, Database backup concepts, and options such as user-managed backup, RMAN-managed backup with or without a catalog, operating system backup, cold and hot backup, full back up, incremental, cumulative backup and implementing backup and recovery strategies.
• Design and development of Business Intelligence Solutions using Informatica, Business Objects, Cognos, and Erwin. Expertise in Oracle12c, MS SQL, Erwin 4.0/3.5, SQL 2012, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored procedures, triggers.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, functions, packages, UNIX Shell Scripting, Indexes, Logical and Physical database design to implement the business logic.
• Migrated SQL servers from 2008R2 and 2012 to 2014 on standalone and cluster environment.
• Performance tuning of Oracle databases using SQL Access Advisor, SQL Performance Analyzer, SQL Tuning Advisor.
• As part of the GDBA Support team we provided L2/L3 level support to the application teams during high-risk issues (escalations) and within normal activities like code migration, Database recovery via RMAN, troubleshoot performance issues, export, and import of tables/schemas among environments.
• Provided L2 and L3 production support depending upon the ticket assigned to meet the corresponding SLA's.
• Developed scripts to proactively monitor and databases and alter the DBA on events such as running out of extents, disk space and actively involved in shell scripting for various CORN jobs to be run.
• Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, the creation of users, schemas, tablespaces, and other database objects.
• Involved in 24x7 support for 8TB, 4 Node production RAC database with an on-call pager.
• Working with the Oracle Support Mechanisms; My Oracle Support (Meta-link), Raising Service Requests.

Environment: Oracle 12c,11g R1,11g R2, OEM 12c/13c, RHEL6, AIX6, GG 12c/11g, SQLPLUS, TOAD, SQL DEVELOPER, PuTTy, Secure CRT, ASM, PL/SQL, MS SQL.

Confidential, Virginia Beach, VA

Sr. Oracle DBA/ Golden Gate Administrator

Responsibilities:

• Installed Oracle DB 11g, 12c RDBMS, RAC on ASM, Applying Oracle Critical patch updates, Implementing and Manage Data Guard, Replication, Backup and Recovery support, and performance tuning etc.
• Expert in performance tuning of database, memory & I/O. used tools such as AWR, ADDM, STATSPACKING, HANG ANALYZE, SYSTEM STATE and analyzing queries using EXPLAIN PLAIN, SQL-TRACE, TKPROOF, OEM.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Worked on Multiple RAC clustered, converting single node instance to RAC and adding an instance to the existing 5 Node RAC.
• Taking the RMAN incremental and cumulative and scheduling the database backup using the Cron tab.
• Monitoring the Oracle Instances, Users, Tables, Tablespaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs, and Alerts.
• Expertise in moving databases to Exadata and Involved in migration strategies.
• Implemented several new features in Exadata concepts like Hybrid Columnar Compression (HCC), Smart Cache, Storage indexes and cell offload processing.
• Familiarity with CellCLI tool to manage the Exadata storage cells.
• Performed cloning and refresh of Database from the production environment to test environment using RMAN Duplicate Database and Data Pump import-export.
• Migrated OLAP databases close to 8TB with minimal downtime using Golden Gate and verified data integrity using Golden Gate Veridata tool for Linux 3 Node RAC.
• Installed and configured GoldenGatev11 and 12c on AIX6.1 and RHEL 5.8,6.7 platform and Performed Cross-platform migration and used Oracle GoldenGate to migrate databases from AIX to Linux as a part of the u12Cloudmigration project.
• Re-wrote the shell scripts to monitor Golden Gate processes various states (like STOPPED/ABENDED/LAG/HUNG) to reduce the number of alerts by grouping them together by the environment.
• Installed Golden Gate using Zero Time Migration, Integrated, and Classic Capture/Extract.
• Migrated SYBASEASE15 to Oracle 10g using the golden gate.
• Configured Golden Gate 12c against RAC and non-RAC databases using the Cluster-ware Database file system.
• Configured Golden Gate BI-DIRECTIONAL replication and replicated tables between instances and used CDR parameters to resolve conflicts and applied business rules in the environment.
• Used Golden Gate in combination with Active Data Guard and RAC12c Container databases to achieve maximum availability and the Highest Fault-tolerant database system.
• Expertise in creating Oracle Tables, Table Partitions, Views, and Materialized Views .
• Implemented Advanced Security in different database one as Transparent Data Encryption and other as Oracle Data Redaction.
• Used TOAD as third-party software for analyzing the database issues and generating results sets in XPS formats.
• Handled all daily DBA activities and experience with PERL/SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints and business rules.
• Involved in 24x7 production database maintenance and on-call support.

ENVIRONMENT: Oracle12c/11g/10g/9i, Oracle EXADATA X2-2 HALF RACK, Sun Solaris, Red Hat Linux, RMAN, SQL Server, Data Guard, Golden Gate, OEM, Grid Control, Toad 10.X, STATSPACK, AWR, Explain Plan.

Confidential, Minneapolis, MN

Sr. Oracle DBA

Responsibilities:

• Configuring Oracle 11g and 12c on Linux and IBM Linux Servers, Oracle RAC, Data Guard, High Availability, (Physical and Logical Standbys) Building Disaster Recoveries across multiple Data Centers and configuring ASM and Database Upgrades.
• Upgraded 10.2.0.4 Two-Node RAC ASM Databases to 11g R2 Two Node RAC ASM.
• Involved in a fresh installation of 11.2.0.1 and 11.2.0.2 and 11.2.0.3 RAC databases on ASM and NFS file systems.
• Performed full and incremental Backup Using RMAN Utility for Production databases.
• Involved in upgrading the databases using Database Upgrade Assistance (DBUA).
• Manually created databases in RAC on ASM and configured RMAN and registered databases in the catalog server.
• Planned and Implemented Disaster Recovery (DR) and HA using RAC and Data Guard.
• Experience in Design, Creating and maintaining the Oracle Databases 11g from the scratch on UNIX and RHEL.
• Developed the Perl and Shell scripts to automate the finance-billing file.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10gR2 to the latest Oracle 11gR2.
• Daily Health Check-Up of the Database and SQL Queries using AWR, ADDM, and TKPROF.
• Installed and configured Golden Gate replication and migrated databases with Zero downtime using Golden Gate and Data guard.
• Performance tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms.
• Setup the Golden Gate Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated databases.
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR, and ADDM reports.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Experience in migration of SQL 2005 to SQL 2008r2 and up-gradation from MSSQL Server 2008 to MSSQL Server 2014.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.

ENVIRONMENT: Oracle 10g/11gR2, OEM, Data Guard, SQL Loader, RMAN, Data Pump, MS*SQL, Netapp, Oracle 12c RAC LINUX, ASM, PL/SQL, GOLDEN GATE.

Confidential

Sr. Oracle DBA

Responsibilities:

• High Availability (Data Guard --physical standby, RAC with ASM).
• Installed, configured and managed 11gR2(RAC) on ASM storage.
• Oracle Advance Security Transparent encryption (TDE) and Redaction.
• Replication (snapshots/materialized views and multi-master).
• Cloud and GRID Control, OEM/OMS, Data Pump (expdp/impdp, dbms datapump), SQL Loader, scp, ftp.
• RMAN (Backup & recovery, database cloning, physical standby).
• Database security (encryption via DBMS CRYPTO, users, roles, profiles).
• Data Warehouse development (creating materialized views &snapshots, STAR schema).
• UNIX administration (shell scripting, cron), DBMS SCHEDULER, DBMS JOB.
• Oracle server/client installation and configuration.
• Tuning (database, SQL & application tuning using ADDM/AWR, STATSPACK, TKPROF, explain plan).
• Net 8 Configurations, LISTENER.ORA, TNSNAMES.ORA and SQLNET.ORA.
• Data Modeling-Logical and Physical Design.
• Data Flow Diagrams (DFD) (Logical design).
• Entity Relational Diagrams (ERD) based on business rules (Logical design).
• Data integrity and normalization/denormalization (Logical design).
• Physical design (DDL from ERDs, DML, DCL).
• Process flow documentation.
• Golden-Gate Replication at schema level to capture, propagate and apply the DML, DDL changes to the replicated database.
• Installed GoldenGate using Zero Time Migration, Integrated, and Classic Capture/Extract.
• Applying Oracle patches (CPU, PSU, and ONE-OFF), using the OPatch utility and fixing bugs.
• Hands-on experience with development tools like TOAD, SQL Developer, and SQL Navigator.
• Write and troubleshoot shell scripting, SQL, and PL/SQL scripts.
• Implemented Database Mirroring on SQL Server 2008R2 in the Prod environment.
• Configured performance tuning and optimization in SQL Server 2005.
• Installing MYSQL with source and binary distribution.
• Working on various performance issues of MYSQL cluster.
• Co-coordinating with on-site counterpart as well as Clients and understanding requirements and providing 24x7on call support for all the production and development databases.

ENVIRONMENT: Oracle 11g/10g, OEL, HP-Unix 11.11, Red Hat Enterprise Linux, RAC, ASM, SQL*Plus, OEM, PL/SQL, SQL Developer, Data Pump, TOAD.

Confidential, Chicago, IL

Jr. Oracle DBA

Responsibilities:

• Involved in monitoring the Database related activities using Oracle Enterprise Manager 11g Grid Control (OEM Grid) and monitoring the backup jobs scheduled in OEM Grid.
• Performed configuration of Oracle ASM on HP-UX, RHEL.
• Performed Installation, Configuration, and Monitoring of Oracle 11gR2, 11gR1 and 10g on UNIX, Linux.
• Installed, configured and monitored Oracle RAC 11gR2 and 10gwith ASM.
• Configured and implemented Oracle 11gR2 Data Guard for Database disaster recovery.
• Experience in Planning Database, Sizing tablespace, create database, scripts, monitor databases, interact with developers, Oracle Install, Upgrade, 24x7 DBA support, Disaster Recovery Automate daily jobs, Schema management, SQL Loader, Export/Import Database, Tune database.
• Experience in RAC, EXADATA, ASM, DATAGUARD, Patching, Upgrades & Migrations.
• Working Experience with the latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Implemented and documented backup/recovery strategies using hot backup, cold backups using RMAN and Export/Import utilities and Wrote Shell Scripting for managing day-to-day activities and automation of backup.
• Performed a logical backup of the database and Schemas using DATAPUMP (Expdp/Impdp) as per the requirement.
• Migration of databases from MS SQL Server 2008 and Oracle 11g.
• Involved in implementation and support of 10g and 11g migrations and upgrades from Oracle 9i and 10g databases on HP-UX and Linux.
• Involved in PL SQL programming and Performance Tuning for Oracle Database by generating AWR and ADDM reports.
• Performed Database activities using Integrated Development tools like SQL Developer and TOAD.
• Effectively resolved incident tickets in the production environment.

ENVIRONMENT: Oracle 9i, 10g & 11g, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, Tuning Advisors, TOAD, Oracle 10g RAC, Sybase, SQL Server 2005.

Confidential

Oracle Developer/DBA

Responsibilities:

• Database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and Stats pack.
• Installation, Maintenance, and Administration of Oracle 10g on Red Hat Linux.
• Implemented Data-guard and administered the production database.
• Installed Oracle 10g RAC database on RHEL and applied all current patches.
• Database Restore using RMAN, Cold Backup, and Export/Import.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Developed PL/SQL packages, stored procedures, functions, Cursors, and Triggers.
• Used Flashback table to restore tables which are a new feature of Oracle 10g.
• Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency.
• Cloned the production database periodically to the testing databases through RMAN.
• Used Enterprise Manager on Oracle10g for the diagnostic summary, host CPU utilization, finding wait events, alert Log errors, etc.
• On-Call 24x7 DBA support for production databases.

ENVIRONMENT: IBM AIX 5.3, RHEL, Oracle 9i/10g PL/SQL, SQL*PLUS, Exceed 6.2, Oracle Enterprise Manager 9.2.0/10g, Quest Software (5.0), VERITAS Cluster, RMAN.