PROFESSIONAL SUMMARY:

• I have 7+ years of experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control and Enterprise Manager on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platforms.
• Installation and configuration of Oracle Server (12c,11g,10g,9i) on IBM AIX, HP-UX, Sun Solaris, Redhat Enterprise Linux and Windows servers in production and development.
• Worked in production (24x7), staging, development & test databases.
• Worked on disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.
• Managed Shell Scripts to Automate RMAN Backups, Hot/Cold backups, Imp/Exp, Datapump, Dump and Schema Refresh, and Production to Dev/Stage Sync up etc.
• Worked on performing Database Tuning - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
• Expert in deploying Oracle 10g/11g/12c agents, Installing and configuring Enterprise Manager 11g Grid Control for very large environment.
• Installation, Configuration and Support of Oracle High Availability Solutions such as Standby Database with and without Data Guard Broker setup, Advanced Replication with Single and Multi master setup and Oracle Streams Replication.
• Proficient with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
• Experience in creating stored procedures, functions, packages, triggers, according to business requirements.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies, Strong interpersonal and communication skills.

TECHNICAL SKILLS:

HP: UX, AIX, Sun Solaris, Red Hat Linux, Oracle VM Server, VMware and Windows Servers / 2005/2008/2012.

Languages: SQL and PL/SQL, UNIX Shell and Perl Scripts

Databases: Oracle 9.x, 10.x, 11.x, 12c, SQLServer 2005/2008R2/2012, Netezza 7.0, 7.2

Clusters: Sun Cluster, IBM HACMP Cluster, Veritas Cluster, Oracle Clusterware, Oracle ACFS and OCFS.

High Availability: Oracle 9i/10g/11g RAC and Standby Database.

Monitoring: OEM Grid Control (10g, 11g, 12c)

Tools: & Utilities: Toad, Aginity, PLSQL Developer and SQL Tools

Oracle Tools: Export/Import, Datapump, RMAN, Veritas NetBackup, IBM TSM, Tivoli, Awamar, DataDomain.

Ticketing System: BMC Remedy and ServiceNow.

Domain: Pharma, Manufacturing, Utilities and High Tech Sector.

Office Tools: Microsoft Office, Lotus Notes and Office 365.

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Installed Grid Infrastructure Software on new Linux Servers for 2 node and 3 node RAC and Failover environments and Oracle Grid Control 11g Installation.
• Experienced in Installing OEM agent and hooking up to the grid.
• Worked on OEM 12C grid for monitoring the Listeners present in the oracle environment.
• Worked in troubleshooting RAC and implemented ASM features.
• Upgraded databases from 11g to 12c on Linux.
• Upgraded and deployed OEM grid agents for 12c OEM grid control.
• Experience in Managing Netezza databases ( create/refresh/backup database, Grant access on database)
• Mentored many fellow DBAs on "Citi-Way" and has been a constant point of contact for technical/non-technical discussions.
• Involved in installations, configurations of SQL Server 2005.
• Maintain, upgrade and troubleshoot Sql server databases.
• Played vital role in establishing change control management for database releases.
• Mentor SQL, PLSQL and Performance Tuning to wide range of audience across the organization.
• Installations/Configuration/Migrations: Installation and configuration of 2, 3, 5 node ORACLE 10G/11g RAC on LINUX/SUN/AIX with ASM and Oracle Clusterware.
• Cross platform migration (little Endian to Big Endian) using Transportable Tablespaces on the Test, Development and Production Databases (10.2.0.4 to 11.2.0.3) from linux to HP-UX.
• Implemented Oracle database 11g Two node Real Application Cluster (RAC) using Oracle Clusterware for achieving high Availability on ASM.
• Deployed scripts for monitoring Golden Gate lag and process (Extract, Datapump and replication)
• Involved in applying patches as per the requirements of the client and upgrade Oracle and DBMS software under Oracle
• Worked on OEM GC 12c/11g, scheduling and troubleshooting OEM jobs and deploying OEM agents. Scheduling Backup Jobs and troubleshooting failed jobs through OEM GC.
• Performance testing (Stress testing) of third vendor applications for DB parameter settings, capacity planning (Memory, Space, CPU) and SQL tuning.
• Lead the DBA team to successfully patch Dev/Stress/Production databases with July-2012 PSU.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Responsible for all the DBA related jobs for all the instances; performance tuning, backup & recovery (RMAN, if required), managing users & privileges, resource limits etc

