Oracle Manager

Abhilash D.

Email : ab86d6@r.postjobfree.com

Voice : 972-***-**** EXT 101

Summary

. Over 7 years of experience as Oracle DBA, providing 24/7 support of

both development and production 11g/10g/9i/8i databases on Various

Platforms.

. Excellent experience in Installation and configuration of Oracle 8i,

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

. Oracle Database Administration on 24x7 critical production and large

databases of over 20 TB using Oracle 11g,10g RAC, 9i, 8i.

. Excellent experience in OLTP/DSS database systems, implementing and

managing very large Oracle databases (VLDB) as huge as 20 TB.

. Experienced on HP-UX and Windows with Oracle8i Parallel Server and

Oracle9i RAC.

. Implemented strategy for partitioning and management of historical

data tables in RAC.

. Experience in Upgrading databases (10g R2 to 11g, 10g R1 to 10gR2, 9i

to 10gR1).

. Installed Oracle Clusterware to provide infrastructure for RAC and

configured 2 node Oracle 11g RAC with EMC.

. Experienced in setting up/installation and configuration of release

11g RAC/10g R1 RAC with EMC Storage.

. Planned and implemented DR & high availability solutions using OEL 10g

Standby Database using Oracle Data Guard, 11g and 10g RAC.

. Designed and implemented Oracle Real Application Clusters (RAC) on

Solaris for an OLTP application with Transaction Application Failover

and high transaction volume.

. Proficient in using OEM and RMAN.

. Proficient in Database Administration activities such as Upgrades,

Patches, TAR support, Performance Tuning, capacity planning, script

development, and documentation.

. Upgrade/Migration of Databases from Oracle 10g to 11g.

. Perform DB patching, Cloning, DB Installation, troubleshoot

issues/errors/incidents, Collaborate with Oracle support for bugs &

issues resolutions and personal research.

. Experience in Oracle GoldenGate installation, configuration,

troubleshooting GoldenGate issues.

. Experience in using GoldenGate in moving large volumes of

transactional data, with minimal impact to online systems.

. Excellent working experience on EMC, NetApp and ASM Storage

technologies.

. Knowledge of the Oracle GoldenGate installation, configuration,

troubleshooting GG issues

. Planned and implemented high availability solutions using Oracle 10g

RAC, Standby Database using Oracle Data Guard

. Hands on experience with Installation, Configuration, Migrations,

Oracle Data Guard, Backup and Recovery using RMAN, Disaster Recovery

and Patching, upgrading and administering 40 Terabytes of Oracle

Databases on Oracle 11g/10g/9i.

. Expertise in supporting replication with snapshots, Materialized Views

and Streams.

. Good knowledge on Oracle streams, data guard physical standby

databases, working knowledge on BCV'S, SRDF, and managing of

partitions and clustering of tables.

. Experience in using OEM, TOAD, and Data Migrations using

export/import, benchmarking using Load testing tools

. Configuring DB Links for users located remotely.

. Installation, configuration, upgrade and performance tuning of Oracle

RAC.

. Database Tuning, PL/SQL tuning using explain plan and used HINTS

extensively to optimize the SQL statements, used cost based approach

extensively and also used rule based methods to tune the SQL.

. Excellent experience in OLTP database systems, implementing and

managing large Oracle databases (VLDB).

. Expertise in maintaining Database Security using auditing.

. Experience with mid tier architectures 10giAS, Knowledge of OEM, TOAD,

Oracle grid-control.

. Experience with SQL, PL/SQL coding, stored procedures, triggers,

functions, packages, UNIX Shell Scripting, Partitioning, Indexes,

Logical and Physical database design.

. Experience on Script Programming using Korn shell, bash shell, Perl,

Awk and knowledge on archiving tolls like tar, gunzip, backup,

auditing both external auditing and internal auditing, experience on

various UNIX platform like Redhat, AIX

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

. Worked on Advanced Replication including synchronous and asynchronous

scenarios

. Experience with Oracle 10g features: Flash-Back Recovery, Datapump,

ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid

Monitoring and Recycle Bin.

. Solid experience with Oracle technology architecture, Oracle and Real

Application Clusters.

. Knowledge of Data transfer between SQL Server and Oracle.

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

critical environment.

. Excellent analytical and problem-solving skills.

. Result oriented, self-motivated, team player, ability to work

independently.

. Excellent written and verbal communication skills.

TECHNICAL SKILLS:

