Kumar Ramachandran

About Kumar Ramachandran

Oracle DBA/Architect/Oracle Manager with overall 17+ years of experience in database administration, design, architecture, installation, configuration, development, replication, data modeling, performance tuning, backup/recovery, Database cloning, Database refresh, and high availability solutions of Oracle Database versions 8i,9i,10g,11g,12c, 18c, and 19c • Expertise in Oracle Cloud Infrastructure (OCI) Tenancy, Architecture design & setup covering Exadata Cloud Service (ExaCS/X-7 and X-9), and Oracle Database@Azure.• Design, deployment, and provision of databases (CDB/PDB) on OCI with High Availability (HA) & Disaster Recovery (DR) using RAC/Data Guard.• Experience in Oracle Database Administration (DBA) like patching, backup & restore, cloning, migration, upgrade, and performance tuning.• Holds on many Oracle Technical Certifications (11g, 12c OCP) and Functional Certifications (ITIL, Six Sigma) and AWS Cloud architect Professional in Information Technology.• Experience in Database Team Management for Handling the 40 members of the teams in Oracle, SQL, and DB2, with outstanding communication and project delivery. • Expertise in Oracle Golden Gate 12c, 19c experience including installation and maintenance of application environments, and managing complex replication topology.• Expertise in Oracle RAC 11g,12c, 19c extensive experience in cluster installation, configuration, and administration, extensive knowledge in maintaining Oracle Clusterware using srvctl, crsctl, ocrconfig, cluvfy, private IP, public IP, SCAN IP, and virtual IPs along with NAS, SAN, and ASM storage.• Expertise in Oracle Dataguard 10g,11g,12c,18c, and 19c with Physical & logical standby administration, Snapshot standby, and active dataguard features.• Proficient in identifying and providing database performance improvements, Specializing in SQL tuning, Database/Instance tuning using Oracle utilities like AWR, ADDM, ASH, SQL tuning advisor, STATSPACK, SQL TRACE, TKPROOF, and Explain plans.• Expertise in database security, database audit, user profiles, security patch updates, PCI/PII Data encryption, TDE encryption, and Oracle Wallets.• Expert in Oracle Database Migration from one data center to another data center using RMAN, RAC, Golden Gate, Oracle Dataguard, Exadata, Transportable tablespace, and expdp/impdp methods.• Exceptional and proven database management skills with experience in managing Oracle Builds, Upgrade, Migration, Database security, Disaster recovery, and Patch management in a large complex system.

Experience

1. Senior Database Administrator (Oracle Exacc Cloud Migration Specialist X-7 X-9)

   Medline

   Jul 2021 — Present · IL, US

   Responsible for large-scale migrations of Oracle Databases on platform such as ExaCS, Exadata Cloud at Customer and Oracle Database@Azure. • Responsible for Migration of Oracle database (19c and earlier) leveraging different migration approaches including cross-platform migrations.• Responsible for Administering and Maintaining the ExaCS, Exadata Cloud at Customer X7, X9 and Oracle Database@Azure. • Responsible for Migrating Non-Exacc Oracle Servers to ExaCC X7, X9 Machines and Oracle Database@Azure.• Responsible for Planning, Designing, and Migrating the Database as per the business requirements to the Exacc environment.• Responsible for Planning, Installation, Configuration, Monitoring, and Deployment of database Exacc environment.• Responsible for upgrading 11g, 12c Database to 19c in Exacc Environment. • Hands-on experience building an Exacc VMs Machine from the Scratch as per the business requirements. • Converting Non-PDB Databases to PDBs and plugging into the CDB on Exadata Cloud@Customer X7-2.• PDB Cloning on the Container Databases on Exadata Cloud@Customer X7-2.• Setup a Dataguard, DG Broker configuration.• Hands-on experience in Applying Grid, VM OS, and DB Patches.

Education

• Anna University Chennai

  Master of Computer Applications - MCA, MCA

  2003 — 2006

• University of Madras

  Bsc, Physics

  1999 — 2002