SUMMARY:

• An Oracle DBA with almost 8+ years IT experience in Oracle (11gR2, 10g, 9i) 11g RAC, 10g RAC, installation, upgrade, designing, backup, recovery, migration, performance tuning, Golden Gate, data guard ASM, Logical Backup etc. spanning various industries like Insurance, Banking, Financial, Consulting etc. in variety of environments like UNIX, LINUX, Windows NT 4.0/2000/2003 in production, test as well as development databases.Currently designated as an Lead Oracle DBA with Syntel Consulting., Phoenix,
• Extensive experience in Administering, Installing and Troubleshooting Oracle Databases and RAC Databases Systems.
• Installed oracle database server on HP - UX, Solaris, IBM AIX, Red Hat Linux environment.
• Providing 24X7 on call support for OLTP,OLAP/DWH production databases.
• Enrolling users, Assigning Roles and Profiles, maintaining system security through monitoring user access to the database
• Creating and Managing Table spaces in database.
• Good Knowledge of Oracle Security and Vault.
• Planning for Backup and Recovery of database information and maintaining Hot Backups, Cold Backups, Logical Backups using Exports and Imports.
• Good Experience and Knowledge of Golden Gate .
• RMAN Backup & Disaster Recovery.
• Experience on Cloning Databases.
• Creating and maintaining physical data models
• Good knowledge of ITIL processes
• Strong experience with Partitioning and Oracle DBA Functions
• Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DWH databases.
• Experience using Grid Control monitoring tools
• Strong query and database tuning skills
• Creating and Maintains Tables, Tables partitions, Indexes and database objects..
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Experienced in using 10g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle Enterprise Manager.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE,11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experience with SAN storage systems
• Fast troubleshooting and resolution skills
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Manage storage growth and planning, including partition management
• Experienced in Oracle Support processes for technical requests through Oracle and other Support
• Experience in Administering, Installing and Troubleshooting Oracle Databases on VMware.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
• Goods hands on experience in Oracle database patching and upgrade.
• Implementing and Supporting DATAGUARD( Physical Standby) on Production Databases.
• Database Up gradation from 9I to 10g, 10g to 11g
• Monitoring and Administrating database through OEM.
• Configuring and Managing the Automatic Storage management (ASM).
• Knowledge of SQL server 2005/2008 database.
• Knowledge of Nosql DB(Mongo DB)

TECHNICAL SKILLS:

Operating System: HP-UX 10.x, 11.x, Sun Solaris 5.9,5.10,, AIX 5.1, 5.2, RHEL 5.6,5.8 and Windows 95/98/ME/NT/2005/2008XP.

Database: Oracle 12c/11g/ 10g/9i/8i

Language: SQL, PL/SQL, UNIX Shell Scripting

RAC Utilities: SRVCTL, CRSCTL, CRS STAT, CRS START CRS STOP, OCRCONFIG, OCRCHECK,OLSNODES

Oracle Utilities: Oracle Enterprise Manager(OEM), EXP/IMP, RMAN, ASMCMD,EXPDP/IMPDP,DBUA,NETCA,Golden Gate DBCA, EMCA, DBV, NID, CSSCAN, OraChk,OSwatcher,TFA

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

Ticketing Tools: Remedy, Scotty, Service Now, Itrack, Manage Now

Monitoring Tool: OEM,12c Grid

Application: Apache,Tom cat, Web logic servers,People soft HRMS

Other Tools: PL/SQL Dev, Toad, Shareplex, Autosys

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix-Arizona

ORACLE RAC DBA & ORACLE DBA.

Responsibilities:

• Providing 24X7 support for production databases.
• Supporting and Monitoring the Oracle RAC databases.
• Documenting database operations through Tickets, Changes
• Monitoring the ASM disk group and adding the disk to the disk group when required.
• Monitoring the Database health check and growth.
• Providing Technical support to Production Environment and developers
• Health Checks (Production Database status, Tablespaces Free Space, Backup status, Other Scheduled Cron Jobs status).
• Managing the user accounts.
• Creating Users, Profiles Granting specific Privileges and roles to the Users.
• Killing User Session.
• Control File, Redo log File and Archive Log Maintenance
• Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed
• Keeping the databases up to date with respect to Latest PSU’s and very comfortable in applying patches
• Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control
• Starting and Shutting down the RAC databases
• Creating and Relocating RAC database services to instances
• Switchover and Failover RAC database with Data guard Broker
• Managing Mount point space
• Enable the Flashback feature in RAC environment and make use of it for flashback the database, table and query.
• Recovering database objects using Flashback ON/Recyclebin utilities(10G)
• Logical backup using Exp/Imp and Datapump.
• Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
• Automated routine DBA tasks like backup’s and stats by using Grid control job’s
• Provided Assistance to application team at the time of SQL tuning in applications.
• Gathering STATS for tables, indexes, schemas, database level.
• Generating AWR,ASH and addm reports.
• Putting table in KEEP/RECYCLE POOL.
• Pin & unpin SQL procedure .