Operating Systems : HP-UX, IBM DB2, Red Hat Enterprise Linux RHEL 3.x,

4.x, 5.x, Sun Solaris OS 5.8/5.9/5.10,

IBM AIX 5.1, 5.2, 5.3, Netezza, Linux and Windows

DB Management : TOAD 7.6/7.5, OEM 9.2/10G (10.1/10.2) Grid control

(RAC), RAT.

Databases : Oracle 11g, 10g, 9i, SQL Server 2000, 2005.

Tuning/Monitoring : RAC 11gR1/R2, RAC 10gR2, Data-Guard 9i/10g/11g, DB

Cloning, Standby Databases, RMAN

9i/10g/11g, TKPROF, EXPLAIN PLAN, STATSPACK

Tools/Utilities : RMAN, OEM, Oracle Management Server,

SQL*Loader, SQL Server, Export/Import, TOAD,

Data pump, Query builder, Net Backup, VB, Crystal

Report, MS Access, Oracle Streams,

Putty, SQL*Plus, SQL * Loader

Programming Others : SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL,

Bourne

Other : EMC, NetApp, VERITAS Netback up, IBM Tivoli, HP Omni

back up, TSM.

PROFESSIONAL

EXPERIENCE:

Client: Target Co-operation, Minneapolis, MN

July '12 to Till Date

Role: Senior Oracle DBA

Description:

Target, is an American retailing company headquartered

in Minneapolis, Minnesota. It is the second-largest discount retailer in

the United States, behind Walmart. The company is ranked at number 38 on

the Fortune 500 as of 2012 and is a component of the Standard & Poor's

500 index.

Responsibilities:

. Installation, configuration and administration of oracle 11GR1/11GR2

RAC.

. Worked on upgrading Oracle Enterprise Manager (OEM) from 11g grid

control to 12c cloud control and installing agents on all production

servers.

. Migrated all production hosts, databases, and listener targets

from OEM 11g to12c.

. Worked on maintenance and tuning of Oracle 11g RAC 6 - Node/Standalone

databases including ASM and CRS.

. Implemented Oracle Active Dataguard and also actively participated in

Oracle Goldengate Planning & implementation.

. Worked on monitoring 12c cloud control database, configuration of

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

control.

. Implementation of Golden Gate for replication at schema and tables

level. Developing Semi-automate scripts to setup streams at table-

level. Used of Materialize view. Performing a data set conversation

without recreate db.

. Performance Tuning through OEM 12c using Real-Time ADDM, Compare

Period ADDM, ASH Analytics.

. Provided instance level performance monitoring and tuning for Event

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

. Tuning of Database (Tuning of Shared Pool, Buffer Cache, Redo Buffers,

and Rollback Segments).

. Supported development teams by providing SQL statement tuning and

optimizing ETL procedures and removing load and query performance

bottlenecks by using tools EXPLAIN PLAN, AWR, and TKPROF

. Worked on the Partition of the tables in Production using the Online

Redefinition in order to avoid the downtime of the Database.

. Performed Refresh Process between Stage and Development database using

DBlink.

. Written the PLSQL Package for refresh Process

. Worked on the SQL tuning of existing WebFOCUS complex queries which

significantly reduced the run time.

. Setting up and configuring Backup and Recovery solutions for the

production databases, as per Target defined standards and processes.

And monitoring the successful completion of the backups on a daily &

weekly basis.

. Writing new shell scripts and modifying existing shell scripts

depending on the requirement.

. Applying application schema changes in Production, Development, and

Performance and Lab environments.

. Reorganized and redefined the tables online using dbms_redefinition.

. Upgraded RAC from 11GR1 to 11GR2. Moved OCR and voting disks into ASM

. Worked on the ERWIN Data Modeler for schema comparison.

. Developed views to facilitate easy user interface implementation and

enforce security on critical customer information.

. Involved in documenting the entire system architecture and data flow

. Involved in Set up, configuration and maintenance of oracle data guard

(primary and standby databases) to ensure disaster recovery, high

availability and data protection.

. Worked closely and established good relationships with developers,

SA's for discussing infrastructure support, recommendations and

implementation to resolve development & production issues.

. Worked on Performance tuning i.e Shared Pool, I/O distribution,

rollback segments, buffer cache to provide instance level performance

tuning for Event Waits, Sessions, Physical/Logical IO and Memory

Usage.

. For performance enhancement implemented Range, List Partitions, Hash

