Ramasubramanian Sankaran

Contact # : 717-***-****

Email: abio5q@r.postjobfree.com

Experience Summary:

** ***** ** ******* ********** in IT industry in various fields like

banking, insurance, financial, retail and manufacturing. Extensive

experience in Exadata, Goldengate and relational database design, analysis,

modeling, development, administration, implementation, trouble shooting and

quality management. Comprehensive experience as Oracle DBA; proficient in

Oracle 8i/9i/10g/11g Software Installations, Migrations, Database Capacity

Planning, Automated Backup Implementation, Tuning Oracle 11g/10g/9i/8i on

Unix and Windows NT platform. Involved with architect group in designing

the logical and physical model of the databases. Have good experience in

UNIX administration. Have impeccable communication and interpersonal skills

and an exceptional team player. Managing the team of Oracle DBAs and

actively coordinated with the end user community.

Education:

Master of Computer Applications Manonmaniam Sundarnar

University 2004

B.com Manonmaniam Sundarnar

University 2001

Certification Completed:

Oracle Corporation Oracle

Certified Exadata Implementation Specialist.

Oracle Corporation Oracle Golden Gate

Essentials

Oracle Corporation OCP DBA

1

2

3 Skills Profile:

. Engineered systems: Exadata, Oracle Database Appliance.

. Replication: Golden Gate.

. Database: Oracle 11g, 10g, 9i.

. Experience in High availability technologies like RAC, Dataguard.

. Operating Systems: Windows NT/2000/XP,Unix/Solaris,Linux

. Languages: PL/SQL, SQL

. Oracle Development: Toad, SQL*PLUS

. Oracle Backup/Recovery: RMAN

4 Architecture / Database Design Experience

. Design and build complex relational databases and data warehouses.

. Work with technical and end users to understand business

requirements and identify data solutions.

. Develop strategies for data acquisitions, data recovery, &

enterprise level database implementation.

. Provide leadership and direction to database developers.

. Provide an in-depth expertise with data security, storage solutions

and replication as well as other complex technical tools and

solutions.

. Define enterprise-level standards (coding, architectural,

migration), platform and tool selection.

5 Exadata Experience:

. Assisted in management and database administration of Oracle

database applications on Exadata platforms.

. Provided technical assistance for designing, installation and

upgrading of existing Oracle databases.

. Performed database management functions such as maintenance, access

issues and security.

. Conducted designing, assembly and tuning of databases in

coordination with development teams.

. Evaluated database performance for investigation of issues and

further resolution for efficiency.

. Implemented procedures for automation of database management through

tables and indexes.

. Executed processes for evaluation of system space, database

allocation and storage metrics.

. Maintained all existing databases and new installations at current

and stable production levels.

Oracle Golden Gate Experience:

. Oracle installations which require real time data replication using

GoldenGate Transaction Data Management Tool.

. Experienced in GoldenGate Install, Configuration, Maintenance,

Trouble Shooting .

. Responsibilities handled include supporting Production System with

focus on tuning performance parameters of GoldenGate software to

enhance replication speed and eliminate downtime.

6 Oracle RAC DBA Experience:

. Architecting, planning, designing, developing, deploying and

supporting RAC/ASM environment

. Installing & configuring Oracle clusterware & Database Software

(Troubleshooting using cluvfy & handling common issues that arise

during integration of the whole - bugs, network issues,

configuration files issues, OCR issue, deinstallation & cleanup of

clusterware)

. Testing and benchmarked the application prior to going into

production to determine its effects on GES and GCS with special

focus on load testing for interconnect traffic.

. Worked with customer for different RAC related issue:[hangcheck

timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk

loss & so on]

. Troubleshoot performance issues for the RAC instances (GC events)

. Backup and Recovery issues related (loss of OCR, Voting Disk and

Oracle clusterware) & also issues with corruption of individual disk

data blocks, loss of OS configuration files, loss of net

configuration files. Also used the Merge backup for backing terabyte

databases. Issues with block change tracking & also flash recovery

area.

. Resolved/Diagnose Node Eviction.

. Upgrade of 10g R2 RAC to 11g R2 RAC

. Add or Remove Node from RAC.

Oracle DBA Experience:

. Oracle installations keeping view of oracle architecture in 11g,10g

and 9i

. Managing control and redo log files in different partitions to

reduce the risk of oracle crashes.

. Managing users, privileges by granting roles, system and object

privileges to the users

. Creating various tablespaces of different sizes depending on the

transactions

. Creating indexes for performance improvement

. Overall - closely managing to ensure that each system for the client

is executed flawlessly.

. Responsible for configuration management, performance tuning and

administration of mission critical production databases

. Troubleshooting any issues related to production, development

databases

. Responsible for configuring & tuning Oracle system parameters

. Understanding performance issues using AWR.

. Migrated data from testing to production environments, and evaluated

the process

. Created and sized Oracle tables

. Created triggers,procedures

. Importing, exporting, Loading of database and tables using utilities

like Import, Export

Database tuning:

. Role as a DBA with major thrust on tuning the queries using the

Explain Plan to optimize for better performance.

. Tuning memory allocation, Buffer cache, Log buffer and shared SQL

. SQL tuning by optimizing the codes.

Backup & recovery:

. Establishing backup & recovery procedure

. Operating in Archive log mode

. Followed hot backup methodology regularly

. Hot and Export backups were maintained periodically

. Used RMAN with catalog for backup & recovery

High Availability:

. Configuring Mission critical Databases in RAC to minimize

catastrophic down time and provide High availability.

. Create and Maintain Logical and Physical Stand by Databases using

ORACLE DATGUARD for reporting and high availability.

Professional Experience:

Project Name : Information Technology shared services

Client : Maryland Health Benefit Exchange

