Suman Kumar

Sr. Oracle DBA

Email: acog26@r.postjobfree.com

Phone: 424-***-****

Professional Summary:

. Around 8 years of experience as Oracle Data Base Administrator,

providing 24x7 production support of both development and production

11g/10g/9i/8i databases on different Platforms

. Outstanding knowledge in Installation and Configuration of Oracle 8i,

9i, 10g and 11g in UNIX/LINUX and Windows environment.

. Hands On Experience in installing, configuring and managing Oracle 11g

RAC with ASM

. Delivering Oracle Database performance-tuning services for customers

with EXPLAIN PLAN, TKPROF, node RAC

. Established Disaster Recovery for Oracle 11g RAC database STATSPACK,

SQL TRACE, ORADEBUG, 10gOEM Grid Monitoring custom scripts

troubleshooting oracle databases using SQL trace utilities.

. Experience in regular Database Administration activities such as

Upgrades, Migration, Patches, TAR support, Cloning, Backups and

Recovery Manager, Performance Tuning, capacity planning, script

development, and documentation

. Experience in using 10g features Flash-Back Recovery, Data Pump, AWR,

ASM, ADDM, ASH, Recycle Bin, 10g Grid Monitoring

. Experience in installation and configuration of Oracle Golden gate

(both unidirectional and bidirectional).

. Skilled in Oracle Streams, Transparent Data Encryption (TDE), Oracle

Tuning Pack, Advanced Security Option(ASO), Data Vault, Fine Grained

Auditing(FGA)

. Skilled in setting up/Installation and configuration of release 10g

RAC R2 with ASM and Raw Devices and 10g CRS.

. Planned and implemented DR & high availability solutions using Oracle

10g Standby Database using Oracle Data guard, 9i and 10g RAC

. Skilled in taking backups using cold, hot and RMAN backups and also

tested different recovery procedures also Cloning/Refresh

. Skilled in developing RMAN scripts for database back up including hot

and cold backup options for both RAC and standalone instances

. Installation, configuration, Designing & Administration of ORACLE

Database Vault

. Experienced with working on large environment with multi terabytes.

. Skilled in Oracle Data ware House Tool CDC(Change Data Capture)

. Skilled in managing OLTP/DSS database systems with VLDB with multi

tera bytes in size.

. Skilled in different environments like HP-UX, SUN SOLARIS, and Linux.

. Installed and configured 10g RAC on LINUX platform with ASM disks for

storage.

. Skilled in dealing with ASM environment such as Installation, taking

backup, migration from NON-ASM to ASM environment.

. Experienced in Commvault storage technologies and backup solutions

. Skilled in cross platform migrations from Windows to Linux, Solaris to

Linux

. Skilled in database upgrades 8i to 9i, 9i to 10g R2 and 10g to 11g

. Experienced in loading data from flat files using SQL Loader and

External Tables.

. Skilled in using tools such as SQL Developer and TOAD.

. Dealing with database security and auditing

. Skilled in SQL Server Database Administration and Data modeling tools

Erwin

. Experience on Oracle Support processes for technical requests through

Meta link.

. Excellent communication skills, with strong troubleshooting, and

problem solving ability

. Provided 24x7on call production support.

TECHNICAL SKILLS:

Operating Systems HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5, 8, 9,

10, IBM AIX 5.1, 5.2, RHEL

2.1, 3.x, 4.x and Windows NT / 2000 / XP

RDBMS Oracle8i, Oracle 9i, Oracle 10g,Oracle 11g

Languages SQL, PL/SQL, C, JAVA, UNIX Shell Scripting

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

Tools & Utilities RMAN, OAM, OEM, EXP, IMP, expdp, impdp, TOAD,

SQL*Loader

ETL Tools Informatica 5.1, Data Stage 6.0, ODI

Data Modeling ERWIN 4.0, Rational Rose

Other EMC, HP OmniBack, Veritas NetBackup, IBM TSM,

NetApp

Professional Experience

Company : S&P Capital IQ, New York

Role : Sr. Oracle DBA

Period : Mar'2014 - Till Date

Responsibilities:

. 24*7 Production Database support of multi-terabyte Oracle 11g database

. Worked on Database upgrades from 10g to 11g for 30 database in span of

3 months. Creating the database,

Tables, tablespaces, data objects, setting privileges, indexes, user

logins, password (security)

