Richard Adaikalanathan

• 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

• 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

• 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.

• 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.

• 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.

GPA: 8.0

GPA: 93%