Anitha Perumal

acghx9@r.postjobfree.com

916-***-****

Page 1 of 7

Experience Summary

• 8 years of experience in Oracle DB administration, development, database design, performance tuning capacity

planning, Installation, Patching, Upgrading, Migration, Backup & Recovery.

• Experience in providing 24x7 supports with customers in Banking, Insurance, Retail domain.

• Wide exposure on Installation, upgrading databases to higher versions and patch management.

• Enabling database alerting mechanism using OEM Grid Control.

• Worked on performance and capacity assessment and tuning of very large databases. Involved in Performance

tuning of OLTP databases.

• Good knowledge on working with logical and physical data models. Worked on enhancement of physical data

model changes.

• Handling all daily operational activities related to database management and administration.

• Tuning databases and user queries using AWR/STATSPACK/ADDM reports.

• Proficiency in Disk management and problem resolving techniques with a good understanding of Capacity

planning and efficient usage of the disk space.

• Worked on performance and capacity assessment and tuning of 15TB large databases

• Good experience in SQL Query Tuning and key Oracle performance related features such as Execution plans,

Hints, Indexes and table Partitions.

• Extensive experience with Oracle – Dataguard, RMAN, ASM, AWR, OEM, PL/SQL, performance tuning,

migrating databases across databases, Logical design, Unix Scripting.

• Has hands on experience in Creating, reorganizing the databases, Installing and Upgrading of Oracle with

different versions.

• Experience on Oracle 10g and 11g Grid Control, Experience in tools like OEM, SQL*NET, Net Configuration

assistant, Oracle Universal Installer.

• Experience on monitoring tools like nmon, perfmon, vmstat and AWR.

• Applied the patch sets released by Oracle Corporation from time to time, performed Application tuning ( SQL

tuning, Memory Tuning).

• Worked on shared delivery model. Ability to handle multiple projects and meet the project deadlines on time.

• Excellent analytical, problem solving, communication, managerial and interpersonal skills with the ability to

interact with individuals at all levels.

• Good interpersonal skills, self motivated and fast ability to absorb new technology and very good team player.

• Provide on call support for staging and production deployments. Experience in providing 24x7 supports.

Technical Proficiency:

• Good Knowledge in performance tuning.

• Experience in Installation and DB Upgrades

• Experience in RMAN backup and recovery strategies

• Good Knowledge on the Explain Plan, Statspack

• Experience in the Data Migration from across databases

Page 2 of 7

• Good Knowledge on the Golden Gate, Dataguard

• Experience on OEM, AWR, vmstat, nmon analysis

Databases Oracle10g & 11g, Teradata12, SQL server2005/ 2008

Operating Systems AIX/HP-UX/Windows, Mainframe

Languages PL/SQL, SQL, T-SQL

Tools/Utilities Tidal Scheduler, Facets5.1, Jprofiler, APP Dynamics, PowerCenter9.1, vmstat, nmon, perfmon,

AWR, OEM, JIRA, QC, TFS, SVN

Backup/Recovery Exp/Imp, Datapump, RMAN backup, SQL Loader

Trainings and certifications

ITIL V3 Certified

Oracle OCP certified (Oracle 9i, 10g)

Oracle 10g SQL & 10g PL/SQL training from Cognizant

DB2 on mainframe training from Cognizant

Education: M.Sc. Information Technology from Anna University in Tamilnadu, India.

Cognizant:

1. Blue Shield of California Jul’13 – Oct’14

Sr. Oracle DBA

: Oracle 11g, Java, Facets5.1, Dataguard, AIX, Powercenter 9.1

Technology

: vmstat, nmon, perfmon, OEM, AWR, Tidal Scheduler, JIRA, Toad, Jprofiler

Tools

Analyze AWR to provide capacity assessment.

Actively worked on AIX P6 to P7 processor uplift.

Analyse vmstat, nmon on prod for CPU, memory, RunQueue utilization for AIX uplift.

Extensively used Grid Control (OEM), and Toad to maintain various database servers.

Worked on Database Cumulative L0, L1 backup and Differential L1 backup in RMAN.

Handle high severity issues and problem tickets

Identifying gaps in database environments and addressing them.

24x7 support for Non-Prod, prod databases to keep business running

Taking logical database backups using datapump.

SQL Tuning using Explain plan and SQL Tuning Advisor.

Worked with SR- Oracle Support to resolve different database related issues.