Company : Deloitte Consulting LLP

Duration : October 2014 - Till date

Description : Involved in Installing, configuring,

maintaining mission critical Oracle and DB2

Database in Production, Development and QA databases on a 24/7 basis.

Working as an senior DBA which

requires extensive technical expertise in multiple Oracle/DB2

Database administration.

Project Name : Cloud DBA Services

Client : The Home Depot

Company : BIAS Corp

Duration : March 2012 - September 2014

Description :

Architect Responsibilities:

. Design and build complex relational databases and data warehouses.

. Work with technical and end users to understand business

requirements and identify data solutions.

. Develop strategies for data acquisitions, data recovery, &

enterprise level database implementation.

. Provide leadership and direction to database developers.

. Provide an in-depth expertise with data security, storage solutions

and replication as well as other complex technical tools and

solutions.

. Define enterprise-level standards (coding, architectural,

migration), platform and tool selection.

Exadata and DBA Responsibilities:

. Participated in analysis and designing of Oracle Exadata Server for

infrastructure and related projects.

. Provided technical assistance for development of physical and

logical architecture models on all Oracle server platforms.

. Coordinated with project teams for designing and implementation of

database infrastructure designs by documentation and system testing.

. Assisted in integration of Exadata applications into current IT

actionable events and solutions.

. Suggested procedures for database performance and tuning of all

database machines and related components.

. Created certified processes and procedures for maintenance and

upgrading of all database machines.

. Conducted analysis and feasibility studies for development of Oracle

Exadata solutions.

. Developed strategies for disaster recovery services of all database

machines along with advisory services.

Oracle GoldenGate Responsibilities:

. Plan GoldenGate setup to achieve Unidirectional replication

. Prepare GoldenGate parameter files for Extraction and Replication

. Install GoldenGate software in Test region to perform POC

. Investigate Replication failures using LogDump utility

. Test initial Data Load option of GoldenGate during environment build

. Setup GoldenGate Database User with necessary privileges

. Identify risks involved with replicating highly volatile tables with

large data volume

. Cross-Train other DBAs on replication concepts

Project Name : My oracle Support

Client : Oracle Corporation

Company : Oracle Corporation

Duration : December 2010 -March 2012

Description : Working in Global customer support

for Oracle database products in 24/7 basis to

support oracle customers around the Globe by handling various

issues ranging from RAC installations,

configurations, performance tuning.

Project Name : Symantec

Client : Symantec Corporation

Company : Cognizant Technology Solutions

Duration : June 2010 - December 2010

Description : Involved in Installing, configuring, maintaining

mission critical Oracle Database in

Production, Development and QA databases on a 24/7 basis.

Working as an oracle DBA which requires

extensive technical expertise in multiple Oracle Database

administration.

Project Name : Credit Suisse

Client : Credit Suisse, Switzerland.

Company : Cognizant Technology Solutions

Duration : May 2008 - May 2010

Description : The Credit Suisse is a provider of wide-ranging

financial services in Europe and other selected markets. It offers

investment products, private banking and financial advisory services

for private and corporate clients. Private Banking- Credit Suisse is

one of the world's largest private banking organizations with

branches in Switzerland and numerous international markets. Private

Banking specializes in providing personal investment counseling and

professional asset management to affluent individuals. Corporate &

Retail Banking - In Corporate & Retail Banking, Credit Suisse

occupies a leading position in the Swiss market. It provides a wide

range of banking services for private and corporate clients in

Switzerland. In addition, it offers online banking services.

Involved in Installing, configuring, maintaining mission critical

Oracle Database in Production, Development and QA databases on a

24/7 basis. Worked as an oracle DBA which requires extensive

technical expertise in multiple Oracle Database administration.

Project Name : Viacom

Client : Viacom Inc., USA

Company : Cognizant Technology Solutions

Duration : Sep 2007 - May 2008

Description : Viacom Inc. is an American global mass

media company with interests primarily in, but

not limited to, cinema and cable television. It is the

world's fourth largest broadcasting and cable company in

terms of revenue. Involved in Installing, configuring,

maintaining mission critical Oracle Database in

Production, Development and QA databases on a 24/7 basis.

Worked as an oracle DBA which requires

extensive technical expertise in multiple Oracle Database

administration.

Project Name : Performance Fibers

Client : Performance Fibers Inc, USA

Company : Caritor India Pvt Ltd

Duration : November 2006 to September 2007

Description : Performance Fibers is a multi-national

manufacturing company with production sites on

three continents. The business has sales, marketing, technical

and applications support, as well as

manufacturing, in North America, Europe and Asia. It is a

global leader in fibers and fabrics for tires, a

significant supplier of fibers for automotive safety

belts and a major resource for a diversity of industrial fibers

products. Involved in supporting mission critical

databases from offshore. Project involves 5 missions critical

databases and application.5 development databases.

Project Name : CERTIDO

Client : Caritor Inc, USA

Company : Caritor India Pvt Ltd

Duration : November 2006 to September 2007

Description : Certido is Caritor Inc internal product, the

availability of the server is highly critical,

involved in supporting and tuning the database.

Project Name : FIFA.com

Client : FIFA, Swiss

Duration : April 2005 to October 2006

Employer : Changepond Technologies

Description : F d ration Internationale de

Football Association (FIFA) is the international governing

body of the sport of football, based in Zurich, Switzerland. The

organization works in conjunction with

regional arms that oversee football development in the different

parts of the world. FIFA also promotes the

sport, regulates the transfer of players between teams, awards the

FIFA World Player of the Year, and

publishes the FIFA World Rankings every month.

Each database consists of more than 600 user objects and there

are more than 40 users. The web sites consist

of more than 20000 pages and have a Content Management System

Application.

Involved in database design and administration

[pic]

Contact this candidate