Sub Partitions, Creating and refreshing materialized views.

. Troubleshooting errors that occurs one daily basis and resolving

problems quickly and efficiently and giving suggestions to developers

when they are required for tuning the code to maximize performance of

the database.

. Worked on Performance Tuning and Memory (SGA) Tuning by identifying

top Sqls/Sessions and Tuning.

. SQL tuning and Database performance tuning has been done based on

reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR,

ADDM and monitor the database performance on daily basis.

. Actively worked on performance tuning of instance (SGA and PGA) and

Physical database that included resolving fragmentation and disk

contention.

. Worked on Recovery Manager (RMAN), Unix Shell Script for backup to

disk/tapes, recovery, export/import, daily maintenance (Crontab).

Environment: ORACLE,SQL*Plus, OEL 10g/11g, Red Hat Linux 5.x, 6-Node RAC,

ERWIN,OEM 12c, IBM AIX 5.3,

Data Guard, Golden Gate, ASM, PL/SQL, RMAN, 20TB,

Shell Script, OEM GRID, SQL Developer.

Client: Aetna, Pittsburgh, PA Oct

'10 to June '12

Role: Senior Oracle DBA

Description:

Aetna is an American managed health care company, providing a range of

traditional and consumer directed health care insurance. Aetna is a member

of the Fortune 100.

Responsibilities:

. 24x7 Oracle Production Database Administration including Oracle

10g/11g RAC.

. Installed, configured and maintained Oracle Databases.

. Installed and configured OEM Grid Control to monitor all databases.

. Establishing standards, policies and procedures for Goldengate

replication administration.

. Responsible for installing and configuring GoldenGate 9.5 on Oracle

Servers

. Managing, troubleshooting and resolving oracle database, RAC and

applications issues.

. Involved in Upgrade/Migration of the oracle databases from Oracle 10g

to Oracle 11g and Sun Solaris to OEL (Oracle Enterprise Linux).

. Implementation of High Availability solutions with Oracle 10g RAC,

Physical and Logical Standby Databases (Data Guard) and Replication

using Golden Gate.

. Developed back-end logic for business applications, e.g. views,

procedures/functions/Packages,triggers.

. Developed scripts and reports using SQL, PL/SQL and Perl.

. Designed and implemented Oracle Real Application Clusters (RAC) on

Solaris with EMC Storage for an OLTP application with Transaction

Application Failover and high transaction volume.

. Established best practices and best procedures for database

administration. Responsible for Software life-cycle support to

include migration of all custom application changes through four

different instances to production.

. Standby Database (Data Guard) setup and configuring DB links.

. Responsible for Database Administration of Oracle RAC 10g/11g and non

RAC databases on ASM with size of databases varying from 20GB to 20TB.

. Monitored/managed 2 node RAC environments, databases

using OEM Grid control, and RMAN database backup and recovery.

. Migrated databases using cross platform transportable tablespace

feature and RMAN convert functionality to perform database conversion.

. Worked on agent related issues in OEM.

. Working alongside programmers and contributing to the development

process; Enabling and analyzing trace files

. Defining and Setting backup and recovery procedures.

. Performed and tuned using AWR, OEM Grid and tkprof

etc Oracle Databases.

. Tuning the database using statspack and custom scripts

. Responsible for continuous database monitoring and reorganization for

ensuring performance

. Tuning and balancing I/O by monitoring file system and tablespace I/O

statistics.

. Experienced in Tuning SQL statements using Explain Plan, SQL Trace,

TKPROF and STATSPACK

. Writing Shell Scripts for managing day-to-day activities and

automation of backup.

. Optimal Space utilization in tablespace by avoiding fragmentation.

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

. SQL and PL/SQL Programming.

. Installation and configuration of Oracle Client software and Tools.

. Analyzed the user requirements and designed partitioned tables for

improving performance of Data marts.

. Analyzed the user requirements and Designed views using STAR schema

for improving performance of Data marts.

. Performed partition maintenance and automated the process of creating

new partitions as and when required.

. Automated the process of analyzing tablespaces every night.

Environment: ORACLE, SQL*Plus, OEL 10g/11g, Red Hat Linux 4.x, RAC,

Solaris 10, IBM AIX 5.3,

Data Guard, Golden Gate, ASM, PL/SQL, RMAN, Toad,

OEM GRID, EMC, NetApp.

Client: Fidelity Investments, Durham,NC

Jul '08 - Sep '10

