Sughanthan ShanmugaSundaram

***, ****** ***** ****, ************, Columbus Ohio 43068

Mobile: +1-614-***-****

E-mail Id: adb0kf@r.postjobfree.com

Professional Summary:

Over 12+ years of experience as Oracle DBA and ORetail application administrator.

Experience in Oracle Retail, Oracle AIA, 10g and weblogic apps server, 10g/11g Db.

Proven ability to install, configure, deploy and handle critical oracle systems.

Ability to assimilate new ideas, concepts, methods and technology.

Dedicated, innovative, co-ordination skills and self-motivated Team Leader

Professional Experience:

Oracle Apps Consultant, Ascena USA TCS Pvt Ltd,, India, October ‘15 – till date

Oracle Apps Lead, Landmark Dubai, TCS Pvt Ltd, Bangalore, March ’13 – September ‘15

Oracle Apps DBA, Accenture Pvt Ltd, Bangalore, India, Sep ‘10 – Feb ‘13

Senior Oracle DBA, Automatic Data Processing Pvt Ltd, Hyderabad, India, June ‘07 – Sep ‘10

Oracle DBA, Zolon Tech Ltd, Hyderabad, India, Sep 2006 – April 2007

Educational Qualifications:

M.E (CSE) - JJ College Of Engg, Trichy, Anna University, 2004 - 2006

B.E (CSE) - Mepco Schlenk Engg Col, Sivakasi, Madurai Kamaraj University, 2000 – 2004

HSC - BHEL Mat Hr Sec School, Trichy, 1998 - 2000

SSC - BHEL Mat Hr Sec School, Trichy, 1996 – 1998

Accreditation:

ITIL V3 Foundation Certified

Oracle Certified Professional 10g DB

Completed course on 9i RAC on Linux with ASM in Wilshire Institute

Oracle DBA course in Sql Star International

Key Technical Skills:

Database Technology : Oracle DB (10g/11g)

Apps Environment : Oracle Retail 12/13/14, Oracle FMW SOA/OSB/ODI, Oracle AIA OIM/OID/OAM

Operating Systems : AIX, Solaris, RHEL, Oracle Linux

Oracle Knowledge : RMAN, (RAC & Clustered & Failover Environments), Active Dataguard, Cloning, Backup & Recovery, Monitoring, flashback, Patching and Tuning

Ticketing Tools : CA Service Desk, Citrix, Rational Clear Quest, Ivanti, Heat

Database Tools : GGate, Bladelogic, Veritas Clusters, Mirror Copy (BCV Backup),

Grid Control and Shell Scripting

Project Experience:

TCS India Pvt Ltd, Oct 2015 – to till date

Role: Oracle Application Tower Lead

Designation: IT Analyst

Client: Ascena Retail Group US

Ascena Retail Group is a 6b$ entity operating in US. I am leading Infrastructure Onshore team, we handle mission critical application like Oracle Retail, Oracle SSO, Oracle FMW etc.

Daily Activities of Infrastructure Team:

Installation and maintenance of Production and Non Production (Dev/UAT/PProd/Training)

Installed Oracle Retail Application 13.2 version for the couple of brands

Install and maintain Oracle FMW SOA/OSB/ODI application 11.x and 12 versions

Installed and maintained Oracle SSO IAM/OAM/OID applications 11.x version.

Maintain certificate renewal with security team and implementsss as per the application requirement.

Work with development team for the new required and help in building the environment

Prepare and present weekly management meeting present from the Apptech tower end.

Prepare and present QBR for the senior management to present from the core IT team.

sssss

TCS India Pvt Ltd, Bangalore, India March 2013 – to Sep 2015

Role: Oracle Retail Lead

Designation: IT Analyst

Client: Landmark Group Dubai

Landmark Groups a 5b$ entity operating in 9+ countries in Middle East. I am leading Infrastructure offshore team, we handle mission critical application, Security Matrix and UC4 Batch scheduler monitoring and maintenance in day to day basis.

Daily Activities of Infrastructure Team:

Installation and maintenance of Production and Non Production (Dev/UAT/PProd/Training)

Installed Oracle Retail Application 13.1, 10g Application Server, UC4 Appworx

Install WMS in new territories; create user setup for the roll out activity.

Worked closely with batch monitoring team, configure and resolve batch related issues.

