Post Job Free

Resume

Sign in

Sr Oracle DBA

Location:
India
Salary:
As per company policy
Posted:
August 19, 2010

Contact this candidate

Resume:

Santhosh Kumar.G

Contact No: +** ********

E-Mail: ks3a5d@r.postjobfree.com

Professional Profiles

• 6+ years of IT Experience includes 5.5 Years as SAP Basis administrator and 1+ year as developer.

• Extensively worked with SAP R/3 products 4.6c, 4.7, NW2004, NW2004’s.

• Good knowledge of Software Development Life Cycle Processes.

• Possesses Strong Analytical, Communication and Management skills.

• Implemented best-in-class operations procedure to manage business processes in a constantly more complex IT system environment.

Areas of Expertise

SAP BASIS Administration:

• Provide SAP Basis administration Support, Performance monitoring & tuning, Problem analysis & resolution, and other activities required to maintain system integrity and maximize uptime.

• SAP R/3 administration including installation, server upgrades, kernel upgrades and hot-pack applications.

• Implemented 2 end to end Implementation project and supported almost 5 years as 24x7 production support in mission critical business system running SAP R/3 running FI, CO, HR, MM modules,BW and APO systems.

• Establishing source and target systems, definitions of RFC destinations, monitoring and administration through RSA1.

• Problem analysis and resolution, and other activities required to maintain system integrity and maximize uptime.

• CTS landscape configuration, RFC definitions and transports administration.

• Expertise in User Administration with Authorization and Roles.

• Profile maintenance

• Client copy such as local client copy, client export/import and remote copy ,client deletion.

• Change and Transport Management system

• Background jobs management.

• Setting of Operation modes.

• SAP Database Administration

• System monitoring and generating daily and weekly monitoring reports.

• OSS support issues resolution and tracking.

• Created Standard operation plan for Sap R/3 Basis administration related task.

• Working knowledge on CUA, Enterprise Portal 6.0, BW, CRM, XI, SRM, APO Architecture and Live Cache Elements.

• Implemented DR Setup using Oracle Data guard method.

• Basic knowledge on Control-M Job Scheduling.

• Backup and recovery administration using brtools.

• Working knowledge on issue and change management tracking tool – Peregrine and IBM’s product ManageNow ticketing system.

Project Management Skills:

• Developed project plans, SLA, technical specification documents.

• Managed, coordinated and mentor sap basis administrators.

• Hard working team player with highly detail and work ethics oriented.

• Excellent communicator and skillful in presentation delivery.

• Experienced in preparing RCA for Severity 1 issues.

Skill Sets

ERP Package : SAP R/3 4.6c, 4.7, my SAP ERP2004,my SAP ERP2005

Front End : SAP GUI 6.20, 6.40

Operating System : Windows 2000/NT/98/XP/03, IBM AIX, LINUX

Language : Java, JSP, Servlets, EJB

RDBMS : Oracle 10g, Oracle 9i, SQL Server 5.0, DB2 8.2

Frame Works : MVC and Struts

Web & Application Server : Tomcat 4.0 & Weblogic 6.0

Trainings Attend

• Two months Corporate Training on SAP R/3 Basis from Optimal Solutions Integration Software Private Ltd, Bangalore from December 2004 to January 2005.

• Three Weeks Knowledge Sharing of Globe Nestle from Satyam Computers.

• One Week training on DB2 from IBM

• Five days training on SAP Net weaver (ADM200) from SAP INDIA.

Professional Experience

• Working as a Sr.Sap Basis Consultant with IBM Global Services Pte, Singapore through Encora Technologies Pte, Singapore from 13th September 2007 onwards

• Worked as a Sap Basis Consultant with Satyam Computer Services Limited, Bangalore from 10th July 2006 to 07th September 2007.

• Worked as a Associate Basis Consultant with Optimal Solutions Integration (Software) Pvt. Ltd, Bangalore From 01st December 2004 to 07th July 2006

• Worked as a Software Engineer with RASCOM Global Soft, Bangalore from 12th August 2002 to 29th October 2004.

Project 1:

