Oracle Management
Resume:
****.********@*****.***
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