. Monitor and tune Oracle database for optimum performance and assist in

capacity planning of Oracle database servers

. Maintained, developed and implemented policies and procedures to

ensure security and integrity of company's Oracle databases

. Fix errors in data for various clients by using GUI interface of

application or PL/SQL scripting

. Developed Oracle PL/SQL code based on requests raised by changes in

business logic, norms and standards

. Extraction of data from different flat files into Oracle Database

using SQL*Loader and automated the process by using Basic Replication

using materialized views

. Performed all aspects of database administration including

Installation, Configuration, Patches, Monitoring, Import/Export,

Cloning etc.

. Provide performance tuning, problem diagnosis, data reorganization and

database upgrade support

. Developed PL/SQL Packages, functions and triggers to implement various

functionalities

. Defined database migration strategy to relocate production database to

new Sun servers.

. Responsible for Creating, Constructing, Operating and maintaining

Interfaces using ODI

. Generated and analyzed STATSPACK, AWR, ADDM, Explain Plan reports and

monitored statistics for performance tuning of the database

. Performed Data replication and Data transformation

. Involved in basic and advanced replication using Oracle Streams

. Implemented 11g features like UNDO tablespaces, Resumable space

management, Segment space management, Redefining Tables

. Plan, implement, and troubleshooting Oracle RMAN backup, restore, and

recovery

. Installation and Configured Oracle10g Grid Control

. Successfully installed and configured Oracle Golden Gate for

replication in Development and Test Environment

. Export and import of database objects using Data pump utilities EXPDP

and IMPDP

. Performed data loads using SQL*LOADER

. Wrote Shell Scripts for Backup and cloning

. Tune SQL, PL/SQL statements found in the reporting utilities and

queries

. Involved in the maintenance and trouble shooting of RAC Databases

. Monitored and managed the space usage and table partitioning

. Implemented and Configured Standby database (Data guard) for disaster

Recovery

. Carried out weekly reviews, technical reviews, made weekly progress

reports

. Acted as primary point of contact between customer and core

development team

Environment: Oracle 11g RAC/10g RAC, RHEL, Sun Solaris, HP-UX, Win NT/03,

Oracle Data Integrator, SQL, PL/SQL, RMAN, Erwin, SQL*Loader, Import/Export

Company : Cardinal Health, Inc. Dublin, OH

Role : Sr. Oracle Database Administrator

Period : May'2012 - Mar'2014

Responsibilities:

. Installed, Configured, Upgraded & Applied patches and bug fixes for

Prod, Test & Dev Servers.

. Upgraded databases, Oracle RDBMS on 10g Real Application Clusters (9ig

RAC) on Linux to 11g Real Application clusters on Linux (10g RAC).

. Responsible for configuration of 11gRAC, 10gRAC on Linux and Solaris

using ASM and RAW devices and Oracle CRS

. Database upgrades and Datacenter Migrations of Oracle databases from

9i and 10g.

. Implemented advanced features of Oracle 10g such as Automatic Database

Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for

monitoring database performance

. Administering ORACLE Databases 10g (10.2.0.2), 11g (11.1.0.7) with

over 5 TB in size

. Experience in Upgrading Dev and Test instances to 11g (11.1.0.7)

. Analyzed the impact of upgrading from 10.2 to 11.1 at the SQL

statement level by using the other component of 11g Real Application

Testing which is called SQL Performance Analyzer or SPA.

. Oracle Cluster ware installed to provide infrastructure for RAC and

configured 2 node Oracle 10g RAC with ASM

. Configured ASM and handled issues and suggested feasible workarounds

for ASM Metadata corruption

. Implemented partitioning on large tables, expertise in using in

composite partitioning, local indexes, global indexes and indexes of

hash partitions.

. Creation & Maintenance of 20 Single Instances and 5 RAC Databases in

Development, Test and Production servers. Coordinated with System

Admin's for Server Support, NAS and SAN storage.

. Performed Pre & Post installation tasks in Migration starting from

Research on Initialization Parameters for Datamart Database and

Database Links, Synonyms, Views & Roles for Different Databases which

will be preferable to current environment.

. Experience in Upgrading Dev and Test instances to 11g (11.1.0.7)

. Experience in Replication of Data bases using Oracle Streams and

Logical Standby.

. Worked with Data Architect on dimensional modeling to optimize the

already existing data-warehouse database using STAR Schema,

