Resume of S.K.



[pic][pic][pic][pic]

Resume of S.K

SUMMARY OF QUALIFICATIONS

• A highly dependable and result-oriented Sr. Oracle DBA with 11 years extensive experience in managing a variety of mission critical databases for large organizations.

• OCP 8i/10g/11g

• Oracle Certified Expert , Oracle RAC 11g and Grid Infrastructure Administrator

• ITIL® V3 Foundation certified

• Proven experience in coordination with different globally spread teams for successful implementation of Projects.

• Proven experience for cost saving efforts for various clients.

• Extensive experience of managing production high volume, transactional 24x7x365 Databases on UNIX (Solaris / Linux/HP-UX, IBM-AIX ) Systems.

• Handle On-call issues and jump into Sev1 /2 calls and ensure timely restoration of database services . Take care of critical Database tasks and ensure end-to-end delivery of work

• Strong communication skills, Effortlessly interact with stake holders, clients, vendors and staff.

• Thoroughly experienced in meeting client expectations thru effective communication, exemplary team work and superior technical knowledge.

• Extensively worked on high availability features like 10G/11G RAC, 9i/10g/11g DATAGUARD , VCS , HACMP

• Installation/Setup & Maintenance of multiple 10GR2/11GR2 RAC environments with ASM on multiple Operating systems

• Implementation of Oracle database backup and recovery strategies using RMAN/Hot/Logical Backups for RAC/Non-RAC databases.

• Extensive experience using RMAN for all type of Critical Recovery scenarios

• Extensively used RMAN for Cloning ,Stage database refreshes , DR creations

• Migrations, Upgradation and Maintenance of RAC/Non-RAC Databases ,Performance Tuning

• Extensive client facing experience .Lead/participate in meetings with stakeholders Application teams and suggesting and convincing for implementing appropriate solutions . Exposed to working in mission critical projects, large database environments and Complex architectural setups

• Extensive experience In Implementing 10g/11g RAC On Linux , Solaris And Other Flavours Of Unix.

Certification:

• Oracle 8i/10g/11g Certified Professional Database Administrator (OCP 8i/10g/11g).

• Oracle Certified Expert, Oracle RAC 11g and Grid Infrastructure Administrator (OCE 11g RAC).

• ITIL® V3 Foundation certified.

• PMP trained- Have completed 35 hrs of PMP Training.

TECHNICAL SKILLS

Oracle Enterprise Edition (11g,10G, 9i , 8i , 7 ), RAC 10gR2/11gR2 - Real Application Clusters ( two/three/four node ) on HP-UX , Sun Solaris , Linux, Installation and configuration of 2/3 Node 10GR2 / 11GR2 RAC setups with ASM on Linux & HP-UX, Upgrade CRS / ASM / RDBMS from 10.2.0.3 to 10.2.0.4 & 11GR1 to 11GR2 , Upgrade 10GR2 (10.2.0.4) RAC setups to 11GR2 (11.2.0.3) RAC on Linux, Dataguard 9i/10G/11G – Creation / Maintenance of Physical Standby Databases, Created & administered 10g/11g RAC-Standby setups, Expert Level in RMAN. Use RMAN for cloning, DB refreshes, standby DB creation etc., OEM (Oracle Enterprise Manager 10g/11g Grid Control), Performance Tuning using tools like statspack / AWR & SQL tuning, Goldengate Replication, Applying critical Patches to all components of RAC i.e CRS Bundle, Latest PSUs/CPU Patches etc., Backup & Recovery (RMAN with TSM/ Veritas Netbackup, Hot and Cold , Exp/Imp , Data Pump), Database Upgrades ( 8i to 9i ,8i to 10gR2 , 9i to 10gR2 & 10gR2 to 11gR2 ) and Patching, Oracle Installation on UNIX (AIX , HP-UX , Solaris, Linux etc) , Scripting ( UNIX Shell).

PROFESSIONAL EXPERIENCE

American Airlines, Dallas, TX Oct 13 – Present

Sr. Oracle DBA

Responsibilities

• Handle On-call issues and jump into Sev1 /2 calls and ensure timely restoration of database services . Take care of critical Database tasks and ensure end-to-end delivery of work .

