+918********* / 787-***-****

acdcgh@r.postjobfree.com

CAREER OBJECTIVE

Seeking an opportunity for professional growth and increased responsibility

towards handling challenging projects in an organization with a vision

towards the future, induce an atmosphere conducive to the sharing of ideas,

learning, and growth as emerging technologies grow, and build highly

motivated and committed team and there by contributing to the group to a

higher and higher degree technically and technologically.

SUMMARY

. Oracle Certified Consultant with 13+ years of experience that includes

developing, deploying, administration, and managing Databases in

Production environments ranging in sizes up to 20TB on various

platforms Solaris, Unix, AIX, Linux and Versions include 8,9i,10g,11g

and 12C.

. Results-oriented DBA Manager / Senior DBA with experience and proven

track in managing technology and Operation team.

. Proven strength in managing On-site resources, meeting goals and

producing results oriented team efforts through excellent

interpersonal, motivational and communication skills.

. Area of Expertise mainly includes Database support & maintenance,

installation, configuration, administration, security management,

memory management, backup, recovery, cloning and up-gradation,

database design in RAC and Non RAC environments.

. Exposure in Oracle Database Server Performance Tuning.

. Exposure in making Standby Databases, Cloning.

. Exposure in documentation as per client requirement.

. Maintaining Oracle APPS database with all flavor of oracle business

suits applications (11.5.9 to 12.2.2)

. Currently working with Infogain Systems Pvt Ltd, Pune.

PROFESSIONAL CERTIFICATION

Oracle Certified Professional (10g DBA)

EDUCATION

Bcom ? Mumbai University ? Mumbai?

MCA ? IGNOU?Delhi Board?

PROFESSIONAL SUMMARY HISTORY:

Current Organization: Infogain Systems Pvt Ltd

Client : One97 Communications Pvt Ltd. (Noida)

: IBM, Pune

: Vodafone, Pune

: ITC, (Hydrabad)

: Glu Mobile(USA),

: Portico India Pvt. Ltd. (Mumbai)

: Hutchison India Private Ltd.(India/UK).

: Landmark -Genesis - Oracle Retail

-(Dubai and Saudi Arab Emirates)

Role : Associate Consultant and DBA Manager.

PROFESSIONAL EXPERIENCE

Oct 2011 to till date

Associate Consultant and DBA Manager

. Managing a team of DBA working on Various Oracle Databases along with

participation in technical assistance.

. Requirement gathering and requirement analysis for defects.

. Understanding the requirements of the customers.

. Preparation technical specifications documents.

. Assigning issues to the team depending on complexity.

. Coordinating with Client and End Users.

. Suggesting Changes in database/applications wherever required.

. Preparing, Working & Review on Change Requests.

. Performance monitoring and performance tuning.

. Database Designing, Creation, cloning, migration and up-gradation.

. Security Analysis and Implementation.

. Database Recovery and Restoration.

. Working closely with application developer for bug fixing

. Implemented Patches (Bug Patches, Security Patches,minor release

Patches)

. Allocating system storage and planning future storage requirements for

the database system.

. Role Management services and Role Switchover of Data Guard.

. Weekly and Monthly analyzing the Database Performance Reports.

. Participated in quarterly meetings with Management to discuss

technical infrastructure.

Notable Accomplishment:

. Re-organized the existing database architecture of unstable database

and made the database stable & boosted the database performance.

. Implement the Standard OEM using 12C.

IBM, Pune

? Senior APPS DBA ?

. Leading and participated with a team of 12 DBA on RAC /Data Guard and

Various Oracle Databases.

. Configured standby database for 20 TB of of critical production

instance.

. Worked on node eviction issues, Scan listener reallocation, and

services management in RAC.

. Migrated databases from NON-ASM to ASM.

. Moving datafiles from one diskgroup/filesystem to another diskgroup.

. Database Designing, Creation, migration and up-gradation.

. Monitoring database performance using AWR and ASH reports.

. Cloning and Refreshes of various databases.

. Involve in Role Management and Switchover of Data Guard.

. Database Space and Security management.

. Database patching for CRS, ASM and Oracle home including PSU.

. Security Analysis and Implementation.

Notable Accomplishment:

. Upgraded oracle 10g data guard to 11g data guard and migrated the

VODAFONE data into a new Data Model Group.

ITC PSPD, Hyderabad

