Kishan M

Work History

Database Administrator

Cisco India Pvt Limited

11.2023 - Current

Responsible for managing40+ Oracle database pods with both engineered and non engineered systems for IOT control center for smooth operation of IOT devices on vehicles
Fixed100+ performance issues of databases for client impact resolution
Delivering assistance for vital production databases and creating database engineering services for AWS PostgreSQL databases
Expertise in cloud security services like IAM Policies, Secret Management, and KMS; extensive familiarity with AWS RDS PostgreSQL
Using CloudFormation, Python, and GitHub to work directly with services like Lambda, Systems Manager, CloudWatch, and SAM Database Infra Automation
Good Knowledge on AWS CI/CD workflows
Diagnosed100+ Oracle and PostgreSQL database performance issues on AWS
Managing10+ Oracle Datawarehouse instances on Exadata x5-2,x6-2 and x8m to improve provisioning,billing and reporting of IOT software
3 Years hands on experience on ASMCMD, IORM, DBFS, Flash Cache, DCLI, ADRCI utilities and achieved high performance and availability of the systems
Participated in hackathon and got3rd place for building anomaly detection system of oracle
Gathered the requirement for patching the Exadata Machine5+ times
Having good knowledge on dcli, cellcli utilities in Exadata
Troubleshooting the patching critical issues with internal team
Using dbnodeupdate.sh to patch the Exadata database OS upgrade; patchmgr to upgrade storage cells; and patchmgr to patch the Infiniband switch
Update database12c to12.1.0.2 and apply the most recent12.1.2.1.2 OS version to the Exadata Database, Storage (CELL), and Infiniband Switches

Senior Software Support Engineer

Oracle India Pvt Limited

10.2021 - 11.2023

Accomplished professional with extensive experience as a global support engineer serving1000+ customers both platinum and non-platinum to troubleshoot and solve business critical outages
Analyzed the cause for90+ potential bugs filed for the different product area of oracle software
Work closely with oracle developers and fixed30 defects
Undertaken500+ escalation of issues on database products for severe performance impacts on mission critical systems
Handled600+ performance issues of database for traditional and engineered systems
Active Involvement in Oracle community support and answered30 consultations for technical assistance
Got15 Appreciations from different customers for timely resolution of Batch and SQL slowness
Experience in data warehousing systems with90TB size databases and features like Materialized views, Parallel execution, Transportable tablespaces, In memory, Multitenant architecture in PDB
Published60 Oracle Knowledge documents of new issues from SR’s
Project - Global Database Performance Customer Support (200+ customers)

Technical services specialist (L2 / L3) - SME Project – HMG

IBM India Pvt Limited

12.2020 - 10.2021

Serve as SME to solve and troubleshoot critical issues on100+ mission critical systems
Automated Maintenance tasks of40+ databases
Analysis of300 critical database space requirement and contention in regular basis for proactive prevention of issues
Detection of anomalies of database performance issues using supervised and unsupervised machine learning algorithms
Used AWR and ASH to solve50+ complex performance issues to operate100% optimal business
Timely generation of EXACHK report for hardware and software configuration issues1 week and1 month
Accomplishments – Recognition for Managing3 regions for stabilizing the environment by automation and diagnostics

Technology analyst Project – Molina

Infosys limited

12.2018 - 12.2020

Having strong experience and knowledge in performance tuning on SQL and database instance tuning using a wide range of technologies including ASH, AWR, SQL trace, SQL profile, SQL Tuning optimizer, SQL Tuning advisor, EXPLAIN PLAN, TKPROF
Established and wrote the Database Administrators Procedures document for the organization
The document outlined all standards for the DBA Operations Group including creating databases, RMAN backup &recovery, DBA tools, administration and monitoring, naming standards
Provided training & knowledge transfer to DBAs on Oracle architecture, Oracle new features, tuning methodologies, RMAN backups
Configured standby and redesigned a thorough backup and recovery strategy for all major production systems to overcome from media failure, user failure, and system crash
Experience in Data Pump, export & import, physical hot backup, RMAN, experience in regular DBA activities such as database refresh, schema refresh & DB alerts, Database migration and database upgradation
Involved in disaster recovery activities like switchover and failover
Accomplishments – Got hike for good performance for stabilizing the project in an exemplary manner

Application technical support associate

Accenture

03.2017 - 11.2018

Strong analytic and problem solving skills On-call production support DBA activities (Oracle11g and12c Database) with24x7 rotational shifts
Install and configure high performance database as per the requirement for both OLTP and OLAP
Worked as fulltime employee in Accenture (Bangalore)(3.4 YEARS)
Project – Starwood / Marriot
Accomplishments –Achieved stewardship award for proactive precautions

Associate software engineer

alchemy techsol pvt limited

07.2015 - 03.2017

Strong analytic and problem solving skills On-call production support DBA activities (Oracle11g and12c Database) with24x7 rotational shifts
Install and configure high performance database as per the requirement for both OLTP and OLAP
Worked as contractor in alchemy techsol pvt limited from28- July-2015 to29-March2017(Starwood/Marriot) for the Accenture client
Accomplishments –Achieved stewardship award for proactive precautions

Summary

Overview

Work History

Database Administrator

Senior Software Support Engineer

Technical services specialist (L2 / L3) - SME Project – HMG

Technology analyst Project – Molina

Application technical support associate

Associate software engineer

Education

M.Sc - Data science

PG Diploma - Data Science

M.Tech - CSI

B.Tech - Information technology

Skills

Community Service

Accomplishments

Timeline

Similar Profiles

Mohammad Shoeb ShaikhMohammad Shoeb Shaikh

KARTIK MOHAN PILLAYKARTIK MOHAN PILLAY

DEEPA RAVINDERDEEPA RAVINDER

Ranjith C ARanjith C A

Manjunath ShekarManjunath Shekar