Oracle Data
Resume:
[pic] Mahesh Keesar
*******@************.***
Summary
Over 7 years of experience in information technology which includes Oracle
Database Administration and administration of UNIX and windows
environments.
. Oracle Database Administration on 24x7 critical production and large
databases using Oracle 10g RAC, 11g RAC, 9i, 8i.
. Implementation of High Availability solutions with Oracle 10g RAC, 11g
RAC, Standby Database Data Guard for large financial applications.
. Installing and configuring ASM for the RAC storage implementation.
. Installations of Oracle 11g RAC, 10g RAC, 9i, 8i on Sun Solaris/Red
Hat Linux, Oracle Enterprise Linux/HP-UX/IBM-AIX/Windows platforms and
creating databases.
. Cloning database from production to test and development.
. Creating standby databases for disaster recovery and reporting
purpose.
. Experience in Patching the Oracle Software and Databases.
. Upgrade/Migration of databases from Oracle 9i to 10g, 9i, 10g to 11g.
. Experience working with Export/Import, Data pump.
. Experience with Partitioned Tables.
. Working experience in OLTP and DSS environments.
. Backup of Databases (Making Backup Schedules depending upon Business
Strategy: Daily Backup, weekly Backup, RMAN incremental backups.)
. Recovery of Databases (Recovering from Media Failure, Recovering
tables dropped accidentally, Recovering data files, Recovering from
Block Corruption etc.).
. Experience providing 24X7 on-call support to maintain all Databases up
and running in Production environment.
. Performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan,
AWR, ADDM.
. Replication using Oracle Golden Gate, Oracle Streams.
. Experience in capacity planning and benchmarking.
. Experience in hot/cold backup mechanisms, EMC BCV concepts
. Knowledge on Oracle Support processes for technical requests with
Metal ink.
. Result oriented, self-motivated, Team player, ability to work
independently.
. Highly motivated, excellent team player, enthusiastic, strong
initiative and quick learner of new technologies. Strong interpersonal
and communication skills in dealing with customers.
Technical Skills
Databases : Oracle 8i/9i/10g RAC/11g RAC, SQL Server 2000/2005,
Teradata.
Operating Systems: Red Hat Linux 4.x, 5.x, Sun Solaris 8, 9, 10,, HP-UX
10.x, 11.x,
IBM-AIX 5.1, 5.2, 5.3, Oracle
Enterprise Linux, Windows
Languages : SQL, PL/SQL, UNIX Shell Scripting
Oracle Tools : RMAN, ASM, OEM Grid Control, TOAD, SQL*Loader,
Golden Gate, Streams
Hardware/Storage : EMC BCV, VERITAS Netback up, Tivoli Storage Manager
(TSM)
Education
Bachelors of Technology (B.Tech) in Computer Science from Jawaharlal Nehru
Technological University (JNTU)
Professional Experience
Client: PepsiCo, Plano, TX
Feb 2010 - Till Date
Role: Sr. Database Administrator
Responsibilities:
. 24x7 Oracle Production Database Administration.
. Installed, configured and maintained Oracle Databases and
Applications.
. Oracle 11g/10g RAC installation, configuration and support.
. Table Partitioning, Creating Locally managed Table spaces.
. Focused on separate Partitions like data loads, index creation and
rebuilding, backup/recovery.
. Worked with Materialized views.
. Applying patches for both Server side and Client side.
. Refresh/Cloning of Database and applications for development and
testing purpose.
. Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g
to 11g.
. Migrated databases from HP-UX to IBM AIX.
. Standby Database (Data Guard) setup and configuration.
. Global operations and maintaining database.
. Using expdp/impdp for export and import.
. Creating and maintaining Materialized Views for replication.
. Refreshing/cloning databases using RMAN.
. Created package for Online Redefinition of tables for every day column
additions and conversion of tables to partitioned or non-partitioned
tables.
. Working alongside programmers and contributing to the development
process; Enabling and analyzing trace files for debugging issues.
. Defining and Setting backup and recovery procedures.
. Responsible for continuous database monitoring and reorganization for
ensuring performance.
. Partitioning large objects to improve the performance and
manageability.
. Responsible for SQL query tuning optimization. Performance tuning
using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR,
ADDM.
. Oracle utilities i.e. export/import Data Pump, Flash Back Recovery,
SQL, Data Guard, ASM and OEM
. Proactive monitoring of databases and applying RDBMS patches, security
patches.
. Writing Shell Scripts for managing day-to-day activities.
. Usage of Partitions to improve the query performance and
manageability.
. Installation of Oracle RDBMS server software and version upgrades.
. Backup of Database (Making Backup Schedules depending upon Business
Strategy: Daily Backup, weekly Backup etc.)
. Recovery of Database (Recovering from Media Failure, Recovering tables
dropped accidentally, Recovering data files, Recovering from Block
Corruption).
. Installation and configuration of Oracle Client software and Tools.
. Installation, configuration and administration of Golden Gate
Replication.
. Replication using Oracle Streams
. Proactive monitoring of Oracle Database & Applications, which include
Space management, Standard services availability check, quickly
identify and resolve database and application level errors.
Environnent : Oracle 10g RAC/11g RAC, OEM (Grid Control), Oracle Data
guard, Golden Gate, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data
pump, SQL*Loader, Import Export, AIX, HP-UX, Sun Solaris and Red Hat.
Client: NetApp Inc, Sunnyvale, CA
Dec 2008 - Jan 2010
Role: Database Administrator
Responsibilities:
. 24x7 Oracle Production Database Administration including Oracle 10g
RAC
. Installed, configured and maintained Oracle Databases and
Applications.
. Installing and configuring ASM.
. Refresh/Cloning of Database and applications for development and
testing purpose.
. Involved in Upgrade/Migration of the oracle databases from Oracle 9i
to Oracle 10g.
. Experience using Export/Import and Data pump for migration of
databases.
. Working with Oracle 9i and 10g partitioned tables.
. Standby Database (Data Guard) setup and configuration.
. Creating and maintaining Materialized Views for replication.
. Cloning Oracle databases from Production to Development, Test
. Refreshing/cloning databases using RMAN.
. Working alongside programmers and contributing to the development
process
. Defining and Setting backup and recovery procedures.
. Responsible for continuous database monitoring and reorganization for
ensuring performance.
. Partitioning large objects to improve the performance and
manageability.
. Experienced in Tuning SQL statements using Explain Plan, SQL Trace,
TKPROF and STATSPACK, AWR, ADDM
. Writing Shell Scripts for managing day-to-day activities and
automation of backup.
. Backup of Database (Making Backup Schedules depending upon Business
Strategy: Daily Backup, weekly Backup etc.)
. Recovery of Database (Recovering from Media Failure, Recovering tables
dropped accidentally, Recovering data files, Recovering from Block
Corruption).
Environnent : Oracle 11g RAC/10g RAC/9i/8i, OEM (Grid Control), Oracle Data
guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Data pump, SQL*Loader,
Import Export, AIX, HP-UX, and Red Hat.
Client: Commerce Bank, St. Louis, MO
Oct 2007 - Nov 2008
Role: Database Administrator
Responsibilities:
. Supporting production database system 24*7.
. Oracle DBA, Primary point of contact for client for production
database support.
. Installation and Configuration of Oracle 10g RAC.
. Migrating Oracle databases from windows to Linux.
. Developer Environment Setup, Support, Cloning and Refreshes.
. Performed database cloning to setup test and development database.
. Used RMAN for backup and recovery. Performed backup validations using
RMAN.
. Implemented Hot, Cold and Logical backup plans.
. Proactive database monitoring using 10g grid control.
. Installation of Oracle RDBMS server software and version upgrades.
. SQL tuning using Stats pack, AWR, Explain plan, Tkprof.
. Installation, Configuration and Maintenance of Logical and Physical
Standby databases.
. Ensuring that all databases are backed up on a regular basis. Fix
backup failures, address and implement resolutions.
. Conducting sizing & capacity planning for Oracle databases.
. Storage and space management including table spaces and data files.
. Management of table space growth, monitoring data files additions,
extent growth.
. Applied patches to Oracle Database 10g,9i.
. Monitoring Growth of tables and undertaking necessary re-organization
of database objects when required.
. Responsible for optimizing the queries and application tuning
. Oracle Database monitoring, troubleshooting and resolved the issues.
. Management of schemas, objects partitioning the tables & indexes.
Environnent : Oracle 10g RAC/9i/8i, OEM (Grid Control), Oracle Datagaurd,
ASM, RAC, PL/SQL, RMAN, Datapump, SQL*Loader, HP-UX, Sun Solaris, AIX,
RedHat Linux.
Client: General Insurance Corporation, Hyderabad Jun 2004
- Aug 2007
Role: Oracle DBA/Developer
Responsibilities:
. 24x7 Oracle Production Database Administrations.
. Managing, troubleshooting and resolving oracle database and
applications issues.
. Refresh/Cloning of Database and applications for development and
testing purpose.
. Working alongside programmers and contributing to the development
process.
. Planning and recommendations for optimum performance.
. Extraction of data from flat files into Oracle Database using SQL*Loader.
. Defining and Setting backup and recovery procedures.
. Developing Hot, cold and logical backup scripts to automate the backup
procedures.
. Tuning and balancing I/O by monitoring file system and table space I/O
statistics.
. Experienced in Tuning SQL statements using Explain Plan, SQL Trace,
TKPROF and STATSPACK.
. Written SQL, PL/SQL functions, procedures, packages and triggers.
. Monitoring and managing the Storage Usage by Resizing Older Table
spaces, Creation of New Table spaces and relocation of data files for
better Disk I/O.
. Writing Shell Scripts for managing day-to-day activities and
automation of backup.
. Optimal Space utilization in table space by avoiding fragmentation.
. Usage of Partitions to improve the query performance and
manageability.
. Installation of Oracle RDBMS server software and version upgrades.
. Recovery of Database (Recovering from Media Failure, Recovering
tables dropped accidentally, Recovering data files, Recovering from
Block Corruption).
. Monitoring of database objects like rollback segments, temp segments
and table spaces.
. Automated the process of analyzing tables.
Environment: Oracle 10g/9i/8i, OEM (Grid Control), PL/SQL, RMAN, Data pump,
SQL*Loader, Sun Solaris, RedHat Linux, Windows.
Contact this candidate