Oracle DBA

[pic]

Shailendra Sinha

********@*****.***

Contact: 614-***-****(M)

Summary:

Over 13 years of database administration/architecture/modeling/development

and database performance tuning in heterogeneous system environment

including Solaris, Linux, and Windows, supporting a variety of mission

critical applications in communcation, consumer packaging goods,

manufacturing, leasing & educational services etc.

Oracle certified Professional with extensive experience with Oracle

database administration including Real Application Clusters(RAC), Data

Guard 10g/11g with MAA, Active Data Guard 11g, Stream replication(one/two

way), installation, configuration, apply patches, migration, sizing and

space management, backup and recovery(RMAN), performance tuning,

troubleshooting etc.

Solid experience in the database designing, data modeling utilizing ERWIN,

SQL Developer Modeler, Oracle Designer & Warehouse Builder etc for both

very large transactional and decision support database environments.

PL/SQL back-end programming - database triggers, packages, stored

procedures, functions, PL/SQL libraries and object oriented property

classes.

Solid experience in managing/supporting very large database.

Employed Oracle Enterprise Management Grid Control in 10g/11g/12C with

standard management, diagnostic, tuning, and change management packs to

perform various administrative tasks. Setup and configured Oracle Streams,

Oracle Business Warehouse ETL, Oracle Management Server to monitoring

database operation etc.

Possesses good skills administering Oracle EBS 11i/R12, OBIEE, WebLogic &

Fusion MW, Oracle Application Express(APEX).

Possesses good skills in administering MS SQL Server, DB2 and Oracle 12c

databases.

Possesses very good skills in various administrative tools using bash

shell, korn shell(ksh) and Perl

Excellent communication, analytical, interpersonal, presentation and

problem solving skills

Education:

Master degree in Statistics

Post Graduate Diploma in Computer Programming & System Analysis

Technical Skills

RDBMS/Middlewa Oracle DB 12c/11g/10g/9i/8i/8/7, SQL Server, DB2,

re Oracle Fusion MW, WebLogic Server, Oracle Application

Servers, EBS 11i/R12, OBIEE, ODI

Utilities/Tool OEM/OMS, SQL Developer Modeler, ERWIN, Warehouse

s Builder, RAC, ADDM, AWR,ASH, ASM, Data Guard,

Log-Miner, TKPROF, STATS-Pack, SQL*Loader, Data Pump,

Export/Import, RMAN, TOAD

Operating Sun's Solaris, Linux, MS DOS, Windows 2003/2008 Server

System

Language SQL*Plus, PL/SQL, Transact SQL, HTML, Perl, Shell

Scripting (Korn, Bourne, Bash)

Professional Experience

1 Database Administrator -

Period: May 2013 - Present

West Corporation 21st Century Communications, Columbus, OH

Twenty First Century Communications (TFCC) is a technology company that

helps utilities quickly receive and send high volumes of information to the

right people, at the right time, using any communication device.

West Corporation: On February 2011, TFCC was acquired by West Corporation,

a leading provider of technology-driven, voice and data solutions.

Responsibilities:

Configured and maintained Oracle online and warehouse databases 10g/11g

Forward modeling/reverse engineering to manage/change schema in Test and

Production using SQL Developer Modeler.

Communicating closely with object and user-interface teams as well as all

pertinent business experts.

Performed data warehouse query and ETL tuning by using various tools such

as Oracle Enterprise Manager Grid Control/DB Console/DB Express(11g/12C)-

AWR, ADDM, ASH, Tuning Advisor, explain plan, TKPROF with SQL trace etc..

and improved the performance over 500% within 3 months.

Provided on-call support, trouble shooting and resolving production-related

database problems, replication, Data Guard etc.. during work hours and off-

hours.

Trouble shooting and resolving any database and/or application issues or

errors that occurred

Managed maintenance plan activities including backups, indexing,

partitioning, integrity and consistency checks.

Environment: Oracle 10g/11g, 11g Replication/Stream, 11g Active Data Guard,

Sql Developer Modeler, ERWIN, Oracle Fusion MW, WebLogic server, Oracle

Data Integrator(ODI), OBIEE, APEX, RMAN, Data Pump, Linux, AIX, Solaris,

SAN, RAID etc.

Database Administrator -

Period: Sept 2008 - May2013

Lourdes University, Sylvania, OH

Lourdes University is grounded in the Franciscan values of learning,

reverence and service, and is known for its quality academic programs. The

university is classified as a Master's college and University by the

Carnegie Classification of of Institutions of Higher Education.

Responsibilities:

Installed, configured and maintained Oracle online databases 11g/10g with 2

nodes RAC, Oracle Data Guard 10/11g with MAA, single instance Business

Warehouse Databases 11g & upgraded Oracle 10g to 11g.

Installed, Configured and Maintained MS SQL Server 2008/2012.

Provided all kinds of Data Modeling, SQL and PL/SQL developent and DBA

support to development teams as well as production support to various

applications.

Trouble shooting and resolving any database and/or application issues or

errors that occurred

Performed database tuning by using various tools such as Oracle Enterprise

Manager Grid Control, SQL Tuning Advisor, ADDM, explain plan, TKPROF with

SQL trace etc.

Monitored the various database activities incl. Daily jobs by developing

Power shell & Linux Bash Shell scripts, Perl and other various tools.