Confidential

ORACLE RAC DBA & ORACLE DBA

Responsibilities:

• Responsible For Installation & Configuration RAC Database.
• Implementation of RAC using ASM on 2 Nodes.
• Implementation of RAC using OCFS2 on 2 Nodes.
• Monitoring of cluster ware files i.e., OCR files & Voting Disk files.
• Monitoring the ASM instances on the multiple nodes.
• Monitoring the ASM disk group and adding the disk to the disk group when required.
• Monitoring the Database health check and growth with script.
• Creation of RAC Database using DBCA Tools as well as Manual.
• Migrating Non-RAC DB to RAC DB using RCONFIG utility.
• Configuring the RAC database in Archive log mode.
• Configure RMAN for the backup of RAC database using a Catalog Repository database.
• Taking Backup through Shell Scripts.
• Enable the Flashback feature of 10g in RAC environment and make use of it for flashback the database, table and query.
• Clone the RAC database to single instance database using RMAN/Hot Backup.
• Apply patches both Interim patches as well as Patch Set patch using Opatch and OUI in RAC environment.
• Taking Backup of OCR and VD.
• Upgraded RAC database from version 10.2.0.1 to 10.2.0.4
• Upgrading of RAC database from 10.2.0.4 to 11.1.0..

Oracle DBA

Responsibilities:

• Part of core Production DBA team maintaining production databases.
• Providing 24X7 support for production databases.
• Installation of 10g and 11g Database on Unix Platform.
• Creation of Database using DBCA Utility.
• Manual Creation of Database using Script .
• Managing the Database Parameter file and Server Parameter file.
• Control File, Redo log File and Archive Log Maintenance
• Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed
• Creating Users, Profiles Granting specific Privileges and roles to the Users.
• Cloning the Database (User Manage, RMAN).
• Preparation of Technical Documentation and User manual.
• Database backup daily and weekly basis.
• Taking Backup through Shell Scripts.
• Installing and configuring Oracle NET on Server and Client machines.
• Configure RMAN catalog database.
• Backup (Hot backup, Cold backup)
• Validating and Checking of corrupt block by using DBVERIFY utility.
• Correcting Corrupted block by using RMAN
• Refresh the database for Testing Purpose.
• Used Exp/imp utilities.
• Data Transport (schema level, tablespace level etc)using Data pump EXPDP, IMPDP
• Configure ASM (Automatic Storage Management) in 10g on RHEL4.
• Creation of Physical Standby(Data Guard).
• Configured Production database and Standby database for Switch Over
• Applying Patches Using OPatch,OUI.(Interim Patch and Patchset).
• Upgraded database from 10g to 11g through DBUA.
• Working with Oracle Support in case of any emergency help required to fix the issue by raising Service Requests(SRs)
• Monitoring Checking of OS level Process using SAR,PS,TOP,DF command.
• Coordinating activities between the project team and database administration.
• Generating AWR,ASH report and ADDM report using sql-script.
• Gathering STATS.

Confidential

DBA

Responsibilities:

• Responsible For Installation & Configuration RAC Database.
• Implementation of RAC using ASM on 2 Nodes.
• Monitoring the ASM disk group and adding the disk to the disk group when required.
• Monitoring the Database health check and growth with script.
• Creation of RAC Database using DBCA Tools as well as Manual.
• Migrating Non-RAC DB to RAC DB using RCONFIG utility.
• Configuring the RAC database in Archive log mode.
• Configure RMAN for the backup of RAC database using a Catalog Repository database.
• Enable the Flashback feature of 10g in RAC environment and make use of it for flashback the database, table and query.
• Clone the RAC database to single instance database using RMAN/Hot Backup.
• Apply patches both Interim patches as well as Patch Set patch using Opatch and OUI in RAC environment.
• Taking Backup of OCR and VD.
• Upgraded RAC database from version 10.2.0.1 to 10.2.0.4
• Performed Oracle software Installation Unix Environment.
• Documenting database operations
• Providing Technical support to Production Environment and developers
• Creating databases according to clients need by generating scripts or by Database Configuration Assistant (DBCA).
• Health Checks (Production Database status, Tablespaces Free Space, Backup status, Other Scheduled Cron Jobs status).
• Managing the user accounts.
• Creating Users, Profiles Granting specific Privileges and roles to the Users.
• Killing User Session.
• Control File, Redo log File and Archive Log Maintenance
• Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed
• Cloning of database to different machine for testing purpose through RMAN or Manual.
• Installing and configuring Oracle NET on Server and Client machines
• Recovering database objects using Flashback ON/Recyclebin utilities(10G)
• Logical backup using Exp and Imp
• Applying Patches (Interim and Patchset) Using OPatch and OUI.
• Gathering STATS for tables, indexes, schemas, database level.
• Generating AWR,ASH and addm reports.
• Putting table in KEEP/RECYCLE POOL.
• Pin & unpin SQL procedure .