It has solid experience has an Oracle DBA. He is proficient in Oracle Database Administration tasks and is currently supporting 400 databases. He has successfully performed database recoveries and ensured that the business critical data is secure. He is a certified professional in Oracle 9i and 10g.

WORK EXPERIENCE:

Client:Confidential
Domain: Healthcare
Duration: 11/01/2008 Present
Confidential is a Fortune 19 company that improves the cost-effectiveness of healthcare. As the business behind healthcare, Cardinal Health helps pharmacies, hospitals and ambulatory care sites focus on patient care while reducing costs, improving efficiency and quality, and increasing profitability. Cardinal Health employs more than 30,000 people worldwide.
This project involves maintaining Cardinal Health databases. The current role involves below listed activities

• Onsite coordinator
• Primary On-call DBA daily during business hours and be available for week-end On-call support
• Support databases in Exadata environment
• Setup Golden Gate replication during database migration from AIX to Linux server
• Install 11gR2 for ASM (Automatic Storage Management) and setup OEM.
• Setup IBM Tivoli monitoring and Ignite Confio monitoring
• Provide support to OLTP, Data warehouse, standby and RAC databases.
• Converted single instance database to RAC.
• Co-ordinate with application team and developers in resolving issues and prepare deployments plans.
• Prepare weekly status reports and presentation slides for monthly review meetings with client.
• Collaborate with team and generate ideas on initiatives like service improvement plans and process automation.
• Represent Oracle team in Root cause analysis meetings related to severity-1 issues and CCB (change control board) meeting
• Handle Database Projects
• Successfully performed point in time recovery after business critical data was lost due to block corruption
• Track space usage and forecast storage requirement.
• Apply Patches, Oracle installations, Perform database upgrades
• Prepare standard operating procedure(SOP) documents for frequently used databases tasks and process
• Database refresh ,Schema refresh, Database Creation ,Implement table partitioning
• Implementing change controls in production environment
• Setup and manage standby databases
• Performance tuning of long running queries
• Coordinate with external auditors in fulfilling regulatory compliance auditing and evidence collection (Sarbanes Oxley)
• Perform deep dives on business critical database applications and submit report on current setup along with recommendations to client
• Maintain accurate database, server information in Database Inventory. Keep technical documents up to date.
• Provide training to junior team members and offer technical help when needed.
• Perform limited tasks related to MSSQL database like instance creation, restore, report generation

Environment: Exadata,Windows 2003 server, IBM-AIX, HP-UX, Solaris, Linux, Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g, Confio, SQL loader, datapump, APEX, BRTools, MSSQL,OEM,Golden Gate,Netbackup

Client: Confidential
Domain: Healthcare
Duration: 10/01/2006 10/25/2008
Confidential is the world’s largest medical technology company and is a fortune 500 company. Medtronic develop and manufacture devices and therapies to treat more than 30 chronic diseases, including (but not limited to) heart failure, Parkinson\'s disease, urinary incontinence, obesity, chronic pain, spinal disorders, and diabetes.
This project involves providing support to client databases.

• Team lead for Oracle DBA Team.
• Provide On-call support
• Create database, create Application schema,
• Perform Database retirement, schema retirement
• Perform Database upgrade
• Perform Database migration
• Install oracle server, EM agent and add database to Grid control
• Regular database tasks, troubleshooting rman backup failures
• Configure the rman backup for databases
• Database refresh, schema refresh using export/import and RMAN clone
• Applying patches whenever needed, setting up database in Active-active clusters
• Set up Grid control and manage database using Grid.

Environment : Oracle8i, Oracle9i, Oracle 10G, Grid Control, OEM, CMDB, Toad

Client: Confidential India
Duration: 11/25/2005  09/30/2006

This project involves installing and testing major releases and patch sets of Oracle RAC database products on different OS platforms.
Oracle software is installed and tested on all available servers like HP-UX, Sun Solaris, Linux x86-64 and make sure that the installation is done without issues, if any issue is seen that incident is updated to Oracle team who in turn will provide fix for the bug.
This testing is done before the software is made available to Oracle customers.

• Install 10gR1 and 10gR2 RAC software
• Configure and setup new servers as per requirement.
• Create databases and test that the software is working fine
• Check if any bugs are present and submit a service request with Oracle Team
• As part of this project I am involved in the pre-release testing of 10.1.0.5.0 and 10.2.0.2.0 RAC software install on Sun Solaris, IBM, HP-UX, Redhat, Linux x8664 servers
• For testing the software I have tested different scenarios like database creation, software installation, node addition, node deletion, database upgrade in RAC environment.

Environment: Oracle 10G, SUN solaris, AIX, HP-UX, Linux

Client: Confidential
Duration: 09/01/2003 10/28/2005

Centralized Business Management System is the application of SRMT group. It centralizes all the functions like work flow and produces the reports as per needs. This unique system delivers a package of virtually instant benefits, which helps an organization to be more efficient and competitive. In this project support is provided to the client databases.

• Responsible for the installation, upgrades, and maintenance of Oracle Database Servers on UNIX based SUN client/server environment
• Responsible for providing 24x7 support for production Oracle databases
• Managing Password Security and Resources, Users, Privileges and Roles.
• Implementing BACKUP and RECOVERY strategies for Offline and Online Backups.
• Prepare disaster recovery strategies
• Responsible for planning and performing routine backup and recovery of the databases.
• Performed database migration and performed cloning of Production database
• Create replication between Oracle databases perform the maintenance window activity related to the production system and databases.
• Applied patches and upgrades for Oracle database.
• Provide solutions to the Oracle error encountered in the production database
• Create and maintain users and segments.
• Address the tickets and provide resolution in timely manner based on SLA.
• On call support engineer

Education & Certifications:

• Graduate Diploma of Information Technology
• Bachelor of Engineering in Electronics and Communication
• Oracle Certified Professional in 9i and 10g (OCP9i,OCP10g)

Trainings Attended:

• Attended workshops and training sessions conducted by Oracle Corporation in Oracle 10g RAC, Oracle 11G, Exadata, Database Upgrade
• Attended training in team management ,Project life cycle methodology processes