CHAITANYA KURRA

ORACLE DATABASE ADMINSTRATOR

aczgzz@r.postjobfree.com

669-***-****

* ***** ** ********** ** oracle database administrator in various roles, my experience has scaled in providing client support, analysis, designing, testing, development, installation, migration, maintenance, Replication, Database Security, RMAN, User management, ASM, Performance tuning and monitoring the database using OEM Grid Control, and administration for oracle databases, which included understanding the requirements, upgrades, performance tuning, backup recovery, cloning, and space management, shell scripting using ORACLE 12c/11g/10g, performing the role of Oracle Database Administrator according to the set standards and timelines. Performed Data masking and Data redaction and created vault in OEM.

Experience Synopsis

Extensive Experience in very large scale database environment and mission critical large OLTP and OLAP systems.

Experience in using oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, upgrading databases and Network Configuration Assistant (NETCA) & NETMGR for creating a Listener, TNS names to establish a Client-Server environment

Experienced in maintaining databases on large Production, Testing and DEV environments and Experience in database cloning with RMAN, Capacity Planning, Database Refresh and Patch management.

Experience with MySQL on both Linux and Windows

Extensive experience in providing 24x7 on call support for Test, development and production databases using Maximum Availability Architecture using RAC and Dataguard

Expertise in Implementing Oracle 11gR2 and 12c RAC implementation on ASM

Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs

RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OSWatcher, Srvctl and Crsctl

Performed various tasks in RAC Cluster: pinning nodes, used ocrconfig to backup OCR, OLR and voting files, creating services using Srvctl, changing scan port number, Multiplex Voting files, Mirroring OCR on different ASM disk groups, Tuning Node Evictions by setting disk timeout, reboot time, miss count, Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover

Applied Patches in rolling fashion and Upgrading Oracle GRID infrastructure 11g, 12c

Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM

Experience in Uni-directional, Bi-directional and Integrated Capture data replication using golden gate.

Troubleshooting Golden Gate issues such as process abending, and lag on replication environments

Troubleshooting Golden Gate issues in both development and production environments

Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and Golden Gate replication

Expertise in Dataguard Configuration, Implementing and Maintaining physical standby databases in 10g/11g/12c on Solaris, AIX, RHEL

Expertise in configuring Active Dataguard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases

Expertise in analyzing database objects, DB-links, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle

Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, Applied logs with delay Configured Dataguard Broker and managed standby databases using DG broker

Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using Golden Gate with Zero downtime.

Used Logdump utility, Defgen utility in GoldenGate environment and Installed Goldengate in dev, test, and prod environment

Migrated databases using GoldenGate from AIX, UNIX to RHEL environments and applied Patches to GoldenGate environment 12.1.0.2

configured Golden Gate wallet for security purposes

Expertise in implementing database Backup and Recovery concepts using RMAN utility.

Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN

Performed Various Tasks on RMAN: configuring backup, Block recovery, data file recovery, registering databases in catalog, TBPIR Table space point in time recovery

Experience in logical backups and Database migration tools with Data Pump, Export/Import and Transportable Table-spaces

Excellent working knowledge of Operation & Production Support with large mission critical systems in multiple technologies and platforms including WebLogic, Apache, JBoss, WebSphere, UNIX, Windows NT, and Oracle

Experience in implementing Flash-Back Technology 10g/11g/12c and used different techniques using Flashback Query, Flashback SCN, creating restore points on database

Extensively used Flashback for Supporting DML and DDL changes and Handled daily production problems/change requests(DBCRS) with Oracle Patching.

Good experience in Patching PSU and CPU Patches Quarterly and Up gradation of databases from versions from 10g,11g to 12c

Expertise in Upgrading databases from 10g to 11g and 11g to 12c and applied patches accordingly

Excellent working knowledge in configuring multiple Weblogic domains including machines, manage servers, node managers and cluster environments

