SUMMARY:

• A technocrat with over 8 years of experience in Database Build, Administration, Client Servicing and Troubleshooting/Technical Production Support.
• Experience in administrating MS - SQL, MySQL and MangoDB database servers.
• Excellent experience in production support, installation, configuration, upgrades Migrations, patches, performance tuning, backup and recovery, cloning, space Management, database security, auditing.
• Installed, configured and managed Golden Gate replication between both RAC and non-RAC environments.
• Hands on experience of MS-SQL Server 2008 & 2012 Enterprise servers on production, Test and Dev boxes.
• Refresh/Create database using RMAN Duplicate/Alternate host restores and perform data refreshes using Datapump utility, Transportable Tablespace, Traditional EXP/IMP.
• Troubleshooting of Performance and Tuning problems in Oracle database using tools like AWR, ASH, ADDM, SATSPACK, OEM Grid Control and manual scripts.
• Installed and configured Oracle 12c Enterprise manager to monitor and report the Database health for over 500+ databases.
• Applied Oracle Patches (CPU/PSUs and One-off patches).
• Installed and administered Oracle 10g and 11g Data Guard.
• Experience in administrating Exadata Machine.
• Strong analytical and problem solving skills, a very good team player and also has the ability to work independently when needed and a quick learner of new technologies.
• Oracle Support processes for technical requests through Metalink.
• Experience in administering various 24x7 On-Call Production Support for critical applications.

TECHNICAL SKILLS:

Operating system: Windows 2008, 2012, Sun Solaris 9, 10, Linux RHEL 5, 6, AIX 5.3, 6.1, Confidential UX 11.

Database: ORACLE 8i/9i/10g/11g/12c, MS-SQL and MySQL.

Tools: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMANGoldengate, TOAD, Patch Management, Data pump, Data Broker.

Database: ORACLE 8i/9i/10g/11g/12c, MS-SQL and MySQL

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Database Administrator

Key Skills: Data Guard, EXP/IMP, Data Pump, RMAN Backup/Recovery, Golden Gate, RAC, OEM Cloud Control, TOAD

Responsibilities:

• Good knowledge and lot of hands-on experience in implementation of database servers (includes HA setup like RAC, Goldengate and data guard).
• Execution of scripts, user creation and management.
• Backup and restore using RMAN utility.
• Deploying the scripts in database on the advice of application team.
• Working on End User requests in the database.
• Regular monitoring of all DB environments (RAC, Goldengate, data guard & single instance).
• Creation of clone database using RMAN for testing.
• Logical Backup of Databases using Export and Import Utility as well as using Datapump. migrated databases using GG and RMAN for 2 node RAC
• Resolved replication issues in Goldengate
• Configured Goldengate on production servers.
• Worked on Golden Gate setup and issue tracking and resolutions with Oracle support.
• Worked with on RAC resolutions on hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, voting disk loss.
• Troubleshoot performance issues for the RAC instances (GC events)
• Severity I issues resolution with corruption of individual disk data blocks, loss of OS configuration files, net configuration files.
• Resolved/Diagnose Node Eviction.
• Upgrade of 11g R2 RAC to 12c RAC.
• Implementing OEM cloud control and installation of agent in servers.
• Maintained all existing databases and new installations at current and stable production levels.
• Applied patches, quarterly patch security updates to existing instances.
• Proactive analysis of systems by running AWR, ADDM reports and taking necessary measures.
• Experience in monitoring and tuning system resources associated with the database performance, hit ratios, I/O, lock and latch contention.
• Deploy and maintain MongoDB databases/DB projects
• Manage and maintain both MongoDB servers across multiple environments.
• Automation of Startup, Shutdown on all production and development databases.

Environment: Windows, Linux, UNIX, SunOS, AIX

Confidential, Jersey city, NJ

Database Administrator

Key Skills: Data Guard, EXP/IMP, Data Pump, RMAN Backup/Recovery, Golden Gate, RAC, OEM Cloud Control.

Responsibilities:

• Worked as a Team Lead for Oracle DBAs to support Production and various non-prod environment and maintaining Oracle databases 12c/11g/10g/9i on Solaris, Confidential -UX, AIX, and Linux.
• Lead onsite-offshore DBA team to provide round the clock Production and non-prod enhancement support of a team sized 15 DBA’s (Onsite & Offshore)
• Work allocation, Track the status and report the weekly, monthly metrics to the client on the tasks and enhancements
• Developing and Implementing Disaster Recovery (DR) Plan.
• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose
• Database cloning from Production to Test and Development environments
• Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace, TKPROF, STATSPACK, AWR and ADDM reports.
• Experience in Identifying performance bottlenecks on high volume transaction systems.
• Creation of database maintenance plans, rebuild indexes and integrity checks
• Intensively involved in the area of installations of Oracle Software, Configuration for database and day-to-day routine works for database administration.
• Implemented database auditing, data security and Remediate high-risk violation in production environment.
• Developed PL/SQL programs (Functions, Procedures, Packages and Triggers) executing on Database.
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management, Index management
• Created Users, Roles and Managing Security & Concurrent Managers administration.

Confidential

Database Administrator

Key Skills: Data Guard, EXP/IMP, Data Pump, RMAN Backup/Recovery, Golden Gate, RAC, OEM.

Responsibilities:

