Siebel DBA

[pic][pic][pic]

MANDAR R. KHATAVKAR

Contact (USA): 812-***-**** (Cell), 812-***-**** (Home)

Email: *********@*****.***

PROFESSIONAL SUMMARY ...

IT Professional as ORACLE Database Administrator (DBA) & ORACLE SIEBEL

Admin

Overseas IT experiences >>>

* Since June, 2012 placed at client's location at Columbus, Indiana, USA as

a full-time employee with KPIT Infosystems Inc. on H1-B visa.

* Year 2010, worked at onsite (Columbus, Indiana, USA) for 3 months as

Oracle DBA & Siebel Admin.

* Year 2008, as a DBA, worked with client "BestSeller A/S" at location

Brande, Denmark.

* Valid Visas:- USA > H1B & B1/B2

PROFESSIONAL SYNOPSIS ...

. "ORACLE CERTIFIED PROFESSIONAL" OCP - DBA for ORACLE 11g.

. Total IT Professional Experience 12+ years.

. Was associated with KPIT Cummins Infosystems Ltd. (Pune, India) since

Nov. 2007 (5+ Yrs.)

EDUCATION ...

. ORACLE CERTIFIED PROFESSIONAL Certification for ORACLE 11g OEM

in Dec. 2011

. ORACLE CERTIFIED PROFESSIONAL Certification (upgrade) for ORACLE 11g DBA

in Aug. 2011

. ORACLE CERTIFIED PROFESSIONAL Certification (upgrade) for ORACLE 10g DBA

in Nov. 2008

. BUSINESS MANAGEMENT as P.G.D.B.A. from SYMBIOSIS (Pune)

in Dec. 2005

. ORACLE CERTIFIED PROFESSIONAL Certification for ORACLE 9i DBA

in Aug. 2005

. ORACLE 9i DBA from SQL Star International Ltd. (Mumbai)

in Apr. 2005

. ORACLE / V.B. from SSI Ltd. - Software Solution Integrated Ltd. (Mumbai)

in Feb. 2000

. GNIIT in Software Technology & Systems Management (3 yrs.) from NIIT

(Mumbai) in Sep. 1999

. Bachelor of Science (B.Sc.) from Mumbai University

in May 1998

TECHNICAL PURVIEW ...

Operating Systems : Windows-x, UNIX, Oracle Solaris 10, Linux

(CentOS)

Database Technologies : ORACLE 9i, 10g, 11g.

Oracle CRM Technology : SIEBEL CRM 8.1.1.1 to 8.1.1.5

OS (UNIX) Technologies : Vi Editor, Shell Scripting, Script Automations,

Crontab, FTP/SFTP etc.

Other tools used : Lotus Notes 8.5, TOAD 9.7, BMC Remedy software 7

(Ticketing tool),

BMC Blade Logic, PuTTY session, X-Shell 3, Appworx 6,

WinSCP 2.3,

VNC Viewer 4.0 etc.

ORGANISATIONAL EXPERIENCE ...

Duration Organization Location Role/Profile

Jun'12 - ... KPIT Infosystems Inc. USA Sr. Oracle DBA

& Siebel Admin

Nov'07 - May'12 KPIT Cummins Infosystems Ltd. Pune Tech Lead as

Sr. DBA & Siebel admin

Jun'06 - Nov'07 RELIANCE InfoSolutions Pvt. Ltd. Mumbai Oracle DBA

(Group Company of Reliance Industries Ltd.)

Jan'03 - May'06 BRUDERER Presses India Pvt. Ltd. Mumbai S/w

Development &

(Swiss MNC in Engg. Industry) Database

Administration

Nov'00 - Dec'02 VOLTAS Limited Mumbai Software

Development

DETAILS OF PROFESSIONAL EXPERIENCE ...

ORGANIZATION : KPIT INFOSYSTEMS INC., NJ, USA

Client : CUMMINS INC., Columbus, Indiana, USA

Designation : Senior Oracle DBA & Siebel Admin

Oracle DBA activities >>>

o New database build with all required and requested configurations &

optimizations.

o Deal with performance issues of Siebel application and database for

Production and non-production environments.

o Investigations of Root cause analysis and optimize the performance and

validate.

o Database standardization drive w.r.t. various important parameters and

checks.

o Automations based upon the requirements of the project.

o Setting up and/or defining new processes after analysis and

presentations.

o Coordination & meetings with application support team for requirements of

deployments and changes.

o Coordination & meetings with offshore team members for on-going

activities updates, knowledge transfer, sharing of thoughts & technical

experiences and handovers.

o Database / Schema / table refreshes along with pre & post requisites.

o Coordination with different dependent support teams like Unix, storage,

