oracle DBA

S REE I N FOTEC H L LC

AVINASH

Oracle Database Administrator

P HONE:972-***-**** Email:****@************.***

SUM MARY:

• Over 7 Years of experience as O racle Database Administrator. O racle 11g

R AC/10g RAC/9i/8i databases running on different environments such as Sun

Solaris, HP-UX, AIX, Red Hat Linux, and Windows .

• Proficient in Oracle Database Administration activities such as U pgrades,

M igrations, Patches, Cloning, Backup & Recovery, Performance Tuning,

capacity planning, shell scripting, and documentation.

• Extensive knowledge on database administration for O racle 8i, 9i, 10g & 11g w ith

experience within very large scale database environment and mission critical OLTP

and OLAP systems.

• Excellent experience in M igrating t he Databases.

• Implemented H igh availability using Golden Gate Replication . Implanted Bi-

directional replication using golden gate.

• Experience with D ata Modeling, Logical and Physical database design .

• Having hands on experience on working with Large OLTP databases like 5 Tb.

• Fulfilled DBA daily activities including user management (creating users,

synonyms, privileges, roles, quotas, table, index, sequence etc.), space

m anagement, and monitoring

• Experience in O LTP/DSS database systems, i mplementing and managing l arge

O racle databases (VLDB).

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

R AC, Oracle 10g RAC

• Experienced at using Oracle Enterprise Manager/Grid Control ( OEM/GR I D

C ONTROL)

• Performance monitoring and tuning with E XPLA I N PLAN, T KPROF,

STATSPACK, SQL TRACE, 10046 TRACE, AWR, ADD M.

• Successfully implemented physical S tandby database using O racle Data Guard

feature for High availability configuration.

• Experience in regular DBA activities such as U pgrades, Patches, T AR

support,Cloning,Backups and Recovery Manager, Performance Tuning,

C apacity Planning and documentation.

• Experience in F lash-Back Recovery, Data Pump, AWR, ASM, ASH and ADDM,

R ecycle Bin and Grid Monitoring.

• M igrated databases from Windows to Linux, Sun Solaris to AIX .

• Troubleshoot Database performance issues using Automated Workload Repository

(AWR) and Automatic Database Diagnostics Monitor (ADDM).

• Knowledge on Oracle Support processes for technical requests through M eta link.

• Planning and scheduling for the backup of database information using UN IX shell

script and C rontab jobs.

• Experienced in using O racle's T ransportable Table space (TTS) feature allows

users to quickly move a user Table space across Oracle databases.

• Strong knowledge and experience of managing Oracle8i, 9 i,10g and 11g RAC

environments using the O EM GridControl tools.

• Have extensive experience in performance and tuning of OLTP and Datawarehouse

applications.

• Data t ransferring with E xport, Import, Data Pump and SQL* Loader utilities.

• Database backup concepts and options such as user-managed backup, R MAN-

managed backupwith or without catalog, operating system backup, cold and hot

backup, f ull backup, incremental and cumulative backup .

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

• Refresh/Cloning of Database and applications for development and testing

p urpose.

• On call 24x7 Production Support Worked beyond regular hours .

• Dealing with database security and auditing.

• Have extensive knowledge Oracle Application Server Administration (web logic)

• Excellent communication, interpersonal and strong analytical skills, Documentation

& P roblem-solving skills with customer service oriented attitude. A very good team

p layer, self-motivated, dedicated in any work environment.

• Knows Perl scripting

• Worked As a DBA for Web Application Projects

K nowledge on Sybase working on the comprehensive set of database management software

technologies that provide the crucial foundation for the Unwired Enterprise and enable you

to manage and mobilize information from data centers to the point of action.

T ECHN ICAL SKILLS:

HP-UX 10.x, 11.x, Sun Solaris 8, 9, 10, AIX 5.1, 5.2,5.3,6.1,7.1 Red Hat

Operating

L inux 4.x, 5.x,6.x, MS Windows 98/2000/ME/NT/XP/Vista

Systems

SQL, PL/SQL, Unix Shell Scripting.

Programming

L anguages

Oracle 8i/9i/10g RAC/11g RAC

RDBMS

DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM,