IBM Global Services Pte, Singapore (http://www.ibm.com/sg/ )

Employed by Encora Technologies Pte, Singapore

Project: Schneider Electric Asia Pacific and USA (St-Louis) Datacenter

Designation: Sr.Sap Basis Consultant

Environment: ECC 5.0, BW 3.5, CRM 4.0, XI 3.0, EP 6.0, SRM 5.5, SCM 5.0, Solman 4.0, TREX 6.10, Content Server (MaxDB) 7.6, NW2004, NW2004s.

OS: AIX 5.3, Linux 2.6

Data Base: Oracle 9.2.0.7, 10.2.0.4, MaxDB 7.6

13th September 2007 – till date

Responsibilities:

• Implemented BW,EP,CRM,APO,SRM,XI,Solution Manager,MDM in respective landscape along with production supporting R/3 landscape for Schneider Electric, Singapore and USA

• Installation of BW 3.5 SR1,CRM4.0 SR1,ECC 5.0 SR1,XI 3.0 SR1,SLD,CUA,EP 6.0,CRM Java, CRM IPC server,SolMan4.0 on AIX 5.3 With Oracle 9i and 10G as Database.

• Managing 4 different system landscapes consisting of more than 20 servers each and multiple instances on production and preproduction server.

• Performed EhP1 upgrade on Solman4.0

• Oracle Database Upgrade from 9.2.0.7.0 to 10.2.0.2.0 for the systems like XI 3.0, CRM 4.0, EP 6.0, SLD, ECC 5.0

• Performed periodical refresh of Maintenance and Pre-Production from the Production Systems for ECC, BW, CRM, SCM,-LC and SRM

• TREX, Content Server and MaxDB Installation.

• Client administration including creation and client copy.

• TMS Landscape Configuration, RFC definitions and Transport administration

• OSS support issues resolution and Tracking.

• Client administration, Client copy, Post client copy procedures and Spool Maintenance.

• Performed Kernel upgrade to latest patch levels.

• Monitored and reported on monthly metrics including space usage, executed Early Watch reports.

• Analyzed short dumps, Monitored batch jobs for root cause analysis of delayed jobs.

• Performed Daily Monitoring.

• Excellent working knowledge of SCM and BW.

• Created and Maintained UNIX Shell Scripts (Basic Level) for monitoring purposes.

• Supported and Used Solution Manager 4.0

• Transport and Import of BW Source Dependent Objects.

• BW Specific system copy and SCM Live Cache Integration.

• Setting up sapconsole for RF Device

• OS level HA Failover Tested on all Production and Pre-Production Servers.

• Max DB recovery using BACKINT for ORACLE.

• Oracle DB recovery using brtools.

• Helped in migration of AIX servers from one data centre to other by taking care off applications with out any issue.

• Maintaining support and upgrade for more than 100 SAP and 20+ Non-SAP servers in each DATACENTERS.

• Implemented the GRC 5.3 RTA Installation ADD-ON in all environments with the post steps described in the notes.

DR Setup:

• Implemented Disaster Recovery Setup using Oracle Data Guard Method.

• Built the DR server with a recovery plan.

• Implemented SSH to transfer the logs quickly from Production to DR Servers.

• Developed the scripts to monitor the applied logs in DR Server.

• Involved in migration of conversion from Oracle Data Guard Method to PPRC setup.

Project 2:

Client: NESTLE

Period: 10th July 2006 to 07th September 2007

Designation: Sap Basis Consultant

Environment: SAP 4.7 Ext Set 2.0, NW2004, NW2004s, BW 3.5, CRM3.0, EP 6.0, APO 3.1

OS: AIX 5.2

DataBase: DB2 8.2.1

Organization: Satyam Computers Services Limited, Bangalore

Project Description:

FTS model is a methodology for providing markets 24x7 Basis support all year around. During the initial design and implementation phase of the Globe project, Basis activities were centralized in Vevey. To accommodate rollout to different markets in different time zones, Basis activities were strategically distributed to three Globe Centers

AMS: 07:00 – 16:00 & AOA: 15:00 – 00:00 & EUR: 23:00 – 08:00

Roles and Responsibilities :

• Handling the Performance related issues

• Performance Tuning

• Work Load Analysis,CPU and Memory Utilization, Buffer and Load Analysis

• Conducting health checks for the R/3 Systems in case of any issues.

• Handling User Tasks and performed major Tasks like DB2 Restore and Backup.

• Ist level of basic monitoring on BW, CRM, APO and Portal Systems.

• Local Client Copy on L& T Systems.

• Client Opening.

• DB2 Scripts Rollout on the effected systems.

• Subdirectories creation (Zdata) -> Used for shared area for every File based data exchange interface.

• Handled, 2nd level investigation on Automated Generated Tivoli tickets from TSM server.

Portal Administration:

1. Starting and Stopping the Portal Environment using SAP Startup Framework located on the desktop of all the portal servers + For clustered portal environment ->Stopping the IIS proxy servers through OASIS tool on the desktop before stopping the portal.

2. Setting up SSO for portals.(Exporting from the portal and importing to the SAP through STRUSTSSO2)

3. Testing the SSO from the portal to SAP Component.

4. Ist level portal monitoring

BIW Administration:

1. Administered BW Systems through administrator work bench RSA1.

2. Monitored performance of the BW systems using YMBW1.

3. Dump analysis.

Live Cache Monitoring:

1. Administered APO Live Cache through LC10

2. Start and Stop of Live Cache using LC10

CRM Administration:

1. qRFC monitoring -> Outbound Queue SMQ1,Inbound Queue SMQ2

2. Monitoring Bdoc Messages (SMW01 and SMW02 )

3. Monitoring CRM Middleware Portal related errors through SMWP

Position Handled in SATYAM COMPUTERS on NESTLE Support and Maintenance Project:

1. Dispatcher Unplanned (DU) Lead.

2. Acted as a Shift Lead on many occasions.

Project 3:

Client: I2 Technologies India Pvt. Ltd.

Period: 24th January 2005 to 07th July 2006

Designation: Associate Consultant, Sap Basis

Platform: SAP R/3 4.6c, 4.7EE

Server OS: Windows 2003 Advance Server

Database: Oracle 9.2

Organization: Optimal Software Integration Software Private Limited, Bangalore

Responsibilities:

• SAP Server Administration includes Development, Testing and Production servers. (Dallas, USA) and local SAP end-user support.

• Installation of SAP R/3 4.7 EE on Oracle database on Windows 2003.

• CTS Landscape configuration, RFC definitions and transports administration.

• Client Creation, Client Copy, Client Export / Import

• Client Administration.

• Profile Maintenance

• Responsible for creating users and maintain user and profile administration for developers and functional consultants with defined roles

• Maintaining authorization for internal customers, determining and assigning which authorization are required for them. (PFCG)

• Direct contact with functional counterparts collecting current R/3 security requirements.

• Tuning the applications by monitoring the job progress and trace of jobs to identify bottlenecks in performance.

• SAPDBA and Brtools tool was used for managing day to day Oracle database administration duties.

• Helped developers by analyzing short dumps and identifying bottlenecks

• Applied Support Packages..

• Spool Administration.

• Actively maintaining SAP instance - operation modes, work processes, background jobs system profiles. Adapt parameters to increase performance and enhance.

• Preparing Reports for Daily Check Lists:

 Check the status of all Server

 Process Overview with status running or waiting

 Check for old lock entry of prior days

 Update records, look for any failed update

 Check System Log for error, warning, message, DB problem etc.

 Review for unknown of different user ID and terminal

 Look for spool jobs that have been “n process” for an hours)

 Look for excessive number of ABAP dumps and there nature

 CPU Utilization, Disk With highest response time, Memory Utilization etc

 Operating System monitoring

 Transaction Response

 Performance of the Server

 Performance of the application