Complex SQL and PLSQL performance tuning.

Database and Server tuning and application tuning using Jprofiler and Perfmon.

Oracle 10g, 11g installation, upgrading databases to higher versions and patch management.

Data guard - Physical, Logical standby database maintenance.

Extensively used Grid Control (OEM), and Toad to maintain various database servers

Set up new DB and provided all database-related support for the DEV and Test databases.

Gather DB stats, Perform database backups on daily basis and On-Demand during QA

testing.

Page 3 of 7

Review and modify DDL/DML scripts produced by the data modeler as per project

requirement.

Generate DDL/DML scripts for Table and column addition and data-type changes using

Visio and implement it in the database.

Involved in designing, managing of schemas and database design.

Create/Maintain the users in the Non-Prod, prod server and grant permissions

Monitor the database during testing and code deployment.

Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean

up/housekeeping.

Capacity planning of the databases/applications by performing Load testing, Scalability

testing and Performance testing of database to identify the system capacity and future

load.

Analyze Workflow log and tune them, Informatica SQL tuning.

Automation of day-to-day DBA tasks / reports using cron jobs.

2. Western-Union Money Transfer, Denver Oct’12 – Jun’13

Role: Oracle DBA

Technology : Oracle11g/10g, UNIX Scripting, Data Stage8.5

Tools : Exp/Imp, SQLLDR, Datapump, vmstat, nmon, perfmon, Toad, SVN, QC, JIRA

Role:

Providing 24X7 on-call support to maintain all Databases up and running in Production

environment

Oracle Installation, up-gradation to higher version.

Physical Standby Database maintenance.

Worked on Database Cumulative L0, L1 backup in RMAN.

Expertise in database backup/recovery using RMAN and export-import.

Extensively involved in Cloning Database from production to development

SQL Tuning using Explain plan and SQL Tuning Advisor.

Upgrading databases to higher versions and patch management

Used Exp/Imp, Datapump and SQLLDR utility for data transfer between staging and

development.

Write PL/SQL procedures, UNIX scripts to handle AS/400 feed_file in oracle server.

Write UNIX scripts for purging activities.

Implemented Uni-directional replication across the database in golden gate

Tuning of databases which includes Server side tuning and application tuning.

Upgrade Oracle database from 9i/10g and 11g.

Refresh TEST and DEV (Oracle) from production databases as and when required.

Optimized different SQL queries to insure faster response time.

Provided on-call support regarding production-related database problems.

Perform testing of scripts and procedures and Setup test environment.

Help QA/DEV team in performing unit and system testing.

Monitor the database during testing and code deployment.

Provide faster solution for issues coming up on QA testing window.

Page 4 of 7

Capacity planning of the databases/applications by performing Load testing, Scalability

testing and Performance testing of database to identify the system capacity and future

load.

Involved in designing, managing of schemas and database design.

Create/Maintain the users in the Non-Prod, prod server and grant permissions

Monitor the database during testing and code deployment.

Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean

up/housekeeping.

3. Wal-Mart, Bentonville, USA July’11 – Sep’12

Role: Oracle Database Analyst

Technology : Oracle 10g, 11g, Teradata, DB2, Datastage 8.5, UNIX, AIX, Solaris

Tools : Oracle Grid control, Dataguard, Toad, AWR, vmstat, nmon

Role:

Responsible for installing, upgrading and configuring Oracle11g environment by

creating databases, storage structures and objects, database backup and recovery,

monitoring and optimizing database performance.

Data guard - Physical, Logical standby database maintenance.

Evaluated server/instance architecture, hardware, system specifications, and capacity

planning.

Hands on experience on performance tuning, identified and reduced/eliminated non-idle

wait events such as scattered file read, sequential file read wait event, log file completion,

in queue, and buffer latch waits.

Set up new DB and provided all database-related support for the production as well as test

databases

Performed performance/memory tuning, server/database monitoring, and configuration.

Upgraded from Oracle 10g to 11gR1

Experienced in EM Grid Control. Extensively used for query execution plan, ASH, and

AWR.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic

Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database

performance.

Experienced with utilities like Data Pump, SQL Loader, Export/Import.

Worked on database restores at times of critical failures.

Implemented Oracle database backup &recovery solutions using RMAN.

Cloned and refreshed production database to testing and development environments.

Provided all kinds of DBA support to DEV teams & production support to various

applications.

