Post Job Free

Resume

Sign in

Dba Oracle

Location:
Trumbull, CT
Posted:
July 02, 2021

Contact this candidate

Resume:

Rajitha Udhyamnivas Appukuttan

adnh3e@r.postjobfree.com +1-203-***-****

Summary

**/* ********** ******* *** performance tuning of production instances in Oracle 9i/10g/11g/12c/19c on Sun Solaris, Linux, UNIX and Windows platforms.

Experienced in Oracle Disaster Recovery and High Availability Solutions (RAC & Data Guard).

Overview

Experience in 10g/11g/12c RAC implementation, maintenance and support.

Expertise in Oracle 10g/11g/12c Real Application Clusters (RAC), Oracle Data Guard, Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load Balancing and designing failover systems on Linux servers.

Experience in Oracle 9i/10g/11g/12c Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard),Backup & Recovery (RMAN) and container and pluggable databases.

Installed 12c, 13c OEM, agent on all the servers and configured required thresholds.

Expertise in Installing, Configuring & Creating Oracle 9i/10g/11g/12c databases on Sun Solaris, Linux, UNIX and Windows platforms.

Prepared a script to generate a report which includes wallet status, Vault status, tablespace usage >90%, database status, Rman backup report. It is a single report for entire environment from OEM repository tables.

Configured multiple Golden gate unidirectional setup.

Expertise in upgrading, migrating & patching Oracle 9i/10g/11g/12c database using Oracle migration utilities

Expertise in Designing, implementing and managing Backup strategy using Oracle Utility RMAN, Export/Import and Data Pump.

Administering & Managing Oracle Users, roles, privileges & creating Database objects.

Performed created physical & logical database design, applied patches, monitored databases and OS (Unix/Linux) performance.

Experience as On-Call 24x7 production DBA support, development DBA.

Expertise in Managing, Training, and Mentoring DBA team.

Expertise in Managing, Training, and Mentoring DBA team.

Responsible overall Onsite/offshore deliverables.

Work closely with Customer on managing day to day issues for Comcast Databases and Design.

Co-ordinated handshake between onsite and offshore.

Handled daily call and weekly with team.

Handled weekly and monthly deliverable calls with Clients.

Handle all escalations & provide timely solutions & documented the same.

Administration aspects which include Proactive issue identification and troubleshooting, helping customer to arrive optimum design solutions for Database.

Observe trends of utilization and Provide proactive performance improvement Suggestions and capacity management plan, sustain databases with latest product updates and security updates.

Make sure agreed SLAs for all Tickets/Incidents & Problems.

Ensure entire Database team adhere to Comcast Change Management Policies & Procedures to carry out any change in Production Environment.

Ensure regular connect with On-shore Team and help them deliver the stated services.

Interviewed multiple DBAs based on required.

Education

MCA (Masters in Computer Application) – Bharathiar Univeristy, India

Certification

Oracle Certified Professional (OCP) DBA for oracle 9i - 2008

Oracle Certified Expert : Real Application Cluster 10g - 2010

Technical Overview

Operating Systems

Servers: Red Hat Enterprise Linux 5.0/6.0, Windows 2000/2003 server, Sun Solaris 5.8/9/10

Databases

Oracle 9i (9.2.0.7), Oracle 10g (10.2.0.4,10.2.0.2). Oracle 11g (11.2.0.2), Oracle 12c(12.2.0.1)

Professional Experience

Company: ExcelaCom Technologies Nov -2010 to Apr-2018

Project: Comcast

Role: Senior Associate DBA

Comcast Corporation is an American global telecommunications conglomerate headquartered in Philadelphia, Pennsylvania. It is the second-largest broadcasting and cable television company in the world by revenue and the largest pay-TV company, the largest cable TV company and largest home Internet service provider in the United States, and the nation's third-largest home telephone service provider.

Responsibilities :

Experience in 10g/11g/12c RAC implementation, maintenance and support.

Expertise in Oracle 10g/11g/12c Real Application Clusters (RAC), Oracle Data Guard, Oracle Automatic Storage Management (ASM), Cluster Interconnects, Load Balancing and designing failover systems on Linux servers.

Experience in Oracle 9i/10g/11g/12c Database Administration on Production, Development and Test Databases including Disaster Recovery, High Availability Solutions (RAC & Data Guard) and Backup & Recovery (RMAN).

Installed 12c, 13c OEM, agent on all the servers and configured required thresholds.

Configured multiple Golden gate unidirectional setup.

Expertise in Installing, Configuring & Creating Oracle 9i/10g/11g/12c databases on Sun Solaris, Linux, UNIX and Windows platforms.

Expertise in upgrading, migrating & patching Oracle 9i/10g/11g/12c database using Oracle migration utilities

Expertise in Designing, implementing and managing Backup strategy using Oracle Utility RMAN, Export/Import and Data Pump.

Administering & Managing Oracle Users, roles, privileges & creating Database objects.

Performed created physical & logical database design, applied patches, monitored databases and OS (Unix/Linux) performance.

Experience as On-Call 24x7 production DBA support, development DBA.

Expertise in Managing, Training, and Mentoring DBA team.

Responsible overall Onsite/offshore deliverables.

Work closely with Customer on managing day to day issues for Comcast Databases and Design.

Co-ordinated handshake between onsite and offshore.

Handled daily call and weekly with team.

Handled weekly and monthly deliverable calls with Clients.

Handle all escalations & provide timely solutions & documented the same.

Administration aspects which include Proactive issue identification and troubleshooting, helping customer to arrive optimum design solutions for Database.

Observe trends of utilization and Provide proactive performance improvement Suggestions and capacity management plan, sustain databases with latest product updates and security updates.

Make sure agreed SLAs for all Tickets/Incidents & Problems.

Ensure entire Database team adhere to Comcast Change Management Policies & Procedures to carry out any change in Production Environment.

Ensure regular connect with On-shore Team and help them deliver the stated services.

Interviewed multiple DBAs based on required.

Awards: Received outstanding performance awards from Excelacom Technologies

Environment: Oracle 9i (9.2.0.7), Oracle 10g (10.2.0.4, 10.2.0.2), 11g(11.2.0.2), 11g(11.2.0.4), 12c(12.2.0.1) Oracle Data Pump, Export & Import utility, OEM Grid, TOAD

Company: Apollo Hospital Dec 2008 – Aug 2009

Project: Internal

Role: Oracle DBA

Apollo Hospitals Enterprise Limited is an Indian hospital chain based in Chennai, India. Several of the group's hospitals have been among the first in India to receive international healthcare accreditation by America-based Joint Commission International (JCI) as well as 13 NABH National Accreditation Board for Hospitals & Healthcare Providers hospitals.

Responsibilities

Creating and managing Tablespaces and datafiles

Monitoring Extents and Segments space utilization

Monitoring Alert & Trace Files

Backup of Databases using Logical (Export & Import) & Physical (Online & Offline) Backup

Creating, managing and monitoring users and their profiles

Configure LISTENER & TNSNAMES files & Troubleshooting

Defined user security by creating views, granting roles and privileges

Documenting day-to-day activities, Changes and Development

Environment: Oracle 9i (9.2.0.7), Oracle 10g (10.2.0.4), Export & Import utility.

References:

Available on Request



Contact this candidate