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