[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)