Manager Oracle

Pratap Singh Negi

Citizenship : Indian

Date of birth : 02 July 1972

Passport : Valid Through 2021

Profile at a Glance

Profile

Approximately 23 years of professional experience in the IT industry with 15 years in Oracle Database administration and Oracle E-Business Suite including installation, database configuration & Creation, backup and recovery, Performance tuning, Oracle RAC and Data Guard.

Expert in areas of Oracle 11g/10g/9i/8i, RAC/ASM/ACFS, Exadata x3,x4,x5 and Golden Gate Implementation Specialist, OEM 12c/13c.

Expertise in Oracle E-Business Suite - 11i/R12 including installation, upgrade, patching, cloning, troubleshooting, tuning and printer setup.

Experienced with tools/utilities: AWR Reports, Stats pack, OEM Grid Control, SQL* Loader, Log miner, data pump, export/import, Golden Gate 11.1

Production support given to the system 24x7. Ability to work beyond regular hours. Carried primary and secondary support roles with cell phone rotation to support during weekends, Holidays and beyond regular hours.

Experienced in Banking, Finance, Telecom, Insurance, Healthcare and Aviation industries.

Technical Lead/Project Management experience.

Experienced in Production DBA support.

Experienced in UNIX, Sun Solaris, Linux, Windows 2003/XP/2000/NT .

Projects

Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault, and Database Firewall and audit alert report, data masking and data redaction.

Implemented TDE column encryption and TDE tablespace encryption use a two-tiered, key-based architecture.

Actively participate with project management team in strategic planning, goal setting and monitoring, providing status updates on a regular basis.

Full cycle implementations of Oracle ERP applications 11i and R12.

Implementation of monitoring/management tools for databases and applications, e.g. OEM, Grid Control etc.

Oracle E-Business Suite /Applications - Performing functional and technical work mainly within the Customer Relationship Management (CRM), Sales Force Automation (SFA), and Self-Service modules of Oracle E-Business Suite (EBS) (Oracle Applications / Oracle Financials for Enterprise Resource Planning (ERP))

Certifications

Oracle Database:

Oracle Certified Professional (OCP) - (SQL, PL-SQL) (Oracle Corp)

Oracle Certified RAC administrator - (Oracle Corp)

Others

ITIL® Foundation Certified.

PRINCE2® Certification

Trainings

Oracle / Project Management

a)11gR2 RAC, G.G. -Oracle Corp, New Delhi

b)DBA 9i from Oracle Corp, New Delhi (Oracle Corp New Delhi Dec 2004)

c)Project Management Using MS Professional (Kokoroe Business Solutions Pvt. Ltd New Delhi)

d)Exadata – Oracle Corp, New Delhi

Organizational Internal Trainings

a)Leadership Skills Build Winning Team

b)LeadershipSkillsPrincipals1

c)LeadershipSkillsPrincipals2

d)Ethical Leadership Skills

e)Measuring Team Performance

f)Mentoring Others

g)Position Yourself To Lead

h)Dynamic Business Presentations

i)Coaching In The Workplace

Key Skills

Oracle Applications:

12.1.3

11.5.10R2

Project Management Tools:

iProjects.

Primavera.

DB Tools:

Oracle Developer Suite.

TOAD.

SQL Developer.

UNIX Box Tools:

Secure Shell.

Putty.

Incident Tracking Tools:

Remedy.

Kintana.

Service Center.

Operating Systems:

Microsoft Windows NT Server & Exchange

Citrix Metaframe

Microsoft SMS/SQL Server

Microsoft DHCP Server

UNIX

Hardware:

Compaq Servers

Compaq SAN

Alpha

Intel

Dell

Sun Microsystems

Performance Tuning Tools:

SQL Tuning LAB

Statspack

TKProf

TOAD

Permanent Address :

H.No :- 16 G.F. Neelam Vihar, Sector 14 Kaushambi

Ghaziabad, Uttar Pradesh – 201010

Phone : +91-120-*******

EMPLOYMENT SCAN

Worked for renowned clients:-

CAFOS,- UK, Edexcel, UK US, IFFCO - United Arab Emirates, McDonalds - ( US - 118 countries and territories around the world), Bharti Airtel ( Indian global telecommunications services company, 18 countries across South Asia and Africa), NAB ( Australia Banking), TIAA - (US - Fortune 100 financial services organization)

Oct 2015 onwards

InterGlobe Technologies Pvt Ltd (IndiGo Group) Doha Qatar

Technical Consultant

Oracle

Oct 2014 to Oct 2015

HCL Technologies Ltd, Noida India

Sr Consultant

(Oracle)

April’11 to Oct’14

IBM India Pvt Ltd,

Sr IT Specilast(Oracle)

Sept’10 to March’11