? DBA Lead ?

Took the challenge to lead / work with the operation teams provide 24x7

support at Client location.

. Managing a team of 7 DBA working on RAC / Various Oracle Databases

being used by entire Paper Mill users.

. Proactively identify issues and make sure services are meeting SLA's.

. Managing the Data Guard and Various Oracle Databases being used by

entire Mill users.

. Cloning the development, test, quality instances.

. General maintenance of Database environments.

. Creating and enabling Data Guard configurations, including setting up

log transport services and log apply services.

. Monitoring log apply rates, capturing diagnostic information, and

detecting problems quickly.

. Knowledge in Role Management services of Data Guard.

. Knowledge in Role Switchover of Data Guard.

. Managing ASM Databases and ASM disk groups.

. Migrated from HP-Unix to Windows server.

. Involved in planning and documentation of backup, storage for critical

databases ensuring customer environments have minimal downtime.

. Database Backup, maintenance and Validation using RMAN as per the

backup strategies and policies.

. Restore and Recovery.

. Handle oracle 10g RDBMS and Data Guard databases.

. Handle oracle Replication server.

. Space management and documentation.

. Creation and Define database users, roles, privileges and password

policies to users as per the policy.

. Scheduling Jobs in database using the tools like toad and monitoring

the same for any errors logs.

. Executing routine month-end tasks rebuilding indexes, analyzing

tables, coalescing tablespaces.

. Replicating the tables and indexes using DBA studio and troubleshoot

refresh groups issues.

. Participated in Disaster recovery planning.

. Running data deletion rules for every three months based on the

timestamp given by the application team.

. Monthly taking the Database Performance Reports.

. Resolved database issues through trouble-shooting including storage,

backup, recovery, and modifying custom scripts for the implementation

to minimize the downtime.

. Proactively identify issues and make sure services are meeting SLA's.

. Participated in quarterly meetings with Management to discuss

technical infrastructure.

Notable Accomplishments:

. 2 TB Oracle database Upgrade from 10.2.0.1 to 11.2.0.1, this instance

is used for automation process to shift the heavy weight of Reels to

do further process to do production to save the time and accuracy in

the process.

. Installed and configured the oracle data guard to avoid the downtime

of 15 hrs of Mill Production.

. Migrated from HP-UNIX to WINDOWS 2003 server

. Participated in Many Internal Audits.

. Got an Appreciation Award from Client for the best performance.

Hutchison / Glu / Portico

? SR. DBA ?

Responsible for Oracle Production and Development Environments

. Managing and monitoring of Data Guard databases.

. Testing and migration of the database to newer version of RDBMS.

. Space management of Production instances.

. Database Security administration, creation of roles and grating the

necessary privileges to production users.

. Cloning of Development, quality and Test databases environment.

. Performing Backup and Recovery.

. Managing ASM Database and ASM disk groups.

. Monitoring and analyzing the index Performance.

. General maintenance of Database environments.

. Tuning databases and operating systems with respected to memory, I/O,

and contention using Explain plan, TKPROF and SAR utilities.

. Scheduling Jobs in database and monitoring the same for any errors

logs.

. Month-end tasks rebuilding and analyzing objects.

. Backup using conventional export/import utility and Oracle 10g

datapump.

Notable Accomplishments:

. Managed 24x7 DBA and Server operations.

. Reduced the Database operation timing of Hutchison from 40hrs to

3:30hrs(U.K)

. Got Special Meritorious Award from Company and out of the ordinary

thanks from Client for the best performance.

1

2 Sr. Database Administrator, 07/2010 - 15/10/2011

3 Datavail InfoTech (P) Ltd. Mumbai,

4 Client- Epsilon International (Primary DBA)

. Provides DBA support for 24/7 online production system support for

Both Oracle/SQL database.

. Maintains and upgrades both production and development databases for

users/clients. Performs database clone, refresh and restore.

. Installed oracle RAC 10.2.0.3.0 and 11.1.0.6.0 and 11.2.0.3

OCFS/NFS/HACMP/ASM on AIX 5L with two node.

. Schedules and performs RMAN NetBackup.

. Researches, documents and applies quarterly security patches for

Oracle RDBMS and Oracle Application Server including J2EE/WebCache,

Report and Portal/BPEL in production, integration and development

environment.

. Participates Data Guard maintenance and testing to ensure data high

availability.

