Resume

Sign in

Sr.Oracle DBA Consultant

Location:
Naperville, Illinois, United States
Posted:
January 25, 2018

Contact this candidate

PAVAN KUMAR KANURU

Email: ac361z@r.postjobfree.com

Phone: +1 (732)-***-****

OVERVIEW

Oracle Certified Professional with 14 plus years of experience in I.T. as Oracle Database Administrator. Extensive experience in relational database design, analysis, development, administration, implementation, trouble shooting, security and auditing. Comprehensive experience as Oracle DBA. Proficient in Oracle 9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i on Unix and Windows NT platform. Having good experience in Shell scripting. Managing the team of Oracle DBAs and actively coordinated with the end user community.

DATABASE SKILLS:

Hands on experience in Oracle 10g/11g/12c RAC Implementation & Administration

Experience in managing Oracle databases running on UNIX/Linux, Sun Solaris and Windows.

Extensive knowledge on database administration for Oracle 9i/10g/11g/12c with experience in large scale databases and mission critical large OLTP and OLAP systems.

Good experience in RAC Clusterware administration.

Installed and configured GoldenGate for replication.

Expertise in Oracle Database Migration Activities (Across platform as well as same platform).

Database Refresh from PROD to DEV/QA/TEST servers using RMAN (Duplicate and Active Duplicate) and cloning.

Installed and configured OEM Grid Control, deployed agents registering and monitoring databases.

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

Applied CPU, PSU patches and regular bug patches with Opatch utility as per the business requirement.

Proficient in Database Administration activities such as Upgrades, Patches, TAR support, Performance Tuning, capacity planning, script development, and documentation.

Extensive experience in Data Center Configuration and Migration from Linux to AIX.

Configuring Transparent Data Encryption (TDE) on Tables / Tablespaces.

Creating and Managing Users, Responsibilities and Request Groups

Planning for storage spaces requirements and placing them for optimum I/O performance.

Extensive experience in Dataguard configuration, implementing and maintaining standby databases.

Proficient in scheduling jobs, patches, alerting for databases, hosts and also database administration through OEM grid control.

Plan, test & implement the database Backup & Recovery strategy depending on the database size. Checking the daily, weekly, monthly backup status.

Recovered Databases from different types of failures/corruption like Disk failure, Logical errors, block corruption

Excellent analytical and problem-solving skills and Result oriented, self-motivated, team player, ability to work independently.

Ability to function successfully in a highly stressful, 24x7 mission critical environment.

Good knowledge on Incident / Problem and Change management process.

CERTIFICATIONS:

Oracle 10g Certified Professional (OCP 10g)

TECHINICAL SKILLS:

RDBMS Oracle 12c RAC/ 11g RAC/10g RAC/ 9i, MySQL.

Operating Systems: Linux RHAT 4/5,6, AIX 5.2/5.3, Microsoft Windows NT,2000/2003/2005.

Tools & Utilities ASM, OEM, Tkprof, Statspack, AWR, ADDM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump, SQL Loader, DBverify, Explain Plan, Automatic SQL Tuning, ASH, SQL Advisor, Putty, Active Data Guard, Data Masking

PROFESSIONAL EXPERIENCE

Client: Penske Truck Leasing, Reading, PA. - June-2016 to Date

Title: Sr. Oracle Consultant

Name of the Project: DBA Support

Responsibilities:

Experience as On-Call 24x7 production DBA support, application/development DBA.

Installed, configured and maintaining Oracle Databases and Responsible for installing and configuring GoldenGate.

Monitoring/managing 2,3,5 node RAC databases using OEM-Grid control.

Experience in configuration and installation of the Oracle 12c RAC.

Installed and configured OEM Grid Control for database monitoring/performance/diagnostics.

Experience in Database Upgradation from oracle 10g /11g to Oracle 12c.

Applied latest releases of the RDBMS patches.

Performed block recovery using RMAN.

Converted oracle databases from Non-ASM to ASM.

Installed and configured GoldenGate for active – active replication.

Planned and implemented high availability solutions using Oracle 12c RAC, Standby Database using Oracle Data Guard.

Implementation of Oracle Data masking using OEM GRID 12c

