[pic]

PAVAN KANKANALA

Phone: 312-***-****

abgghe@r.postjobfree.com

SUMMARY

> Over 8 years of Information Technology experience in Oracle Database

Administration (12c/11g/10g/9i/8i) on different operating system

environments like Sun Solaris, Linux, IBM AIX, HP UX and Windows

2000/NT with strong domain knowledge in Financial, Banking, Insurance

and Healthcare Industries.

> Proficient with special focus on Oracle Database Administration and

RAC installation, maintenance and administration.

> Implementation of Oracle Backup and Recovery strategies using RMAN

with Data Guard in RAC environment.

> Good Knowledge in Installing, Upgrading and Configuring Oracle

Enterprise Edition 8i/9i/10g/11g/12c databases on different operating

systems of Production databases for testing and training environments.

> Setup of Oracle Enterprise Manager (Grid Control & Cloud Control)

10g/11g/12c for database monitoring/performance/diagnostics. Complete

range of Oracle DBA activities including day-to-day production

database monitoring includes alert logs, trace files, archive files,

Troubleshooting production issues and Performance Tuning issues.

> Experience in Performance tuning using various aspects of the database

utilities like Statspack, Automated Workload Repository (AWR) and

Automatic Database Diagnostics Monitor (ADDM).

> Designing Database, tuning Database, Database Security & Assigning the

Roles, Profiles and Privileges to the various Users on Objects and

Maintaining Integrity by applying server enforced, and Optimization by

Explain Plan, TKPROF and SQL TRACE facility.

> Testing and implementing different physical and logical backup and

Recovery methods like point in time, media recovery, full/partial and

export/import.

> Extensive knowledge of Oracle Architecture, SGA, PGA, Binary

structure, Listener, TNSNames, SQLNet, V$ and DBA views.

> Experience in basic and advanced replication using Materialized Views

and experience in using OEM, TOAD, PL/SQL Developer, SQL Developer.

> Monitored and applied database critical and non critical patches from

Metalink.

> Extensive experience with Database Cloning and Refreshing pre-

prod/test/dev databases with prod/pre-production databases.

> Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of

databases using RMAN with VERITAS Net Backup, IBM TSM, Commvault.

> Extensive experience with Oracle Advanced Security Option and Label

Security like TDE, Network Encryption and strong authentication.

> Experience in writing Shell scripts to backup, restore database and

automate daily activities.

> Involved in different scenarios of OLTP as well as Data warehousing

databases.