. Creates and updates database inventories. Prepares and documents

systems, databases, servers and environments.

. Participates in client/project meetings for need assessment and design

review.

. Creates, documents and implements standards and modeling to monitor

and enhance the capacity and performance of the database. Programs and

writes codes as necessary.

. Develops data import and export routines to automate data loading.

. Develops back-up and recovery procedures and data archive/purge

procedures. Creates supporting technical documentation.

. Provides leadership and work guidance to less experienced personnel.

5 Sr. Database Administrator, 03/2008 - 07/2010

6 Integration InfoTech India (P) Ltd. Pune,

7 Client- PRCNET.com

. Up gradation of database for 9i to 10g,11g.

. Applying one off bug patches, quarterly CPU patches, DST patches using

OPatch utility.

. Day to day monitoring of database, maintenance, troubleshooting,

resolving incidents on ticketing system.

. User management issues involving control user access to resource and

information by allocating the right privileges.

. Managed Space issues involving resizing table spaces, data files

. Administration of all database objects, including tables, clusters,

indexes, views, sequences, packages and procedures One-Off Patch

Installation.

. Purging of Oracle trace files & trims alert.log, listener.log files on

regular basis.

. Interacting with Oracle for Technical Support. (SR)

. Day to day monitoring of database, maintenance, troubleshooting,

resolving incidents on ticketing system.

. User management issues involving control user access to resource and

information by allocating the right privileges.

. Managed Space issues involving resizing table spaces, data files

. Administration of all database objects, including tables, clusters,

indexes, views, sequences, packages and procedures Provides leadership

and work guidance to less experienced personnel.

8 Database/System Administration, 10/2006 - 03/2008

9 Hewlett-Packard Globe-soft Limited (HP)- Chennai

10 Client- Agilent Technologies

. Maintained and administrated more than 200 Oracle 10g, 9i and 8i

databases and SQL Server database 2000 in development, integration and

production environment at Agilent Ltd..

. Maintained and troubleshot Application Server in middle tier and

application E-Business Suite. Supported application development

effort.

. Installed oracle RAC 9.2.0.4 OCFS on Red hat Linux 2.1 with four node.

. Researched, documented and applied quarterly security patches for

Oracle RDBMS and Oracle Application Server including J2EE/WebCache,

Report and Portal/BPEL in production, integration and development

environment.

. Participated in client/project meetings for need assessment and design

review.

. Designed, developed, implemented and maintained database for internal

and external users/clients. Created supporting technique

documentations.

. Scheduled and performed RMAN NetBackup and database clone refresh and

restore.

11 Database/System Administration, 11/2000 - 10/2006

12 Investment Research & Information Services Limited.

. Designed, developed, implemented and maintained database in IRIS Ltd..

. Performed database backup and recovery to ensure data high

availability.

. Supported and maintained computer system, networking and software

implementation.

. Designed, implemented and developed database/ Laboratory Information

System.

13 Oracle DBA, 09/2005 - 10/2006

Client- KOTAK MAHENDRA Bank Ltd.

. Provided DBA consultant for 24/7 online banking systems.

. Implemented Oracle 9i Data Guard and ensured the data high

availability.

. Performed RMAN backup and tested various RMAN recovery scenarios.

. Monitored and tuned databases to optimize the performance and satisfy

the availability requirements of multiple applications using SQL

Tuning Advisor (STA).

. Analyzed and tuned the database to identify potential database issues

such as response delay and locking contention with tools like

Statspack, EXPLAIN PLAN, and TKPROF.

IT SKILLS

Database: : Oracle 12c/11g/10g/9i/8i / Sql server

2000/2005 administration., Data transfer using

SQL*Loader, Export/Import utilities, RMAN backup and

recovery, performance tuning, database installation

and creation, upgrade and migration, clone and

rename, restore and refresh, Data Guard, RAC, etc.

Applications/Servers: J2EE, Oracle Application Server, Application E-

Business Suite.

Operating Systems : Solaris 9i/5.8, Linux 2.4, AIX,Windows NT/2000/XP

Professional, DOS.

Storage : SAN / NAS/ DAS.

Oracle Apps : 11.5.9 and onwards

Training Programs Attended

. Managerial effectiveness program.

. Time management program.

. Effective communication skills.

. Presentation skills.

. ORACLE 10g RAC. [pic]

[pic]

Contact this candidate