Kamlesh Kumar Singh Email & Phone Number

• Have 11+years of experience in IT industry as Oracle DBA.• Worked as Exadata Database Machine Administrator (DMA).• Hands on experience of patching ExaCC VM, grid and database home through OCI console.• Hands on experience of Exadata machine patching the software/firmware in compute node, Exadata storage servers, and Infiniband switches• Performance & health monitoring of both Exadata machines and database through OEM and CLI.• Space management from ZFS console.• Scaling of resources (like CPU and RAM) from OCI console for Exacc.• Experience in Installation & configuration of oracle clusterware/grid and database 19C/12C/11G.• Good Hands on Patching and Upgrade of Oracle Databases• Database migration/refresh using RMAN, data pump and dataguard. • Hands on experience to use clusterware and grid Infrastructure tools.• Troubleshooting issues for the RAC and database• Hands on experience to work on ASM.• Knowledge of add/remove node process from RAC.• Proficient in using RMAN, Configuration of backup in server and OEM.• Proficient in configure logical trough data pump and physical backup through RMAN.• Configuring backup schedules depending upon business strategy (daily backup, weekly backup and monthly backup) through cron job.• Implementation and maintaining database security (create and maintain users and roles, assign privileges).• Implemented dataguard/DR between data centers using Oracle Active Data Guard.• Performed DR drill from primary to standby and vice-versa • Proactive working with Oracle Support in order to resolve critical issues of hardware and software. • Knowledge and understanding of numerous software packages and operating systems.• Knowledge of Basic Shell Scripting, Written multiple scripts and deployed for housekeeping. • Result oriented, self-motivated, team player, ability to work independently• Self-motivated, quick learner with strong problem solving and analytical skills, ability to work independently. • Hands on experience to use Service now and AOTS.

Listed skills include Oracle, Linux, and Sql.