Review and modify DDL/DML scripts produced by the data modeler as per project

requirement.

Generate DDL/DML scripts for Table and column addition and data-type changes using

Visio and implement it in the database.

Perform testing of scripts and procedures and Setup test environment.

Help QA/DEV team in performing unit and system testing.

Page 5 of 7

Monitor the database during testing and code deployment.

Provide faster solution for issues coming up on QA testing window.

Involved in designing, managing of schemas and database design.

Create/Maintain the users in the Non-Prod, prod server and grant permissions

Monitor the database during testing and code deployment.

Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean

up/housekeeping.

4. Pfizer C-Link Dec’09 – Jun’11

Oracle Apps DBA

Technology : Oracle 11g/10g, UNIX, Windows, PL/SQL, Datastage 8.5

Tools : SQL developer, OEM, RMAN, Dataguard, Visio, QC, Microsoft TFS

Pfizer Incorporated is a pharmaceutical company, ranking number one in sales in the world, based

in New York City. The company strives to provide access to safe, effective and affordable medicines

and related health care services to the people who need them. The Project plans to develop a

Customer Validation Tool/Customer Pick List (CVT/CPL) for Pfizer's CRM and Task force

management.

Role:

Providing Oracle DBA support for implementing RMAN backup/recovery strategies.

Maintained Database servers through OEM.

Analyze existing database system and architecture and improve performance

Used PL/SQL for various work and tuned as and when required.

Recorded in the document all the commands and responses in the testing scenarios in order

to provide an accurate reference manual for doing recovery when disaster strikes.

Recovered successfully two production databases from RMAN backups due to an

unexpected media failure resulting in data corruption errors.

Checking alert logs for any database errors and correction

Execution of user scripts in production environment

Strong Experience working in ITIL environment

Review and modify DDL/DML scripts produced by the data modeler as per project

requirement.

Responsible for new entity and attributes addition to the database.

Physical implementation of data model changes in DB like table, column, Data-type and

indexes.

Provide faster solution for issues coming up on QA testing window.

Identify, trace and tune SQL queries for better performance

SQL Tuning using Explain plan and SQL Tuning Advisor.

Tuning database queries and PL/SQL performance tuning for larger Databases.

Help QA/DEV team in performing unit and system testing.

Provide faster solution for issues coming up on QA testing window.

Identify, trace and tune SQL queries for better performance

Page 6 of 7

Hewlett Packard:

Jul’06 – Dec’09

Cadbury Schweppes, Doctor Pepper

Role: Oracle DBA

Technology : Oracle 11gR1/10.2, Solaris, AIX/HP-UX/Windows, SQL Server 2005, ITIL

Tools : Toad, SQL Developer, T-SQL, SQL, PL/SQL, OVSC, QC

On call DBA during critical production periods; coordinated database recovery during several

database outages. Involved in integrating their process with Oracle. Implemented Oracle Dataguard

and RMAN.

Role:

Involved in designing, managing of schemas. Managing schema objects, such as tables,

indexes, and views

Monitor DB growth and provide DB capacity planning for apps expansion

SQL and PL/SQL: scripts, triggers, procedures, packages maintenance and tuning.

Manage users, maintain systems security, control and monitor database access

Monitor alert log and trace files & Manage disk space and archive location

Worked on Database Cumulative L0, L1 backup and Differential L1 backup in RMAN.

Set up new databases and provided all database-related support for the DEV as well as Test

databases.

Gather DB Stats, Perform database backups on daily basis and On-Demand during QA

testing.

Worked with ITIL processes (Incidents, Change, Patch and Problem Managements) &

SLA.

Tune databases and SQLs using tools like EXPLAIN PLAN, TK-Prof and PL/SQL

procedure tuning.

Duplicated, refreshed lower environments using RMAN

Database and Server tuning and application tuning.

Oracle 10g, 11g installation, upgrading databases to higher versions and patch management.

Data guard - Physical, Logical standby database maintenance.

Design and implement DB security, user management

Support developers in tuning DB and apps for optimal performance

Install, configure, upgrade software: server, tools, applications

Create/Maintain the users in the Non-Prod, prod server and grant permissions

Monitor the database during testing and code deployment.

Disk/Space/File system maintenance and file movement as UNIX level, File/folder clean

up/housekeeping.

Automation of day-to-day DBA tasks / reports using cron jobs.

Page 7 of 7

Contact this candidate