OBJECTIVE:

A career opportunity with a progressive organization where I can apply my technical, supervisory and administrative skills to achieve project/unit goals, where initiative, hard work and results are recognized and where I can share my technical expertise and grow professionally.

PROFESSIONAL SUMMARY:

• Having more than 7 years of experience in areas of Oracle Database Administration in Production Environments handling different versions of Oracle from 9 to 11g R2 on various Operating systems like IBM AIX, Red Hat Linux, with good Knowledge On Oracle Architecture
• 2+ years of experience in Exadata Machine L3/L4 Support, managing Exadata compute nodes/cell storage nodes
• Experience in Planning, coordinating, executing Quarterly Full stack patching for EXADATA with no downtime (100% availability)
• Co - coordinating with Oracle on the ASR’s generated for hardware issues in EXA environment
• Generating EXACHK reports, analyzing the report and take corrective actions
• Experience in Exadata ILOM management
• Experience in SOX compliance process for databases
• Proficient in automating reports/tasks through Shell scripting/OEM information publisher reports/BI publisher reports
• End to end management of EXADATA in OEM12c, configuring incident rules, monitoring templates, generating tickets etc.
• Analyse and optimise the ticket stratergy and find scope for automation and work with the automation team to see the feasibility of automation
• Proficient in Oracle Database Design & Administration, Backups & Recoveries, Performance Monitoring & Tuning and Shell Scripting.
• Experience in installation and maintenance of RAC and ASM
• Installation of 11GR2 Grid Infrastructure RAC and Standalone Server
• Experience in Setting up Oracle Data Guard, Data Guard real time apply and Data Guard Broker for administration of Physical Standby databases.
• Experience in installation and configuration of Oracle Enterprise Manager 12 cloud control, deployment of 12c agents
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration and applying oracle patches on single instance & RAC DB
• Design database backup strategy for production, non-prod databases, database duplication and recovery operations through Recovery Manager (RMAN) and Flashback technology
• Experience in data transfer utilities like Data pump and import/export
• Administrating all database objects like Table/Index segments, Constraints, stored procedures and triggers. Managing Database Structures, Database Access, Roles and Privileges
• Experience on using ADDM, AWR, Oracle Enterprise Manager for performance monitoring
• Proficient in Unix Administration part pertaining to DBA i.e. User maintenance, Monitoring of CPU, Disk and Memory usage, File system monitoring and writing Shell scripts for basic database administration
• Experienced in handling the team as a lead and confident in handling customer escalations
• Experienced in representing DB tower in Rapid Response(WAR Room) in case of a High Priority issues
• Innovative in approach, hardworking, structured, performance oriented, with a penchant for strategy, knowledge transfer, analysis and research, is extremely committed to the job and eager to work towards the excellence of my company
• Possess quick and strong grasping power, excellent communication and organizational skills. Always adaptive to new environments and enjoy learning new things
• Proficient problem-solver who envisions business and technical perspective to develop workable solutions. Experienced in handling Production issues and providing efficient solutions.
• Excellent database support record demonstrating excellent customer service, ability to troubleshoot and ability to innovate
• Experience in working with global teams & self-motivated, desire to learn independently

SKILL:

• Oracle DBA (9i to 12c), RAC, Performance Tuning, Backup and Recovery, Troubleshooting
• Oracle Exadata, GoldenGate administration
• OEM administration
• AWR, ADDM, SQL/PLSQL, shell scripting, Code review
• Exalogic system administration
• Linux, Solaris,AIX,Windows
• HP OMI, HPOO

PROFESSIONAL EXPERIENCE:

Confidential

ORACLE EXADATA ADMIN/ORACE DBA/OEM ADMIN

Responsibilities:

