SUMMARY

• Sr. Database Administrator/Consultant with over 11+ years of professional experience supporting Oracle 12c/11g/10g, Goldengate 11g/12c and Cassandra 3.1(NoSQL) in various platforms with UNIX (RHEL, Solaris, HP - UX, IBM-AIX), Windows sever (2008/2012), OLTP, OLAP, Data Warehousing.
• Experience in installation and configuration, Data Guard, migrations, upgradations, capacity planning, backup and recovery, cloning, Database security, performance tuning, automation (scripting/Jenkins/Ansible) and troubleshooting.
• Extensive experience working with Project and Operations/Production support teams to manage mission critical applications.
• Experience in working with Oracle 12c/11g/10g (RAC/Non-Rac/Standalone/ASM/Non-ASM) in different platforms like Linux, IBM AIX, Windows, Sun Solaris and HP-UX
• Experienced in setting up a Grid Infrastructure, Installing and configuring Real Application Clusters on Oracle 12c/11g/10g with ASM, NON-ASM and Flex ASM.
• Managed multitenant architecture with CDB and PDBS combinations in oracle 12c.
• Experience in managing Reporting/AUXLIARY database with source 6 Production Database and Down streams to Hadoop/Teradata using Goldengate 12.2.
• Experience in analysis, planning, architecture design, deployment, delivery of database/Infrastructure projects and customer/vendor management.
• Worked closely with Oracle expert consultants to enhance design and architecture.
• SME and point of escalation for mission critical application.
• Experience in Goldengate 11g/12c Bi-directional (Active-Active), unidirectional, broadcasting replication, flat file adapters, VeriData configurations.
• Handle numerous Goldengate issues with CDR, Abend, Lag, Data integrity and Performance issues.
• Hands on experience in upgrading Goldengate from 11g to 12c.
• Hands on experience in creating Goldengate down streams capture setup and sending Goldengate Initial Load.
• Deployed and configure Goldengate plugin on OEM 12c/13c. Configure x-agent and j-agent for Goldengate monitoring.
• Hands on experience in working with three-way replication using Shareplex 7.0, 7.6, 8.0.
• Upgraded Shareplex from 7.0 to 7.6 in complex three-way replication environment.
• Experience in creating database using DBCA, Scripts, silent installation method. Automated db creation using Ansible/Jenkins.
• Experience in Database Migration using Data Pump, RMAN duplicate, Transportable tablespaces, db links and Goldengate initial load.
• Performed databases cross platform migrations from 11.2.0.4 Solaris 9 to RHEL 6.
• Performed Zero Downtime migration using oracle Goldengate downstreams capture for mission critical application.
• Automated Data Guard failover using Jenkins and Performed DR test using Data Guard Broker and Manual switch over.
• Experience in RMAN Backup, Restore and Recovery and database restore-points and flashback.
• Experience in setting up Oracle 11g/12c Physical Standby Data Guard and Active Data Guard.
• Experience in creating duplicate database using RMAN duplicate ( cloning).
• Experience in Upgrading Oracle Grid Infrastructure and Oracle RDBMS from 11.2.0.4 to 12.1.0.2.
• Performed RDBMS Downgrade from 12.1.0.2 to 11.2.0.4.
• Hands on experience in creating monitoring templates, threshold metrics, groups, deploying agents, incident rules and notification rules using OEM 10g/11g/12c/13c.
• Experience in applying PSU, CPU, one off patches and security patches.
• Very Good at writing Shell Scripting to configure monitoring, jobs, backups, applications jobs.
• Worked with oracle support to resolve variety of issues.
• Experience in Troubleshooting/Analyzing/Fixings issues using ASH, ADDM, SQL Plan Management (SPM), SQL Performance analyzer, SQLT, SQL Tuning Advisor, Database/Instance Tuning and application tuning.
• Good experience in managing issue, finding RCA’s and working on Severity SR.
• Experience in Extracting and Loading data from various Flat Files using SQL loader utility.
• Cassandra 3.1 Database (NoSQL) Installation & Configuration and monitoring.
• Experience in designing Data Model in Cassandra and working with Cassandra Query Language.
• Implemented Multi - Data Center and Multi-Rack Cassandra Cluster.
• Experience in Cassandra Replication.
• Knowledge in Cassandra Read and Write paths and Internal Architecture
• Experience in running Cassandra Nodetool repairs.
• Experience in Optimizing Database for operational and performance efficiency
• Exposure about Exadata and ZDLRA (Zero Data Loss Recovery Appliance)
• Key team member as interacting with customers and client on daily basis
• Strong decision-making, organizational, planning and problem-solving skills
• Provide value added services to the company through experience, Oracle’s best practices implementation, testing, and excellent written and verbal communication skills.
• Mentoring peers, preparing documentations of all database procedures and guidelines.

TECHNICAL SKILLS

Operating Systems: Sun Solaris 10, RHEL 6&7, HP-UX, IBM AIX

RDBMS: Oracle 12c/11g/10g RAC with ASM/Non ASM

Replication Tools: Oracle Golden Gate v 11.1/ 11.2/12.1/12.2/12.3 , Shareplex 7.0/7.76/8.0

