Oracle Manager

SARANYA CHANDRASEKARAN Email-id: **********@*****.***

Mobile: +91-996*-***-***

SUMMARY:

• Over 2.9 years of IT experience with Apps DBA on full cycle Oracle E-business

Suite (11i/R12) implementations.

• Extensive experience in Oracle Apps DBA ranging from EBS versions 10.x

through R12 and databases ranging from version 7.x through 11g.

• Managed VLDB global environments as large as 7TB

• Supported implementations and upgrades of EBS 11.10.5.2 to R12.

• Provided a health check of production EBS to address many instability and

performance issues and documented findings and implement recommendations.

• Well versed in all Linux based platforms and Windows and IBM AIX servers.

• Engaged proactively with project management team in strategic planning, goal

setting and monitoring, providing status updates on a regular basis.

• Strictly ensured Service Level Agreements (SLA) goals are successfully met by

DBA group.

• Extensively experienced in Installing, Patching of Oracle DB and Applications.

• Extensively experienced in Troubleshooting Concurrent Manager.

• Hands on experience with Oracle applications cloning.

• Patch analysis for database and applications patches including mini pack, one-of

patch.

• Exposure of setting up jobs for routine monitoring, DB shutdown, backup, DB

startup and database builds.

• Worked on 24/7 high availability environments

• Good communication skills.

ORACLE APPLICATIONS SETUP AND SUPPORT CONCENTRATIONS:

• Oracle eBusiness Upgrades: 11i to 12

• Oracle 10g and 11g RAC.

• Oracle Internet Directory (OID) and SingleSignOn (SSO) Integration.

EDUCATION & CERTIFICATION & TRAINING:

B.Tech in Information technology, Anna University

Oracle Certified Associate.

Actively Pursuing R12 DBA Certification.

SKILLS:

Environment: SUN SOLARIS, LINUX, Windows 32 bit

Tools: Oracle Enterprise Manager, SQL PLUS

ERP Oracle Applications 11i, R12

Oracle Utilities Sql*Loader, Export, Import, Putty

11i Utilities FNDLOAD, WFLOAD, FNDCPASS.

PROFESSIONAL EXPERIENCE:

HCL TECHNOLOGIES LIMITED

CLIENT: Teradyne (US) May 2010 –Nov 2010

Oracle Applications DBA

Responsibilities:

• Identified critical application issues including those relating to performance, Work

Flow, forms, reports and concurrent processes and solved problems

• Instituted proactive performance monitoring measures (using ADDM, AWR) to

ensure SLA performance goals.

• Conducted benchmark testing to stress published performance measures.

• Performed cloning activities to build development and test environments

• Architected and implemented Disaster Recovery procedures in compliance with SLA

availability clauses which included RMAN setup and configuration and Data Guard

installation.

• Implemented EBS security that leverages technical options with customers’ demands.

• Completed impact analysis of apps and database upgrade.

CLIENT: VMWARE (US) Dec 2010 – June 2011

Oracle Applications DBA

Responsibilities:

• Oracle Apps DBA support for Non Production ERP suite (11i10) on SUN Solaris

platform.

• 24/7 support includes patching, cloning, performance tuning and documentation

• Maintain VLDB OLTP databases in 24x7 production environment.

• Resolve performance related issues reported by user community.

• Wrote and implemented a number of shell scripts in order to monitor certain manual

task with alerts to the appropriate person. Utilizing TOAD, OEM and Grid Control

for system monitoring and tkprof for session monitoring.

• Extensively worked on Oracle Applications AD Utilities.

• Database Administration tasks.

• Monitor alert logs, space and object growth related problems in the databases.

• Oracle Applications System Administration such as managing concurrent programs

and requests, application security, user registration, assignment of responsibilities

CLIENT: NCR (US) July 2011 – April 2012

Oracle Applications DBA

Responsibilities:

• Team Oracle Apps DBA supporting upgrade and migration of Oracle EBS 11.5.9

(11i) on a Solaris platform to Oracle EBS 12.1.3 (R12) on a RH Linux platform.

• Implementation included Payroll, HR, GL, Financials

• Worked in conjunction with Business Users, Project Management Office to resolve

all issues prior to Go Live as well as after.

• Responsible for the on-demand patching of all non-production

• Provide daily production support for EBS after Go-Live

• Used OEM to monitor the performance of PROD and Performance Test environments

• SPOC for all migration activities.

• Configured OEM for monitoring of all environments.

• Load balanced the application tier to two nodes and converted it to a shared

APPL_TOP.

• Used Data Pump to move large amounts of data from one instance to another.

• Worked in conjunction with Developers to resolve performance issues with custom

code (reports, forms, workflow, concurrent reports, mviews etc.).

• Assigning responsibilities to users.

• Code Migration through FNDLOAD, WFLOAD

CLIENT: Sentosa development Corporation (Singapore) May 2012 – Till Date

Oracle Applications DBA

Responsibilities:

• Patch analysis, planning and application to all environments per client request.

• Provide weekly clones of production for development and test instances.

• Created post clone procedures that include modifying sensitive production data.

• Provided a health check of production EBS to address many instability and

performance issues and documented findings and implement recommendations (both

windows and Linux servers).

• Responsible for clones on demand and frequent patching of all systems.

• Planning and managing database backups.

• Configured and implemented OEM to manage all instances.

• Analysis of trace and log files to determine and resolve potential problem areas.

• Monitored and diagnosed database performance through monitoring of alert files,

trace files.

• Post installation trouble shooting.

Contact this candidate