Prasanna Kumar K

• Worked on Canara bank HQ as a Senior oracle database administrator for payroll applications.
• Handled 50+ Oracle RAC databases for HRMS application.
• Worked on DR activities such as switchover and switchback activities.
• Worked on performance tuning for long running payroll sessions.
• Applied DB PSU patch on RAC databases every quarter on prod databases.

• Worked on rehydration of EC2 instances in non-prod environments and applied oracle patch on OS level as well
• Worked on 300+ view creation and testing on the production environment
• Deployed DML and DDL scripts in Jenkins pipeline and involved myself in weekly & Monthly production releases
• Installing and configuration of shareplex in oracle servers
• Worked on restoration of ec2 instances on QA environment from AMI backup
• Worked on multiple user creation, privilege issues and session related performance issues
• Worked on DB upgrade and cloning of oracle databases in QA environment
• Supported Verizon wireless product and managed more than 60+ oracle RAC databases and EC2 instances
• Installing & maintaining shareplex in oracle servers and did replication from production to non-prod environments
• Installing and configuration of oracle RAC 19c databases in Linux environment
• Worked on data pump export & import in prod and non-prod environments
• Worked on multiple user creation, privilege issues and session related performance issues

· Supported Verizon wireless product and managed more than 60+ oracle RAC databases and EC2 instances.

· Installing & maintaining shareplex in oracle servers and did replication from production to non-prod environments.

· Installing and configuration of oracle RAC 19c databases in Linux environment.

· Worked on data pump export & import in prod and non-prod environments.

· Worked on multiple user creation, privilege issues and session related performance issues.

· Successfully learned and deployed an application for report reminder and maintenance in PowerApps technology within a month

· Worked Hands on in power automate flows for the automation of email reminders and report reminders.

· Handled a team of 3 members and performed day to day operations such as data pump backup and object management.

· Successfully migrated oracle databases from 12c to 19c in Linux environments including few production databases.

• Successfully learned and deployed an application for report reminder and maintenance in PowerApps technology within a month
• Worked Hands on in power automate flows for the automation of email reminders and report reminders
• Handled a team of 3 members and performed day to day operations such as data pump backup and object management
• Successfully migrated oracle databases from 12c to 19c in Linux environments including few production databases
• Supervising modifications to any existing database software to meet end-user needs; informing end users of changes in databases and training them to utilize systems
• Installing & maintaining several Oracle database software and further updating the database security protocols
• Conducting database backup and recovery during disaster recovery & testing; fixing database performance issues and capacity issues
• Establishing and configuring several EC2 instances on cross platforms including Linux & Windows
• Interacting with customers to schedule and perform critical production activities
• Monitoring system performance, identifying problems and responding in a timely manner to user-reported errors
• Successfully upgraded and cloned several Oracle databases on both Linux and Windows environment
• Upgraded, patched & performance tuned Oracle databases throughout the Zone-2 Area (London, France, Europe & Spain)
• Improved operational effectiveness by analysing data and developing high-level reports
• Provided technical support for testing initiatives, database upgrades and installations
• Conducted knowledge transfer sessions for the Development Team with focus on enhancing their understanding of database (DB) best practices