DB Utilities: RMAN, OEM 10g/11g and cloud control 12c/13c, Data Guard

10g/11g/12c, Data Guard broker.:

Languages: SQL, PL/SQL, Shell Scripting.

Tools: SQL*Loader, EXP/IMP, Datapump, Transportable Tablespace, TOAD, SQL Developer

Other: Hummingbird, Putty, FTP, SFTP, SSH, SCP, TELNET, MobaXtem

Ticketing Tools: Pier, ITSM, Jira and Service Now.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Sr. Database Administrator/Consultant

Environment: Oracle 12c/11g. Cloud control 12c/13c, Goldengate 11g/12c, Linux 6,5,6.7 and 7.1, RMAN, RAC, Data Guard, ASM, SCP/SFTP, Jenkins, Explain plan, AWR, ASH, ADDM and TOAD 12.

Responsibilities:

• Installed configured and maintained 8 set of 4 nodes and 8 set of 2 nodes oracle 12c RAC and Setup Active-Active Oracle Goldengate Replication.
• Managed Reporting/AUXLIARY database with source 6 Production Database and down streams to Hadoop/Teradata using Goldengate 12.2.
• Created databases using DBCA, Silent Method, Automated Database Creation using Jenkins and Ansible.
• Maintained multitenant architecture with one CDB (Container Database) and PDB’s (Pluggable database’s) with Flex ASM.
• Experience in supporting 400+ databases and 80+TB size database environments.
• Hands on experience managing critical replication setup using oracle 12c Goldengate.
• Installed and configured active-active setup of Oracle Goldengate 12c in PDB architecture with RAC high available.
• Configure Goldengate X-Agent to maintain cluster high availability and deployed J-agent.
• Set up Goldengate monitoring using oracle 12c/13c cloud control.
• Setup Oracle Goldengate Conflict Detection and Resolution (CDR ) feature to resolved conflicts.
• Installed and maintained Oracle 12c Cloud Control and deployed Agents. Installed oracle 12c Goldengate monitoring plug-in to Oracle 12c Cloud Control.
• Involved in Production released and Changes Management.
• Created ACFS file system and Installed and configure Grid Services to support SAP landscape.
• Support SAP team with oracle database maintenance, Performance Issues, database/OS upgrades and Oracle PSU’s.
• Performed database upgrade from oracle 11.2.0.4 to 12.1.0.2.0 on linux
• Applied oracle PSU + OJVM, one-off and security patch on oracle 12c Grid/RDBMS homes.
• Upgraded oracle Goldengate 11g to 12c and applied Goldengate patch.
• Hands on experience in setting up a Physical Standby Data Guard and Active Data Guard.in linux and Windows environment
• Performed Data Guard failover using DGMGRL.
• Worked on both classic/intergrade extract and replication.
• Hands on experience Oracle Goldengate downstream capture setup.
• Performed Zero Downtime migration using Oracle Goldengate Downstreams capture for mission critical application.
• Configured RMAN backup and worked with NetBackup team to test the restore scenarios.
• Written Shell Script to monitor database and oracle Goldengate replication.
• Upgraded TFA.
• Worked on Critical performance issues.
• Actively monitor Database performance.
• Hands on experience in solving performance issue and analyzing AWR/ASH/ADDM/Statspack report.
• Worked with Oracle support 24/7 SR on critical issues.
• Worked with solution architect to enhance database design.
• Worked closely with application team to understand the business requirement.
• Cassandra 3.1 Database (NoSQL) Installation & Configuration and monitoring.
• Experience in designing Data Model in Cassandra and working with Cassandra Query Language.
• Implemented Multi - Data Center and Multi-Rack Cassandra Cluster.
• Experience in Cassandra Replication.
• Knowledge in Cassandra Read and Write paths and Internal Architecture
• Experience in running Cassandra Nodetool repairs.

Confidential, Irvine, CA

Sr. Oracle DBA

Environment: Oracle 11g/12c. Grid Control 11g/12c, Goldengate, IBM AIX, Oracle Solaris, Linux, RMAN, RAC, Data Guard, ASM, Oracle, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL* Plus, PL/SQL, SQL* Loader and TOAD 12.

Responsibilities:

• Install, configure and managed DEV/QAT/Pre-Prod and Productions running on Oracle 11g/12c database’s on RAC/Standalone with ASM/NON-ASM.
• Worked in critical Migration and Upgradation projects from 11.2.0.4 to 12.1.0.2
• Worked on post upgrade performance issues.
• Applied PSU, one-off patches in oracle 12c.
• Worked with the application teams to designed database purging policy using oracle table partitions.
• Configure DBMS Jobs to Drop Table Partitions.
• Created tables, views, functions and pl/sql procedure as part of the application release.
• Managed two-site of Physical Standby database with database size of 30TB.
• Configured two way active-active replication using oracle Goldengate 11.2.
• Written and configure shell scripts to monitor database.
• Used SQL plan management to fix the plan. Also performed export/import of sql plan.
• Worked on critical issues. System failure, application slowness. Data Guard latency issues and etc
• Applied PSU/OJVM component patch on physical standby Data Guard and 11.2.0.4 RAC cluster environment.
• Provided support to development and application teams.
• Supported the releases and planed changes.
• Managed 24/7 weekly on call.

