SUMMARY:

• Highly self - motivated, versatile and logical thinking Confidential Certified database administrator (10g) having more than 11.5 years of experience in Confidential Installation, Database configuration and Administration, tuning
• Database Migrations, Supercluster, Exadata, RAC (Real application cluster),Golden gate, Backup and Recovery, Dataguard, DR planning, strategy & implementation and troubleshooting of various Confidential Products/versions on different platforms covering Redhat Linux, Unix, windows NT /2000, Aix, Solaris.
• Seeking a challenging area of work to apply existing skills and to continue the learning process.

TECHNICAL SKILLS:

• Oracle Exadata, Oracle 12C, Oracle 12C OEM, Oracle 11g, Oracle 10g, Oracle 9i
• Install & configure Oracle Cluster 11g and 12C(Real Application Cluster) on Solaris, Linux & AIX
• Symantec NetBackup (earlier VERITAS NetBackup)
• HP Unix, Solaris, Windows NT, Linux, AIX, Oracle VMWare server
• Quest Space Manager for Live Reorg
• Knowledge of MongoDB, AWS & IBM Optim InfoSphere Data Archiving

PROFESSIONAL EXPERIENCE:

Confidential

Senior Confidential Database Administrator

Responsibilities:

• Upgraded 150+ databases from 11g to 12C RAC and migrated to new servers using DG broker setup.
• Assisted in management and database administration of Confidential database applications on SuperCluster/Exadata T4 platforms.
• Provided technical assistance for designing, installation and upgrading of existing Confidential databases.
• Assisted in integration of SuperCluster/Exadata/SAP applications into current IT actionable events and solutions on Confidential VMware server (Solaris LDOM & Zones).
• LiveReorg SAP tables & indexex using Quest Space Manager.
• Expert skills in Confidential RDBMS (12C/11g/10g)/ASM/OCFS/CFS Installation, RAC Database Creation, Performance Monitoring & tuning and Database maintenance procedures using PL/SQL programming, VERITAS Cluster and Shell scripts.
• Deep knowledge of DB performance/scaling concepts and tuning best practices.
• Conducted Performance Review of Confidential Database for business critical applications with Senior Leadership team
• Excellent experience in performance tuning using STATSPACK, EXPLAINS PLAN, SQL TRACE, TKPROF, AWR and ADDM reports.
• Experience on Building 12C/11g/10g Confidential RAC databases clusters in the production environment.
• Experience on Building Flash Cache based database using Fusion-IO
• Good understanding of Confidential internal stacks like Cache Layer, Transaction Layer, Data Layer etc.
• Good understanding of ASM internal stacks like physical metadata and virtual metadata
• Experience of OEM 12C Grid/agent configuration to monitor Confidential database.
• Expert skills in Confidential RDBMS (11g/10g)/ASM/OCFS/CFS Installation, RAC Database Creation, Performance Monitoring & tuning and Database maintenance procedures using PL/SQL programming, VERITAS Cluster and Shell scripts.
• Experience of working with high availability Database using MC/Service guard, VERITAS cluster environment
• Extensive knowledge of Confidential functionality & internals. Strong analytical and debugging skills.
• Involvement in Developing a Disaster Recovery (DR) & Conduction/Implemented a DR Exercise through Setup of Confidential physical standby (DATA GUARD).

Confidential

Oracle Database Administrator

Responsibilities:

• Working six Production/UAT Database.
• Working in database Administration, Confidential Server Installation, Database design, Database Migration/Upgradation, Backups & Recoveries, Performance Tuning, User management, Table space management, Security management.
• Daily monitoring of the entire heavy batch runs on production databases for better performance.
• Applying CPU patches for compliance and providing RCA for any issues related to database

Confidential

Oracle Database Administrator

Responsibilities:

• Working with over 100 Production/UAT Database.
• Working in database Administration, Confidential Server Installation, Database design, Database Migration/Upgradation, Backups & Recoveries, Performance Tuning, User management, Table space management, Security management
• Managing Of REAL APPLICATION CLUSTER.
• Involvement in Developing a Disaster Recovery (DR) & Conduction/Implemented A DR Exercise through Setup of DATA GUARD (Implementation of Physical Standby Database).
• Upgrade the Confidential Database from 9i to 10g, 11g.
• Applying CPU patches for compliance and providing RCA for any issues related to database

Confidential

Oracle Database Administrator

Responsibilities:

• Working in database Administration, Confidential Server Installation, Database design, Database Migration/Upgradation, Backups & Recoveries, Performance Tuning, User management, Table space management, Security management
• Close monitoring of Databases & alert logs also Performance monitoring of database while Batch runs.

Confidential

Oracle Database Administrator

Responsibilities:

• Providing Technical Support to Various Prestigious Clients (GPIL, ESPN, GAIL, Kotak, UPSC, NIC, IFFCO, BSNL, Honda Siel, PNB Bank, MTNL, Air Force Etc).
• Working in database Administration, Confidential Server Installation, Database design, Database Migration/Upgradation, Backups & Recoveries, Performance Tuning, User management, Table space management, Security management
• Managing of REAL APPLICATION CLUSTER.
• Involvement In Developing A Disaster Recovery (DR) & Conduction/Implemented A DR Exercise Through Setup Of DATA GUARD (Implementation Of Physical Standby Database)
• Upgrade the Confidential Database from 9i to 10g, 11g.
• Backup tasks - using OS backup (Hot and Cold). Confidential backups, generally through Export - Import utilities, Data Pump, RMAN.
• Having Experience In Continuous Performance Monitoring And Tuning Of The Databases And Application Using Tuning, Diagnostics Pack, STATSPACK, Explain Plan.