Project 3:

Recruitment Data Management Systems:

RDMS is software, which helps big consulting companies to maintain all the vendors. It maintains all the detail of the particular vendor. Since it is Web Based Application, Vendors can see all the information such as Requirement assigned, Short-listed, Rejected, Uploading of Consultants CV, Bill details etc.

Period: August 2003 to October 2004

Environment: JSP,Servlets,Tomcat,Oracle 8i,Eclipse3.0

Organization: RASCOM Global Soft, Bangalore

Responsibilities:

As a developer and Oracle DBA:

• Getting User Requirements from the Client.

• Preparation of HLD, LLD, TestCases

• Coding

• Preparation of Test Cases

• Execution of Test Cases.

As a Oracle DBA,

Taking care of user administration, backup and day to day activities.

Project 4:

Task Scheduler:

Task Scheduler is software, which helps users to organize day-to-day activities in a proper and efficient Way. Task Scheduler also helps the user to track the activities already Planned

Task Scheduler caters into any individual or an organization. Task scheduler users can assign tasks to individuals or group, track and manage it and it reminds the users about their daily tasks

By using task scheduler, one can organize work to be done according to priority and use time more effectively and reduce stress. And individuals can set goals/objectives and accordingly

Plan time for them by using task scheduler an organization can keep track of its employee‘s work effort spent by them on work evaluate time spent on hourly basis, and accordingly manage time effectively.

Period: August 2002 to July 2003

Organization: RASCOM Global Soft, Bangalore

Team Size: 6

Designation: Programmer Trainee cum Programmer

Responsibilities:

• Getting User Requirements from the Client.

• Preparation of HLD, LLD, TestCases

• Coding

• Preparation of Test Cases

• Execution of Test Cases.

Environment: JSP,Servlets,Tomcat,Oracle 8i,Eclipse3.0

Education:

Degree: BE. Computer Science Engineering

Universitry: Madras University

College: Bharath Institute Of Science and Technology

Year: April 2002

Percentage: 70%

Higher Secondary (XII STD): Sri Ramakrishna BHEL higher Secondary School, Ranipet

Board: State Board

Percentage: 83.1 %

Year Passed: April 1998

High School (X STD): Government High School, Ranipet

Board: State Board

Percentage: 81.4 %

Year Passed: April 1996

Personal Details

Father’s Name: D.Govindaraj

DOB: 02 June 1981

Sex: Male

Martial Status: Married

Nationality: Indian

Languages Known: English, Tamil, Hindi, Kannada

Passport No: E2626827

Issued Date and Place: 03 Sep 2002, Chennai.

Valid Up To: 02 Sep 2012

Visa Status in Singapore: Holding PR Status in Singapore.



Contact this candidate