Database Administrator Capacity Planning

John Chelliah

+1-706-***-**** **********@*****.*** www.linkedin.com/in/jchelliah/ Sacramento, CA Career Summary

IT professional database administrator with over 25 years of hands-on experience in database and Very Large database (VLDB) administration, Cloud adoptions and migrations, Linux/Solaris System Administration, Backup & Recovery, High Availability, Disaster Recovery, and Performance tuning. Expertise in SuperCluster and Oracle Exadata engineered system Architect and Configuration, Capacity Planning, Administration, Troubleshooting critical issues and Advanced product Support, Migration Products/Services. PostgreSQL, MS SQL, MySQL administration.

Self starter with excellent ability to deliver results under pressure in high paced environments. Skills

Functional Skills: Global Delivery Professional Services Problem Solving Cross-Functional Collaboration Communication Strategic Consulting Team Leadership: Coaching Mentoring.

Database Management: Oracle Database (Version 8 to 23ai) HA/DR (Backup/Recovery, RAC, Data Guard, RMAN, Flashback) ASM SQL*Loader Database/SQL Performance Tuning Exadata SQL Oracle Enterprise Manager (OEM) PostgreSQL MS SQL MySQL Data Migration/Replication: RMAN DataPump DMS

Programming Languages: Shell scripting Python PL/SQL Operating Systems: Oracle/Red-Hat Linux Sun Solaris Windows HPUX IBM AIX Professional Experience

Senior Principal Advanced Services Engineer May 2007 – Jan 2025 CSS (Formerly ACS) Tech Delivery - Eng Sys & Cloud Infrastructure, Oracle -US I worked at Oracle for 17+ years in different roles in Pre and Post-sales support, solution architect including leading delivery teams, mentoring and coaching of delivery engineers, and short/long-term consulting.

• Managing Requirement gathering, design, capacity planning, implementation of application and database architecture and Oracle products and MAA(Maximum Available Architecture) solutions and services for various top-tier businesses and organizations.

• Built customer trust through QoS, Escalation Management, QBRs, and cross-team collaboration for faster issue resolution. Developed proactive services, reducing reactive work by 40-45%.

• Collaborated with Engineering team for Planning and Configuration patterns of deploying engineered systems like Exadata, ZDLRA, SuperCluster and OCI C@C.

• Configuration of Exadata Machines, ZDLRA and Supercluster using Oracle Proprietary installation tools.

• Exadata/Database migration, patching and upgrade, RE-IP, Expansion, Multi-racking, Disk Swap and HW troubleshooting

• Subject Matter expert (SME) for designing and maintaining High Availably of Oracle Products like Real Application Clusters, Active Dataguard, RMAN.

• Worked in conjunction with Oracle support and independently on troubleshooting and root cause analysis for critical issues across Oracle database products and all Engineered Environments.

• Performance tuning, capacity planning and configuration Assessment of Oracle Engineered Environments

• Facilitated data refreshes across environments of databases upwards of 10TB in size.

• Managed Exadata and Supercluster related problems from identification to completion.

• Conducting POCs for Exadata/SuperCluster/ZDLRA environment to various oracle clients

• Provided complete documentation for all work performed while onsite with customer, and mentor the customer’s DBA staff on Oracle products.

Past Career Experience

Senior DBA – Cognizant, Chennai

Supporting numerous MS-SQL, PostgreSQL Oracle Database Components like RAC, Dataguard, ASM and Streams for various customers.

Jan 2005 – May 2007

DBA – Sify,Chennai

Leading team of 7 DBAs to support inhouse Oracle, PostgreSQL and MySQL databases.

Dec 2003 – Jan 2005

DBA-Global Digital innovations, Bahrain

DBA to support Oracle databases and MS-SQL server databases. Oct 1999 – Oct 2003

Jr DBA -TNSoft, Chennai

DBA to support Oracle databases and MS-SQL databases. Jun 1998 – Oct 1999

Education

MBA( Information Technology) Sikkim Manipal University 2006 Post Graduate Diploma in Software Technology SSI 1998 Bachelor of Science (Physics) Bharathiar University 1998 Certifications & Trainings

• Oracle cloud training 2020-24

• OCI 2024 Cloud AI 2024

• OCA Oracle Automous DB cloud 2022

• OCA Oracle Cloud Infra 2020 2021

• ZDLRA TOI 2016

• Oracle Exadata administration 2012

• Oracle 11gR2: GI, administration 2010

• Oracle 11gR1 new feature 2009

• Oracle Certified DBA expert 10g 2008

• Oracle 10G: 10GR2 RAC 2006

• Oracle 10G: Dataguard 2006

• Oracle 10G: New Features for Administrator 2005

• Oracle 9i: Real Application Cluster 2005

• Oracle Certified DBA Oracle 9i (OCP) 2004

• Oracle Certified DBA Oracle 8i (OCP) 2000

Contact this candidate