Management Oracle

Priya Dorairaj

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

Professional Summary

Over 10.5 years of progressive IT experience in Oracle Database Administration, SQL, PL/SQL and UNIX shell scripting.

Over 8 years of DBA experience in Oracle 9i/10g/11g databases – Software Installation, patching, database creation, upgrades, refreshes, maintaining RMAN and logical backups, storage management, security management, performance analysis, troubleshooting oracle errors/bugs, automation of database administration scripts and decommission.

Over 3 years of experience as DBA of SQL Server 2000, 2005, 2008 databases including maintenance of backup using SQL Litespeed.

Around 2.5 years of experience in Client/Server technologies predominantly using Oracle 9i/10g SQL and PL/SQL.

Extensive experience in design, implementation, and support of disaster recovery solutions using Data Guard

Proficient in managing high availability (HA) solutions using Oracle 11g Real Application Clusters (RAC) and Automatic Storage Management (ASM)

Experience in implementing replication using Oracle Golden gate and Oracle Materialized views.

Performed database administration in various OS environments like Red Hat Linux, HP-Unix, AIX Unix, Oracle Solaris and Windows 2000/2003

Experience in handling databases pertaining to Data warehousing (OLAP), Operational (OLTP) and Web applications.

Experience in handling databases on AWS cloud infrastructure EC2 servers.

Experience in Healthcare and IME (Information, Media and Entertainment) domain

Worked on all types of environment including development, testing and production

Handled customer calls, meetings and direct customer interactions at the client site.

Involved in project coordination activities with all stakeholders such as application teams, end users and infrastructure teams.

Handled project management tasks such as planning, technical assessments, capacity planning, status reporting, and resource allocation.

Technical Skills

Primary Skillset

Database Administration of Oracle 11g, 10g and 9i

Secondary Skillset

Database Administration of SQL Server 2000, 2005 and 2008

Programming Language

Oracle SQL and PL/SQL

Scripting

Unix Shell Scripting

Operating Systems

AIX Unix 5.3, HP Unix 11.31, Redhat Linux 5.9, 6.4, Windows 2000, 2003, 2008

DBA Interfaces/Utilities

SQL Plus 9i/10g/11g, Oracle Enterprise Manager (OEM), Oracle Names Server (ONS), Quest Toad, Quest Spotlight, Foglight SQL Developer, SQL Server Management Studio, Query analyzer, BRTools (SAP), RMAN, DGMGRL (Dataguard), ASMCMD (ASM), SRVCTL (RAC), GGSCI (Golden Gate), impdp/expdp (Export/Import), sqlldr, emagent(OEM), OPatch

OS Interfaces

Putty, CRT, Ultra VNC, Exceed, HP Openview, xming

Database backup tools

RMAN, SQL Litespeed 5.1/6.1, SQL backtrack

Version control

Microsoft Visual SourceSafe 6.0, CCC Harvest 7.1

Project Management tools

Microsoft Project 2003 (MPP)

Other Tools

Remedy, JIRA

ITIL Process Areas

Incident Management, Asset Management, Change Management, Service Request Management, Risk Management, Knowledge Management and Problem Management

Familiar Standards

IT Infrastructure Library (ITIL) v3 Framework, Sig Sigma

Professional Experience

Cognizant Technology Solutions, India & Singapore Jul 2004 – Mar 2015

Client : Houghton Mifflin Harcourt (HMH)

Domain : Information, Media and Entertainment

Role : Senior Database Administrator

Duration : Jan 2014 – Mar 2015

Database : Oracle 10g/11g

OS : Redhat Linux 5.9, 6.4

DBA Interfaces : SQL Plus 10g/11g, RMAN, Toad, DGMGRL, ASMCMD,

SRVCTL, GGSCI, impdp/expdp, OPatch, AWS Management Console

OS Interfaces : Putty, Xming

Others tools : Foglight, Spotlight, JIRA

Roles and Responsibilities

Build new database environments on AWS cloud EC2 (Elastic Compute Cloud) instance using ASM on AWS Elastic Block Storage (EBS) and migrated existing application data from Oracle RAC database in datacenter server to AWS cloud.

Install grid infrastructure software, database software, apply PSU patches using OPatch utility, create ASM instance, create new database using DBCA, configure and schedule RMAN backup jobs and create and maintain RMAN catalog databases.

Configure jobs to copy RMAN backups to AWS cloud S3 (Simple Storage Service).

Implement Oracle 11g data guard physical stand-by and Oracle Restart feature as high-availability solution for disaster recovery (DR) in AWS cloud environment.

Configure Oracle dataguard broker, observer process to enable fast-start-failover (FSFO).

Install, configure and administer Oracle 11gR2 Real Application Clusters (RAC) with Automatic Storage Management (ASM) on Linux servers in datacenter.

