Database Manager

Jeetendra Kappala

*********.*******@*****.***

Oracle Database Administrator

SUMMARY:

8+ years of IT Industry experience in the field of Oracle database administration.

Good experience and through knowledge in the Implementation and configuration of Oracle Real Application clusters 11g, 10g on active-active architecture, 10g/12c Grid Control, Recovery manager (RMAN), Data Guard, Automatic Storage Management (ASM), Advanced Replication, Disaster Recovery.

Experienced in implementation of Large Data Warehouse databases in Oracle 10g/11g with several key features like RAC, ASM, Partitioning and Password Complexity.

Experienced in different phases of oracle 9i/10g/11g upgrade process involving planning, database preparation, database upgrade and post 10g upgrade activities. Had performed 50+ database upgrades from Oracle 9i/10g and from 10g to 11g.

Experienced in writing shell scripts, PL/SQL stored procedures, Functions, Triggers, Packages, space management and storage allocation.

Good experience in different UNIX flavors like HP UNIX, IBM AIX, Sun Solaris and RedHat Linux.

Have thorough experience on testing several oracle components; handling service requests, tar on Metal ink Support.

Design and maintain database solutions for new and existing projects by understanding the business requirements

Develop and maintain database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.)

Write scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers.

Provide primary support for the organization's data repositories and will be responsible for requested SQL or Oracle reports

Work with managers of each functional area to identify and prioritize data information needs and requirements

Troubleshooting the performance issue in oracle Database.

Implementing the Golden Gate Unidirectional for reporting database.

ASM SAN migration.

Implementing the Schell scripting to automate the database task, Alert and Reports.

Strong functional knowledge in the Largest Media and Entertainment Company & Investment Banking and Retails.

Installation of web logic for 12c OEM.

ZFS snapshots & rollbacks

Upgrading 10g database to 12c.

Good communication and Interpersonal skills. Experienced in client-facing roles.

Migration data from SQL Server database to Oracle Database.

Using KSH programming to automate the database monitor and activities.

Technical skills:

Operating Systems : Solaris, Linux, AIX, Windows (95, 98, NT), HP UNIX

Databases : Oracle/10g/11g RAC & 11g R2/12c RAC

Database Tools : TOAD, PLSQL Developer,

: DBArtisan, Putty, Service Now and Remedy, Autosys

Languages : PL/SQL, SQL

Administrative Tools : 10g/12C Grid computing, Data Guard, DBArtisan,

PVCS, HP Performance Tool, Autosys, Oracle Enterprise Manager (OEM) 12C, SQLPlus, SQL*Loader, SQL*Net, Export, Import, Data- pump, RMAN, Toad, Netbackup, Commvault backup, Shell Scripts,

I3 tools, Oratop, Oracle Stream, Protegrity, OID, Golden gate, Veridata

Eclipse.

EDUCATION / CERTIFICATIONS:

Bachelor of Technology, INDIA

Oracle Certified Associate.

Oracle Certified Professional.

Oracle Exadata.

Solaris Admin-I

State Of Indiana. Indianapolis IN (Deloitte) Mar’ 16 – Present

Role: Sr. Database Administrator and Golden gate.

Database Refresh using active database duplication technique.

Configure the golden gate process for Indiana life cycle report.

Implement the code using the DBCR process and automate the script to deploy the code in higher Environment.

Using SRDF process to sync up the Data Guard and Using SCN backup method to sync up the data guard.

Automate the task clone DB’s to ZFS

Setup the new Data guard after creation a new database, and do failover and switch over based on the requirement.

Design and maintain database solutions for new and existing projects by understanding the business requirements

Develop and maintain database structures that utilize database architectural standards (normalized tables, primary keys, foreign keys, events, triggers, etc.)

Write scripts to create, optimize, and maintain databases, tables, constraints, functions, stored procedures, indexes, and triggers.

Provide primary support for the organization's data repositories and will be responsible for requested SQL or Oracle reports

Work with managers of each functional area to identify and prioritize data information needs and requirements

Set up 12.2 GOLDENGATE from scratch on two node RAC 12c using ACFS file system.

Install, configure and support uni-directional Oracle-to-Oracle replicated environments utilizing Golden Gate for reporting.

Using the GoldenGate Process to masking the sensitive data for reporting.

Masking the Critical Sensitive data using Oracle Masking process and Implement the fully automation of masking process using EMCLI tool.

Manual Upgrade 11.2.0.4 database to 12c and migrate into 12c PDB.

Applying the PSU patch every quarterly for every Prod and Lower environment in the database and Yearly on Cluster using Rolling Fashion.

Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.

Creating the 12c multitenant cluster database for new application and provide the end to end support to configure the application to connect 12c database.