windows, architect teams.

o Defining process and strategies of database backups & frequencies.

o Configuration & set-up of traditional & RMAN database backups &

validation.

o Managing, maintaining & troubleshooting of Database backups.

o Testing backup restoration scenarios with storage team.

o Investigation and planning of removing database fragmentations.

o OEM set-up and configuration and mapping OEM alerts to remedy.

o Validation / testing of schema or table level reorg activities.

o Monitoring of BMC Remedy tickets and actions accordingly.

o Setting up and monitoring database server crontab jobs.

o Database Administration and Monitoring with automations and OEM.

o DBA Support during major project go-lives and upgrade releases.

Siebel Admin activities >>>

o Routine Siebel admin activities like SRF compilations, Repository

migrations, bouncing of Siebel application etc

o Full and/or Incremental compilations.

o New Siebel environment build with BMC Blade logic jobs.

o Coordination with unix & storage team for all pre & post requisites.

o User creations as per defined process.

o Coordination with application support teams for planned/unplanned

outages, project go-lives & upgrade releases.

o BI Publisher installations and configurations for Siebel.

o UPK (Oracle's User Productivity Kit) configurations & integration with

Siebel applications.

o Performing Siebel UCM Admin activities.

o Troubleshooting on Siebel email response issues and present RCA.

o Coordination with application support team, business owners & lotus notes

team on email issues.

o Work upon deployment checklists and configuration changes in Siebel along

with application support team.

o Creation of new objects in Siebel like users, responsibilities, profiles,

workflows, templates etc.

o Monitoring of Siebel components with server manager and bounce if

required.

o Defining new process and standards with business and owners approvals.

ORGANIZATION : KPIT CUMMINS INFOSYSTEMS LTD., Pune, INDIA

Client : CUMMINS INC., USA

Designation : Tech lead as Senior Oracle DBA & Siebel Admin

* ONSITE Roles & Responsibilities

Duration : 90 days (Approx. 3 months) 12 July 2010 to 10 Oct. 2010

Role : Onsite coordinator as Oracle DBA & Siebel Admin

Oracle DBA activities >>>

o Performing routine Core DBA activities for Siebel databases.

o Gather Siebel schema level statistics.

o Setting up hot & cold backup scripts and file-system maintenance

scripts in cron jobs.

o Database parameter comparisons between Siebel databases.

o Taking databases in Archive & No-Archive log mode and changes in

database parameters.

o Worked with security team for getting security exception approved for

various database issues like port opening for TNS entries and DB links

etc.

Siebel Admin activities >>>

o Understanding Siebel architecture, hands-on experience in configuring

Siebel environments & Siebel Tools.

o Worked with BMC Blade Logic jobs for building-up new Siebel

environments.

o Bouncing of Siebel environment for SRF migrations and running browser

genb script.

o Full / Incremental compilation of SRF.

o ODQ / "Siebel Data Quality" system recreation activity using VNC

viewer.

o Siebel application level activities like user creation, assigning

position & responsibilities etc.

o Monitoring of Siebel components and various tasks performed at Server

Manager.

o Stopping and starting of ISS / IDS services.

o Siebel Repository Migration activities to development, staging and

production environments.

o Troubleshooting at Siebel app server and database point of view

w.r.t. error log files.

o Bouncing of web servers to resolve browser related issues like "site

minder" etc.

o Running & monitoring of Siebel jobs at application level.

o Generation of user level DB extracts.

o Siebel related Oracle SR creation & follow-up with Oracle for the

same.

o Co-ordination with DBA/other support teams for planned/unplanned

outages.

* OFFSHORE (Pune, INDIA) Roles & Responsibilities

Technical task details >>>

o We support approx. 800 database instances on Unix OS which includes

Production, Staging & development database environment.

o Coordination and follow-up with Oracle support (metalink) for

respective SR requests.

o Coordination and discussion with users and client for respective

database requests.

o File system management at OS level in coordination with Unix Team.

o Database Space management - Tablespace monitoring & managing

tablespaces below threshold limit by resizing data files or adding

more datafiles.

o File system High Utilization & follow-up for cleanup activities etc.

o Identifying and sorting DB Link issues.

o As per ORA errors, identifying the requirement & changing database

parameters and perform DB bounce.

o Checking and validating all Invalid Database objects and related

coordination with user.

o Analyzing Schema, Tables, Indexes etc to improve database

performance. Also made automation of respective shell scripts for the

same with email notifications.

o Server reboot activities and required coordination with other teams

like Unix, Application team etc.

o Schema / Table level and query based normal Export & Import and also

Data Pump Export & Import utility, also worked with Export & Import

of objects from lower version of Oracle.

o Script deployments & code migrations as per user request with valid

approvals for production databases and giving troubleshooting

suggestions to users, if required. Keeping awareness of Cummins

processes too.

o User management tickets which includes user creations, giving grants,

roles and assigning profiles as per the request and process with

valid approvals.

o Schema & Table level data Refresh taken as a project activity.

Refresh is done with the export-import approach as disabling

constraints & triggers, dropping indexes, truncating tables and after

Import is done, enabling the same constraints & triggers with index

creation.

o DB & Server level performance monitoring with OEM for any performance

issues to trace top activities, top sqls etc. In case of performance

related issues w.r.t. SQL tuning, using OEM plays importance role in

identify badly affecting SQL queries which causes Table level locks

and Dead locks etc. Also it's useful to identify various server,

Databases, Agents mapped to concern OEM and their respective status.

We also use OEM to set "Black-out" for Server Reboot activity.

o Using TOAD as DB tool for various requirements of Source code &

Script deployments related tickets and for using session browser for

session level monitoring. Also it's useful to login to databases

w.r.t. TNS string in cases of not having respective server logins.

o Tablespace Reorg activity done on many Production databases for

Tablespace space management.

o Setup various Email Alerts & Automations and its notifications as a

part of Value-Additions to the project. We need to present all kind

of Value-Additions that we do; to our Client in our monthly meetings.

o Appworx version 6 is a job scheduling third-party software, we use

for execution of Batch jobs, Chains etc. we get automated tickets and

email if any chain or job fails, we check in Appworx for respective

log file and fix the same accordingly.

Non-Technical task details >>>

o Excellent written, verbal communication and team coordination skills.

o We are using "BMC Remedy 7" as a ticketing tool to resolve client's /

user's project & issues specific ticket requests. We have to make

sure tickets should not to go out-of-SLA as well as keep control on

SLA ratings.

o I have consistently achieved to always be in TOP 5 DBAs in case of

"Performance & Productivity index" of every month. Our managers

releases Performance & Productivity index every month for our DBA

team w.r.t. various parameters & statistical calculations.

o I have worked as a "Shift Lead" for a long time. Shift Lead has added

role & responsibility of monitoring Remedy ticket queue, taking lead

role in handling escalations & also assigning to respective

resources.

o Along with Rotational shift-wise DBA support in 3 shifts, I am

working for 24x7 On-call DBA support to our client w.r.t. tickets and

planned / scheduled activities. Also providing Extended DBA support

for "On-call" weekends and sometimes work-from-home, after working

hours too.

o Project Transitions ( Knowledge Transfer ) givens to our internal DBA

team. This Transition included, know-how of respective DBA

activities, processes, Point-of-contacts & knowledge of real-time-

scenarios.

o Data consolidation project activities for client based Project-wise

analysis of mapping of processes, documentation, automations,

enhancements, value-additions, Remedy tickets v/s SLA impact analysis

etc.

o Attended Six Sigma training & worked for Six Sigma Project named

"Establish a framework for Reduction in Number of databases used in

Engine Business Unit (EBU)". Process benefits: Clubbing of small

databases to have greater control and monitoring, thereby reducing

the efforts and costs required in maintaining these databases.

Financial benefits: Annualized saving = US $1,18,800 approx.

Reduction in the number of databases handled will decrease the

efforts and time required to monitor and maintain these databases. As

a result, the monthly cost of maintaining these databases will be

reduced.

o SOX activities - working on SOX reporting & SOX audit.

Sox is a audit concept implemented on Production databases which

enables to capture all database level DDL's and w.r.t. ticket details

etc. we have quarterly SOX audits which includes all SOX details of

each database for DBA/DDL/DML & Public accesses. I have done a

successful SOX Implementation on many Production Databases.

Client : BESTSELLER A/S, BRANDE, DENMARK

Designation : Oracle Database Administrator

* ONSITE ASSIGNEMENT >>>

LOCATION : BRANDE, DENMARK

Duration : 87 days (Approx. 3 months) 1st March 2008 to 26th May

2008

Role : Onsite coordinator DBA

o Coordination between Offshore DBA Team, Developers, TL's & client

DBAs so as to get all deployments done successfully on time.

o Discussions & Group meetings with Client DBAs regarding new project

approvals, suggestions & project related performance issues.

o Participation in decision making as Onsite DBA & taking lead role in

solving Database related issues and presenting strong technical

initiative as Onsite DBA and carry out successful coordination.

* OFFSHORE Roles & Responsibilities as a DBA >>>

o Monitoring of Database Cloning processes.

o Database monitoring with automated scripts, Views & OEM.

o Database monitoring for Top SQL queries & space managements & work

load management.

o Participation in project related SCRUM meetings and performing SCRUM

related tasks.

o SCRUM related Script deployment follow-up & coordination with onsite

DBAs

o As per Standard Document, Script checks, Code review & Peer review

of project related scripts & Deployment coordination with Developers

& DBAs.

o Reviewing DB Design and understanding "Requirement Analysis (RA)"

documents & Assisting in "ER Diagram"

o SQL Query Performance Tuning with various approaches to tune the

query. Study and analysis of Explain Plan & Trace files for SQL

Query optimization and Tuning.

ORGANIZATION : RELIANCE InfoSolutions Pvt. Ltd. (Group Company of RELIANCE

INDUSTRIES LTD.)

Project : Reliance Retail - IT Operations DBA Team

Designation : Oracle Database Administrator

* Roles & Responsibilities as a DBA >>>

o Monitoring of Archive Log files and Space management.

o Monitoring of Alert log file for checking DB errors or warnings.

o Managing Database downtime for various offline activities and

Shutdown & Startup of database.

o Changing Archive Log Mode status from No archive log mode to Archive

log mode.

o Tablespace Management like adding or resizing of Data files.

o Monitoring of Tablespace utilization, space allocation, space

requirement & % full.

o Monitoring of Database thru Oracle Enterprise Manager (OEM).

o Net search on various ORA errors and rectification.

o Monitoring Database with Data Dictionary & Dynamic Performance

Views.

o Monitoring of Active sessions, CPU usage, Top activity events, DB

Hang analysis.

o Check Alert History for Archive Area Used, Database CPU Time, Generic Alert Log Error Status, Tablespace Space Used for

status as Critical or Warning.

o Creating Users on tablespaces and granting Privileges.

o Create & Drop Table Partitions to make free space available on

tablespaces.

o Monitoring of Scheduled Task scripts using Crontab.

o Executing various PL/SQL script files such as, Procedures, Packages,

Triggers, Views on respective Databases on request from Application

Development Team.

o Transfer of partitioned backup files to another backup location thru

FTP.

o Taking Export Dumps / backups of various Schema and Tables.

o OEM / DBConsole installation, configuration on windows.

o Scheduler scripts made for all Servers for Monitoring of - Archive

Logs, Tablespace utilizations, Alert log file (tail) details, Report

of Database up or down.

o Checking of Listener Logs file size status, whether its exceeding

allocated size or not.

o Controlling and monitoring user access to the database.

o Maintaining archived data on tape. Manual backup of Archive logs on

Tape.

o Planning of Database growth and changes.

* Other than, DBA activities >>>

o Server & Client Installations and Database setup of Reliance Retail

Branches.

o Technical support to Reliance Retail software at Database as well as

Application level.

o Working with TOAD for Database troubleshooting & Database queries

etc.

o Visits to Reliance Retail outlets for Technical troubleshooting.

ORGANIZATION : BRUDERER Presses India Pvt. Ltd. (Swiss MNC in Engg.

industry)

Profile : Software Development & Database Administration

* Software Development of Customer Relationship Management (CRM) Software:

Platform : Visual Basic 6.0 and Oracle 9i

Various utilities & modules of CRM that we developed are; Contact

details of Company, Customer and Competitors., Machine technical

details, Machine complaint history, Quotation generation, Machine

price-list handling, Enquiry register, Company visit reports, Company

Vouchers, Petty cash updations, Tour Instruction reports, etc.

Basic DBA Activities included are, Monitoring Database Alert logs,

Tablespace alteration and checking utilization, DB Space management,

Backups & Export dumps, Monitoring of All DB activities thru OEM,

Managing Users and granting roles & Privileges, etc.

* Customer Satisfaction Survey (Software Development & pre - post Survey

Analysis):

Software Development: Platform : Visual Basic 6.0 and MS Access

Analysis of post-survey results of Customer Satisfaction on various

parameters along with special reporting outputs as well as the

graphical presentation etc.

Pre - post Survey Analysis:

My contribution included, identifying or finding out Customer

requirements / needs and accordingly the designing and preparation of

CSS format, implementation & post implementation follow-up.

ORGANIZATION : VOLTAS LIMITED (Cooling Appliances Business Division)

Profile : Software Development

o Complaint Management System Platform : Visual Basic 6 and

Oracle 8i

o Product Technical Specification System Platform : Visual Basic 6

and Oracle 8i

o Service MIS Reports Platform : Visual Basic 6 and MS

Access

o Satisfaction Survey Analysis Platform : Visual Basic 6 and MS

Access

PERSONAL DETAILS ...

Address : 3219, North Country Brooke Ct., Columbus, Indiana - 47201,

USA

Date of Birth : 29th September 1976

[pic]

Contact this candidate