Configuring Transparent Data Encryption (TDE) on Tables / Tablespaces.

Performed production databases cloning using RMAN to Dev for testing.

Coordinating Offshore and Onsite DBA for overall client and business deliverables.

Configured all databases in OEM 12c cloud control and configuring the alerts by installing the agents on clients.

Involving database capacity planning for the future business growth.

Configured DataGuard for production databases and performed Switchover.

Attending Change control meetings with respective application teams for code review

Documenting and maintaining all database issues with fixes for root cause analysis.

Identify and encrypt critical application tables or individual columns using Data Masking and TDE.

Client: Penske Truck Leasing, Reading, PA. - Oct-2013 to May-2016

Title: Sr. Oracle Consultant

Name of the Project: Freight Operation Information System

Responsibilities:

Managed over 100 plus Oracle databases.

Provided 24x7 Production database & application.

Installed, configured, and maintained Oracle 10g and 11gR2.

Upgraded databases from Oracle 11gR1 to 11gR2

Performed large batch jobs, and tuning of SQL queries and database systems.

Provided support to Application Database Administrators in designing the database.

Performed DR TESTING as per client requirement to maintain high availability.

Configured GoldenGate for Unidirectional replication.

Implemented Oracle database backup & recovery solutions using RMAN.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.

Experience in Database Refresh and patch management and in Database cloning with RMAN.

Extensive experience in Data Center Configuration and Migration from Linux to AIX.

Experience in converting single instance to RAC.

Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.

Applied patches to update and implement security fixes to Oracle E-Business Suite.

Provided SQL query optimization.

Client: Penske Truck Leasing, Reading, PA. - Aug 2011 to Sept-2013

Title: Oracle Consultant

Name of the Project: DBA Support

Responsibilities:

Managed and executed database change requests.

Experience in database refresh from production to development.

Performed Data transfer using Oracle transportable table space feature.

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

Worked on Table space creation and maintenance support such as adding data files to the production, development and support and test databases.

Maintained redo log and archived log files.

Involved in index creation and rebuilding to improve the query performance.

Resolved row chaining and migration.

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

Monitored the CPU usage and IO statistics to identify any OS level Performance killers.

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

Handled Database change request from the application developers as when required.

Monitored and scheduled jobs.

Partitioning and re-organization of table and indexes.

Performed Troubleshooting of database problems faced by the application developers/users.

Client: Deutsche Investor Services Pvt. Ltd, Mumbai, India - Feb - 2008 to Jul-2011

Title: Sr. Oracle DBA Consultant

Name of the Project: RNTA

Responsibilities:

Managed and provided support of 45 plus Oracle databases.

24x7 Production database and applications support.

Experience in Up gradation of Oracle databases from 11gR1 to 11gR2.

Experience in Troubleshooting RAC startups, node evictions, reboots.

Synchronized Standby databases with Production databases.

Implemented DR TESTING exercises/snapshot standby feature for client requirement to maintain high availability.

Planning and implementing Backup strategy for the databases using RMAN, Scripting backup.

Database clone from PROD/DR to DEV/QA/TEST servers using RMAN.

Partitioned large tables for better performance and manageability.

Extensive experience in Data Center Configuration and Migration from Linux to AIX.

Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups

Identifying fragmented tables and re-organizing tables and rebuilding indexes.

Provide support to Development Team with their SQL query optimization using SQL Trace, Explain Plan, SQL Query Analyzer and Optimizer Hints.

Client: CITI BANK, NA., Mumbai, India - Sep-2003 to Jan-2008

Role: Oracle DBA Consultant

Project: TRIMS

Responsibilities:

Involved in 24x7 production database maintenance and on-call support.

Provided Database support for more than 100 plus Oracle Databases.

Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth

Experience in Database cloning using RMAN and Export / Import.

Experience in SQL query tuning.

Designed backup and recovery procedures for OLTP system. Conducted periodic cold and hot backups.

Created the partitioned table using Range, hash, list partitioning.

Partitioned large tables to increase the performance.

Implementing and maintaining database security (create and maintain users, roles and assign privileges), Oracle Configuration Management Pack.

Troubleshooting database problems faced by the application developers/users.

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

Creating technical documentation and imparting knowledge sharing within the team.



Contact this candidate