identifying Fact and Dimension Tables for providing a unified view to

ensure consistent decision making.

. Implemented and managed optimum physical database design (tablespaces,

datafiles, extents, redo logs, archive logs) and assessed database

capacity by monitoring online storage, growth and file system space,

in adherence to the Optimal Flex Architecture.

. Provided instance level performance monitoring and tuning for Event

Waits, Sessions, Physical and Logical IO and Memory Usage.

. Re-designed table and index partitioning strategies HINTS to improve

the query performance.

. Monitoring Day-Day Backups, Log's & recovering them as per the

requirement. Utilized LOG MINER Technology & applied Application

Database Transactions on other Databases.

. Successfully implemented Backup & Recovery using RMAN which includes

hot backups and Cold backups.

. Experienced in configuration of 10gRAC on Linux and Solaris using ASM

and RAW devices and Oracle CRS and Veritas Netbackup as a media

management layer.

. Performance tuning of Queries by maintaining Aggregates, Compression,

partition, indexing and use of Hints, Stored outlines, Statistics.

. Supported development teams by providing SQL statement tuning and

optimizing ETL procedures and removing load and query performance

bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.

. Cloned schemas, objects and data on new server using exports from 10g

database and imported in 11g using data pump.

. Responsible for capacity planning, database security, recovery planning

and installing patches

. Worked extensively on monitoring 10G grid control database, configuration

of error notifications, installing listeners, and adding them to the grid

control.

. Worked on configuring Oracle Data Guard and EMC Symmetric Remote Data

Facility on production server.

Environment : Oracle 10g RAC, 11g, UNIX, Solaris 10, Informatica, TOAD,

VERITAS, OEM, ERWIN 7.2, SQL, PL/SQL, TKPROF, Weblogic, EXPLAIN PLAN,

Business Objects XI, DataGuard.

Company : AT& T Atlanta, GA

Role : Sr. Database Administrator

Period : Jan 2011 - May 2012

Responsibilities:

. Involved in 24x7 support for both production and development

databases with on-call pager

. Installed Oracle Streams for Basic and Advanced Data Replication

between Oracle Databases and other databases

. Used Oracle Streams for propagation and management of data,

transactions and events in the data stream to ensure smooth and

transparent data flow

. Upgrade and Migration of Database from 9.2.0.6 to 10.2.0.2 and

applying patches whenever required.

. Cloned/Refreshed Oracle Databases for development and testing

. Partitioned large tables to increase the performance

. Performance tuning of Oracle Database Objects by fixing row chaining

. Installed and Configured Oracle Dataguard for Oracle 10g & 9i for the

maintenance of Stand by database

. Extensive use of Oracle Dataguard for protection of critical

production data & provide data / disaster recovery support

. Optimization and tuning SQL queries using TRACE FILE,TKPROF,EXPLAIN

PLAN

. Continuous monitoring of database performance during peak and non-peak

loads using STATSPACK

. Tuning heavy data loads, monitoring and Performance tuning

. Setup backup and recovery procedures using RMAN. Performed hot and

cold backups using RMAN

. Performed block recovery using RMAN

. Performed backup validations using RMAN

. Oracle Database monitoring, troubleshoot and resolve the issues

. Management of schemas, objects partitioning the tables & indexes

. Automation of data load using Korn shell scripting and SQL*Loader

. Responsible for setting and managing user accounts, Granting required

privileges to users

. Defining and Implementation of backup and recovery strategies

. Performing all daily Maintenance tasks. Interacting with Oracle

Customer service when required

. Writing scripts for the system and database for effective

functionality and report generation

. Applied High priority, security patches downloaded from Metalink.

. Involved in Logical and Physical database design

Environment: Oracle 10g with RAC, Oracle 9i, Oracle 8i, TOAD, Solaris8,

9.

Company : Southwest Airline, Dallas, TX

Role : ORACLE DBA

Period : Oct 2009 - Jan 2011

Responsibilities :

. Provided 24X7 support for all the production and development

databases.

. Installed and configured Oracle 10g.

. Other duties include applying oracle database patches, design and

creation of databases as per user requirement, creation of database

users, monitoring, tuning, troubleshooting, and backup and recoveries.

. Applied patches using OPATCH and Patch sets using OUI

. Cloned/Refreshed Oracle Databases.

. Implemented Disaster Recovery plans

