SUMMARY

• A highly dependable and result - oriented DBA admin with 7 years extensive experience in managing a variety of mission critical databases for large organizations.
• Strong Technical background in System (Linux, windows) and network administration .
• 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.
• 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.
• Extensively used RMAN for Cloning, Stage database refreshes, DR creations, Critical Recovery scenarios
• Migrations, Upgrading and Maintenance of RAC/Non-RAC Databases, Performance Tuning
• Extensive experience In Implementing 10g/11g RAC On Linux, Solaris And Other Flavors Of Unix.

TECHNICAL SKILLS

Databases: Oracle 10g/11g/12c

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL, Java, C#, python, Html, JavaScript, power shell

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential

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, CRS bundle patches/PSU to RAC/Non-RAC databases.
• Planned and upgraded multiple databases from 10.2.0.4 CRS/ASM to 11.2.0.1 GRID Infrastructure
• Space Management in ASM Diskgroups, added disk to diskgroup and created new diskgroups.
• Diagnose, identified and resolved performance bottleneck in RAC, DATAGUARD, and ASM environment.
• Created new RAC databases, planned and converted standalone database to multiple 8 nodes RAC.
• Installed and Configured 2/3 Node 10gR2/11gR2 setups with ASM on Linux & HP-UX
• Configuration of RMAN backups, 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 job s, alerts, notifications etc.
• Support RAC & Single Instance Production/Stage/Dev databases on Veritas Clusters (VCS)
• 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…
• Database refreshes using RMAN cloning. Extensively used RMAN for all types of recovery/backup scenarios.

Confidential

DBA

Responsibilities:

• 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
• Installation, Administration and Maintenance, Patching, Cloning, Upgrading Oracle 11g/10g
• Creation of new Diskgroups, Disk addition/deletion etc.
• Performance tuning of problematic queries
• 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 job s, 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…
• 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
• Applying Patches to RAC/Non-RAC databases.
• Space Management in ASM Diskgroups Addition of new disks etc…

Confidential

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 11g to 12c, Applying Patches to RAC/Non-RAC databases
• Space Management in ASM Diskgroups. Addition of new disks etc…
• 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.
• Troubleshooting day-to-day Standby database issues
• Installation and Creation of new databases in Dev and Production environments.
• 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
• Configure Listener and tnsnames configuration and troubleshoot related issues

Confidential

Oracle/SQL DBA

Responsibilities:

• Supporting 24*7 Production databases of up to 4.3 TB along with development and maintenance databases
• 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..
• Perform routine Backups of the Database, Troubleshooting User’s regular Problems, Disaster Recovery Management, Physical Storage Space Management, Cloning of database. Security Implementation
• 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, Monitored Alert Log Files and trace files
• Manage Database Security and enforce Data Integrity where necessary
• Implemented Backup and Recovery strategy for database
• Evaluate and implement products to enhance existing database solutions (reduce costs, improve efficiency, improve performance
• Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements
• Perform all database management responsibilities in Microsoft Azure for production and non-production workloads
• Provide database administration, performance tuning support for Markets Business