• Extensively working on multiple 10g/11gR2 RAC environments on ASM, 10g/11g DATAGUARD setups & RMAN

• Applying quarterly PSU Patches to RAC/Non-RAC databases.

• Applying CRS Bundle patches/PSU to CRS on RAC clusters.

• Upgradation of CRS/ASM/RAC databases from 10.2.0.4 to 10.2.0.5 & 11.1.0.6 to 11.2.0.3 ,10.2.0.5 to 11.2.0.3 etc..

• Upgradation of 10.2.0.4 CRS/ASM to 11.2.0.1 GRID Infrastructure

• Space Management in ASM Diskgroups, Addition of new disks etc…

• Troubleshooting RAC, DATAGUARD, and ASM issues

• Creation of new RAC databases, conversion from single instance to RAC .

• Installed and Configured 2/3 Node 10gR2/11gR2 RAC setups with ASM on Linux & HP-UX

• Configuration of RMAN backups/Monitoring for RAC databases , refresh stage databases

• Setup 11g Standby database setups , Active Dataguard

• Setup multiple Dataguard Setups (deployed Dataguard Broker-DGMGRL) for 2/3 Node 10g RAC Clusters , Enabled Fast_start Failover

• Perform DR drills e.g Switchover/Switchback using DG Broker etc

• Upgraded RAC-Dataguard setups from 10.2.0.3 to 10.2.0.5

• Setup and configured OEM 10G Grid Control agent installs on servers, configure new databases for monitoring, Setup jobs , alerts , notifications etc.

• Support RAC & Single Instance Production/Stage/Dev databases on Veritas Clusters (VCS)

• Install and configure Goldengate replication. Perform zero downtime migrations

• Export and import of tables , schemas and Full db as per development/Application team req. using Data pump /Exp-Imp

• Configure RMAN backups for databases and schedule them through Crontab

• Resolve common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc…

• Performance Tuning of problem queries

• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.

National Australia Bank Jan 10 - Sep 13

Sr. Oracle DBA – Senior SME

Responsibilities:

• Extensively working on 10g/11g RAC , ASM & RMAN

• Install and setup 11g RAC with ASM on Linux, HP-UX platforms

• Setup and maintain Oracle Data guard (Physical) with Fast Start Failover, Active Data Guard

• Setup and maintain 11g RAC-Dataguard setups

• Installation, Administration and Maintenance, Patching, Cloning, Upgrading Oracle 11g/10g

• Creation of new Diskgroups, Disk addition/deletion etc.

• Performance tuning of problematic queries

• Creation of new RAC databases, conversion from single instance to RAC

• Refresh RAC/Non-RAC databases from production to Dev/Test/QA using RMAN

• Use Data Pump, Exp/imp for Schema/table level refreshes

• Install and configure Goldengate replication.

• Working on OEM 10g/11g. agent installs on servers, configure new databases for monitoring, Setup jobs , alerts , notifications etc.

• Configure RMAN backups for databases and schedule them through Crontab

• Resolve common database issues like Locking, FreeSpace, connectivity issues, Applying patches etc…

• Performance Tuning of problem queries

• Database refreshes using RMAN cloning. Extensively using RMAN for all types of recovery/backup scenarios.

• Handle On-call issues and jump into Sev1 /2 calls and ensure timely restoration of database services.

• RMAN Catalog maintenance, purging sufficiently old backups from tapes etc.

• Troubleshooting problems of development and application teams.

• Database refreshes using RMAN backups and hot backups also .Extensively using RMAN backup & restores

• Work on Physical Standby databases in Dataguard environment and perform related activities i.e

• Perform Role Switchover for maintenance of Primary database etc

• Created physical standby setups in Dev/Production environments in

• Maximum performance/availability mode

• Troubleshooting day-to-day Standby database issues

• Day-to-Day Maintenance of multiple 10G/11G RAC environments on ASM

• Applying Patches to RAC/Non-RAC databases.

• Upgradation of RAC databases from 11.2.0.1 to 11.2.0.3 etc…

• Space Management in ASM Diskgroups Addition of new disks etc…

McKinsey & Company Inc. Jul 06 - Dec 09

Sr. Oracle DBA

Responsibilities:

• Supporting 24*7 Production databases along with development and maintenance databases.