. Responsible for optimizing the queries and application tuning.

. Perform SQL tuning and assist developers with coding PL/SQL.

. Provided support to Application Database Administrators in designing

the database.

. Installed and Implemented Backup & Recovery procedures.

. Implement Hot, Cold and Logical backup plans.

. Worked on several shell scripts to maintain the database activities

. Mentoring the Database Performance using automated scripts.

. Answerable for setting and managing User Accounts, Granting required

privileges to users.

. Experienced in Security Administration and Space Management

. Perform other regular DBA activities including space management and

performance monitoring.

. Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN

PLAN.

. Continuous monitoring of database performance during peak and non-peak

loads using STATSPACK.

. Involved in process improvement, Oracle Server

Installations/Upgrades/Patches, Space Management, Capacity Planning,

Backup & Recovery, Disaster Recovery, Database Performance Tuning,

Memory Tuning, Application Tuning, Security Administration, Data

Warehousing, Dataguard, Oracle Advanced Replication, Real Application

Clusters, Oracle standby services.

. Implement "Stored Procedures and Triggers" based on business plans

using PL/SQL.

. Automation of data load using Korn shell scripting and SQL*Loader.

Environment : Oracle 10g/9i/8i, RHEL 3,4

Company : Aviva Life Insurance, Hyderabad, India.

Role : Database Administrator

Period : Aug 2008 - Sep 2009

Responsibilities:

. 24*7 Production database administration, support and monitoring to

ensure a proactive problem recognition and resolution of database

issues

. Installation and Maintenance of Stand by database.

. Conducting sizing & capacity planning for Oracle databases.

. Upgraded production and development databases to Oracle 9i.

. Applied patches to Oracle Databases and Oracle Applications.

. Cloned/Refreshed Oracle Databases and Oracle Applications for

development and testing.

. Used RMAN for backup and recovery. Performed backup validations using

RMAN.

. Implemented Hot, Cold and Logical backup plans.

. Involved in taking Backups using Oracle RMAN (Recovery Manager) and

TSM (Tivoli Storage Manager). Defined Data Storage policies like

number of backup versions to keep, the retention period for inactive

copies etc. Installed and configured TDP using dsm.opt, tdpo.opt

files.

. Customization and development of Korn shell scripts.

. Management of schemas, objects partitioning the tables & indexes.

. Automation of data load using Korn shell scripting and SQL*Loader.

. Responsible for setting and managing user accounts, granting required

privileges to users.

. Defining and Implementation of backup and recovery strategies

. Perform other regular DBA activities including space management and

performance monitoring.

. Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN

PLAN.

. Continuous monitoring of database performance during peak and non-peak

loads using STATSPACK.

. Involved in process improvement, Oracle Server

Installations/Upgrades/Patches, Space Management, Capacity Planning,

Backup & Recovery, Disaster Recovery, Database Performance Tuning,

Memory Tuning, Application Tuning, Security Administration, Data

Warehousing, Data Guard, Oracle Advanced Replication, Real Application

Clusters and Oracle Standby.

Environment : AIX, Redhat Linux, Oracle 10g, 9i and Oracle 8i,

Solaris

Company : GGK Technologies, Hyderabad, India.

Role : Jr. Oracle Developer & Administrator

Period : May'2007 - Aug' 2008

Responsibilities:

. Provided support for all the databases as an operational database

administrator.

. Installed and configured Oracle 8i databases.

. Other duties include applying oracle database patches, design and

creation of databases as per user requirement, creation of database

users, monitoring, tuning, troubleshooting, and backup and recoveries.

. Responsible for optimizing the queries and application tuning.

. Perform SQL tuning and assist developers with coding PL/SQL.

. Provided support to Application Database Administrators in designing

the database.

. Installed and Implemented Backup & Recovery procedures.

. Implement Hot, Cold and Logical backup plans.

. Analyze, design and implementation of the Database for e-commerce

system.

. Implement "Stored Procedures and Triggers" based on business plans

using PL/SQL.

. Proactive database monitoring using automated scripts based on

v$views.

. Frequent Database audits to ensure the SOX standards were not

voilated.

. Developer Environments setup using database cloning and refresh

procedures.

Environment : ORACLE 8i, LINUX, SUN SOLARIS 8

EDUCATION

Bachelor in Engineering from Acharya Nagarjuna University, AP, India.

Contact this candidate