Vikash Kumar Email & Phone Number

Greater Melbourne Area

Darwin City, Northern Territory, Australia

• Performing complete database administration tasks from database creation, backup and recovery, maintaining database objects, monitoring and database performance tuning to Implementing Dataguard for high availability.• Automated database health check reporting so as to get database availability information along with other vital database metrics for all databases in the estate in one place.• Look after the Oracle database estate consisting of 19c EE and SE databases.• Assist in migrating legacy applications running on Oracle to MSSQL. • Installation, patching and upgrade of Oracle databases.• RMAN Backup & recovery, database & schema cloning.

Bengaluru, Karnataka, India

• Plan, discuss, co-ordinate and drive various customer database migrations. • Proactive patch evaluation and deployment planning.• Working for continuous improvement to the Database Engineering and Implementation processes.• Scripted post patching database/clusterware validations which helped in doing proper validations quickly and avoiding the possibility of human errors while checking the clusterware resources’ statuses post patching. This resulted in system downtime reduction and last-minute surprises.

Bengaluru, Karnataka, India

• Discuss, plan and drive database projects. Gather requirements, conduct research, evaluate available technology solutions, test and implement.• Migrating On-premise Oracle Databases to AWS RDS and Oracle OCI OAD (Autonomous Database). Migrating Oracle databases across platforms on On-premise environments. • Installation, patching and upgrade of Oracle databases, backup/recovery, performance tuning, cloning.• Scripting and automation of repetitive and error-prone tasks such as database patching, database creation. Created database administration related self-service tool using Unix Shell scripts that allowed the application teams to carry out L1 database related activities themselves thus avoiding dependence on the DBA.• Maintain high availability for Oracle databases, carry out DR-Drills at scheduled intervals for critical databases and do the required planning and coordination. Working to ensure that targeted Service Levels for production database availability and performance are met.• Evaluating Oracle Patch Updates and Security fixes regularly, testing and applying them patches to the production environment according to the change management process.• Performing complete database administration tasks from database creation, maintaining database objects, setting up monitoring in Oracle Enterprise Manager. Setup Oracle Enterprise Manager Cloud Control 13.4 from scratch and moved databases to it to be monitored.• Implementing Oracle High availability solutions like Oracle RAC, Dataguard.• Monitoring and troubleshooting database and query performance related issues, carrying out pro-active and reactive performance analysis and troubleshooting, conducting SQL reviews for impact analysis prior to production implementation.

Bengaluru, Karnataka, India, Manchester, Uk

• Upgrading and migrating databases with minimal downtime. Successfully migrated several critical production databases for a UK banking giant with zero downtime using Oracle Goldengate.• Automating repetitive tasks such as database patching, housekeeping of applications and databases through writing Unix Shell scripting. Automated Oracle Dataguard setup through Unix shell scripting which helped save several man hours and minimized the risk of human error. • Discussing and coordinating with key stakeholders of various projects, gather requirements, design solutions and implement them. Conduct research, evaluate and test various database technologies for suitability to meet business requirements.• Monitor and troubleshoot database and query performance issues. Conduct SQL reviews for impact analysis prior to implementation.• Implementing Oracle High availability solutions like Oracle RAC, Dataguard and Goldengate wherever appropriate.• Ensuring that the targeted Service Level agreements for production database availability and performance are met. Carry out DR Drills as per planning.• Review database patches, test the installation and implement to remove database bugs and security vulnerabilities. Perform production releases based on release management schedule.• Provided database support for over 1000+ databases (both Production & Development) including flavors of Oracle, Sybase and MS SQL Server.

Bengaluru, Karnataka, India

• Providing assistance to Oracle customers through Service Requests (SR). Owning and resolving problems and managing customer expectations throughout the Service Request lifecycle in accordance with global standards• Handle issues related to database migrations/ upgrades, DBA activities, NLS, JVM, ASM, NET, Internal errors like ORA-00600 & ORA-07445, Installation, Enterprise Manager and those related to Oracle Utilities.• Writing support articles for new or lesser-known issues that can be used by the Support Analysts and the customers alike.• Replicating customer issues inhouse by creating proper database environment for providing solution or bug fixing.• Handling issues related to DBA activities, NLS, JVM, Oracle ASM, Oracle Sql*Net, errors related to Oracle Utilities like exp/imp, datapump, sqlloader etc., memory management related errors like ORA-4030, ORA-4031 etc. and database physical and logical corruption.• Performing Database and query tuning activities using tools like statspack, AWR, ADDM, 10046 and 10053 optimizer traces, sql trace and explain plan etc., database and object statistics collection, analyzing and removing table and index fragmentation, tweaking database initialization parameters etc.