Migrating the normal database to Exadata server using RMAN duplicate, Datapump and Using storage SRDF process.

Upgrade the Grid Infrastructure 12.1.0.2.0 to 12.2.0.1.0 using Rolling fashion.

ASM disk expansion in various database cluster nodes.

Create PL/SQL procedure for gather state and Kill blocking session and schedule the Job into DBMS job Scheduler.

Tuning the SQL query and figure out the right plan for the query and apply the Hints.

Tuning the SQL performance issue using SPM.

Apply Patch on OEM 12c agent

Extensively working on Real Application Cluster (RAC).

Coordination with clients, vendors and various application for the scheduled database maintenance.

Best Buy Co. Inc. Richfield MN (TCS) Jan’13 – Mar’16

Role: Sr. Database Administrator

RESPOSABILITIES:

Configure 11g Grid Infrastructure on two and three node cluster and creating 11gR2/12c RAC (11.2.0.4) database.

Adding space on ASM disk group as and when required.

Implemented Fast-start-Failover on all critical production database for maximum availability

Implemented Active standby database

Implemented Oracle11g one node RAC technology.

Database Refresh using active database duplication technique.

For various Oracle Bug like TNS crash, Shared Memory segment, etc. we have applied One of Patch recommended by Oracle support.

Based on Issue we go into the depth and do the root cause analysis for our customer and come up with short and long term plan.

Do various database refresh using RMAN and Data Pump export utility

Take the consistent backup of active standby database using the data pump utility.

Upgrading the RAC cluster 11g2 to 12c.

Upgrading the database from 11.2.0.2 to 11.2.0.4

Applying the PSU patch every quarterly for every Prod and Lower environment database using Golden home concept.

Coordinate with the various customers and raised the change request plan based on agreed window

Coordinate with customer located in different part of country like US/CANADA and gather the information and prepared the implementation plan and distributed the working among the team members.

Tuning the SQL query and figure out the right plan for the query and apply the Hints.

Tuning the SQL performance issue using SPM.

Apply Patch on OEM 12c agent

Extensively working on Real Application Cluster (RAC).

Create the Standby database and maintain the SYNC with Primary database using SRDF process and Incremental backup.

Configured the Listener and alias to setup Transparent Application Failover (TAF).

Responsible to Handle the RCA and work order for customer.

Perform Routine Maintenance of database with Health Check.

Monitor the Alert like Tablespace, CPU Utilization, Service Relocated, Archive Log Job, Backups etc. and take necessary action.

Interacting with Oracle Support for technical assistance requests.

Implement the Golden gate to replace the Oracle Streams.

ASM SAN migration.

Refresh the Development/QA database from Production using SRDF and RMAN whenever request come from Application Team.

Migrating the database from once cluster to another Cluster.

Rename the ASM disk group.

Migrating the database from old to new Hardware using Disk Swing method.

Rename the ASM disk group.

Create a Shell script to automate the database and Cluster Monitoring.

Create a new database as per application standard in Cluster environment using Command line or DBCA.

To create and Handle Oracle Stream’s in Production Environment.

Troubleshooting the RMAN backup issue.

Applying the Patch in OEM.

Knowledge sharing and Create a SOP’s when every required.

Execution of standard and non-standard tickets which were being raised in Service Now.

Providing technical assistance to other team members.

Coordinating with team at India and US East Coast.

oAS per SLA, Assigning tickets to team.

oGathering requirement from client, consolidate and send to team for work on the same.

oPlanning with client on automation of database activities.

oSending guidelines on Improvement to scripts.

Environment: Oracle 11g/12c, TOAD, PL/SQL Developer, RMAN, Oracle Enterprise Manager 12C (OEM),

Grid, Data Guard, AWR, ADDM, Golden Gate, RHEL 5.6.

Hartford Insurance Group. India (TCS) Dec’10- Dec’12

Role: Database Administrator

RESPONSIBILITIES:

Installing and creating 11gR2 RAC (11.2.0.2.0) database on ASM.

Database upgrade from 9.2.0.6 to 10.2.0.4 and upgrading from 10.2.0.4 to 11g (11.2.0.2.0) using DBUA utility and also using the manual upgrade technique.

Implemented standard monitoring scripts, making modifications necessary to work in RAC and stand-alone environment.

Planned and implemented PSU patches on a number of different database versions.

Creation of Project QA and development environments, using cloning, expdp/impdp, normal export/import and edited DDL scripts to generate smaller versions of the production environment.

Development of Shell scripts for Implementation of hot backups across all databases and emailed alert notifications to assist 24x7 operations.

Development of Backup and Recovery tests for production and non-production environment.

Using a combination of AWR, ADDM report and wait event tracing against overnight batch processes to identify performance problems.

