R OOP G ROVER

[acgeib@r.postjobfree.com]

O BJECTIVE

Seeking a challenging position in field of Database Administration and management where

extensive experience can be further developed and fully utilized.

H IGHLIGHTS

Possesses over 15 years of extensive experience in Oracle and Sql Server Database

Administration for mission critical enterprise applications with heavy transactions.

Hands-on experience on Oracle databases 11g/10g/9i/8i, Oracle 10g Real Application

Clusters (RAC), Data Guard, Oracle Golden Gate (Active–Active and Active-Passive) and

Ms SQL Server 2008/2005/2000 with Microsoft clustering on windows 2003.

Database administrative duties included installation, database upgrades, patching,

cloning, implementing backup/recovery (using Commvault, RMAN and Data Pump),shell

scripting, capacity planning, site failover/switchover, performance tuning, configuring data

replication.

Experience in Installing and Configuring Weblogic servers, Apache and Oracle Application

Servers. Set up Domains, Data sources for different application environments. Create

scripts to auto start and shut down using boot identity file for maintenance.

Worked on 24*7 Production environment, supported enterprise applications JDE, Siebel,

Oracle Content Server, PeopleSoft having multiple databases overall sizes between 1Gig to

2 Terabytes, which also included Standby Databases (using Data Guard) on Sun

Solaris/Linux/Windows. Configured Feed to Ware house database using Golden Gate,

Pl/Sql procedures and Materialized Views.

Installed, Configured and upgrade Oracle Enterprise Manager 10g Grid Control to 12c

cloud. Installed agents, created targets, set up credentials, scheduled jobs and configured

metrics and alerts.

Analyze and evaluate corporate-wide data requirements and implemented high

availability solutions using Data Guard, Golden Gate, Clustering, Mirroring and Log

Shipping. Identify and perform necessary system upgrades and patches.

Experience in developing, Troubleshooting and Customizing Web based and Client/Server

Applications and Apex applications for effective business solutions. Well versed in various

steps of SDLC Processes.

Understands production change control process and release management.

1

T ECHNICAL P ROFICIENCY

ERP Oracle Apps 11. 5. 9, Siebel 8.2, JDE, PeopleSoft, Oracle Content

Server

RDBMS Oracle 10gR2 RAC, Oracle 11g/10g/9i/8i/8, SQL Server

2008/2005/2000/7/6.5

GUI Oracle 11g/10g/9i/6i/6 DS (Designer 9i,Forms 9i,Reports 9i), Ms SQL

Reporting Services 2008/2005, Developer 6i, Apex

Application Server Oracle 10g/9i Application Server, Web Logic 8/10, Tomcat, Apache

Language VB 6, JAVA 2 (JDBC, Servlets) Java Script, VBScript, ASP, C, C++, Unix

Shell Scripting

Operating System Red Hat Linux 6/5/4, SOLARIS 2.10/2.9/2.8/2.7, Windows Server

2003/NT/2K

Tools VSS, SQL Developer, Toad, Oracle Enterprise Manager 11g/12c (Grid

Control),Oracle Golden Gate, Pentaho, Statspack, Logdump, AWR,

Data Pump, Sql Loader, Shell Scripting, SVN,SSIS,SSRS,SSAS

R ELEVANT E XPERIENCE

S R . D A TA BA SE A D M I NI S TR A T O R M A R 2 0 13 – P RE SE NT

YOU TECHNOLOGY, LLC ( A DIVISION OF THE KROGER)

Install, Configure, Clone and Patch Oracle Database Servers for production and non-

production environments on Linux servers on Amazon Cloud.

Create DR site, set up real time data replication using Golden Gate and Data guard to

minimize downtime. Also configured data replication using Pl/SQL for warehouse system .

Setup Enterprise Manager 12c to monitor systems, register targets, schedule

maintenance jobs, define metrics and alert events.

Greatly improved performance by updating stats, identifying and reorganizing indexes and

rewriting queries. Used explain plan and hints to enhance performance of Sql queries.

Created shell and Pl/Sql scripts for automation of repetitive processes to minimize errors.

Manage database security and resources.

Implemented database backups and retention policies. Test backup strategies regularly.

Created database structures with partitioning, created partitions on big tables for better

performance in warehouse database.

Troubleshoot remedy tickets. Provide 24*7 database support.

Perform root cause analysis on failure. Work with other teams to resolve application and

database related issues.

Refresh non production environments when needed.

Upgraded database to 11g with almost zero downtime using Golden Gate.

2

S R . D A TA BA SE A D M I NI S TR A T O R M A R 2 009 – M A R 2 013

B C H O U S I N G, C A NADA

Installing, Configuring and Patching Oracle and SQL Database Servers, Application Servers

and Reporting Servers (SSRS)for production, staging/test and development environments.

Administrating over 130 databases (Oracle and SQL Server). Administrative duties

included designing and implementing high availability solutions and strategy for Backups

and Recovery as per SLA, upgrade and patch databases, managing databases Security,

Auditing, space, memory and performing other maintenance tasks.

Providing database support for Enterprise Applications like Siebel, JDE and Oracle Content

Server and In-house developed applications. Upgrading and Migrating Oracle and SQL

databases and Implement the necessary critical and security/CPU patches and service

packs.

Set up web servers, IIS. Installed and configured Weblogic server, Apache and Oracle

Application Server. Set up domains, Data Sources, Connection Pool for different

application environments. Create shell,SQL scripts and SSIS packages to schedule

maintenance tasks.

Configuring Oracle 10g/11g Physical standby databases using data guard broker. Setting

up replication to remote site using db links, database mirroring and Log Shipping to