Software’s,

C lusterware, SQL*PLUS, SQL* LOADER, EXP, I MP, Data Pump

A pplications

(expdp, impdp), TOAD, DB Art isan, SQL TRACE, EXPLAIN PLAN,

a nd Tools

T KPROF, STATSPACK, AWR and ADDM, SQL Developer, Golden

G ate

HTM L, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, MS Visio, Perl

Web Related

scripting

a nd Other

Tools

EDUCAT ION :

Bachelor of Technology.

P ROFESSIONAL EXPER IENCE:

AT&T, PLANO,TX. 09/2014 to Present

ROLE: Senior Oracle DBA

Responsibilities:

• Providing production support for 24X7 database availability for Oracle and SQL server

Databases.

• Maintenance and monitoring of oracle 11g R2/10g database instances hosted on L inux

a nd Sun platform.

• Upgrade and M igration of Databases from 10g R2 to 11g R2 and applying patches as per

requirement.

• D BA activities such as configuring Grid events, Regular Backup’s, Replication,

T uning, and t roubleshooting performance issues.

• Simulate a copy of production databases into test databases for application upgrade

testing.

• Support and advise the development teams on database related issues.

• Installed and Configured G OLDEN GATE E xtracts/replicate for multiple databases.

• Configured and built heartbeat monitoring in Golden Gate .

• Configured error handling for restart, logging, production support and status reporting

i n Golden Gate .

• Identified and produced documentation of best practices.

• Trouble shooting and performance tuning golden gate replications

• Space Management w hich includes table space creation, adding new data files.

• Managed Table spaces, Rollback Segments, Redo Logs and other database object.

• Oracle installation, creation of database, which includes physical and logical design.

• Assisted developers in creating stored Procedures, T r iggers, Functions, Cursors

a nd Packages.

• Involved in support for 1 TB 2 N ode production RAC database .

