Lukka Phani Kumar

PHANI (ORACLE DBA) Email :--Cell :- - ➢ ORACLE DATABASE ADMINISTRATION SUMMARY:✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ ✓ Having around 4+ years of Experience in production support on 24*7 Environment. Installation of oracle 10g/11g/12c database on Unix flavors. Creation & Configuration of Databases with DG setup. Troubleshooting the issues in the database level. Backups and restoration Data pump, RMAN, Export/Import. Performed the multiple database upgrade from 11.2.0.4 to 12.1.0.2 Experience in Applying Patches,Patchsets, Upgradations. Hands on experience in Patching on RAC and NON-RAC environments. Hands on experience in both in-place and out-place patching. Good experience in patching using cloning home method. Having experience in outplace (rolling) patching with zero downtime for databases. Performed Quarterly Bundle Patches for all Production, Pre-Prod and Dev environments. Cloning Databases like RAC & NON RAC, Converting to RAC HOME to NON RAC HOME. Migrating Database from Non-RAC to RAC & Non ASM to ASM. Creation of RAC & Non RAC ASM databases, ASM instances and administration of ASM Instances and ASM Disk groups. Created and Maintained Non-RAC & RAC Stand-by database. Configuration of clone & catalog database. Recovery of lost objects and data files using RMAN. DR drills from Production to Standby and vice –versa. Design and implemented RMAN backup strategy for RAC databases. Administration of ASM Instances and ASM Disk groups in RAC environment Having experience in Migrating Non-RAC Database to RAC Database. Design and implemented RMAN backup strategy for RAC databases. Administration of ASM Instances and ASM Disk groups in RAC environment Administration of RAC instances using SRVCTL, CRSCTL. Having experience in Configuring and Managing Physical standby databases. Having experience in database cloning & Migrations by using RMAN. Experienced in Backup activities using Export/Import utilities. Creating Tablespace and data files according to requirement Hands on experience of Recovery scenarios. Cloned the oracle database. Performed daily backups, restoration of data as per requests from client using RMAN. Performed Database and Schema refresh. Implementing and maintaining database security (creating and maintaining users and roles, assign privileges). ➢ INDUSTRY EXPERIENCE • • ➢ Oracle DBA for Rolta India, Mumbai.(May 2016 to April 2019) Oracle DBA for IBM India pvt.ltd, Mumbai. (April 2019 to May 2020) QUALIFICATION • ➢ B.Tech from JNT University, Kakinada in year of 2016 TECHNICAL EXPERTISE ✓ Databases : Oracle 10g and 11G /12C DBA activities ✓ Operating Systems : Linux, OEL, Windows. ✓ Networking : TCP/IP, Oracle Net. ✓ Database Tools : SQL Developer,OEM, Exp/Imp, Data pump, RMAN. ➢ PROJECT ABSTRACT Project 1 : Support, Maintenance & Upgrade Company Client Name Role Environment Duration : : : : : Rolta India, mumbai. National Grid, USA Associate Oracle DBA Oracle Database 12c&11g May 2016 toApril 2019 Role: Associate Oracle DBA Responsibilities: ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ ➢ Providing 24X7 support for production and Development databases Part of core Production DBA team maintaining production databases. Installation and Configuration of Oracle databases. Performed patching, Upgrading Databases and clusters from 11.2.0.1 to 11.2.0.4 and 11.2.0.4 to 12c. Applying Patches, Patchsets. Maintaining and managing stand-by databases using Oracle Data Guard. Maintaining RAC&Non RAC ASM databases, ASM instances & administration of ASM Instances and ASM Disk group. Configuring RMAN and maintaining Recovery catalog, writing automation scripts for RMAN and performing backup and recovery with RMAN. Planning and Scheduling backups using Cron. Administering the physical aspects of the database such as creation of Tablespaces, Users. Maintenance of Database security. Implementation of backup and recovery processes. Coordinating activities between the project team and database administration. Project 2 : Support, Maintenance & Upgrade Company Client Name Role Environment Duration : : : : : IBM Indiapvt.ltd, mumbai. DBS Bank, Singapore. Associate Oracle DBA Oracle Database 12c&11g April 2019 to May 2020. Role: Associate Oracle DBA Responsibilities: ✓ Created new databases and users: set up backups, export, and other monitoring scripts using RMAN and for recovery strategy. ✓ Creating and monitoring the tablespaces, allocating tablespaces for users. ✓ Creating and managing database objects like tables, views, and indexes. ✓ Creating, granting and monitoring user access rights and privileges and roles. ✓ Maintain user access, space management, and database security. ✓ Checking of Alert log and Trace files to monitor the database on a daily basis. ✓ Created and maintained database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers. ✓ Monitoring and maintaining of CRON jobs. ✓ Design, develop, and implement automated backup and restoration procedures. ✓ Transferring the data between one database to another database using logical backups like EXP/IMP and DATAPUMPS. ✓ Cloning/ Refresh from PRODUCTION instance to TEST instances using both Hot and Cold Backup. ✓ Provide technical support for database maintenance. DECLARATION: I hereby declare that all statements made above are true and correct to the best of my knowledge and belief. Thank's and Reguards, Phanikumar.L