achieve high availability and minimal downtime. Perform annually Disaster Recovery

Tests.

Installing and configuring Oracle Enterprise Manager 10g Grid Control and Upgrading to

12c cloud control. Maintain Grid Control targets, setting up credentials, blackouts, user

defined metrics, jobs. Configuring User defined alerts and setting metric thresholds using

Grid Control

Migrating databases from sql server to Oracle.

Refreshing non prod environments for releases, deployments, development, testing and

troubleshooting purposes using data pump export/import, RMAN cloning and T-Sql

scripts.

Working closely with development team to perform checks and tuning Oracle database

servers and applications. Executing ASH/AWR and SQL Server Profiler reports for

performance and database tuning. Partition large tables for performance gain, redefine

table structure to have partitioning key, develop scripts to maintain partitions.

Configured RMAN catalog, backups and scripts using Grid Control and CommVault. Backup

destination disk, tape and Data domain device.

Encrypt and Audit finance related data and other sensitive data on non prod databases

using Grid Control and stored procedures.

Installed and Upgrade Apex to 4.1. Setup workspaces and security. Deploy apex

applications.

Rendering 24*7 on call Production database support

3

S R . D A TA BA SE A D M I NI S TR A T O R F E B 2 005 – F E B 2 009

P R O V I N C I A L H E A L T H S E R V I C E S A U T H O R I T Y ( PHSA),CANAD A

Installing, Configuring and Patching Standalone and Clustered Database Servers,

Application Servers, SharePoint and Reporting Servers (Oracle and SQL Server) for

production, staging/test and development environments.

Administrating over 650 databases. Administrative duties included devise strategy for

Backups and Recovery as per SLA, Administering Database Security, and Maintenance of

databases.

Upgrading and Migrating Oracle and SQL databases and Implement the necessary critical

and security patches. Upgrading Oracle databases from 8i to 9iR2/10gR2 and SQL

databases from 2000 to 2008 using wizards and manually.

Working closely with development team to perform checks and tuning Oracle database

servers and applications.

Configured RMAN, Hot and Cold backup scripts for daily/weekly and archive log backups

for SOX and Non Sox databases. Generating monthly Sox backups and audit reports and

creating remedy sox tickets

Configuring SQL Cluster for critical applications using Microsoft Clustering. Replicating

databases to remote sites and databases using Log shipping. Maintained 2-4 node

clusters. Add/Remove nodes for maintenance operations.

Refreshing databases for development and Testing using Scripts, database links and

export/import.

Creating and modifying SSIS, DTS packages, shell and windows scripts to automate the

tasks like refreshing databases or schemas or loading data from external sources.

Installed and Configured Application Server. Deploy applications build using

Forms/Reports and Java.

Migrating Application from Client/Server based to Web based architecture using Oracle

developer forms and reports and Oracle Application Server 10g

Installed Oracle 10g RAC, configured, Add/Remove node during database maintenance.

Rendering 24*7 on call Production database support

D BA/D E V E L O P M E NT E N GI NE E R J A N 2 004 – O C T 2 004

C O N A X A C C E S S S Y S T E M ( P ) L T D ., I N D I A

Migrated Oracle Designer Repository from 2.1.2 to 9i. Migrated Subscriber Management

System from Forms 4.5 to Oracle Forms 9i and implemented at T elnor, Norway and CNBC,

Mumbai

Upgraded Oracle database from 8i to 9i and Application Server from 9i to 10g.

Defining and enforcing database standards, policies, guidelines, and documentation

4

Implemented security of data at forms level and database level by creating users, roles,

triggers, constraints

Scheduled process to load data from external sources to warehouse database

Identifying database performance issues & implementing solutions

Refresh test/Staging environments from production databases.

Performing online and offline backups and recovering the database when required using

RMAN or third party tools

Developed new modules of the application for new functionalities as per client requests.

D ATABASE D EVELOPER N OV 2 003 – J A N 2 004

CHANDIGARH INFOTECH CENTRE, INDIA

Designed and developed production, development and test databases.

Created database schemas and back-end coding (i.e. packages, procedures, triggers)

Replicated OLTP databases to Reporting databases using export/import and DTS packages

Performing database backups and Tuning application code and SQL queries.

Implementing security of the database

S O F TW A RE D E V E L O P E R J A N 2 002 – N OV 2 003

S O F T W AR E A S S O C I A T E S, I N D I A

Conferred with personnel of organizational units involved in order to analyze current

operational procedures

Converted data from project specifications and statements of problems in order to create

and modify application code

Developed and implemented Inventory system, Payroll system to Vallabh Fabrics, India

Planned and prepared technical reports and instructional manuals as documentation of

program development.

Prepared time and cost estimates for completing projects.

E DUCA TION

Masters in Computer Science, India

Bachelor of Science, India

Post Graduate Diploma in Computer Applications

Diploma in Information System Management

C ERTIFICATIONS /COURSES

5

Oracle Golden Gate -2013

Sql Server – High Availability Solutions - 2012

Oracle 11g Database Administration - 2011

Oracle 10g Database Administration -2009

MS SQL Reporting Services 2005 -2008

Oracle Apps (11i) System Administration -2007

Oracle Apps (11i) Installation and Patching -2007

Oracle 10g Real Application Clusters -2006

Oracle 10g Application Server Administration -2005

Oracle Designer 9iDS -2004

Oracle 8i and 9i Database Administration Certification -2003

Oracle 8 Database Administration Certification -2001

Advance Java, ASP Web Development Tools -2000

Oracle 8i with Developer 6i -2000

6

Contact this candidate