Review and monitor system and instance resources to ensure continuous database operations (i.e., database storage, memory, CPU, network usage, and I/O contention).

Execution of standard and non-standard tickets which were being raised in Remedy.

Providing technical assistance to other team members.

Ensuring database security with the help of grants and required access to prevent unauthorized access to the databases.

Database refreshes using cold and hot backup.

Creating the users with necessary privileges, roles, profiles and space quota.

Index creation, table partitioning & rebuilding to improve the query performance.

Handling Database change request from the application developers as when required

Installation of CRS, ASM and databases (RAC and Non RAC)

Apply Patch on OEM 12c agent

Managing Physical Standby Databases

Rebuild a Physical Standby Database whenever required.

Clone dev/qa/stg database from production using fracture and recover point technique

Restore and Recovery of database using RMAN backup.

Monitoring of targets using Grid and resolving alerts from grid.

Resolving problem managements and general request tickets. (Client Ticketing System, with SLA’s)

Monitoring file system on which oracle related files exist.

Installation of oracle binaries and creating databases.

Upgradation database to 9i to 10g and 10g to 11gR2.

Creating rules for alerting, setting thresholds, upgrades to Grid and Installation of Agents

Tuning SQL’s for Performance using tuning Advisor.

Applying patches to databases.

UNIX Scripting.

On Call Rotation

Scheduling and monitoring the backups.

Coordinating with team at India and US East Coast.

Supporting 100+ production instances and hundred and fifty test and model instances.

Built 3 node RAC databases using oracle 11.2.0.4 CRS/RDBMS.

Monitoring and troubleshooting production databases that are on High Availability.

Led Capacity planning and storage allocation workshops.

Prepared and implemented Data Archival Strategies to improve OLTP performance.

Restoring Prod Mirror databases, development databases from production.

Installed and configured 10.2.0.4 OEM Grid control (OMS, Repository and Agents).

Setup Monitoring and Notification polices in OEM Grid Control.

Responsible for code review and change management.

Implemented Backup Recovery Solutions using RMAN, Shell scripts, Net Backup.

Identified database bottlenecks using OEM Grid Control, AWR, ADDM,

Performance Tuning of databases, application level and SQLs.

Writing shell scripts and RMAN scripts to automate the RMAN, exports and hot backups.

Documenting the procedures and processes.

Scheduling hot backups and logical backups for databases.

Failovers to Physical Standby Database.

Coordinating with team at India and US East Coast.

oAS per SLA, Assigning tickets to team.

oGathering requirement from client, consolidate and send to team for work on the same.

oPlanning with client on automation of database activities.

oSending guidelines on Improvement to scripts.

Environment: OEL, Oracle Database Version 10g/11g/12c, RMAN, DataGuard, RAC, ASM, Oracle Enterprise

Manager, Grid Control 12c, ADDM, SQL, Shell Script, RDBMS.

MMNA (USA Client) (TCS) SEP’07- Dec’10

Role: Database Administrator

RESPONSIBILITIES:

Managing and execution of Database change requests

Database Refresh from production to development and support databases.

Data transfer using Oracle’s Transportable Tablespace Feature.

DBCC requests handling, batch job monitoring, database health checking, ensuring the database availability and monitoring the database.

Creating Roles & Profiles

Creating the users with necessary privileges, roles, profiles and space quota.

Tablespace creation and maintenance support like adding data files to the production, development, and support and test databases.

Maintaining redo log and archived log files.

Creating database link & Snapshots.

Maintaining and monitoring database security.

Index creation & rebuilding to improve the query performance.

Tuning the performance of the Database through the following

Design level changes

Memory optimization (Shared pool, SGA, DB block buffer, Log buffer)

Resolving Row Chaining and migration, disk stripping

Reducing I/O Contention (Rollback, Archive, Table space and Latch)

Application level tuning (TKPROF/Explain Plan/SQL Trace.

Monitoring the CPU usage, IO statistics, CPU time to identify any OS level Performance killers

Space management on temp, data & index table spaces in all the production, support, development & test instances

Troubleshooting database problems faced by the application developers/users

Environnent: Oracle 9i/10g/11g, AIX,HP-UNIX, Linux, Solaris

Personale Information

1. Full Name (Legal): Jeetendra Kappala

2. Availability Date: 2 weeks

3. Work Authorization Status: H1B

5. Current Location: Indianapolis IN

6. Contact Number: 952-***-****

7. Willing to relocate to client location: Yes

8. Best time to call: 11:30 am to 2pm EST

9. Skype ID: jeetendra.kappala

10. Green Card Process Status – 1-140 Approved.

11. LinkedIn - https://www.linkedin.com/in/jeetendra-k-b8945931

Contact this candidate