Role: Senior Oracle DBA

Description:

Fidelity Investments is an American multinational financial services

corporation. It is one of the largest mutual fund and financial services

groups in the world. It was founded in 1946 and serves North American

investors

Responsibilities:

. Installed and configured OEM Grid Control.

. Performed Oracle Database upgrades from 10.2.0.2 to 10.2.0.3 in AIX RAC

environment.

. Involved in Upgrade/Migration of the oracle databases from Oracle 9i to

Oracle 10g.

. Perform installation, maintenance, and troubleshooting and performance

administration of Oracle 11g under IBM z/OS 1.12.

. Performing Online and Offline database backups on schedule.

. Scripting (shell) of automated backup for Cold / Hot backups and also

defining and Setting backup and recovery procedures.

. Implementation and Configuration of OEM & Oracle Management Server for

maintenance and monitoring.

. Performing daily Archive log file backup and checking Alert Log files.

. Monitoring the table space growth and resizing the table space on 9i RAC

environment.

. Using RMAN & User Managed backup methods for better control.

. Implementation of High Availability solutions with Oracle 10g RAC,

Physical and Logical Standby Databases (Data Guard) and Replication using

Golden Gate.

. Generated and analyzed STATSPACK reports and monitored statistics for

performance tuning of the database.

. Review alert logs and dump files to check for any problems related to the

database/user.

. Installation and Maintenance of Shareplex Replication, Quest-Spotlight.

. Perform database cloning/exp/imp to setup identical databases in the

production and development environments.

. Upgrade/Migrated the production and development databases from 9i to 10g.

. Involved in Database sizing, Capacity Planning.

. Identify Top SQL that are consuming heavy resources and provide support

to the development team in identifying SQL queries that are consuming

high resources and to see if these queries can be fine tuned for better

performance.

. Presenting user-friendly reports, and providing training to end users on

reporting functions.

. Involved in monitoring the lock/block processes, releasing locks in case

of resource blockage and gathering statistics.

. Experience with Repository Manager to import Metadata for sources and

targets and the mapping designer to map source to the target.

. Maintained Microsoft SQL Database Server 2003.

. Net8 Configuration for Clients Connection.

. Creating ODBC for users & Application Developers.

. Co-ordination has been extended to Application developers for coding to

improve the performance of the database.

. Successfully refreshed and migrated databases between different UNIX

platforms by using database cloning, database duplicating, Transportable

Tablespaces, and Datapump facilities.

. Exported data's from all Units are imported at Central Office for

Management review about the Units.

. Automated the procedures and interface programs using Oracle Advanced

Queuing, Oracle Enterprise Manager.

. Created users and set permissions.

. Managed database security using groups, roles and handled number of

databases in different places.

. Created database objects and managed the permission access on the objects

with necessary security.

Environment: HP Integrity Superdome Sx2000 chipset, 32 processor, 10TB,

Solaris Fire 440, IBM z/OS 1.12,

SQL Developer,Oracle 9i/10g/11g, HP Integrity rx 8640, RHEL

AS 5, SQL * Plus, OEM, Erwin DM.

Client: Paychex, Rochester, NY

Apr '07 - Jun '08

Role: Oracle DBA

Description:

Paychex, Inc. is a recognized leader in the payroll, human resource, and

benefits outsourcing industry, with a steadfast commitment to success and a

record of achievement that continues a tradition of delivering excellence

Responsibilities:

. 24x7 Oracle Production Database Administration.

. Installation, Configuration, Upgrade, patching of Oracle RDBMS and

applications Work on IBM z/OS with OEM Grid control to maintain the

database effectively.

. Proactively monitoring the database.

. Implementation and configuration of OEM Grid, Oracle Management Server

for maintenance and monitoring data.

. Hot / Cold backups of the database through RMAN, Hot backups & BCV's

. Setup and configured Oracle Physical Standby database (Data Guard) for

disaster recovery as well as to offload the running of huge reports.

. Performed Cloning/Refresh to setup Test and Development database

. Generated and analyzed STATSPACK, AWR, ADDM reports and monitored

statistics for performance tuning of the database.

. Review alert logs and dump files to check for any problems related to

the database.

. Database cloning/exp/imp to setup identical databases in the

production and development environments.

. Worked on operating system command line utilities like SAR, TOP,

MPSTAT, VMSTAT

. Monitored performance and availability of the VIS application a high-

availability web-based application running Oracle9i RAC on HP-UX