Upgradation of WebLogic servers in development, testing and production environment and applying patches

Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like AWR, ASH, SQL-Trace, ADDM, SQL tuning using Explain Plans and Hints, Performance Tuning for better performance and Monitoring and optimizing the performance of the database through database tuning - Tuning applications, Tuning Instance, and Tuning Disk Usage

Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database

Worked on Exadata Database Machine X2-2 Half Rack, X3-2

Implemented new Exadata Machine features like smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases

Firewall Updates and VPN implementation

Migrated databases into Exadata Machine with minimal downtime using Dataguard

EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations

Opened, resolved, or updated Tier II Support tickets for Manage Firewall clients

Proficient in EBS Installation, Patching, Cloning, Database Refresh, Upgrade (EBS and Database), Disaster Recovery, High Availability and Backup & Recovery (RMAN)

Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control (OEM)

Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling jobs using Auto sys, RMAN, SQL tuning advisor to tune sql’s on database

Configured, troubleshoot, and upgraded Checkpoint Firewalls for Manage clients, which included network and/or resource access, software, or hardware problems

Use Oracle Meta-Link Support to resolve issues related to database servers, security patches and Proficient in raising SR with Oracle Support and using Meta-link to resolve the bottlenecks in the database environments

Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams

Have Ability to function independently and plan, evaluate and design solutions to problems as they occur and Ability to work well in a group environment and Good ability to mentor other DBAs in the group

Technical Skills:

Operating Systems

HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS

Oracle 12c/11g/10g/, Oracle 11g Real Application Cluster (RAC), ASM

Oracle Tools and Utilities

Data Guard, GoldenGate, Logdump, Defgen, Web logic server, OBIEE, WebSphere, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, AVAMAR, RMAN, RAC TOOLS ORACHECK, oratop, TFA collector, OSWATCHER,

Languages

C, SQL, PL/SQL, AWK Scripting, Perl

Tuning Tools

TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning Advisor

Ticketing Tools

Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, GIRA,BEAWebLogic8.1,9.2,10

Work Experience:

Client: General ELECTRONICS Oil and Gas, Louisiana, LA

Duration :(Dec 2015 to Till-date)

Role: Sr. Oracle DBA

GE Oil & Gas is a subsidiary of the American multinational conglomerate corporation General Electric. the company supplies mission critical equipment for the global oil and gas industry. it fosters collaboration and allows customers to better understand how GE products and services fit into their projects.

Responsibilities:

Installed, configured and maintained Oracle 12cR2 Real Application Cluster (RAC) 3 node RAC, Migrating single Instance Databases to 3 Node RAC environments

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment

Performed the 12c Upgrade of RAC cluster ware from 11g.

Install, configure and administration of Bea WebLogic Server 8.1/9.x in various environments

Duplicated issues and tested solutions to make sure problems were resolved properly.

Assisted Development and Business analyst teams by capacity planning and cloning of databases to the test environments so they could develop custom applications and perform a variety of tests for quality assurance and issue resolution

Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC server’s.

Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed.

Deployed the applications, formats of WAR, JAR and EAR in WebLogic 8.1 SP5/9.x

Troubleshooting multicast issues using Weblogic Java Utility Multicast Test

Established performance tuning best practices used by the DBA and Development teams.

Performed the Instance caging for the Exadata databases.

EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations

Enabled Flashback for database to create restore points and supporting DDL changes

Applied PSU quarterly on 11g/12c GRID & RDBMS homes using Opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN

Provided Manage Firewall Clients' with regular status reports of their trouble tickets

Daily Health Check Up of the Database and SQL Queries and Performed large batch jobs, and tuning of SQL queries and database systems

Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring.

Performance tuning Golden Gate replication and used Log dump and report files for troubleshooting.

Installation and configuration of oracle Golden gate on 12c & 11g.

Configuration and troubleshooting of Golden Gate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICAT issues

Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM

Worked on Exadata Production databases and providing the Technical support to Application Support team for performance and database related issues

Up gradation of GRID infrastructure from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2