Fujitsu Consulting India Pvt Ltd

Sr IT Consultant ( Oracle Application/ Database

Feb’09 to Sept’10

Sandhar Technology Ltd

Manager – IT

May06 to Feb’09

Global Trade Cracker Ltd

IT Head cum DBA

March’99 to May’06

Bharti Airtel Ltd

IT Head cum DBA

Feb’98 to Feb’99

Sew Engineering Works Ltd

IT Officer

May’96 to Jan’98

Precision Electronics Ltd

Asstt Programmer

Professional Snapshot :

InterGlobe Technologies Ltd – (Oct 2015 Till Date )

Technical consultant ( Oracle / IT Infrastructure)

Client – SITA AERO – Doha Qatar

Working as Technical Consultant Responsible for managing the IT Infrastructure and Oracle Database management.

Responsible for the following :-

The client is having databases (Production, Development, Data Warehousing, and UAT) on different versions ranging from Oracle 10g to Oracle 11gR2 RAC with Linux. All these databases are mission critical and support 24 x7 project delivery and BAU support for Oracle database stack.

Just completed the migrations project (11gr2 to 12c Upgrade and migrated to Linux OS) with in-house applications.

Researched new technologies and calculated future needs to achieve accurate capacity planning.

Responsible for all aspects of the database design, deployment, administration and its management and operational functions and proactive monitoring and troubleshooting.

Developed, implemented and monitored service level agreements with staff and customers, ensuring compliance and quick resolution of specific issues. Achieved 99% system availability and 98% customer satisfaction for three years.

Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault, and Database Firewall.

Created and implemented disaster recovery plans and procedures for Data Center, including hot sites for mission critical applications.

Setting up the KRA’s and reviewing the same for team appraisal.

HCL Technologies Ltd. NOIDA – (Oct 2014 To Oct 2015 )

Consultant.

Working as Consultant Managing and supporting to reputed clients across the globe along with competency management activities.

Responsibilities Included the following :-

Ensuring that required methodology is strictly adhered to. Handling various technical aspects like project documentation, system design & integration, monitoring critical paths & taking appropriate actions.

Facilitated ongoing communication with internal project team to assist with prioritizing workload to ensure milestones are met.

Reviewing existing services, negotiating with the customers, monitoring the Service Level Agreement (SLAs). Implementing service improvement policy and establishing priorities & planning for service growth.

Implementing project plans within deadlines, defining best practices for project support and documentation.

Converting business strategies into structured projects with deliverables identified. Developing and deploying of key execution strategies across businesses.

Conducting periodic external/internal customer review and incorporate feedback received.

Conducting periodic reviews with key stake holders.

IBM India Pvt Ltd, India – (Apr 2011 To Oct 2014 )

Project Manager cum Technical Specialist.

Working as Project Manager cum Technical Specialist, Responsibilities included the following:

Overall Oracle Practice Management and Serve as Steering Committee member on strategic projects.

Support the sales cycle through scoping and approval of engagements, Executive-level prospect meetings and Solution reviews

Responding to RFPs (Request for Proposals).

Ensure team billable utilization targets are met.

Implementing service improvement policy and establishing priorities & planning for service growth.

Negotiating Contracts with Local Suppliers for New Data centre DR site readiness.

Developing and deploying of key execution strategies across businesses.

Converting business strategies into structured projects with deliverables identified.

Reviewing existing services, negotiating with the customers and producing & monitoring the Service Level Agreement (SLAs).

Overseeing delivery of projects from conceptualization to delivery within preset budgets and deadlines.

Installing and configuring the Oracle database for internal projects.

Responsible for project staffing and resource scheduling on a broad range of consulting engagements.

Provide coaching and mentoring to assist in resources' career development.

Handle day-to-day administrative tasks such as: vacation scheduling, expense reports, time entry, etc

Manage project portfolio to ensure quality, on-time and on-budget implementations using a mix of global resources.

Fujitsu Consulting India Pvt Ltd – (Sept 2010 To April 2011 )

Sr Consultant – Oracle Applications and Database

As an APPS DBA responsible Offshore Production support & Monitoring of Oracle R12 Apps for a major UK based outsourcing client. Tasks included Various Instance refreshes, Database administration tasks.

As a L3 support member of Oracle Apps DBA Team in India we are supporting 20+ customers remotely.

Team is responsible for 24X7 supports for working on alerts and issues, instantly coming from a monitoring tool, named RMON, developed by Fujitsu Projects Team.

Currently involved in working with tickets for patching, cloning, migration and tuning of Oracle Database.

Handling more than 100 instances ranging from 50 GB to 1 TB.

Working on ticket assigned by client DBA.

Assisting in the administration and day-to-day operations of different Databases to provide user support.

Working on different tasks on priority basis.

Applying patches (DB+Applictions) after PPA.

Performed the database up gradation from lower versions to higher versions

Cloning of Oracle Application instances with rapid clone.

Checking Daily Backup, Disk Space management and user management.

Modifying Shell Scripts to cater the client's adhoc requests.

An excellent team player, have very good relationships with the various Application teams and the Infrastructure teams.

Day-to-day Siebel support for operations, monitoring and problem resolution

Coordinate and support release deployment activities for Siebel applications

Work closely with all teams to deliver highly available and scalable services for Siebel with minimal/zero downtime

Sandhar Technology Ltd, Gurgaon - Feb'09 to Sept'10

Manager - IT

Ensuring smooth running of the system on the whole

Database upgrade 10.2.0.2 to 10.2.0.4 & 11g

Performance tuning of database and application tier

Backup & recovery strategy implementation

Database administration, Security and space management activities

Patch work and maintenance of Oracle Applications

Cloning of application & Database

System Administration tasks for Application tier

Tuning the Concurrent Manager

Project Setup

Oracle Applications 12.0.4 EBS Suite.

Database on Oracle 10g (10.2.0.4) RAC setup.

Operating System Sun Solarie 5.10 & Windows Series Servers

SAN Storage

Backup Software - VRTS NetBackup

Above 7000 approx. application users spread in 24 circles across the world

Global Trade Cracker Ltd – May'06 to Feb'09

IT Head cum Oracle DBA

Installing Oracle 9i/8i on Red Hat Linux Adv. Server 2.1 and Fedora Linux, MS-Windows NT/2003

Plan and perform backup/recovery

Handle and optimize Export/Import of Data, Load data using SQL * Loader

Tuning the Database for Peak Performance.

Maintaining high availability on servers using techniques such as Oracle Parallel Server’s

Collaborate with the system administrator to analyze the requirement /up-gradation /purchase of existing and new hardware, software products.

Main Activities

Troubleshoot hardware, software and network operating system

Be familiar with all hardware and software

Be familiar with network operating system

Provide orientation to new users of existing technology

Train staff about potential uses of existing technology

Train staff about new and potential use

Provide individual training and support on request

Provide recommendations about accessing information and support

Maintain current and accurate inventory of technology hardware, software and resources

Troubleshoot all technology issues

Maintain log and/or list of required repairs and maintenance

Make recommendations about purchase of technology resources

Research current and potential resources and services

Provide network access to all staff and students

Install work stations

Connect and set up hardware

Bharti Healthcare Ltd – March'99 to May'06

IT Head

1. Manage information technology and computer systems

Plan, organize, direct, control and evaluate the operations of information systems and electronic

data processing (EDP)

Develop and implement policies and procedures for electronic data processing and computer

systems operations and development

Meet with managers to discuss system requirements, specifications, costs and timelines

Hire and manage information systems personnel and contractors to design, develop, implement,

operate and administer computer and telecommunications software, networks and information

systems

Control the computer systems budgets and expenditures

2. Ensure technology is accessible and equipped with current hardware and software

Main Activities

Troubleshoot hardware, software and network operating system

Be familiar with all hardware and software

Be familiar with network operating system

Provide orientation to new users of existing technology

Train staff about potential uses of existing technology

Train staff about new and potential use

Provide individual training and support on request

Provide recommendations about accessing information and support

Maintain current and accurate inventory of technology hardware, software and resources

Troubleshoot all technology issues

Maintain log and/or list of required repairs and maintenance

Make recommendations about purchase of technology resources

Research current and potential resources and services

Provide network access to all staff and students

Install work stations

Connect and set up hardware

Load all required software

Provide network accounts and passwords as required

Monitor security of all technology

Install and maintain Foolproof and passwords

Input and maintain IP addresses

Advise staff of security breach and/or change in password or security status

Ensure installation of lock out programs

Identify and prepare hardware for disposal when appropriate

Ensure hardware is stripped and secured before disposal

4. Perform other related duties as required during working hours

Sew Engineering Works Pvt Ltd – Feb'98 to Feb'99

IT Officer

Assist technology users in identifying and implementing systems improvements.

Troubleshoot hardware, software and network operating system

Be familiar with all hardware and software

Be familiar with network operating system

Provide orientation to new users of existing technology

Provide network accounts and passwords as required

Monitor security of all technology

Precision Electronics Ltd – May'96 to Jan'98

Asstt Programmer

Write programs in a variety of computer languages, such as Foxpro++ and Cobol and C++.

Update and expand existing programs.

Debug programs by testing for and fixing errors.

Build and use computer-assisted software engineering (CASE) tools to automate the writing of some code.

Contact

Tel : +974-******** (Qatar )

E-mail : ******.****@*****.***

Contact this candidate