Perform ASM related tasks such as creating new ASM instance using asmca, discovering asmdisks using ASMLibs, creating diskgroups, adding disks to diskgroup, deleting disks from diskgroups and monitor the rebalancing activities.

Manage Oracle RAC databases using crsctl/srvctl utilities, troubleshoot RAC configuration issues, health checkup using RACcheck, administer OCR and Voting disk and change initialization parameters for better performance whenever required.

Carried out POC for cross-platform database cloning (Solaris to Red Hat Linux)

Installation of Oracle Golden Gate software, setup of uni-directional replication using Oracle Golden gate for setting up reporting server, understanding application schema design, table dependencies to setup replication, configure conflict detection, resolution and identify and remediate data synchronization issues, adding new tables to existing replication environment and moving tables from one replication group to another.

Fix ASM/Grid related issues after a server instance is cloned from Amazon Machine Image (AMI).

Administration of Oracle RAC and stand-alone grid infrastructure databases.

Upgrade databases from 10.2.0.4 to 11.2.0.3.9 using DBUA.

Clone Oracle database using RMAN, periodically refresh test database from production database using data pump export/import, create guaranteed restore points and flashback database based on user’s request.

Troubleshoot Oracle 11g upgrade issues and provide support in performance tuning during application load testing using AWR, ADDM, ASH reports. Enable SQL trace and provide the tkprof output for developer’s analysis.

Automate monitoring of backup jobs, storage reports using Unix Shell scripting.

Work closely with application team, review the PL/SQL code whenever root cause analysis of performance issue indicates poorly tuned SQL code and provide recommendations for developers.

Raise SR with Oracle Support for different ORA errors raised and co-ordinate with Oracle support to solve the issue.

Client : Merck Sharp & Dohme, Singapore

Domain : Healthcare

Role : Senior Oracle Database Administrator

Duration : Jan 2012 – Dec 2013

Database : Oracle 9i/10g/11g, SAP database

OS : HP Unix 11.31, RH Linux, Windows

DBA Interfaces : SQL Plus 9i/10g/11g, Oracle Enterprise Manager, SQL

Developer, SAP BRtools, RMAN, srvctl, asmcmd, sqlldr

OS Interfaces : Putty, Exceed, HP Openview

Backup tools : RMAN

Others tools : Remedy

Roles and Responsibilities

Worked as Database SME for datacenter relocation from one site to another site. Involved in planning, execution and management of all database related activities.

Worked as Database SME for database migration from HP PA-RISC server to Itanium server.

Actively involved in providing guidance in the planning and implementation of database solutions.

Monitor and resolve Database Service incidents within established SLAs. Acknowledge and Address database alerts raised by enterprise monitoring tools within established SLAs.

Provide database support for CRM Online Data Store (ODS), data warehousing (Informatica), BI (Business Intelligence) application teams right from the project kick-off through performance tuning during load/performance testing until database code deployment during go-live/hyper-care.

Utilize enterprise database monitoring tools (OEM) to monitor and resolve database performance and availability issues.

Involved in meetings to decide on replication methodology to implement based on application requirement.

Installation of Oracle Golden Gate software, setup of uni-directional and bi-directional replication using Oracle Golden gate, understanding application schema design, table dependencies to setup replication, configure conflict detection, resolution and identify and remediate data synchronization issues, adding new tables to existing replication environment and moving tables from one replication group to another.

Involved in setup of database table replication using Oracle Materialized view.

Administration of Oracle High Availability RAC and non-RAC environments.

Database refresh using legacy export/import (exp/imp) and data pumps (expdp/impdp).

Perform full and incremental online backup, full and incremental offline backup using RMAN and schedule the backup in Oracle Enterprise Manager.

Perform database recovery for any business critical issues, DR exercise and refresh of one database from another using RMAN.

Configuring users, profiles, roles and basic auditing as part of database security management.

Worked with technical team to tune, analyze and improve existing database and application server performance. Assisted in setting up star schema for one of the BI application for optimal performance while using Cognos report.

Proactive monitoring, identifying areas that need to be improved in the application and database using Explain Plan, SQL Trace, TKPROF, STATSPACK, AWR, ADDM and OEM GRID control.

Experience in performance tuning using various tuning advisors like SQL Tuning Advisor, Memory Advisor, UNDO Advisor, RDA, Segment Advisor and MTTR Advisor for giving recommendations.

Involving into performance issues and identify the bottlenecks using with Automatic Workload Repository (AWR), SQL access Advisor, ASH samples the state of all active session every second and Automatic Database Diagnostic Monitor (ADDM).

Coming up the tuning recommendations with using SQL tuning advisory and used to implement new SQL profiles to resolve Performance issues.

Involved in SAP database administration activities such as code tree installation, tablespace management, database upgrades, database backups and restores.

Adhered to documented change control by raising RFC and perform modifications to databases during weekend windows.

Assign the work to offshore shared services team for delivering new environments and coordinate the same till closure.

Prepare weekly status reports, track the progress of the assigned projects and present to the client managers.