• Proactive monitoring is done through OEM 10G GRID Control.

• Database refreshes using RMAN backups and hot backups also. Extensively using RMAN for all types of recovery/backup scenarios.

• RMAN Catalog maintenance, purging sufficiently old backups from TSM Server etc.

• Troubleshooting problems of development and application teams.

• Upgradation of databases from Oracle 8i to 9i , 8i to 10GR2 , 9i to 10GR2 etc..

• Day-to-Day Maintenance of multiple 10G RAC environments on ASM

• Applying Patches to RAC/Non-RAC databases.

• Upgradation of RAC databases from 10.2.0.1 to 10.2.0.2 etc…

• Space Management in ASM Diskgroups. Addition of new disks etc…

• Configuring TAF

• Work on OEM issues i.e

• OEM Agent Installation on servers

• Configure OEM monitoring for Databases , Manage OMS Processes etc..

• Work on Physical Standby databases in Dataguard environment and perform related activities i.e

• Perform Role Switchover for maintenance of Primary database etc.

• Created physical standby setups in Dev/Production environments.

• Troubleshooting day-to-day Standby database issues

• Installation and Creation of new databases in Dev and Production environments.

• Handling Production databases on High Availability Clusters (HACMP) on IBM-AIX platform

• Export and import of tables, schemas and Full db as per development/Application team req.

• Configure rman backups for databases and schedule them through Crontab.

• Resolve common database issues like Locking, FreeSpace ,connectivity issues, Applying patches

• Performance Tuning of problem queries

• Work on Materialized views and handle related issues

• Configure Listener and tnsnames configuration and troubleshoot related issues

• Tracing problem user sessions and analyzing TKPROF reports

Apple Inc. Jul 05 - Jun 06

Oracle DBA

Responsibilities:

• Supporting 24*7 Production databases of up to 4.3 TB along with development and maintenance databases

• Proactive Monitoring is done through tools like BMC PATROL,DBSPI

• Database refreshes(Duplicate Database) using rman backups.

• Performance tuning of problem queries

• Troubleshooting problems of development and application teams.

• Handling Standby databases (Data Guard).

• Job Scheduling through Crontab and dbms job package

• Upgradation of databases from Oracle 8i to 9i.

• Complete and incomplete recoveries using rman

• Replicating data through Materialized views

• Scheduling rman backups and other scripts in crontab

• Migration of databases , reorganization

• Configuration of tnsnames and Callout listeners

• Installation and Creation of databases

• Export and import of tables, schemas and Full db as per development team req.

• Tracing problem user sessions and analyzing TKPROF reports

• Resolving locking issues, space management, applying patches etc .

• RMAN Catalog maintenance, Purging sufficiently old backups from TSM Server etc.

• Troubleshooting problems of development and application teams.

Max New York Life Insurance Jun 05 - Jul 05

Oracle DBA

Responsibilities:

• Creation of databases using DBCA and also using scripts

• Day-to-day problems like Locking, latching, performance problems etc.

• Setting up SQLnet/Listener/Tnsnames.ora

• Scheduling RMAN and logical backup using scripts

• Database Refresh(Cloning of database)

• Managing Disk Space, Tablespaces, Objects etc..

Hughes Escorts Communications Ltd Nov 04 - Jun 05

Responsibilities:

• Perform routine Backups of the Database

• Troubleshooting User’s regular Problems.

• Disaster Recovery Management.

• Physical Storage Space Management.

• Cloning of database. Security Implementation

Neurosoft Systems and Software Jun 03 – Aug 04

Jr. Database Administrator

Responsibilities:

• Assisted in maintaining the Production Database in Oracle 8i On UNIX Platform

• Perform routine Backups of the Database(Non-RMAN)

• Take Logical Backup of the Database (Export Backup)

• Creating data in the central database by importing dump files received from various Client sites.

• Monitor Database performance.

• Manage Database Security and enforce Data Integrity where necessary

• Monitored Alert Log Files and trace files

• Responsible for installation and setting up ORACLE on Win NT at the User’s end and provide them connectivity with the Production Database Through TNSNAMES.ORA.

• Implemented Backup and Recovery strategy for database

EDUCATION

B.E Information Technology from Dehradun Institute of Technology

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download