Performed health checks of RAC Cluster-ware components OCR, voting files and backups using ocrconfig and Troubleshooting Issues using Clusterware logs in 12C

Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and Managing services using RAC Tools SRVCTL and Cluster-ware resources using CRSCTL.

Oracle Enterprise Manager: Installed OEM 13c on database 12.1.0.2 and Monitoring databases using Grid Control 10g/11g/12c and 13c for Configuration of error notifications and adding to the grid control

Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS_SCHEDULER

Dataguard: Configured Physical Standby databases using data guard in maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business

Configured Active Dataguard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Dataguard Broker and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing

Worked on Service now Ticketing system to resolve the incidents based on Severity

Used crontab utility for scheduling jobs.

Perform Daily Monitoring of Oracle Instances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.

Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.

Also configured database cloning using RMAN.

Worked with offshore team and coordinating database monitoring, scheduled calls to discuss database issues

Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures

Extensively used USH, Ticketing Systems BMC Remedy and Service now and 24x7 production Support Database Maintenance and on-call Support.

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP,WebLogic server 8.1/9.0,10g/11g, Goldengate11g, 12c, orachk Defgen, Logdump, ASH reports, Oracle Patching Opatch, Data Pump, putty

Client: Care First Inc, MARYLAND, MD Duration:(April 2014 - Sep 2015)

Role: Sr. Oracle Database Administrator

CareFirst BlueCross BlueShield is a not-for-profit, non-stock health services company which, through its affiliates and subsidiaries, offers a comprehensive portfolio of products and administrative services to individuals and groups in Maryland, the District of Columbia and portions of Northern Virginia. CareFirst is the parent company of CareFirst of Maryland, Inc., and Group Hospitalization and Medical Services, Inc. CareFirst, Inc., and its affiliates are governed by a Board of Directors and special statutes regulating the company's business in Maryland, the District of Columbia and Northern Virginia

Responsibilities:

Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases

Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate

Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicate and replicated tables to different Instances using GoldenGate

Upgradation of databases from 11.2.0.2 to 11gR2 and Applied patches to databases 10g/11g

Configured custom execute queue in WebLogic 8.1

Configured Disaster recovery databases using Dataguard: configured Active Dataguard, Dataguard Broker and snapshot standby databases, Troubleshooting Issues in Data Guard Environment, missing archive log, performance of Standby databases using stats pack, applied logs with delay, Tuning Media Recovery process, Performed DR testing

Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database

Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery

Planning Recovery Procedures and Performing backups in Both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities

Configured repository database for setting up OEM 12c, used 10g,11g for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 11g, 12c

Created User accounts, Roles and granting required access permissions and privileges

Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes

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 profiles, Creating and rebuilding Index’s, re-organizing tables

Used 11g new features Invisible Indexes, and turn off indexes temporarily to check how queries perform without Index’s and Worked on Oracle Database Appliance, patching

creating table partitions and dropping partitions when required, creating index’s and rebuilding indexes for maintenance, creating new DB-links for new environment.

Environment: Oracle 11g/10g, Oracle 12c(Testing), Oracle Goldengate 10.4, Oracle Goldengate 11.2, Oracle Enterprise Manager Grid Control,weblogic, Oracle Enterprise Manager (OEM), Sun Solaris,Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Client: Government Employee Health Association, Kansas City, MO Duration: Sep 2012 - Feb 2014

Role: Sr. Oracle Database Administrator

GEHA (Government Employees Health Association) is a self-insured, not-for-profit association providing health and dental plans to federal employees and retirees and their families through the Federal Employees Health Benefits Program (FEHBP) and the Federal Employees Dental and Vision Insurance Program (FEDVIP). GEHA provides benefits to nearly 1.8 million people worldwide

Responsibilities:

Implemented Oracle Database 11gR2 2,3,4 node RAC Clusters on RHEL Linux Severs

Performed health checks of OCR, voting-disk, Interconnect and RAC instances and managed resources using Crsctl & Srvctl, creating services using Srvctl, relocating services and patching RAC cluster and troubleshooting 10g, 11gR2 cluster