• Creation and Maintenance of Oracle databases as per the specification provided by application team, taking care of disk space, memory and other available resources.
• Downloaded and apply patches.
• Installed Critical Patch Update (CPU) on Clustered (RAC), NON Clustered databases and ASM instances on versions of oracle release.
• Software Upgrade (10.2.0.3 to 10.2.0.4)
• Installed Oracle on Linux
• Created and maintained database using homemade UNIX (KORN) shell scripts.
• Database Refresh using RMAN.
• Managing Users by Creating Roles and Granting & Revoking privileges
• Created oracle objects on request
• Restored database using RMAN on request
• Space management
• Resolved performance issues reported on production database

Environment: Windows, Linux, UNIX, SunOS

Confidential

Database Administrator

Key Skills: Data Guard, EXP/IMP, Data pump, RMAN Backup/Recovery, Golden Gate, RAC, OEM.

Responsibilities:

• Production support 24/7.
• Determination of type of oracle server setup.
• Installation of Oracle Database servers (ASM, clusterware, grid and database software installation).
• Implementation of RAC database on ASM storage with node addition and deletion.
• Handling upgrade and patching of RAC databases.
• Handling node eviction and multiplexing clusterware files.
• Installed GoldenGate software in Test and dev instances
• Configured Goldengate on production servers
• Upgraded Oracle Goldengate v10 to v11
• Moving the RAC DB instances from non ASM to ASM and viceversa.
• Grid Infrastructure installation and configuration.
• Installation and configuration of ASM in all the servers.
• Patching the binaries with the latest PSU patches and Bundle patches.
• Patching the cluster software and database home with rolling upgrades.
• Creation of Database in all type of servers.
• Configuration and administration of Data guard.
• Execution of scripts, user creation and management.
• Backup and restore using RMAN utility.
• Data/Database migration using RMAN in various scenarios.
• Cluster configuration verification using Cluvfy utility.
• Database upgrade from 10.2.0.4 to 10.2.0.5, 10.2.0.5 to 11.2.0.1 and 10.2.0.5 to 11.2.0.3.
• Cluster upgrade from 11.1.0.6 to 11.1.0.7 and 11.1.0.6 to 11.2.0.4
• Worked on various scenarios of restore from tape independently.
• Scheduling backup policy and writing UNIX shell scripts for scheduling automated backup.
• Exporting and importing data in database using Data Pump utility.
• Deploying the scripts in database on the advice of application team.
• Working on End User requests in the database.
• Regular monitoring of all DB environments (RAC, data guard & single instance).
• Implementing OEM grid server and installation of agent in servers.
• Configuring server and database monitoring for all servers and database in OEM.
• Testing switch over and switch back in the servers in DR site and primary site.
• Database refresh in various servers using RMAN (both single instance & RAC setup).
• Installation of oracle client in the application server and also adding up tns entry and setting up database connectivity.
• Troubleshooting the problems and issues and finding a workaround and avoiding down time for all the environments.
• Hands-on experience in working on DR-drill activity various times and ensuring that activity is completed perfectly.

Environment: Windows, Linux, UNIX, SunOS, AIX

Confidential

Database Administrator

Key Skills: Data Guard, EXP/IMP, Data Pump, RMAN Backup/Recovery and RAC

Responsibilities:

• Worked on various scenarios of restore from tape independently.
• Installation of Oracle Database servers (ASM, cluster ware, grid and database software installation).
• Patching the binaries with the latest PSU patches and Bundle patches.
• Patching the cluster software and database home with rolling upgrades.
• Configuration and administration of Data guard.
• Execution of scripts, user creation and management.
• Backup and restore using RMAN utility.
• Cluster configuration verification using Cluvfy utility.
• Scheduling backup policy and writing shell scripts for scheduling automated backup.
• Exporting and importing data in database using Data Pump utility.
• Deploying the scripts in database on the advice of application team.
• Working on End User requests in the database.
• Regular monitoring of all DB environments (RAC, data guard & single instance).
• Implementing OEM grid server and installation of agent in servers.
• Configuring server and database monitoring for all servers and database in OEM.
• Testing switch over and switch back in the servers in DR site and primary site.

Environment: Windows, Linux, UNIX, SunOS, AIX

Confidential

Database Administrator

Key Skills: Providing support as L1, User ticket handling, EXP/IMP, Data pump, RMAN

Responsibilities:

• Creation of Tablespaces, data files, users etc., for the project requirement.
• Controlling the users operations by limiting the memory spaces and grant the necessary roles, privileges and profiles to the users.
• Performed regular RMAN backups to safeguard from User errors and Media failures.
• Creation of clone database using RMAN for testing.
• Using TKPROF, STATSPACK to find ways to improve the database’s performance.
• Creation of Clone database for the test database environment using RMAN.
• Logical Backup of Databases using Export and Import Utility as well as using Datapump.
• Recovery of lost objects and datafiles.
• RMAN Backup and recovery strategies.
• Datafile Consistency using DB Verify.
• SQL Loader and PL/SQL Object creation
• Implementation of DATAGUARD Physical Standby.
• Checking the Archive log shipping between the Primary and the standby (DR) databases and troubleshooting it by rebuilding the Standby databases.
• Transportable Tablespaces.
• Recovery Catalog using RMAN.

Confidential

L1 support for Linux servers and Oracle Database

Responsibilities:

• Handling incident queue and assigning to team members based on priority and criticality.
• Arranging conference call between respective team with customer to understand the current issue.
• Monitoring system generated alerts and raising incident based on priority.
• Assigning resources to change request CRQ on schedule window.
• Raising change request based on request from client and incident ticket.
• Performing basic health check on Server and Database, sending report to higher management.
• Follow up with respective team to resolve incident ticket which is SLA going breach.
• Managing customer service operations for rendering and achieving quality services.
• Responsible for resolving customer complaints on performance bottlenecks.
• Providing value added customer services by attending customer queries and issues.