Data Oracle

Professional Summary:

Around ** years of experience as a Oracle Data Base Administration in implementing large-scale production environments across multiple heterogeneous system environment including UNIX, Linux, AIX, HP-UX and Windows.

Experience as an Oracle DBA in various domains to deliver new products, upgrades with Oracle 12c/11g/10g/9i/8i on Sun Solaris, Red Hat Linux, SUSE, HP-UX, IBM-AIX and Windows platforms.

Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to RAC environment.

Hands-on experience with Oracle Real Application Clusters (RAC10g/11g/12c), Golden gate, Exadata and Data Guard.

Experience in upgrading databases from 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1.

Implemented Golden Gate for Standby Configuration and developed procedures for Replication.

Performed data replication, transformation and delivery of database transaction using Golden Gate replication tool.

Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.

Implemented Golden Gate for data recovery and data migration for Oracle 11gR1 RAC multi nodes on IBM AIX and debugging Golden Gate issues such as extract, replicate rebuild and abend.

Hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g and 12c.

Strong experience in Hot/Cold Backups and Point-in-time Recovery procedures using RMAN.

Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, data Migrations using export/import, benchmarking using load testing tools.

Delivered SQL and Database performance tuning services via V$/GV$ views, Explain Plan, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM) Grid control, analyzed SQL trace dumps.

Extensive experience on OEM, TOAD (Tools for Oracle Application Developers), SQL*Plus and SQL*Loader as well as traditional UNIX command that requires for Oracle DBA.

Worked on POC OEM 12c/13c Cloud, installed in all our non -prod databases

Worked on building and rolling out new 12c databases for test/dev./qa environments.

Experience in resolving the Severity 1, Severity 2, and Severity 3 according to the Service Level Agreements (SLA’s).

Experienced in day-to-day DBA activities including schema management, user management (creating users, synonyms, privileges, roles, quotas, tables, indexes, sequence), space management (table space, rollback segment), monitoring (alert log, memory, disk I/O, CPU, database connectivity), scheduling jobs, UNIX Shell Scripting.

Good knowledge on ITIL processes and concepts for managing incidents, change requests.

Good Experience and working knowledge on Exadata configuration like 1/8, Quaterr, Half, Full Rack and Infiniband inter connect.

Good Knowledge on Bigdata eco systems(Clouders / Hattenworks/MAPR).

Qualification:

Masters in computer applications (MCA) from Periyar University.

Oracle Certified Associate 11G Adminstration.

Work Experience:

Client : Charter Communications

Role : Senior Oracle DBA, GoldenGate and Exadata

Period : Mar 2018 – Till date

Location : Saint Louis, Missouri, USA

Roles and Responsibilities:

As a senior member of Oracle Advanced Technical support group, provide advanced technical support to enterprise DBA team on Oracle database related technologies such as full rack Exadata Database Machine X5-2, Golden Gate 12c/11g RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, VLDB, optimize server resource utilization etc.

Perform Active duplication of non-production databases on Exadata X6-2 server according the Data Warehouse development project's requirement and compress large volume partition table by using Oracle HCC (Hybrid Columnar Compression) techniques.

Active participent in analysis and designing the infrastructure related projects. Assisted in integration of External applications into current IT actionable events and solutions.

SQL tuning in RAC Production and Performance Testing environments by using statistics, hints, SQL tuning set, SQL profile and etc.

Software and firmware maintenance of the Exadata storage servers in the Database machine including routine health check, patching and upgrades according to the suggestions from Oracle support department.

Maintenance of production and non-production databases which includes table space management, user creation, and privileges, roles,Installing 11g/12c Clients,RMAN Backups Configuration,Partition Creation,Support RMAN backup and recovery, Refreshing schems/Full database using RMAN and, data pump(Export/Import) tool.

Monitoring the critical application databases.

Extensively develop and maintain Korn shell and Perl scripts.

Worked on Sev1, Sev2 issues and offered best solutions with resolution.

Implementing the Prod changes durung the schedule window .

