Summary
Overview
Work History
Education
Skills
Certification
Extra-curricular activities
Languages
Timeline
Hi, I’m

Richard Adaikalanathan

Bengaluru

Summary

Skilled Senior DATABASE ADMIN and CLOUD CONSULTANT bringing 10+ years’ experience in administration of databases and expertise in Replication, Performance Tuning, Backup & Recovery, Cloud Data Migration and architecting, designing Cloud solutions. Knowledge on datastore like MYSQL,MongoDB,Cockroach DB and also on Kubernetes and GKE.Collaborative and team-oriented with first- rate oral and written communication, complex problem-solving and decision-making abilities.

Overview

10
years of professional experience
1
Certification

Work History

Apple India Pvt. Ltd

DBA and Cloud Consultant
10.2022 - Current

Job overview

  • Administration/Performance Tuning of large number of mission-critical Apple Databases for Mongo,MySql, Oracle and Cockroach DB
  • Worked on database migrations from On-Premise to AWS RDS and EC2
  • Worked on database migration to GCP CloudSQL, BigQuery and GCE
  • Provided effective resolutions to issues and involved in planning, pre-migration and post migration activities and co-ordinating with various teams for successful implementation
  • Driving P0/P1 calls with business and stakeholders on migration progress and issues.
  • Worked with staff to develop and implement procedures to prevent data loss and maximize system availability demonstrating technical client service.
  • Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
  • Provided solution designs to meet system strategies, capabilities and technologies and to respond to current and future business requirements.
  • Provided architectural leadership and guidance to technical teams to deliver robust, highly scalable and cost-effective solutions.
  • Basic Understanding of building data pipelines.
  • Defined cloud architecture for both hybrid and non-hybrid cloud solutions.
  • SSL certificate management/renewals for on-prem and AWS hosted DBs
  • SQL Plan management and query optimization issues
  • GoldenGate replication and troubleshooting lag and performance issues

CitiCorp Services India Pvt.Ltd

Senior Manager and Cloud Administrator
10.2020 - 10.2022

Job overview

  • Worked as Senior DBA and Cross-functional Manager for 12 markets across the globe including MY, TH, IND, HK, CHINA, AUS for Global consumer Banking LOB
  • Mentoring and managing a team of more than 20 experienced resources
  • Managing BigQuery ,analyzing performance of queries , POC for data migration
  • Perform Version upgrade, migration from AD to LDAP, patching of DB2 databases
  • Risk control and Internal Audit management
  • SQL Plan management and query optimization issues
  • COB drill and Failover of critical Citibank online and mobile applications
  • Worked with internal specialists, product, and engineering teams in driving different projects in tandem with stakeholders with defined roadmap/milestones.
  • Working on Major upgrade projects from 12c to 19c OraaS and InPlace upgrade
  • Program Management, Metrics Management and Project Management
  • Worked on Oracle/ MySQL/ MongoDB

Oracle India Pvt. Ltd

Oracle DBA and Cloud Administrator
10.2019 - 10.2020

Job overview

  • Worked in oracle database migration from 12c On-Premise to 18c Cloud in OCI and AWS RDS and EC2
  • Patching in all 18c databases from 18.3.0.0 to 18.8.0.0
  • Performing DB backup and refresh from Production to development environments using Cloud backup Utility in OCI
  • Performing application upgrade and weblogic administration
  • Provided effective resolutions to issues and escalated problems with knowledgeable support and quality service
  • Oracle 20c autonomous database administration.

TATA CONSULTANCY SERVICES

Senior Oracle DBA
04.2016 - 10.2019

Job overview

  • Coordinated with project management on database development timelines.
  • Implemented security measures to protect vital business data.
  • Conducted tests to identify issues and make necessary modifications.
  • Built databases and table structures for web applications.
  • Set up and controlled user access levels across databases to protect important data.

COGNIZANT TECHNOLOGY SOLUTIONS

Oracle DBA
10.2013 - 04.2016

Job overview


  • Responsibilities:
  • Worked in oracle database versions (9i, 10g, 11g and 12c) and PostgreSQL
  • Upgrading oracle database from 11.2.0.4 to 12.2.0.1
  • Performing DB refresh from Production to development environment
  • Performed Cloning using RMAN Utility
  • Troubleshooting performance issues in production servers
  • Extensive experience in OEM 12c and 13c Tool
  • Working with RAC management and ASM Disks Management
  • Analyzing AWR reports
  • Implemented uni-directional replication using Goldengate and troubleshot lag issues.

Education

Anna University
Chennai

MBA from General Management
09.2015

DMI College Of Engineering
Chennai

Bachelor of Engineering from Electronics And Communication
05.2013

University Overview

GPA: 8.0

Don Bosco School
Chennai

05.2009

University Overview

GPA: 93%

Skills

  • Performance Tuning, Backup & Recovery- Cloud Data Migration
  • Installing and maintaining Oracle database versions and datastores like MySql, MongoDB and Cockroach DB
  • Experience on Unix/Linux and Windows OS platform
  • On-prem to Cloud and Cloud to Cloud database migration ( RDS, Cloud SQL ,Spanner, BigQuery, Aurora,EC2/GCE etc)
  • Deliver successful implementations of cloud solutions
  • Troubleshoot query performance and index related issues
  • Deep understanding of GCP and AWS technologies and GCP, AWS, OCI certified
  • Network troubleshooting knowledge (traceroute, ping ,ifconfig, nslookup, netstat)
  • Fundamental Knowledge of Python and scripting
  • SQL plan management, Sql baselines and profiles management
  • Goldengate replication, monitoring and troubleshooting
  • MYSQL, MongoDB, IBM DB2 Administration
  • Disaster Recovery Management, Strategic Planning, Risk Mitigation
  • Devops tool - Kubernetes
  • Experience in project management and delivering technical solutions

Certification

ITIL V3 certified
Oracle Cloud Infrastructure
AWS Solution Architect
GCP Associate Cloud Engineer
Oracle Autonomous Database Specialist
Oracle GoldenGate 12c Implementation Essentials

Extra-curricular activities

Cricket (School, College and District Team). 

Table Tennis/Badminton.
Certified in Swimming

Languages

English
Native or Bilingual
Tamil
Native or Bilingual
Hindi
Limited Working

Timeline

DBA and Cloud Consultant

Apple India Pvt. Ltd
10.2022 - Current

Senior Manager and Cloud Administrator

CitiCorp Services India Pvt.Ltd
10.2020 - 10.2022

Oracle DBA and Cloud Administrator

Oracle India Pvt. Ltd
10.2019 - 10.2020

Senior Oracle DBA

TATA CONSULTANCY SERVICES
04.2016 - 10.2019

Oracle DBA

COGNIZANT TECHNOLOGY SOLUTIONS
10.2013 - 04.2016

Anna University

MBA from General Management

DMI College Of Engineering

Bachelor of Engineering from Electronics And Communication

Don Bosco School

Richard Adaikalanathan