Manager Oracle

Spandana D

EMail:****.*@*******.***

Sr.Oracle DBA

Contact: 972-***-**** EXT 101

Summary

. Around 7+ years of experience in the IT industry involving Production

Database Administration.

. Oracle Database Administration experience in variety of different

environments like HP-UX, SUN SOLARIS, AIX, RedHat Linux and Windows.

. Proficient in database administration, production support, installation,

configuration, upgrades, patches, performance tuning, backup and

recovery, cloning, space management, database security, auditing,

troubleshooting, database design, TAR support, Unix shell scripting and

documentation.

. Migrating and Upgrading the Databases in different environments and

versions.

. Experience on high volume databases with sizes varying from 100GB to

20TBs of data.

. Experienced in installing and setting up Oracle 12c, 11g R1/R2, 10g, 9i,

8i databases.

. Experience in Administration, Security, Provisioning, Consolidation,

Development, Staging, Validation, QA and Production database

environments.

. Experienced in Installation of high availability RAC environment (2, 3

and 4 node clusters) and upgraded standalone databases to 10g/11g RAC

environment.

. Experience in Configuring Single instance, Oracle Real Application

Clusters(RAC) and Automatic Storage Management(ASM).

. Experienced in day-to-day DBA activities including schema management,

user management, space management, monitoring, scheduling jobs, UNIX

Shell Scripting.

. Experience in Performance tuning of oracle databases using Oracle Grid

Control, STATSPACK, and tuning of SQL scripts using SQL Trace and TKProf.

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

cold backup options for both RAC and standalone instances.

. Experience in using GoldenGate to support data replication, replication

monitoring, tuning and capacity planning in oracle database environment.

. Administered Oracle GoldenGate 11g application for real time

transactional change data capture, transformation, and delivery, offering

log-based bidirectional data replication.

. Experience in installing and configuring GoldenGate and in moving large

volumes of transactional data, with minimal impact to online systems.

. Excellent experience in various migration techniques like export/import,

Datapump, backup restore, cloning, and dataguard.

. Proficient in setting up Standby Database supported by ORACLE DATAGUARD

for disaster recovery purpose.

. Configured database 10g, 11g for ORACLE FLASHBACK TECHNOLOGY.

. Managed Materialized Views for data replication purpose.

. Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic

Workload Repository) for analyzing the database performance and tuning.

. Creation and maintenance of database Standard Operating Procedures