Environment: Oracle 11g/12c RAC, ASM, Toad, AWR, ADDM, ASH, SQLT, Data Pump, TDE,Database design flow charts, ACL, OEM 13C, RMAN, SQL*Loader, NETBACKUP, TFACTL, Datacenter, SAN and NAS Migrations,Exadata,Goldengate.

Client : Pepsico

Role : Senior Oracle DBA, GoldenGate and Exadata

Period : Sep 2017 – Mar 2018

Location : Dallas, Texas, USA

Roles & Responsibilities:

Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.

Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS), Datapump.

Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.

Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.

Setup, reconfigured and monitored single instance and multimode RAC to RAC Dataguard for DR.

Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration in 12c.

Created new databases/ instances on 11g/10g/12c RAC and single instances using customized scripts, DBCA.

Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.

Redesigned table and index partitioning strategies, using HINTS to improve the query performance.

Configured Manager, Extract and replicat processes to set-up uni and bi -directional replication.

Troubleshoot Golden gate on Oracle and sql server databases.

Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat, etc.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.

Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues

RCA for Node evictions and Instance evictions.

Monitoring the the Unii/Bi-ditrctional data replication using the Goldengate in 11g/12c.

Environment: Oracle 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, Data Pump, TDE,Database design flow charts, ACL, OEM 13C, RMAN, SQL*Loader, NETBACKUP, OLTP, Datacenter, SAN and NAS Migrations,Exadata,Goldengate.

Client : LLOYDS Banking Group

Implementation Prtner : Wipro Technologies

Role : Senior Oracle DBA,Goldengate

Period : Apr 2017 – Aug 2017

Location : Bangalore, India

Roles & Responsibilities:

USER Management: User Management (creation/updating) as per Database guidelines, USER access control, capacity planning for every 6months.

Created Database status reports with the help of Automatic work load repositories .

Modification of oracle parameters and also involved in the database startup/shutdown activities in a maintenance window.

Taking Hot and Cold Backups, Exports etc.

Excellent experience in database backup & recovery techniques and implementation of those recovery techniques to ensure business continuity.

Involved in Oracle database cloning and datapump activity related to refreshing schema using IMPDP and EXPDP.

Monitoring the OEM alerts from OEM and fix the issues pernmatly.

Installed 10g agents and start,restart,upload the agents when agents are down.

Involved in 10g RAC configuration,database,ASM installation.

Monitored the Voting disk, OCR files and its backup and recovery.

Database migration from Non RAC to RAC environment.

24/7 oncall rotational shifts and resolved the tickets based on priority Sev1,Sev2.

Decomissioned the oracle databases which are not required based on customer confirmation by maintaining the backup next 6 months .

Configured the Unidirectional Goldengate replication in 11g and configure the Table/Schema level replication by setting up the parameter files.

Fixing the Abended processe like Extract/Replicte.

Worked on the Integrated extract/replicat .

Mnaging the dataduplication using the handle collision.

Involved in 12c Goldengate setup.

Environment: Oracle 10gR2, RAC, Data Guard, Sun Solaris Servers, Linux, AIX and Windows XP,Goldengate.

Client : Blue Ash & Fusion MI (Middle-tier Interface)

Implementation Prtner : Epsilon Data Management, LLC

Role : Senior Oracle DBA, GoldenGate and Exadata

Period : May 2016 – Apr 2017

Location : Bangalore

Roles & Responsibilities:

Implementation of High Availability solutions with Oracle 12c RAC, Physical and Logical Standby Databases (Data Guard) and Replication using Golden Gate.

Efficiently performed installation, setup and creation of 4 node cluster RAC with Oracle 11g and 12.1.0.2 database using GRID infrastructure with ASM file systems on RHEL 6.X.

Maintenance of Oracle 11g/12c Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Build Oracle Data Guard with high availability and performance configurations and participated in Data Guard Switch over and Switch back in 11g and 12c.

Implemented Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).

Extensive skills to configure and build one-way, two-way, active-to-active Oracle Golden gate Extract/Replicat for multiple databases.

Strong experiences in configuration and building heartbeat monitoring in Oracle Golden gate.

Configure error handling for Oracle Goldengate restart, logging, production support and status reporting.