Highlight any risk on a timely basis to the client and arrive at contingency plans.

Client : IMS Health, UK

Domain : Healthcare

Role : Senior Database Administrator

Duration : Feb 2007 – Dec 2011

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

OS : AIX 5.3 Unix, Windows 2000/2003/2008

DBA Interfaces : SQL Plus 9i/10g/11g, Oracle Names Server, Toad,

SQL Server Management Studio, Query analyzer, OPatch

OS Interfaces : CRT 1.3, Ultra VNC, HP Openview

DB backup tools : SQL Litespeed 5.1/6.1, SQL backtrack

Scripting : Unix Shell scripting

Roles and Responsibilities

Installation of Oracle Software and upgrade of Oracle database from Oracle 9i to Oracle 11g.

Involved in POC carried out for checking application compatibility with Oracle 11g version, developed case study and coordinated database upgrade from Oracle 9i to 11g.

Database administration tasks like creation of database, database maintenance and decommission of databases.

Installation of patches for Oracle bug fixes and time zone patches.

Database storage management activities – Monitoring HP openview alerts for tablespace, tablespace report generation, evaluating space requests and adding space to the tablespace.

Database security management activities – Involved in creation of users, roles, granting roles/privileges to database users and liaising with Unix admin to setup Unix users.

Database refresh activities and logical database backup maintenance - Export/Import at database, schema, table and partition levels and partial export/import.

Database performance analysis - Configuring Statspack/AWR for database performance analysis, database instance tuning, running Tkprof/trace, interpreting Explain Plan, analyzing query performance and providing guidelines for query tuning.

Involved in developing, testing and implementation of scripts for database administration using UNIX shell scripting to automate database maintenance activities like export, tablespace usage monitoring etc.

UNDO and TEMP tablespace usage monitoring, providing recommendations for optimizing its usage and for adding additional space for provisioning increase in database volume.

Have good knowledge of basic database configuration parameters and was involved in configuring the database parameters for new database setup in Oracle 9i, 10g and 11g.

Backup/Recovery of databases using SQL Backtrack.

Involved in maintenance of roles, database links, directory objects, table partitions etc.

Involved in troubleshooting of Oracle errors reported by database users and handling any production issues that need DBA intervention.

Involved in basic administration activities like installation, database creation, shrinking, backup, restore, user creation, SQLMAIL configuration, database upgrade and migration in SQL Server 2000, 2005 and 2008 databases.

Project : Maintenance of COBRA and DDMS systems

Client : IMS Health, UK

Domain : Healthcare

Role : Oracle Developer

Duration : Jul 2004 – Jan 2007

Databases : Oracle 9i/10g/11g

Programming Language : SQL and PL/SQL, Power Builder

OS : AIX 5.3 Unix, Windows 2000/2003/2008

Scripting : Unix Shell Scripting

Database interfaces : SQL Plus 9i/10g/11g, Toad for Oracle, sqlldr

OS interfaces : CRT 1.3

Version control : Microsoft Visual SourceSafe 6.0, CCC Harvest 7.1

Project Management : Microsoft Project 2003 (MPP)

Methodology : SDLC - Waterfall

Roles and Responsibilities

Involved in requirements gathering, analysis, design of change requests of a large data warehousing application.

Technical assessment, capacity planning, effort estimation, prepare project plan, design document and test case documents.

Develop application code using Oracle PL/SQL, Powerbuilder, Unix Shell scripting, testing, integration, implementation and warranty support of change requests.

Prepare implementation plan, develop deployment scripts, deploy code changes in UAT and production environments and perform version control using CCC Harvest.

Involved in quality related activities like peer code review, metrics generation, preparing PMO reports, presenting the status report to client, conduct internal audits of the project artifacts, defect analysis, tracking, risk management etc.

Involved in knowledge transition sessions for handover of projects to Support team for production support after the warranty period.

Involved in following internal tool development.

oBridging Configuration Wizard

oGeneric Reporting Tool

oGeneric Compression Tool

oKnowledge Repository Site

Educational Qualification

Degree with Branch

College/University

Year of passing

Masters of Science in Software Engineering (Distant Education)

Birla Institute of Technology & Science (BITS), Pilani

2008

Bachelors Degree in Information Technology

Sri Venkateswara College of Engineering, Madras University

2004

Certification and Training

Certification/ Training

Awarded By/ Conducted By

Month & Year

Oracle Database 10g Administrator Certified Professional (OCP)

Oracle Corporation

Dec 2007

Oracle Database 10g Administrator Certified Associate (OCA)

Oracle Corporation

Jan 2007

Oracle 10g Database Administration workshop

Oracle Corporation

Jan 2007

Sun Certified Java Professional 1.4

Sun Microsystems

Jan 2006

Oracle 9i PL/SQL Certified Associate certification (OCA)

Oracle Corporation

Jun 2005

Contact this candidate