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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- dividend yield of s p 500
- resume bachelor s degree
- list of pre k themes
- annual dividends of s p 500
- history of s p 500 chart
- current pe ratio of s p 500
- country of s america
- sector percentages of s p 500
- should i switch out of s mode
- is switching out of s mode bad
- should you switch out of s mode
- take windows out of s mode cmd