• Responsible for monitoring and resizing Oracle database objects (Table spaces, Tables,

I ndexes etc,

• Responsible for memory and Application tuning of the databases using Oracle utili ties

l ike O EM,SQL T race, TK Prof and Explain Plan.

• Parti tioning of large tables for fine tuning performance.

• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup

p lans.

• Taking periodic Backup of the Database and the software using R ecovery Manager

a nd VER ITAS.

• Generated regular Stats-Pack reports for the performance tuning of the databases.

• Experience with E xport and Import to migrate the database.

• Responsible for optimizing data access and performance by tuning indexes.

• Involved in root cause analysis, problem solving, issue t racking and support in

p roduction.

• Performed Replication of the Production database for setting up instances for the QA

and Testing teams.

• Hands on experience in wri ting U N IX Shell Scripts..

• Managed the existing databases by applying new required release modification to

existing database structure and applied new Oracle patches as required.

• Generated A utomatic Workload Repository (AWR) report to collect processes and

maintained performance statistics for problem detection & self tuning purposes.

• Generated A utomatic Database Diagnostic Monitor (ADD M) i n order to analyze

data in the Automatic Workload Repository (AWR) in order to identify potential

performance bottlenecks.

• Involved in analysis, design and development phases of the project.

• Worked with Business Analyst to collect and document business requirements.

Environment: ORACLE, SQL Server, SQL*Plus, Oracle 11g/10g, R ed Hat Linux 4.x,

R AC, Oracle E nterprise Manager, Data Guard, ASM, PL/SQL, R MAN, Toad for

O racle Expert 12.

Cit rix, Fort Lauderdale, FL 01/2013 –08/2014

Role: Sr. Oracle DBA

Responsibilities:

24x7 on-call production database support

Installation and Configurations of O racle 11g, 10g.

Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and

d isaster recovery/reporting purpose.

I nstallation, configuration, maintenance and tuning of Oracle 11g and 10g

databases.

Upgraded Oracle Database from 9 i to 10g, 10g to 11g.

Logical, p hysicaldata modeling, implementation and d atabase administration .

Migration of the database from Sun Solaris to I B M AIX, Windows to Linux.

Expertise in recovering the database. Performed complete and incomplete database

recovery.

Configured and maintained Grid Control Repository and Deployed O MS Agents on

d ifferent database servers.

Automated the nightly R MAN backups

Writing and modifying U N IX shell scripts, Perl scriptsto manage Oracle

environments and for Backend Oracle Processes.

Developed PL/SQL scripts for Extraction, Transporting & Transforming ( ETL ) data

f rom Production databases to Data Warehouse Databases.

Using the 11g Grid control, O EM for the database tasks like adding the data file,

resizing the data file, code compilation, User/Role creation and maintenance etc.

Experience in taking backups with R MAN i n both C atalog/ No catalog modes.

SQL tuning and D atabase performance tuning has been done based on reports

generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, A DDM and

monitor the database performance on daily basis.

Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking

Logical Backups (with Export/Import Data pump utilities).

RMAN I ncremental backups

Logical and Physical Database Design

Capacity Planning and bench marking

Partitioning of the tables for better performance and manageability

Creating & Managing Database Structures, Storage Allocations, Table/Index segments,

Rollback segments, Constraints, Database Access, Roles and Privileges.

Performance tuning of Queries by maintaining Aggregates, Compression,

partit ion, indexing and use of Hints, Stored outlines, Statistics for the same.

Performed policies on data confidentiality, integrity, availability, and auditabili ty,

Based on Access Controls for Access to Data at the database level.

Performed SQL and P L/SQL tuning, oracle contention and monitored production

database using automatic workload repository (AWR), automatic database diagnostic

monitor (ADDM) and automatic session history.

Cloning databases using scripts as well as RMAN.

Experienced in D atabase Security User Management, Privileges, Roles, Auditing,

P rofiling, Authentication.

Worked closely with the Oracle developers for the better performance in Applications in

w riting the Packages, Triggers, Mat Views and Indexes on the tables.

Experienced in documentation, provided documentation for database design,

analysis, modifications, creating schemas etc.

Enabled the audit on all the dev/test databases, analyzed and reported the audit

records about the suspicious activity in the database.

Strong Knowledge on wri ting Sql/DBA queries

Monitoring the database storage and day-to-day activities.

Have knowledge on RF Mobility and done website reports

Table partitioning for better performance.

Have good knowledge on Google Mapping ability to tie in graphical reports

Knowledge on Sybase working on the comprehensive set of database management

software technologies

Golden Gate i nstallation and configuration.

Replication using Golden Gate.

Environment: O racle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris,

H P-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer,

SQL*Loader, ERWIN, Data pump

CI T I Bank, I rving, TX 11/2011 – 12/2012

R ole: Oracle DBA

R esponsibilities:

24x7 on-call production database support

Installation and Configurations of O racle 11g, 10g.

Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and

d isaster recovery/reporting purpose.

Implemented D ata Guard for D isaster recovery.

Worked on Data Modeling, D imensional Data Modeling, S tar Join

SchemaModeling,Snow-Flake Modeling, FACT and Dimensions Tables.

Setup and configure S tandby database for high availability by using D ata Guard.

M igrated & upgraded databases from Oracle 10g to oracle 11g

Installed and implemented Golden gate to replicate data between databases.

Replication using Oracle Streams.

Documented i nstructionsfor migrating & upgrading databases.

Refreshed schemas f rom Production environment to Dev/Test environment using

exp/imp and expdp/impdp u tilities.

Experience working on Visual Studio 2012( IDE)

Wrote various shell scripts to automate tasks.

Creating P L/SQL procedures for E xtraction, T ransformation and L oading of data

Created schema ( tables, Indexes, views, sequences, synonyms, packages).

Setup database a uditing, granted privileges to users through system/object roles.

Implement and maintain database security.

Created d b link for inserting large tables directly without taking export.

Online index rebuilds

Created PL/SQL Procedures, Functions, T r iggers .

Taking Hot and cold backups.

Modified Data Using Perl Scripting

Creating and managing partitioned tables and indexes.

Monitor and tune database performance using STATSPACK, AWR, ADDM

Increasedperformance of sql queries by creating m aterialized views and by

enabling q uery re-w r ite.

Perform decommission of a d atabase operation

E nvironment: O racle 11g RAC, Oracle 10g RAC, HP-UX, RedHat Linux, Sun Solaris,

W indows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer,

SQL*Loader, ERWIN, Data Pump

Super Media, Dallas,TX 06/2010 – 10/2011

Role: Oracle DBA

R esponsibilities:

24x7 on-call production database support

Installation and Configurations of 9 i, 10g databases.

Installed Oracle 10g RAC, Standby Databases for high availability and

d isaster recovery/reporting purpose.

Organizing Oracle Database operations, installation, creation, configuration

of Databases, laying out database tables and database schema design, startup and

shutdown of Databases.

Load data into Oracle using SQL * Loader, RMAN backups, Export/Import

database objects/schema, Enforce database accuracy and integrity.

Creating users and roles for database and give the privileges.

Performance monitoring and tuning using Automatic Workload Repository

(AWR ) & Automatic Database Diagnostic Monitoring ( ADD M )

Automated the Replication process using Materialized Views for reporting

databases.

Using the A DD M t o analyze performance problem and with help of AWR

reports for individual SQL statements. Analyzing recent session activity with an

ASH report.

Responding immediately to any critical conditions, and proactively to any

developing conditions, including: locking, corruption, d isk spaces andPerformance

issues.

Cloning of production database to the test environment using Recovery

M anager (RMAN ).

Created Standby databases for D isaster Recovery, using D ata Guard.

Load data using SQL*Loader

Backup and Recovery

Created database objects like t ables, views, indexes, partit ions.

Develop, document and enforce database standards and procedures.

Setting O racle Streams for replication between two databases.

Environment: O racle 10g RAC, Oracle 9i, Sun Solaris, RedHat Linux, IBM AIX, HP-UX,

W indows, Shell Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer,

SQL*Loader, Data Pump

21st Century I nsurance, Florida 01/2009 – 05/2010

Role: Oracle DBA

R esponsibilities:

24x7 on-call production database support

Installation and Configurations of 9 i, 10g databases.

Installed Oracle 10g RAC, Standby Databases for high availability and disaster

recovery/reporting purpose.

Performed b ackup and r ecovery activities.

Daily database administration tasks including backup and recovery using R MAN,

I mport/Export .

Designed the d atabase schema and created any necessary database objects.

Applied p atches, upgraded databases

Worked on all phases of the project lifecycle including mapping data requirements,

data definitions and construction of logical data models.

Performance Tuning of Applications/Databases using various Oracle tools like SQL

T race, TKPROF, Explain Plan, AWR and ADDM .

Tuned memory structures such as the database buffer cache, shared pool and

l ibrary cache.

Assist application developers to meet their day to day requirements related to

performance.

E nvironment: O racle 10g RAC, Oracle 9i, IB M AIX, Windows, RedHat Linux, Shell

Scripts, ASM, RMAN, OEM/Grid Control, TOAD,SQL Developer, SQL* Loader, Data Pump

Andhra Bank, Hyderabad 10/2007 –

11/2008

Role: Oracle DBA

R esponsibilities:

Responsible for maintenance of production.

Created tables, views, materialized views

Database administration tasks included performing regular H ot & Cold Backups,

J ob Scheduling.

Managing Database Structure, Storage Allocation, Table/Index segments

Cloned databases from PRODUCTION to create TEST, DEVELOPMENT and UAT

Configured and managed OEM to stabilized oracle database into healthy

environment.

Monitoring Growth of tables and undertaking necessary re-organization of database

as and when required.

Trouble shooting performance issues using Explain Plan and TKPROF.

Involved in numerous Unix Korn Shell Scripting pertaining to the activities of the

D BA

Maintenance & modification of Shell Scripts.

Implemented Oracle's Advanced Features such as Partition table, Partition Index,

F unction Based Indexes and Loaded bulk data with SQL* Loader.

Develop, document and enforce database standards and procedures.

Generated scripts for daily maintenance activity like analyzing the tables/indexes,

and monitoring their growth.

Troubleshooting and fixing database listener issues.

E nvironment: O racle 10g, Oracle 9i, Oracle 8i, RedHat Linux, Sun Solaris, Windows, Shell

Scripts, RMAN, OEM/Grid Control, SQL*Loader, Data Pump

Contact this candidate