PRAVESH KUMAR

• Showcased excellence across full oracle lifecycle support of Oracle databases (11g R2, 12c R1,12c R2, 19c) in Linux/Solaris/Unix/virtual environment supporting mission critical systems;
  proficient in database architecture, implementation, high availability, networking, securing, patching,
  cloning, monitoring, performance tuning, configuration and troubleshooting Oracle databases.
• Extensive intelligence in ITIL & ITSM foundation framework which includes Service Delivery
  functions such as Incident Management, Problem Management, Change Management & Configuration
  Management; expertise in managing high-severity incidents to ensure service availability with minimal delay and impact towards ensuring smooth operations of various environments
• Technology Evangelist enthusiastically meeting deadlines with innate skills in building high performing
  teams entailing 20 members that excel in delivering business value through technology transition
• Migrated & upgraded databases from Oracle 11g to 12c, 12c to 12.2 and 12.2 to 19c
• Monitoring & optimizing performance of the database, planning for backup & recovery of the database, allocating system storage & planning future storage needs
• Backups using RMAN for complete & valid restore and recovery purpose
• Monitoring & optimizing performance of the database, planning for backup & recovery of the database, allocating system storage & planning future storage needs.
• Working with the team to provide enterprise-wide, Oracle Database Administration support for production systems; providing DBA services to application development teams entailing database design, database generation & database production support
• Database performance tuning running at object level by de-fragmentation of database storage structure.
• Migration of database from Non-ASM to ASM storage.
• Database restoring with flashback feature.
• Managing Data Guard gap detection and resolution.
  
  
  

Project Title: Airtel Datacenter Noida Database Migration
Client: Airtel DC NOIDA UP

India Leading telecom Bharti Airtel datacenter Migration

Butterfly transformation project in India, Transform post-paid business data with the new IT solution for post-paid products-CRM, Billing, OM, EPC.

• Design telecom Hobs EPC Product according to client DC/Network architecture and successfully implemented.
• Installation and configuration of Oracle Database environment on Linux, Handled and troubleshoot oracle issues and applied database patches and refresh data between databases.
• Analyze solution and assist the migration strategy and guide them solution of circle wise incremental migration. Coordinate with Customer in calculation hardware (Cores and memory) for maximum utilization of existing and new resources.
  Design and implement DR and Physical Backup via tool.
• Monitored and optimized the performance of DB
  through Stats Pack/AWR/ADDM.
  Bitmap/B-tree indexes, Parallel Query, Materialized view. Online table redefinition, undo management, DML locks resolution, rebuild indexes etc.

• Project Title: BSNL DC Migration Project
• Client: BSNL
• Expansion & consolidation of Data Center Migration and upgrade, DB Management.
• Migration of BSNL datacenter to completely new upgraded datacenter with larger operational capacity. Databases for Kenan Admin, catalog and 50 billing Kenan customer databases sized 2+ TB each, along with Mediation, Roaming and Connect-Vu migrated with Zero Down time. Tuxedo Middleware, Mediation, Roaming and AI applications also migrated to new site.
• Reshuffled hardware (Cores and memory) for maximum utilization of existing and new resources.
• Database design and implementation to support capacity expansion.
• Creation and maintaining OS failover cluster, business Copy and Databases RMAN backup configuration for the same. managing entire storage plan and configuration on DC & DR.
• Remove fragmentation at object level and reclaim space after huge data deletion in tables. Tuning database instance, memory structures, tuning queries to optimize query execution plan, performance report analysis (like Stats pack, AWR etc.), tuning OS kernel for optimized database/OS performance.
• Planning and Restoration of complete DC at DR site using Ignite backup.
• Configuration of ZDB and hot RMAN backups on HP Data Protector and resolution of related issues.
• Restore and recover databases for migration and in case of any failure, check backup sanity and undo any human error.

Project Title: Network Switching System
Client: Idea Communication Noida

Oracle database Installation and configuration.
Perform upgrade of databases and software to new release levels.
Manage database's storage structures.
Support all day to day activities related to database like data consolidation, data migration scripting.
Manage schema objects, such as tables, indexes, and views.
Monitor DB backup on daily, weekly basis and maintaining database so that in case of any discrepancy system can be restored to original state.
Proactively monitor database's health and taking preventive or corrective action as required.
Monitor and tuning performance issues.
Schema refreshes using Oracle Export & Import data Pump Utility.
Managing database storage structure like tablespaces, tables, indexes.
Database cloning/Upgrade and duplication using RMAN.
Convert Business need in to Technical complex queries.
Experience in Data migration using import and export.
Write procedures, functions, views, materialized views as required.
Responsible for performance tuning activities in project.