cluster with EMC SAN.

. Create and maintain users, roles and privileges & Auditing Triggers.

. Upgrade/Migrated the production and development databases from 9i to

10g, 10g to 11g.

. Involved in discussions with the management regarding the

advantages/disadvantages and upgrade plans.

. Setup and configured 2 node Oracle 10g RAC with ASM.

. Maintaining, Building and optimizing Data Marts for efficient usage by

applications and users for such tasks as reporting.

. Responsible for setting and managing user accounts, Granting required

privileges to users.

. Involved in Database sizing, Capacity Planning.

. Perform Space Management & Troubleshooting the database issues.

. Identify Top SQL that are consuming heavy resources and provide

support to the development team in identifying SQL queries that are

consuming high resources and interact with the development team to see

if these queries can be fine tuned further.

. Actively involved in monitoring the lock processes, releasing locks in

case of resource blockage and gathering statistics.

.

Environment: Oracle 8i, Oracle 9i (9.0.1.2.0 & 9.2.0.4.0) 10g (10.2.0.1),

AIX 5.2, 5.3 RS6000, SQL*LOADER, Solaris

3500, Solaris 10k, Dell 5560 with Xeon Processors.

Client: BirlaSoft, Hyderabad, India

May'05 - Mar '07

Role: Oracle DBA

Description:

Birlasoft is a Global Information Technology Services provider with global

workforce of over 4000 employees. The company provides software and

consulting to the banking, financial service, insurance and manufacturing

industries. The project is Data Center Migration. I was responsible for

migrating Oracle databases to new Location

Responsibilities:

. Involved in a 7 member DBA team.

. Load data from OLTP systems into data warehouse databases.

. Installed and configured Oracle and Oracle Products on Linux and

Windows Environments.

. Monitored & tuned the performance of database and SQL statements

. Monitored for unusual conditions in database against contention,

load throughput and cache utilization.

. Performed database Logical backups using export, import and

Datapump.

. Performed database Recovery using physical, logical and RMAN

backups.

. Testing of Backup's and Documenting backup strategies. Created

scripts for automating online daily backup for databases and for

automating data loading from flat files.

. Monitored regularly whether primary and standby databases are in

synchronized and clearing the backed up archive log files after

confirming that they are applied on the standby database.

. Monitored the database objects growth, managing the extents growth

and de-fragmenting the objects, which are running out of maximum

extents. Monitoring the excessive fragmentation of table spaces and

taking remedial steps.

. Starting the reporting database using the standby database data

files and standby control file.

. Daily activities include monitoring batch application for

performance and space requirements and tuning the system to

optimize space and performance.

. Collecting the statistics using Explain Plan and TKPROF, studying

the report.txt during performance slowdowns. Collecting the

statistics of tables and indexes by analyzing for cost based

optimizer mode.

. Used SQL LOADER for dumping data into database from Legacy Systems

and Flat files.

. Used TOAD tool to access database and PL/SQL developer to create

PL/SQL Procedure.

. Shell scripting in Korn Shell for monitoring heartbeat of the

database, disk utilization and paging dba with errors in alert log

file.

. Worked with DW team for loading data to warehouse databases.

. Performed Table space Management and Rollback table space

Management.

. De-fragmentation of database objects

. Involved in migration of the databases in Oracle 8i from Windows to

Linux

. Monitor and tune Database, SQL statements performance using OEM,

STATSPACK, TKPROF, EXPLAIN PLAN.

. Cloned environments to create patch test, development and QA

environments

. Conducted multiple "dry runs" (test runs) to gather timings for

production upgrades.

. Applied High priority patches downloaded from Metalink.

. Other activities like applying RDBMS patches, security patches,

proactive monitoring of databases.

. Managing users by granting them privileges, roles and taken control

over full user's quota and maintenance.

. Worked on taking user and table level backup using user/table

levels exports and maintain the on data of each individual user.

. Checked the integrity of physical backup using DBVERIFY utility for

every backup performed.

. Periodically checking on Alert log file and Trace file for errors

and Manage,clean old log files before log destination get filled.

Environment: Oracle 8i/9i OEM, Linux, HP-UX, TOAD, Database

Tools/Utilities, STATSPACK, TKPROF, UTL_SMTP,

SQL*LOADER, Cronjob Oracle forms and reports 9i

Education:

Bachelor of Technology in Jawaharlal Nehru Technological University (JNTU),

India

Contact this candidate