Confidential, SFO, CA

Sr. Oracle DBA

Environment: Oracle 11gR1/R2, Grid Control 11g/12c, RMAN, RAC, Data Guard, ASM, Oracle Goldengate, Multi Master Replication, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL* Plus, PL/SQL, SQL* Loader, Oracle Solaris 10, Linux 6.0 and TOAD 10.0/11.0, HP - UX.

Responsibilities:

• Worked as Primary Oracle Database administrator to Manage12 applications.
• Install and configure Oracle 11gR2 RAC and Standalone on RHEL6 with ASM.
• Tested new feature of Oracle 12c like pluggable database and online table partitioning.
• Involved in Migration project from hp-ux to linux from oracle 10.2.0.4 to 11.2.0.4
• Configure replication using Oracle Goldengate 11g.
• Analyze Goldengate trail files using logdump and setup Goldengate monitoring to monitor abends.
• Configure Oracle Advanced Multimaster replication active-active replication.
• Worked on complex script to configure application jobs.
• Applied PSU patch on single standalone database and Grid Infrastructure patches on RAC environments.
• Managed change control, release management and successfully applied the changes in the database.
• Configure RMAN backups on the production.
• Experience in SQL tuning. Used SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ASH, ADDM, SQLT to analyze and worked with oracle support to trouble shoot the performance issues.
• 24/7 Oncall support to manage mission critical application.
• Manage and Supported oracle active Data Guard and physical standby Data Guard.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiles and Privileges.
• Used various methods like SCP, SFTP, FTP and PSFTP (from windows) to transfer files from legacy server to DCC servers.
• Provided troubleshooting and problem-solving support to application developers.

Confidential, Warren, NJ

Sr. Oracle DBA

Environment: Oracle 10g and 11gR1/R2, Grid Control 11g/12c, Enterprise Manager, RMAN, RAC, Data Guard, ASM, Goldengate, Shareplex 7, SCP/SFTP, TKPROF, Explain plan, SQLT, AWR, ASH, ADDM, SQL* Plus, PL/SQL, SQL* Loader, Oracle Solaris 10, AIX 5.2/5.3, Red Hat Linux 5.0/6.0 and TOAD 10.0/11.0

Responsibilities:

• Supported critical production environments with RAC, Standalone, ASM or NON-ASM environments.
• Upgraded 4 nodes RAC cluster from 10.2.0.4 non-ASM to 11.2.0.4 ASM.
• Installation, configuration, maintained Oracle11g and 10g on Solaris, IBM-AIX 5.3 and RHEL 5/6.
• Installed and configure more than 10 RAC cluster on 11.2.0.3 with ASM, non-ASM.
• Involved in upgrading 10.2.0.4 to 11.2.0.3.
• Installed and setup a three-way replication using Shareplex 7.6 on oracle 11.2.0.3.
• Supported complex replication environment with over 2400 tables replicated.
• Experience in creating, configuring and maintaining Data Guard using Physical Standby and Active Data Guard physical standby on 11gR2.
• Executed processes for evaluation of system space, database allocation and storage metrics on Oracle Exadata.
• Configure RMAN backup and setup tape backup using IBM Tivoli and netbackup.
• Designed backup policy and created scripts to automate RMAN backup.
• Applied CPU/PSU, Interim patch, Clusterware patches in oracle 10g. Also applied grid infrastructure patch in oracle 11gR2.
• Analyze database performance using AWR, ASH, ADDM reports.
• Worked on SQLT to generate trace files for oracle support analysis.
• Work with Datapump and sql loader utilities.
• Created & Managed Database Structures, Storage Allocations, Table/Index segments, Undo management, Constraints, Database Access, Roles, Privileges and Profiles.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Configure gather statistics and copy stats jobs.
• Configure monitoring jobs for Long running SQL/active session count/inactive session count/full table scan/missing or unusable index/invalid object/partition not available.
• Worked closely Data warehouse teams and automate the feed as per the application requirement.
• Experience in using packages like DBMS SCHEDULER to schedule jobs.
• Work with development/operations teams to optimize sqls.
• Performed database recovery using RMAN.

Confidential, Clarks Summit,PA

Oracle DBA

Environment: Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager, RMAN, RAC, Data Guard, ASM, SCP/SFTP, SQL* Plus, PL/SQL, SQL* Loader, AIX 5.2/5.3 and Red Hat Linux 5.0

Responsibilities:

• Provided support to operational team to manage Oracle 11g and 10g on Red hat 5.0, IBM-AIX 5.3.
• Involved in database migration project. Helped build team to Install and configure of Oracle 10g RAC cluster.
• Used SQL Loader to load data using flat files.
• Used datapump to refresh lower environment.
• Workd on OEM 10g.
• Worked on Ticket to resolve ongoing issue.
• Provide support to application team on ongoing issue.
• Overall worked on Day to day Database task like health checks, RMAN backup status, OEM status and similar administration activities.
• Worked on Production deployments and Jira Tickets.