Worked on Exadata X2-2 and x3-2 machines and migrated application databases using Expdp, GoldenGate and Dataguard

Worked on different Features on Exadata x3-2: Hybrid column compression, Smart scan, Flash Logging, DCLI, create and drop Flash disks, Flash Logging, Enabling Flash Cache Compression, Cell monitoring and Alerts, Cell Offload Efficiency, Hybrid columnar compression, controlling database resources using IORM plan

Performed various tasks on ASM, Installed standalone servers on ASM, used asmcmd to manage disk groups in ASM environment and Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM, tuning ASM parameters for better performance

Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases

Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate

Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicat and replicated tables to different Instances using GoldenGate

Upgradation of databases from 10.2.0.4 to 11gR2 and Applied patches to databases 10g/11g

Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database

Installed and administered, NIS, NIS+, NFS, and Send mail for centralization and firewall setup with iptables on Red Hat

Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery

Created User accounts, Roles and granting required access permissions and privileges

Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes

Environment: RHEL-4.x,5.x, Sun-Solaris 9, OEM 10g-11g, Oracle 10g,11g, RAC 10g,11g, Srvctl, Crsctl, ocrconfig, ASM, ASMCA, Dataguard, Active Dataguard, snapshot standby, GoldenGate v10, v11, Exadata x3-2, x2-8, Migration, TKPROF, AWR, ADDM, ASH, RMAN, Data pump, Opatch, Materialized views, Toad, Putty

Client: The Hongkong and Shanghai Banking Corporation, Chennai

Duration: (May 2010 - Jun 2012)

Role: ORACLE DBA

HSBC Holdings PLC is a British multinational banking and financial services holding company headquartered in London, United Kingdom. It is the world's sixth largest bank by total assets with total assets of US$2.410 trillion. It was established in its present form in London in 1991 by The Hongkong and Shanghai Banking Corporation Limited to act as a new group holding company

Responsibilities:

Setup physical standby’s (DATAGUARD) for several Databases running 11g well(Container level and Non-CDB)

Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI

Assisted in keeping a daily log of Share point issues and submitting that log each week to IT management

Converted physical standby to Snapshot standby and back to physical standby

Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.

Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate

Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.

Data pump including database links and network links. Upgrade the binaries by applying patch

set and interim patches using Opatch and Opatch Auto

Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and

Logical I/O and Memory Usage .

Configured and implemented Oracle Streams (Advanced Replication) for high availability

Tested database performance issues (monitoring and tuning) to ensure database optimization

Involved in gathering requirements from end users

Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance

Replication was configured to run even at the time of failover (Data Guard) of the source database

Providing technical support to Application Support team for performance and database related issues

Effective Production Support and off hour support, support ha5ndover

Environment: Oracle 11g, Red Hat Linux 5.8, OEM 12c, RAC, Oracle Advanced Security, Pluggable databases, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, Opatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations

CLIENT: PI DATA METRICS, HYDERABAD, INDIA

Duration: May 2008 - March 2010

Role: Junior Oracle DBA

The Pi Datametrics platform been painstakingly collecting our own data since 2004 During this time we worked tirelessly with our customers to identify what they really needed to be able to make clear-cut ROI online. From a process of close-listening, we gradually built our enterprise SEO platform Pi Datametrics, and the rest is history

Responsibilities:

Experience in moving the data from one server to another server using SFTP, FTP and SCP

Schema Refreshing of databases using normal copy method and exp /imp utility

Involvement in space management, rectification of lock problems, user management

Regular Data Refresh from Production to Test and Development environments using RMAN

Duplicate Database or Data Pump utility for oracle 10g and 11g servers

Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes

Grant and Revoked user privileges and roles as per requirement and killed blocking session

Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files

On-Call 24x7 DBA support for production databases.

Environment: Oracle 10g, Red Hat Linux, SQL, Oracle Enterprise Manager 10g,Quest Software (5.0),Putty

EDUCATION:

Bachelors of Technology, ANU, India

Contact this candidate