> Oracle Exadata Administrator (Maintenances of Exadata System,

installing Exadata software offline and rolling mode, bundle patching,

performance tuning, exacheck processes, migration to Exadata (RMAN

Restore, switchover, data broker, export/import dump, transportable

tablespaces).

> Versatile team player with excellent analytical, communication and

inter personal skills.

> Provided 24 x 7 support and flexible to work beyond regular hours.

TECHNICAL SKILLS

Operating Systems HP-UX 10.x, 11.x, Sun Solaris, AIX 5.1, 5.2, 4.3, IBM, Red Hat

Linux RHEL 2.1, 3.x, 4.x, SUSE 10, 9 and Windows 95/98/NT/2000/XP

Databases Oracle 8.x/9.x/10g/11g/12c, Oracle 10g Real Application

Clusters(RAC), MS SQL Server 2000/2005, MS-Access

Languages C, C++, SQL, PL/SQL, Unix Shell Scripting, AWK scripting.

Web Servers Apache Webserver

High Availability Oracle 10G RAC, Symmetric Replication, DataGuard/Standby

Replication, Shareplex, Veritas Cluster, Oracle E-Business Suite.

ETL Tools DataStage

Web Tools HTML, XML

Tools/Utilities/E Oracle Import/export utility, SQL * Loader, ADDM & SQL Adviser,

TLs TKPROF, Oracle Data Pump, SQL diagnostics, EXPLAIN PLAN,

AUTOTRACE, RMAN, STATSPACK and AWR, OEM, OWM, TOAD 8/9/10 & SQL

Developer, PL/SQL Developer, Datapump, Grid Control, Erwin 4.0,

svrmgrl, SQL Trace, Opatch, MS-Office suite, NetApp, Veritas

NetBackup, Veritas Clusterware, CommVault

PROFESSIONAL EXPERIENCE

CLIENT: JOHNSON CONTROLS, MILWAUKEE, WI

APR'11 - TILL DATE

POSITION: Oracle DBA

Roles & Responsibilities:

> Responsible for tuning the database performance issues like query

tuning and memory tuning (SGA tuning) and also partitioned the tables

and indexes for better performance in a warehouse environment.

> Database tuning, Application Tuning & performance monitoring. Fine

tuning Initialization parameters, I/O, SQL Profiling, SPM, Memory and

Operating System kernel parameters.

> Performed database tuning using Explain Plan, Hints, Toad, SQLTXPLAIN,

SQL ADVISOR, ADDM & AWR reports, and Enterprise Manager.

> Implemented different Partition methodologies to improve performance

and manageability in Datawarehouse Environment.

> Ongoing proactive database-level performance tuning, with a good

working knowledge of Oracle internals.

> Responsible for administration and support of Oracle 11g and 10g

databases. Upgraded the databases from Oracle 10.2.0.4 to 11.2 and

implemented the dataguard on 11g databases.

> Responsible for installing, maintaining, performance tuning, and

monitoring of Oracle database versions 10g and 11g on HP-UX in dev,

test and production.

> Have setup the cronjobs for runalert, spacewatch monitoring, RMAN

backup and recovery (level_0 and level_1), archive log purge, trace

purge and AWR reports on HP-UX environment.

> Extensively used Oracle 11g features like Interval Partitioning, SPM,

Statistics collection enhancements, AWR Baseline enhancements, RMAN

enhancements etc.

> Installed and Configured Oracle 11gR2 2-node RAC & Oracle Restart on

HP-UX/Linux platform.

> Installed, upgraded and patched Oracle software. Setup brand new

machines including Oracle software installation, Oracle side

configuration, third party backup software TSM troubleshoot and backup

testing.

> Implemented database refresh with the hot backup using ACTIVE

DUPLICATE or full export. Used DATAPUMP to do table level, schema

level and full database defragmentation.

> Developed or modified some Oracle backup and recovery scripts. Used

Oracle backup utility RMAN to implement Oracle backup and performed a

number of times of disaster recovery.

> Installed and configured 11g OEM grid control with dual OMS on

different hosts with a Server Load Balancer.

> Upgraded and configured OEM 12c from 11g with dual OMS and

Installed/rolled out OEM agent processes on all database, middleware

and application servers.

> Upgraded OEM Cloud Control and all server agents from 12.1.0.2 to

12.1.0.3.

> Configured Server Load Balancer for OEM 12c.

> Integrated 3rd party management tools like Apache, Tivoli, Siebel,

Remedy, Websphere etc.

> Worked on deploying and upgrading different plugins for OEM 12c.

> Provided on-call production database support.

> Oracle 11i/R12 Implementation & Upgrade (11.5.9 to 11.5.10.2 and

11.5.10.2 to 12.1.2).

> Performed Oracle Apps cloning from production to test/dev environment.

> Monitoring long running Concurrent requests.

> Performing Oracle Apps Administration using AD utilities.

> Applying Oracle Apps bug fix patches.

> Workflow data purging done as part of performance improvement and

avoid huge data growth in Oracle Apps DB.

> Managed Oracle Apps User Creation and Responsibility assignment.

Environment: Oracle Applications 11.5.9/11.5.10.2/12.0.6/12.1.1/12.1.2,

Oracle 10g/11g/12c, HP-UX, TSM, RMAN, RAC, Active Data Guard, Exadata X2-8,

OEM 11g/12c, OEM Cloud Control, AWR/ADDM, Unix Shell Programming, TOAD

10/11, PL/SQL Developer, SQL Developer

CLIENT: MONEYGRAM INTERNATIONAL, MINNEAPOLIS, MN

APR'10 - APR'11

POSITION: Oracle DBA

Roles & Responsibilities:

> Handled database size of more than 8TB.

> Managed and maintained the Oracle 10g/11gRAC OLTP Production, Pre-

Production and Development Databases on Linux Platforms.

> Configured, Maintained and monitored the Physical standby databases,

also enabled Active Dataguard for reporting tools.

> Migrated 10g databases from Non-ASM to ASM file system and later

upgrading them to 11g.

> Configured and monitored Oracle 10g Grid control.

> Provided full technical support to various application teams before

the databases go to Production.

> Experience in interaction with the top management and escalations of

the complex issues.

> Performed entries capacity planning required creating and maintaining

the databases.

> Used Triggers for database activities, like delete, update and users

log on.

> Allocated the system storage and planned future storage requirements

for the production database system.

> Done the Migration Review required before the database migration and

QA after the database is migrated.

> Maintained the RMAN repository and customized recovery catalog.

> Worked with BI/Cognos team to tune various ad-hoc queries in the data

warehouse environment.

> Created Partitions, materialized views, indexes, undo & temp spaces in

the ware house environment.

> Creation of Users and Granting them privileges and roles.

> Maintained table and index Partitions.

> Implemented High availability using Golden Gate Replication, Implanted

Bi-directional replication using golden gate.

> Hands on experience in Data warehouse databases.

> Involved in session management and monitored the critical wait events

in the database.

> Involved In query optimization using cost based optimizers.

> Performed sql tuning using EXPLAIN PLAN, SQLTXPLAIN, SQL ADVISOR, ADDM

and AWR reports.

> Proactive database monitoring using 11g grid control.

> Performed logical and Physical data modeling using Erwin tool.

> Used different oracle trace events for performance tuning.

> Responsible for conducting weekly meeting, tele/video conference with

clients, development teams both onsite as well as offshore.

> Assisted in management and database administration of Oracle database

applications on Exadata platforms.

Environment: Oracle 10g/11g, SUSE 10, RMAN, RAC, Active Data Guard, OEM,

AWR/ADDM, Unix Shell Programming, Golden Gate, TOAD 10, PL/SQL Developer

CLIENT: STATEFARM INSURANCE, BLOOMINGTON, IL

DEC'09 - APR'10

POSITION: Oracle DBA

Roles & Responsibilities:

> Installed and configured Oracle 10g (10.2.0.4.0)/11g Database on Sun

Solaris and Linux advance Server for Development, Test and Production

Systems.

> Installed and Configured RAC on RedHat Linux Advanced Server with 2

nodes server side with load balancing and using Automatic Storage

Management (ASM).

> Configuration of RMAN for the RAC environment for backup and recovery

purpose using Enterprise manager.

> Performed database & system level space management and monitoring.

> Involved in replication setup, configuration and maintenance of

replication processes.

> Performed Database Cloning to create TEST and DEV instances using

Duplicate command and also some manual methods.

> Configuring DataGuard to ensure high availability, data protection and

disaster recovery for enterprise data.

> Applied latest releases of the RDBMS Patches from Oracle to the

Production and test instances to resolve few technical challenges &

issues.

> Migrated oracle databases from 9.2.0.7 to 10.2.0.3.

> Contacted Oracle for Technical Assistance Request to track the

problems in the database and resolved accordingly.

> Experience working with Oracle tech support/metalink, user

administration.

> Responsible for creating documentation on Oracle security for all the

production and preproduction databases.

> Tuned and optimized SQL Queries, SGA, and Disk I/O using Oracle

Enterprise Manager and monitoring the AWR, ADDM reports, generated

from snapshots taken at the peak business hours.

> Daily Monitoring of alert log files for errors, trace files and

archive log destination files.

> Monitored and tuned rollback segment, temporary tablespaces, redo log

buffer, sort area size.

> Designed and implemented hot backups using a combination of

incremental, differential and full backups using RMAN.

> Tested and Implemented different physical and logical Backup and

Recovery methods like point in time, Media recovery and Full/partial

export/import.

> Designing Database Architecture experience using both logical and

physical modeling using ERwin tool.

> Planning and scheduling for the backup of database using Crontab and

GRID jobs.

> Performing object level, schema level auditing on the databases for

any unauthorized usage.

> Performing Management tasks on Schemas and objects using TOAD and

PL/SQL Developer.

> Provided support for changes on any major application or logical

Database design.

> Provided 24x7 support. Willingness and flexibility to work beyond

regular hours based on business demands.

Environment: Oracle 9i/10g/11g, Sun Solaris, RMAN, RAC, Data Guard, OEM,

AWR/ADDM/Statspack, Unix Shell Programming, ERWin, SQL, PL/SQL, Stored

Procedures, Functions and Triggers, TOAD9.0, PL/SQL Developer

CLIENT: WRAP TECHNOLOGIES, INDIA

DEC'07 - NOV'09

POSITION: Oracle DBA

Roles & Responsibilities

> Organizing Oracle Database operations like installation, creation,

configuration of Databases, laying out database tables and database

schema design, startup and shutdown of Databases.

> Setting init.ora parameters, maintaining Data Files, Control Files, Redo

Log Files, managing Tablespaces, segments, extents, indexes and

performing management of Undo Data. Maintained Test Database for testing

and research work.

> Creating tablespace and planning the location of data, index and rollback

tablespace redo log files and control files in adherence to the Optimal

Flexible Architecture (OFA).

> Creating users and roles for database and give the privileges to suitable

user.

> Monitoring database on a regular basic with the help of Alert logs,

Listener log, Redo log status, Fragmentation level of Tablespaces,

Rollback segments.

> Working with System/ SQLtuning to resolve the performance issues of

oracle database.

> Experience in system tuning with the help of tuning log switches,

pga_aggregate target, tuning advisors, pinning package in memory,

Statspack to ensure good performance of oracle database.

> Using the ADDM to analyze performance problem and with the help of AWR

reports for individual SQL statements. Analyzing recent session activity

with an ASH report.

> Good knowledge of SQL Transformation, Full table scans, Table access by

ROWID, Index Scans with the help of Optimizer.

> Working on data profiling tool such as IBM Information Analyzer.

> Working on an Indexing Strategy to create various types of Indexes

rebuilding them and monitoring those indexes for better performance of

SQL quires.

> Monitoring of the queries with high response time and high disk reads per

execution and tuning them with the help of SQL performance tuning tools

like Explain Plan, TKPROF, Auto trace, SQL trace, End-to-End Tracing.

> Managing large database objects with the help of DML and DDL languages.

> Installation and configuration of Oracle Database Software 10g on IBM-AIX

platform.

> Responsible for taking hot backups and logical backups at schema,

tablespace and database level.

> Configure and managing the logical standby database.

> Writing UNIX shell scripts to automate database administration including

scripts for database creation, statistics gathering and security

administration.

> With help of EXPORT/IMPORT utility of database to do table level and full

database Defragmentation.

> Well aware with different recovery phases like Data recovery, Instance

recovery, Media recovery.

> Troubleshooting various Database Features like Mean time to recovery

(MTTR), Flashback Query, LogMiner, Replication to keep database as

available as possible.

> Successfully implemented physical standby databases using Oracle Data

Guard feature for High availability configuration.

> With help of Database links provided connectivity to other databases.

> Capacity planning for changes in the size of databases due to business

growth.

> Carrying out Problem Management and Change Management activities in

Corporate Information Services across the Information Technology stack.

Triaging issues in Production / Stage /Development with respect to

Database Servers, N-Tier Applications, Network Elements, ensure 24x7

uptime and availability.

Environment: Solaris 8.0/9.0/10.0, OAS 10g, RHEL, Windows 2000 Oracle 8i

(8.1.6/8.1.7), Oracle 9i/10gR1, Oracle Enterprise Manager, Oracle

Partitioning, Oracle Replication, Hot Standby, SQL*Plus, PL/SQL,

SQL*Loader, SQL Server 2000, Toad.

CLIENT: BRIGADE TECHNOLOGIES PVT LTD, INDIA SEPT'06

- NOV'07

POSITION: Oracle DBA/Developer

Roles & Responsibilities:

> Part of Migration team to migrate databases from Oracle 8i to Oracle

9i.

> Test the migrated databases in different scenarios with different

loads, test different new features of 9i and how we can take advantage

of those new features.

> Managing user management (synonyms/privileges, roles, quotas, table

partitioning, index, sequence), space management (tablespaces,

rollback segment)

> Maintenance of database instances, Managing logical and physical

database structures and rollback segments.

> Created different types of Indexes (B tree, reverse key, IOT and

function based etc) and partitions on tables.

> Backup and Recovery set up through RMAN and Export / Import utility.

> Applied different recovery procedures for complete and incomplete

methodologies depending on the type of failure.

> Performed Backup and Recovery strategies through Cold/Hot Backup and

maintained User managed backups using RMAN.

> Optimized Instance parameters settings for Shared Pool, Buffer Pool,

Log Buffer, Sort Area and multiplexed control files, log files on

multiple disks.

> Configuration of listeners, tnsnames on Linux environment for oracle

work group server databases on production sites.

> Used Triggers for database activities, like delete, update and user

log on.

> Managed System Users, security and system monitoring for production

environment.

> Performed table, schema level, export and import.

> Data loading from flat files to oracle tables using SQL loader

utility.

> Monitoring alert log files, network log files and trace files.

> Responsible for administration of Windows NT and UNIX environments.

> Provided System support for both development and 24/7 production

environment.

Environment: ORACLE 8i/9i, UNIX, PERL scripting, Windows NT, SQL, PL/SQL,

Toad, Pl/SQL Developer, Cronjob, Import/Export

EDUCATION/PROFESSIONAL CERTIFICATION

> Oracle 10g Database Administrator Certified Professional (OCP)

> Bachelor of Technology in Computer Science from JNTU, Hyderabad.(Pass out

Year: 2006)

Contact this candidate