Patched Oracle Database Server 10g and 11g using Oracle patch.

Established database backup/recovery strategy for different databases using

RMAN & OS level

Setup and support of Oracle replication(replication and conflict solution)

Modified database design using ERWIN followed by database other changes

including table-spaces, triggers, stored procedures as well as

configuration and storage allocation to support application enhancement.

Provided on-call support regarding production-related database problems

Worked with IT managers and application developers to ensure the database

integrity, high availability and security

Environment: Oracle 10g/11g RAC, MS SQL Server, MySQL, Oracle Fusion MW,

WebLogic server, Oracle ERP(EBS 11i/r12), APEX, SQL*Plus, PL/SQL,

SQL*Loader, SQL Developer Modeler, ERWIN, Warehouse Builder, Linux, Windows

etc.

2 Database Administrator -

Period: July 2003 - Sept 2008

Nielsen Co., Lancaster, PA

Nielsen Consumer Panel Solutions (CPS) is innovative, successful and growth-

oriented marketing information and consulting services company. CPS's

products and services enable consumer-packaged goods and service companies

to segment and finely target high volume potential households. Such

regional and micro-marketing campaigns provide significant spending

efficiencies and increased profitability for consumer goods and service

companies.

Responsibilities:

Designed and built Oracle database system using ERWIN/ Oracle Designer.

Maintained and did quick changes using ERWIN's reverse engineering.

Installed, configured and maintained Oracle database 10g, & upgraded Oracle

8i to 9i &9i to 10g.

Provided all kinds of logical/physical modeling and DBA support to

development teams as well as production support to various applications.

Created and maintained different database entities included tables,

schemas, table-spaces, data files, redo log files, rollback segments and

renaming/relocating of data files on servers.

Trouble shooting and resolving any database and/or application issues or

errors that occurred

Performed database tuning by using various tools, like Oracle Enterprise

Manager and ADDM/STATSPACK

Monitored the various database activities by developing shell scripts and

using various tools.

SQL Tuning using explain plan, TKPROF with SQL trace and SQL Tuning

Advisor.

Patched Oracle Database Server 9i and 10g using Oracle patch.

Established database backup/recovery strategy for different databases

Applied different recovery procedures for complete and incomplete

recoveries depending on the type of failure.

Setup and support of Oracle one way Stream replication(replication and

conflict solution)

Modified database structures including table-spaces, tables, views,

triggers, stored procedures as well as configuration and storage allocation

to support application enhancement.

Developed scripts to monitor the storage usage, object status for daily job

Provided on-call support regarding production-related database problems

Worked with IT managers and application developers to ensure the database

integrity, high availability and security

Environment: Oracle 8i/9i/10g, SQL*Plus, PL/SQL, ERWIN, Oracle's Designer,

SQL*Loader, SQL Server, AQT, SAS, MS Outlook, Solaris, Hummingbird etc.

Database Engineer:

Period: Apr 2002 - Jul 2003

Interpool Inc., Princeton, NJ, USA

Responsibilities:

Installed, upgraded and patched Oracle software. Setup brand new

machines including Oracle software installation, Oracle side

configuration, third party backup software

Developed Oracle procedures/functions/views using SQL and PL/SQL

Developed Oracle Forms/Menus/Reports.

Developed or modified some Oracle backup and recovery scripts. Used

Oracle backup utility RMAN to implement Oracle backup and performed a

number of times of disaster recovery.

Performed database tuning using Explain Plan, Toad, Oracle Enterprise

Manager

Trouble shooting and resolving any database and/or application issues

or errors that occurred

Environment: Oracle 7/8i, SQL*Plus, PL/SQL, Oracle Forms/Reports,

ERWIN, Windows, Unix

Oracle DBA:

Period: Jan 2002 - Mar2002

HTN Solutions Group, Hitech Network Inc., Toronto

Responsibilities:

Involved in Database high availability planning and deployment

Involved in Database/System tuning

Involved in the Design, creation and administration of the production,

development databases

Involved in documenting the environments and processes

Involved in Development support and SQL Tuning

Responsible for refreshing Stage databases with production data

Implemented backup strategy using RMAN

Environment: Oracle 9i, SQL Server2000, Windows, Solaris, SQL, PL/SQL

Data/Database Analyst

Period: Nov 1985-Dec 2001

Statistical Services, TATA Enterprise, India

Responsibilities:

Analyzed and resolved issues related to the Oracle Database Performance,

Physical problems after the initial month of data gathering

Used Oracle's designer tool to design a new database combining existing

databases from Access, Arc/Info, and paper documents. This involved going

through the database modeling and creation process; creating an Entity

Relationship Diagram of the database model, creating and running the DDL

(data definition language) to build the database on a UNIX server, writing

business rules for data input, and running quality assurance reports on the

data structure.

Defined the oracle objects enabling the applications meet the business

requirements

Tuned Oracle databases Logical objects (Tables, Views) and application SQL

code as needed.

Environment: Oracle 7/8/8i, SQL*Plus, SAS, SPSS, TSO/ISPF, JCL, VSAM, QMF,

DB2, MVS/OS390

Professional Development/Training:

Oracle Database Admin, Backup & Recovery, Performance Tuning, Network Admin

at Oracle Education

Oracle WebLogic configuration and Management from Oracle Education

Unix/Linux Systems Administration at Toronto, Canada.

References Available on

Request

Contact this candidate