(SOP's).

. Experience with OLTP and batch processing in a large data processing

environment.

. Migrated single instance databases to multimode 10g/11g RAC environment

for high availability and load balancing.

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

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

Data modeling, Logical and Physical database design.

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

and PRIVILEGES, OEM Grid Monitoring.

. Solved many Network related problems in a database using Oracle Net

Configuration Assistant (NETCA), Oracle Net Manager, Net stat and ping

utility, providing Oracle Networking Solutions (tnsnames.ora,

sqlnet.ora).

. Strong experience in providing 24/7 support for corporate databases,

timely resolution of tickets, and on-call rotation.

. A self-motivated, responsible and reliable team player with a set of

strong technical skills.

. Excellent analytical, interpersonal and communication skills.

. Enthusiasm in learning new technologies.

Technical Skills

Languages : SQL, T-SQL, PL/SQL, C, C++, UNIX Shell Scripting,

Perl, XML, HTML.

Databases : Oracle 12c/11g/10g/9i, MS-SQL Server 2000/2005/2008, MS

Access.

Networking : ISO 8583, TCP/IP, UDP, SCI, PCI, NFS, DHCP, LAN

Platforms : HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 5.8, 8, 9, 10,

AIX 5.1, 5.2, 5.3,5.4,

Linux RHEL 2.1, 3.x, 4.x, MS SQL Server 2000 & 2005,Windows

NT,XP

DBA tools : SQL*Loader, SQL*Plus, Toad,

EXP/IMP,EXPDP/IMPDP,OEM, UML,

RMAN,GoldenGate, Tkprof,DBCA, DBUA, CORBA

Education

Bachelor of Technology from JNTU, Hyderabad, India.

Professional Experience

Century Link, Columbus, OH

Oct'2012- TILL DATE

(Sr.Oracle DBA)

(Oracle10g/11gR1/11gR2/12c/RAC/ASM/GOLDENGATE/DATAGUARD/RMAN/OEM/Upgrade/

Migration)

Responsibilities:

. Planning, Implementing and Validating various versions of Oracle

Databases to 10g Release 2(10.2.0.1, 10.2.0.2 and 10.2.0.4)& 11g

Release 2(11.2.0.2,11.2.0.3) upgrades on all the environments (Dev,

Test, Stage and Production) also Planning of back out procedures like

downgrades/building parallel environments and also working on proof of

concept for Oracle 11gR2 upgrades.

. Implemented Oracle Patches (CPU, PSU) on the Compliance databases

Device a plan to patch them quarterly so that we can cover all the

databases in a year.

. Checking Databases Backup and Restore validity periodically, and Data

refreshes from Production to Non-Production environment, Creation

Duplicate Databases using RMAN Backups.

. Responsible for installing, supporting the oracle standalone,

RAC(2node) and RAC(2node) with dataguard databases of the version 11g,

10g and 9i on Sun Solaris 10, RHEL 5.5, AIX 5.3 and Windows 2008.

. Used Vertias Cluster File System (VCFS), ASM file system and SCAN

LISTENER in installing Oracle 11g RAC and also installed oracle grid

agents on standalone and RAC databases.

. Worked with maintaining the OCR and VOTING DISK in normal and external

redundancies and also worked with cluster ready services (CRS) and

used CRSCTL for maintaining CRS.

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

PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2.

Installed and configured Oracle GoldenGate on Oracle 10g.

. Implemented GoldenGate for data recovery and data migration for Oracle

11gR1 RAC 2 nodes on IBM AIX and debugging GoldenGate issues such as

extract or replicate rebuild and abend.

. Worked on installing the data guard on RAC databases for disaster

recovery and setup the dataguard broker. Tested the dataguard

switchover on the RAC databases manually and also using dataguard

broker.

. Worked on setting up the flashback and restore point on the databases

and also flashbacked the databases to restore point when required.

. Worked with different utilities like dataguard broker DGMGRL, SRVCTL,

CRSCTL and CLUVFY.

. Implemented and administered Oracle GoldenGate (v10) for Database

Replication between production and reporting node.

. Performed Initial load, extract, replica, trial files and exporting

data onto Repository Database using GoldenGate tool.

. Responsible for upgrading GoldenGate 9.5 to Golden Gate 10.0.

. Database Maintenance, Data warehousing. Data Modeling using Erwin.

. Worked on installing CPU patches manually and also using enterprise

manager grid control. Worked on installing the Rollover patches for

RAC databases.

. Worked on refreshing the tables, schemas using exp & imp and also

using expdp & impdp. Refreshed the databases from PROD to UAT, QA, and

DEV using RMAN.

. Performance tuning of oracle databases using Sql Access Advisor, Sql

Performance Analyzer, sql Tuning Advisor.

. Worked on DR tests using dataguard and VVR, resolved the issues during

switch over and switch back.

. Migrated the databases from 9i and 10g to 11g from Solaris 10 to RHEL

5.5.

. Upgraded the databases from 9i and 10g to 11g and resolving the issues

during upgrade.

. Created the dblinks (private and public), synonyms (private and

public) and views. Validated the views and compiled the views which

are invalid.

. Have used different tools like TOAD (10.6), DBArtisan (8.7.2),

EXPLAIN PLAN, AWR, ADDM, TKprof, STATSPACK, Oracle enterprise

manager (GRID CONTROL) 11g to solve the performance issues.

. Helped developer in installing Oracle Client, troubleshoot and

establish the connection to Oracle database through JDBC.

. Responsible for monitoring the daily jobs and resolving and finding

reasons for failed jobs.

. Perform production system problem analysis and recommend corrective

measures in a timely manner.

. Responsible for creating the sizing documents for databases as per

storage provided by application team. Documented all the necessary

work for future reference.

Environment: Oracle 10.2.0.4, 11.1.0.6, 11.2.0.2, 12.1, IBM Maximo,

Windows 2008, RHEL 5.5, Sun Solaris 10, AIX 5.3, JIRA Ticketing system,

OEM 11g/12c grid, SQL*Loader, Windows XP, LINUX, TOAD, SQL Developer.

Covidien, Mansfield, MA

Aug'2011- Sep'2012

Sr.Oracle DBA,

(Oracle 8i/9i/10g RAC/ASM/ GOLDENGATE/DATAGUARD/RMAN/SQLTuning/

Upgrade/Migration/Space Estimation/24*7 support)

Responsibilities:

. Worked on Oracle Databases 10g Release 2(10.2.0.1, 10.2.0.2 and

10.2.0.4)& 11g Release 1(11.1.0.6,11.1.0.7) and upgrades on all the

environments.

. Performance Tuning for Optimized results using Explain-Plan, SQL-

Trace, STATS PACK Reports and AWR Reports.

. Production Support for Critical Application Databases, work closely

with Application Team in identifying issues and provide solutions for

various issues.

. Implemented Oracle Patches (CPU, PSU) on the Compliance databases

Device a plan to patch them quarterly so that we can cover all the

databases in a year.

. Checking Databases Backup and Restore validity periodically, and Data

refreshes from Production to Non-Production environment, Creation

Duplicate Databases using RMAN Backups.

. GoldenGate installation, configuration for replication.

. Helped in Performing GoldenGate replication monitoring, tuning, and

capacity planning.

. Have set up the cronjobs for runalert, spacewatch monitoring, RMAN

backup (level_0 and level_1) and recovery, archive log purge, deletion

of archive logs and AWR reports on AIX-5.3.

. Used normal import and export and also datapump import and export

for exporting and importing schemas, tables etc from one database to

another.

. Responsible for tuning the database performance issues like query

tuning and memory tuning (SGA tuning) and also partitioned the

tables and indexes for better performance.

. Have used different tools like TOAD (10.1), EXPLAIN PLAN, AWR, ADDM

Oracle enterprise manager (GRID CONTROL) 10.2.0.4 to solve the

performance issues.

. Kept tracking the database performance using oracle enterprise

manager and checking the users sessions which consuming more CPU and

taken the necessary steps to reduce the CPU usage.

. Created new schemas, tables, indexes, jobs, tablespaces and granting

the previleges to the user as per demand and also written pl/sql

code to delete million rows by committing after every 10,000 rows.

. Installed the oracle dataguard on 11g (physical standby database) on

IBM-AIX-5.3for high availability, disaster recovery and used

dataguard broker for switchover and failover using utility DGMGRL.

. Performance tuning of corporate databases, using tools like sql

trace, tkprof, AWR, ADDM, SQL Tuning.

. Worked on Automatic Storage Management (ASM) for managing data in

SAN. Worked with ASMCMD utility for monitoring the ASM and

experienced in ASM like adding new disks, creating new disk groups

and configuring these disk groups into ASM on AIX-5.3.

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD(10.1), Recovery

Manager (RMAN), Tivoli, Oracle Enterprise Manager (OEM), SQL*Loader,

TKPROF, Data Guard, Shell Scripts, Golden Gate, AWR, ADDM, HTML, DHTML,

Windows 2008, RHEL 4.0, AIX-5.3, JAVA.

PNC Bank, Pittsburgh, PA

Jan'2010 - July'2011

Sr.Oracle DBA

(Oracle8i/9i/10g/11g/RAC/ASM/DATAGUARD/RMAN/SQLTuning/Upgrade/Migration/Spac

e Estimation/24*7 support)

Responsibilities:

. Involved in 24x7 Oracle Production Database Administration.

. Upgraded the databases from Oracle 10.2.0.4 to 11.2 and implemented

the dataguard on 11g databases. Installed the RAC on 10g and 11g

databases.

. Worked with maintaining the OCR and VOTING DISK in normal and external

redundancies and also worked with cluster ready services (CRS) and

used CRSCTL for maintaining CRS.

. Supported the databases with frontend Siebel and Java applications.

. Responsible for creating the disk groups and adding the diskgroups for

datafiles in ASM for RAC environment which resides on SAN storage.

. Setting and troubleshooting of oracle listener, network connection,

user security and administration. Tuning for optimum performance like

SQL tuning.

. Responsible for user management like creating users, creating roles,

granting roles and privileges and creating profiles and granting them

as per need.

. Worked on import/export, import/export Data Pump and SQL- loader and

also worked with RMAN backup and recovery

. Experience in SQL, PL/SQL, Shell Scripting, Partitioning, Data

modelling, OLAP, Logical and Physical Database Design, Backup and

Recovery procedures.

. Design, document, implement, and maintain all backup, recovery

including disaster recovery procedures.

. Implemented database replication using shareplex.

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

Standby Database Data Guard, Replication.

. Created physical standby database (for disaster recovery) from hot

backup of primary database.

. Write monitoring/health check scripts to alert team of database

uptime/downtime status, sizing issues, which ensured availability

99.98% of the time.

. Creating Tables, indexes, & triggers to assist developers.

. Managing, troubleshooting and resolving oracle database, RAC and

applications issues.

. Refresh/Cloning of Database and applications for development and

testing purpose.

. Expertise in Replication of Oracle Databases using Logical Standby and

Streams and Shareplex.

. Upgraded Shareplex from 5.0 to 5.3.2.

. Performing Backup/Recovery of all the Oracle databases using RMAN.

. Scripts for Health Check of Databases.

. Expert scripting experience in Perl and all UNIX shell scripting

variations.

. Reading Alert Logs and User trace Files and Diagnosing the Problem.

. Providing Solutions to the Problems Faced by end Users or Programmers.

. OS level activities like space monitoring of Mount points.

. Scripts for Analyzing of Tables and Rebuilding of Indexes.

. Taking periodic backup of the database and the software.

. Automation of Backups.

Environment: Oracle 11g/10g, SQL, PL/SQL, Erwin, TOAD, Recovery Manager

(RMAN), Oracle Enterprise Manager (OEM), SQL*Loader, STATSPACK Data Guard,

Shell Scripts, Grid Control, AWR, ADDM, Shareplex, HTML, DHTML, Windows

2008, RHEL 4.0, HP-UX 11.0.

Johnson & Johnson, New Brunswick NJ

June'2008 - Dec'2009

Oracle DBA

(Oracle 9i/10g /DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space

Estimation/24*7 support)

Responsibilities:

. Scripts are developed to monitor the growth of the Database and

purging policy is implemented at frequent intervals by raising change.

. By monitoring production Database through Instance Monitor, suggested

some parameters for Database Tuning.

. Functionality testing has been performed against the identified

modules.

. Volume management using Verities Volume manager to configure Disk

group.

. Configured Verities Net Backup R3.2 is to automate the physical Backup

of the Database.

. Scripts are developed to monitor the growth of the Database and

purging policy is implemented at frequent intervals by raising change

controls.

. Expertise in Replication of Oracle Databases using Logical Standby and

Streams and Shareplex.

. Worked on Recovery manager to recover the Database.

. Also involved in SQL performance tuning.

. Creation of database links.

. Estimating the size of Databases.

. Creating Databases.

. Upgraded the databases from 9.2.0.7 to 10.2.0.2

. Monitoring Standby Database whether all the logs transferred to

Standby site and applied properly.

. Checking the Alert Logs of production Databases for any errors

reported by Oracle.

. Adopting change control Mechanism (Lotus Notes Server) for replicating

the changes made to the production Databases.

. Export and Import of databases from one database to another databases.

. Monitoring the performance of production database through Instance

Monitor (Quest Tool) and growth of the database and suggesting for

change in parameters if required.

. Writing the shell scripts to automate the Backup and copying the

production copies to Test environment. (Scripts to copy from one test

database to another database)

. Attending specific requests from online, bug fixing, Bulk rate, Data

warehouse Teams.

Environment: SQL Navigator, Oracle 9i, 10.0, data Stage, Remedy, clear

quest, Sun Solaris, H.P, Windows2000, PL/SQL, Shell Scripts,

Maestro,ERWin4.0,TOAD.

HDFC, HYD, India

Jan'2007 - May'2008

Jr.Oracle DBA

(Oracle 8i/9i/10g /DATA GUARD/RMAN/SQLTuning/Upgrade/Migration/Space

Estimation/24*7 support)

Responsibilities:

. Database Design, Backup & Recovery, Tuning and Analyzing the Database.

. Coding PL/SQL & Shell Scripts, Design/Code reviews.

. Installation of the Databases, Environment Building to OFA compliancy.

. Backup Cold, Hot, Online, Exports, Performance Tuning, Remote sessions

tracing.

. Recovery Manager (RMAN) Implementation and strategies, Various

Database Recovery scenarios verification in advance.

. Altering the Database objects and files during maintenance.

. Implementation of RAC Technology.

. Database Maintenance, Data warehousing. Data Modeling using Erwin.

. Software design of medium/large business applications, Design

methodologies.

. Database (SQL) design, ER Modeling, Design and Development Of database

design.

. Jobs Scheduling, Exports/ Imports, Space Management.

. Hot and Cold Database Backups and recovery, Shell Scripting,

Restoration Tuning Memory.

. SGA, I/O, OTIMIZATION, SQL tuning, Security Management.

. Remote Database Access Security management 24 x 7 Monitoring.

. Managing the network and service changes on the network of the

databases.

. STANDBY Database implementation and Automation of the process (KSH,

LOADER, PL/SQL scripting combination) of ftp download of files to

proper load and update on tables.

. Writing shell scripts, Loading data into the database from the flat

files with SQL*Loader.

Environment: Solaris 2.6/2.8, Oracle 8.0.5, PL/SQL, shareplex, Perl,

Windows NT shell scripting, TOAD.

Contact this candidate