Part of weekly CAB meeting for Infra related CR implementation

Daily Health check for both production and non production environment

Raise Oracle Sr for any base product bugs and follw up on the same.

Both db and application refresh of UAT to Training once in 3 months

Automated Health Check with web dashboard reduces manual effort from 4 hrs to 1hr.

Deployment of components as part or SR or CR (DB objects, Pro C, Forms)

Query level tuning, Application Tuning, Space forecasting

Accenture India Pvt Ltd, Bangalore, India September 2010 – February 2013

Role: Oracle Retail and AIA DBA

Designation: SSE

Client: C1000 Retail Client (C1000.com)

C1000 is a retail client implementing Oracle Retail, Oracle Finance using Oracle 10g, Application server and integration using Oracle AIA. Implementation of C1000 retail business in Oracle Suite is done in IDC Accenture.

Daily Activities of Technical Architecture Team:

Installation and maintenance of Production/Test/Dev/UAT/Mock 11g environments

Oracle DBA Activates (Installation of db, tablespace monitoring, synonyms, grants for Oracle Retail (13.2)/Oracle Finance (12.1) Environments, Oracle AIA (10g) environments

Performing operational tasks and activities (Monitoring log files, performance tuning, application monitoring and migration between environments.)

Configured system resources (JMS, DB Data Sources, File systems, etc.) as per requirements of the Oracle AIA.

Deployment of Services using Ant/Hudson/Build Scripts

Deployment of DB Tables, DB Objects, PC files and Forms for Retail

Deployment of Xsd, Dvm, fault polices, ESB, BPEL and xrefs for Oracle AIA

Deployment of Workflow, Mapping PMF files, tables and grant for Informatica

Installed and configured on Identity Management, Oracle BAM

Working in Virtualized environment using VMWare & Cloud

Configured scripted management (stop/start/etc) of the servers/domains.

Good in UNIX shell scripting.

Oracle Finance 12.1 Cloning of apps and db tier

Proficient in Oracle Database 10g, 11g

Automatic Data Processing Pvt Ltd, Inc, Hyderabad, India.

Role: Senior Oracle Database Administrator June 2007 – September 2010

Designation: SSE

Automatic Data Processing, Inc (NASDAQ: ADP), a $9 billion dollar Fortune 200 listed payroll company. ADP has 60 years of experience with over 585,000 clients in US and many more around the world offering service in Payroll, Tax, Hr, Share Brokerage, HR, Dealer Service, Retirement Benefits, etc.

We Middleware Engineering DBA team supported over 45 in house applications consists of over 9000 database with all types of DBA activities.

Daily Activities:

Administered 24/7 mission critical production payroll RAC databases

Installation of Oracle 9i, 10g and 11g with Veritas cluster and failover db’s

Installation of 11g in Lintel Farm using ASM storage

Implemented standby, dataguard & replication in DR site for production db’s

Scheduled and monitored expdp, Rman (hot & cold) and BCV backups

Worked on DB migrations from BW to DCx, Windows and Solaris to Lintel Farm

Upgrade Oracle db and apply patches as per the ora errors(ORA-600) and new release

Clone, restore db as per requirements

Implemented, configured and managed OEM Grid control for Lintel Farm databases

Soft and hard High Availability (HA) testing the newly created RAC environments.

Installed and maintained Golden Gate, Bladelogic

Flashback, Sysaux, undo table space maintenance

Deadlock detection and disengagement.

Shell scripting for backup and as per requirements.

Used Sitescope, BMC, and Netcool monitoring tools.

Zolon Tech Ltd., Hyderabad, India

Role: Database Administrator Sep 2006 – April 2007

Responsible for a pilot project as a data warehousing DBA & Team lead, assigned client’s task to developers, creating database instances as per requirement, testing the completed job in local & remote client machine and go live.

Initiate and Co-ordinate weekly client meeting, assigned tasks among the developers and delivered assigned tasks successfully with minimum supervision is a major accomplishment.

Client: Worked as a Database Administrator for Conquest System US

Daily Activities:

Managed 24/7 Databases for local or remote db

Regularly performed cold backups of production db

Network handling and troubleshooting in terms of database

Designed and created database as per the project requirements

Managing roles, privileges and profiles for different groups of users

Managing user data, space usage and applications

Planning and implementing recovery procedures in case media failures

Contact this candidate