Arjun Kadam

About Arjun Kadam

An Information management professional with 12+ years of experience. Specialized in Database Administration of Oracle PostgreSQL, OCI Exadata service and Azure PAAS databasesIn addition, excels in database optimization and tuning. Seeking a challenging career as a Database Administrator/Architect to explore his capabilities, where work is a constant learning process.Mail - a••••••••@gmail.comMobile - 90••••••38

Experience

1. Database Administrator

   Tata Consultancy Services

   Mar 2012 — Present · Mumbai, IN

   Oracle Cloud Database Operations and Migration (ExaCS):• Oracle cloud foundation setup using Oracle Database service for Azure (ODSA) and interconnect.• Migration of on-prem and Azure oracle databases to OCI Exadata cloud service using Zero Downtime Migration (ZDM) and Datapump approach.• Implementation of dynamic scaling on OCI VM cluster to perform automatic scale up/down to reduce OCPU.• OCI ExaCS DomU Quarterly and monthly maintenance activities (VM cluster,Grid,Oracle)• Managing Exadata and CDB/PDB operation through dbaascli (backup restore, cloning, best practices) Oracle and open-source Database Operations:• Installed and configured oracle RAC 2 node 12c/19c setup and 2 node standby setup.• Implementing Data Guard, Managing & Troubleshooting issues related to archive shipping, and parameter configuration. Performing database role switchovers during DR Drills.• Configuration OEM agent on new database target for monitoring• Configured Various Information publisher reports for monitoring, Health Check, Database growth, DB inventory and other alerts in OEM 13c.• Configured Custom Metric extensions to fetch custom database reports such as standby archive gap report, user account expiry status report.• Experience on Azure cloud portal,Server provisioning,Managing databases on Azure ( SQL,MySQL, PostgreSQL)• Optimized Oracle servers CPU to reduce overall license cost and periodic DB purging activity to release spaceon the database.• Oracle Database security standards implementation such as Oracle TDE, SSL connectivity using TCPS, walletcreation and addition of certificates for HTTPS security.• Quarterly Database and Grid infrastructure PSU patch apply for standalone and RAC database.Automated Database health alerts using OEM (tablespaces, object sizing, ORA- error tracking, object maintenance like index rebuilds, table movements etc)• Identifying worst-performing SQLs and getting them fixed with the help of SQLTRPT, SQLHC report.

Education

• D.G. Ruparel College

  High School

  2005 — 2007

• Vidyavardhini's College of Engineering and Technology

  Bachelor of Engineering (BE)

  2007 — 2011

Skills

• Postgresql
• Oracle Database Administration
• Affiliate Marketing
• Html
• Web Development
• Mass Email Marketing
• Ca Automic
• Database Administration
• Oracle Apps Dba
• Unix
• Oracle Applications
• Php
• Bmc Control-M
• Sql
• Linux
• Databases
• Oracle
• Email Marketing
• Mysql