• Working as a Team lead to own DBA operations (Oracle/Exadata) provide technical guidance, client interactions, team building, people management and ensuring strong handshake between onsite - offshore teams.
• Coordinating and participating in Exadata Patching activity
• Exadata user management
• Generating EXACHK/SOS reports
• Set up GoldenGate(GG) environment, troubleshoot and fix the GG errors
• Expertise on Oracle Real Application cluster Administration(RAC)
• Oracle Automatic storage management
• Managing and maintain oracle Data Guard(Standby Database)
• Database creation, patching and migration
• Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
• Managing/generating Quarterly SOX audit reports for the SOX complaint database’s
• Worked with developers to provide queries and tuning the queries for better performance.
• Testing of backups using different backup solutions like (Avamar/Networker/DDBOOST)
• Perform Continuity of business test using standby setup. Deploy recovery techniques during media failures. Extract and report database performance co-ordinates using Stats pack /AWR.
• Configured OEM incident rules, monitoring templates, thresholds etc.
• Managing a team of 12 resources
• Identify the KPI(Key Performance Indicators) in the DB area and making sure the KPI’s are healthy
• Relocation of OCR/VOTING disks as part of storage migration for 10g/11g dbs
• Providing monthly service improvements /Automations
• Scheduling APP connect meetings with application team, to help them asses the database wrt capacity/performance/issues
• Review/access the DB landscape and identify the Key risks/issues and derive a plan to mitigate the risk
• Representing the CAB/CCB meetings of change management process
• Work on problem tickets derived from the high priority tickets(P1) and find the RCA and fix to prevent future occurrences
• Responsible for maintenance and administration on, enhancements, following change management policies, report capacity and availability, updating of the ticketing system and KEDB.

Confidential

ORACLE DBA

Responsibilities:

• Database Administration for Production, Test, Development, Staging and Standby Servers,
• Performing daily health checks of production and test instances & keeping Production databases up and running 24x7
• Managed more than 1500 databases
• Install and setup OEM12c
• Installing agents, adding targets, setting metrics for alerts
• Setting up of Oracle Standby database for production databases for disaster recovery
• Exploring oracle new features of ORALCE 12c and enabling those at the database level
• Creation and working on oracle 12c databases
• Have automated many manual tasks through shell scripting, which saved ample of time
• Resolving critical issues related to database
• Work with other teams and take care of maintenance activities
• Cloning oracle homes
• Upgraded Oracle Enterprise Manager from 12.1.0.1 to 12.1.0.3
• Setting up of Batch jobs which are highly critical for business, scripts through crontab for monitoring alert logs, cleaning trace files etc
• Providing 24/7 on-call support to databases we support
• Also successfully converted physical standby db to ACTIVE STANDBY DATABASE
• I have setup necessary scripts for database duplication, new RMAN features like In-Memory Cloning (active database duplication) which helped to reduce time taken to refresh databases since there is no need to pull the backups from tape, actively use 11GR2 Target less Database Duplication feature for duplicating databases

Confidential

ORACLE DBA

Responsibilities:

• Database Administration for Production, Test, Development, Staging and Standby Servers
• Designing and Creation of new Oracle databases both RAC and Non-RAC, configuring cluster database services to suit Client Needs
• Performing daily health checks of production and test instances & keeping Production databases up and running 24x7
• Monitoring the trace files, Alert and log files
• Responsible for designing database backup strategy for production, non-prod databases as per Client requirements, perform database duplication and recovery operations through Recovery Manager (RMAN)
• Applying Oracle quarterly patches for Oracle 11g Cluster, Oracle Grid Infrastructure and Oracle databases and bug fix patches whenever recommended
• Setting up of Oracle Standby database for production databases for disaster recovery
• Maintainenance and troubleshooting of Oracle 2-node RAC 10g,11g,11gR2 & single instance database in AIX,LINUX
• Database Restore/Refresh from prod/staging to lower environments for business purpose
• Installing Oracle Agents, Setting up Oracle Enterprise Manager to monitor all targets to ensure databases are up 24/7
• Administrating all database objects & Managing Database Structures, Database Access, Roles and Privileges and Database Auditing
• Preparing necessary scripts, install packets for major production release and implementing same
• Providing 24/7 on-call support to databases we support
• The project also expects us to cater to the needs of the customers by continuously keeping track of new requirements and implement oracle features for better stability and environment support, below are some of my major s:
• Installation of 11GR2 Grid Infrastructure RAC and Standalone Server
• Upgrade of Grid Infrastructure (Standalone), databases from 11.2.0.2 to 11.2.0.3
• Upgrade of 2-node RAC database from 10g to 11g
• Involved in configuration of Oracle Enterprise Manager 12c, deploying 12c agents
• I have set up Oracle Data Guard(Physical Standby) for Oracle 9i,10g and 11g databases successfully. Data Guard real time apply is being setup for all 11g databases and Data Guard Broker for administration of Standby databases. Performed Disaster Recovery activities successfully
• Have automated entire refresh process through shell script which had complex process of pre & post refresh steps, also wrote shell script for listener log purging
• Have automated email notification alert mechanism for application team, alert mechanism if ORACLE DB SERVICES are not running on preferred & available nodes.