Setting up High Availability Oracle Golden gate OGG systems on Oracle 11gR2 RAC environments Front-end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack .

Environment: Oracle 12c/11g, RAC 11g, OEM 11g,12C,13C Grid Infrastructure, Oracle, Grid Control, Performance Tuning, OSQ, Import/Export, Data pump, Oracle Data guard, PL/SQL,Toad, OEM, Putty, VM Ware, Unix Shell Script, Linux, Solaris, HP-UX, Secure Shell, OBIEE 11g, Windows NT, Golden gate and Exadata.

Client : Johnson & Johnson and Abudhabi Commercial Bank

Implementation Prtner : Cognizant Technology Solutions

Title : Oracle DBA

Period : Apr 2013 - May 2016

Location : Bangalore, India

Roles & Responsibilities:

Provided 24x7 on call DBA support for over 3000 Oracle 9i/10g/11g production, QA, DEV databases on RHEL, HP-UX, and Solaris.

Involved in the installation, configuration of multi node -- 2, 3, 4 Node Oracle 10g/11g RAC with ASM.

Migrated Oracle 10g/11g RAC and non-RAC Single instance databases with ASM using Transportable Tablespaces (TTS), Datapump.

Upgraded production, Development databases from Oracle 9.2.0.8, 10.2.0.2, 10.2.0.4 to 11g/11g RAC.

Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.

Downgraded the 11g database during the version patch failures.

Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.

Created new databases/ instances on 11g/10g/12c RAC and single instances using customized scripts, DBCA.

Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.

Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.

Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.

Configured the ACL’s and change the Character set of existing database during migrations.

Recovery of Database (Recovering from Media Failure, Recovering the tables dropped accidentally, Recovering data files, recovering from Block Corruption) from previous RMAN backups.

Partitioned of large tables and indexes to improve performance, availability, creating and rebuilding the Indexes, database reorganization to improve performance of the queries and the database.

Performed capacity planning, space monitoring like tablespace growth, ASM disk space.

Implemented the Transparent data encryption in oracle databse for datasecurity.

Environment: Oracle 10g/11g, Oracle 10g/11g RAC, ASM, Toad, AWR, ADDM, ASH, SQL, Data Pump, TDE,Database design flow charts, ACL, OEM, RMAN, SQL*Loader, NETBACKUP, OLTP, Datacenter, SAN and NAS Migrations.

Client : Petro Canada (Suncor) & BCBS

Implementation Prtner : IBM India Private Limited Role : Oracle DBA

Period : Feb 2010 - Mar 2013

Location : Bangalore, India

Roles & Responsibilities:

Responsible to Support the Production/Development databases that includes on site coverage and 24*7 after-hours coverage based on a rotating on call schedule.

Maintenance of Production and Development Transaction and Data Warehousing databases.

Used EMC BCV Sync& Split strategy for backing up and restoring the databases.

Troubleshoot problems using tools such as RDA, DBVerify, Oradebug, network diagnostic tools, etc.

Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL batch queries. Regular scripts were run to monitor and manage space in Table spaces.

Configured Table Partitioning using Range, Hash and Composite partitioning techniques.

Splitting partitions, re-creating indexes, and analyzing indexes.

Setting up and Managing Flash Recovery Area. Worked on 10g Flashback Technologies: Flashback version query, Flashback Transaction Query, Flashback Table. Configured and Enabled Flashback Database.

Performance tuning with ADDM, AWR (Stats pack) and used Oracle Enterprise Manager (OEM) grid control for monitoring.

Regularly Gathered Statistics for Schemas using DBMS_STATS.

Diagnosed Oracle bugs and coordinated with Oracle support through Metalink to resolve them in timely manner.

Responsible for the database development and version control of the db deploy and builds.

Developed PL/SQL Stored Procedures, Packages, Functions & Database Triggers.

Refresh the schemas from prd to Non prod using EXPDP/EXP, IMPDP/IMP.

Environment: Oracle 10gR2,, Data Guard, Sun Solaris Servers, Linux, AIX and Windows XP, SQLT.

Contact this candidate