Environment: Oracle 9i,10g,11g, OEM 10g/11g/12c, RMAN, Data guard, Sun Solaris 5.9, 5.10, AIX 6.1, RHEL 3.x/4.x,/6.x, RAC, ASM, SQL Server 2005/2008 and Netbackup.

Confidential

Oracle DBA

Responsibilities:

• Installation of oracle databases and Oracle Binaries for Failover Environments including creating and up gradation of databases using scripts.
• Support involves as an Oracle Database Administrator across cross platform provisioning systems and solutions, Oracle 11i Financials Systems and Data warehouse systems.
• Support involves handling multiple Oracle 10g RAC with Veritas Cluster, Sun Cluster and Oracle Clusterware across various applications hosted in Oracle 9i/10g and 11g Databases across Linux, HP-UX and Solaris
• Extensively involved in Performance and Tuning of various Oracle Reports/Queries for Oracle 8.x, 9.x and 10.x version for various Provisioning Applications and Datawarehouse.
• Configuration of various alerts and monitoring in Oracle database using Oracle Enterprise Manager Grid 10g.
• Extensively worked on Backup/Recovery using RMAN and Scripts based for Oracle 9.x, 10.x, 11.x with SAN and NAS File systems with and without Oracle ASM.
• Worked exclusively for decommissioning of the databases for the applications has been migrated over to the new environment.
• Worked on Ticketing System with Remedy Service Desk for various Production Support Issues for 24X7X365 Days.
• Responsible for planning and upgrading databases to 11.2.0.1/11.2.0.2.
• Automated most of the House keeping jobs and alerts using shell/SED/AWK and Perl Script and configured in Tidal Enterprise Scheduler.
• Installation and Configuration of Oracle 10g Instances in VMware Linux Systems for Various Development and QA Environments.
• Extensively involved in Weekly Maintenance, Re-Organization and Health Check of Databases.
• Responsible for 10g and 11g client installation across for all the application servers.
• Extensively involved in Weekly Maintenance, Re-Organization and Health Check of Databases.
• Worked on various Backup/Recovery using RMAN with Tape and SAN for Oracle 9.x and 10.x and also RMAN and VERITAS Net Backup.
• Scheduled Autosys Jobs the AUTOREP browser and configuration of jobs including troubleshooting.
• Implementation of database backups using RMAN (rc catalog) & exp/imp utilities for Transactions DBs and Neaps Filer backup for Data warehouse.

Environment: Oracle 9i,10g,11g, Putty, OEM, RMAN, Data guard, Sun Solaris 5.9, 5.10, Enterprise Linux, SQL Server 2000/2005, AIX 6.x, Windows 2003, RAC, ASM, Toad.

Confidential

Oracle DBA

Responsibilities:

• Install and configure database and applying security patches.
• Proactive performance monitoring by implementing Foglight, UNIX scripts and automated jobs (Grid) for alerts.
• Manage and modified RMAN shell scripts for database back up with various backup policies, and automate scripts for recovery, standby creation, RMAN refresh according to business demands.
• Experience in using packages like DBMS JOBS, Autosys and crontab to schedule tasks.
• Monitor the database backups and services.
• Responsible for applying Oracle patches using the OPatch utility
• Provided 24x7 production support i.e. fixing production issues, supporting new as well as existing applications, troubleshooting production scripts, etc. Experience working with various support teams: oracle support, Quest, SUN, EMC storage support and used Meta-link to download patch and resolve issues.

Environment: Oracle 9i, 10g,11g, Putty, OEM, RMAN, Data guard, Sun Solaris 5.9, 5.10, Enterprise Linux 4.x,5.x,, AIX, Windows 2003, RAC, ASM, Toad, VERITAS HA.