Prashant Sharma (OCP®, OCE®)

Client: Kaiser Permanente: Founded in 1945, Kaiser Permanente is recognized as one of America’s leading health care providers and nonprofit health plans. With $95.4B Operating revenues, Kaiser currently serve members in 8 states in US and the District of Columbia. Environment: Managing a large number of PDBs in Oracle 19c with a focus on multitenant architecture (Container Databases (CDBs) and Pluggable Databases (PDBs)).Allocate CPU, I/O, and memory resources to individual PDBs using Resource Manager. Manage and monitor resource utilization to ensure fair distribution and avoid resource contention. Leverage Oracle Data Guard for disaster recovery and high availability. Create clones of PDBs quickly for testing and development purposes. Relocate PDBs between CDBs with minimal downtime using the PDB Relocate feature. Implement a robust backup and recovery strategy to ensure data integrity and availability.

Vendor Management: • Acted as the primary link between the organization and HCL for a few applications. • Coordinated with HCL to ensure timely delivery of services and resolution of issues. Backup and Recovery: • Ensured robust backup and recovery processes. • Coordinated with HCL on disaster recovery planning and testing. Security and Compliance: • Implemented database security policies and ensured compliance with regulatory requirements. • Worked with HCL to apply security patches and updates. Monitoring and Reporting: • Established and maintained monitoring systems for database health and performance. • Generated and reviewed regular reports on database metrics with HCL. Stakeholder Communication: • Communicated effectively with internal stakeholders to understand their database needs. • Facilitated regular meetings and updates with HCL and internal teams.

Kyndryl (Ex-IBM) • Experience in installation, configuration of oracle 11GR1 RAC databases on Linux with ASM • Setting up oracle 11gR1/12c data guard on Linux production and standby with ASM. • Upgrade of Oracle RAC from 11gR1 to 11gR2 ASM • Structured data warehouse data into appropriate reports using Teradata database. • Experience with ADDM and SQL performance tuning. • Supporting the production environments with deployments and break fixes. • Experience in database design and implementation. • Experience in supporting Exadata environments. • Extensive experience in setting up and administration of Oracle RAC. • Experience in setting up data center migrations using Dataguard. • Extensive experience with RMAN for backup and recovery. • Supporting the oracle development environments. • Experience in supporting multiple application/production environments. • Excellent Backup and recovery scenarios and have good experience in recovering 10G/11G/12c databases. • Experience in supporting and upgrade of all oracle versions all oracle database versions 10g/11gR1/11gR2/12c. • Experience with Oracle 12c pluggable databases and converting to pluggable databases. • Extensive experience with RMAN for backup and recovery. • Experience in setting and maintenance of standby databases. • Experience in maintenance and production support of 24/7 oracle databases. • Strong communication and coordination skills.

Client: Thames Water, A large private utility company responsible for the public water supply and wastewater treatment in most of Greater London, Luton, the Thames Valley, Surrey, Gloucestershire, north Wiltshire, far west Kent, and some other parts of England. Environment: Oracle 12c, 11gR2, 10g, 9i on HPUX, AIX and Linux, Managed 120 databases. Client: Friends Life, UK was a Guernsey-incorporated investment vehicle which had the stated intent of consolidation in the British life insurance industry. Environment: Oracle 11gR2, 10g, 9i on HPUX, AIX and Solaris, Managed 145 databases Client: Diageo, UK, a multinational beverage alcohol company, with its headquarters in London, England Environment: Oracle 11gR2, 10g, 9i on AIX, Managed 75 databases. Client: Jones Lang LaSalle Incorporated (JLL), A global commercial real estate services company, United Kingdom with offices in 80 countries Environment: Oracle 10gR2 on windows. Managed 42 databases. Client : Informa PLC, a British publishing, business intelligence, and exhibitions group. Headquartered in London, it is listed on the London Stock Exchange and is a constituent of the FTSE 100 Index. Environment: Oracle 12cR2 on AIX. Managed 15 databases.

· Datacenter implementation at one of the hydropower stalwart in public sector, which includes 2 nodes RAC and one dataguard in different location. · Commissioning of database servers in 23 different locations of India’s public sector aviation company. · End-to-end solution (which includes installation of oracle RAC 2 nodes, one disaster recovery site and 2 IFS applications servers) at a public sector company that deals with networking and communications. · Setup of an entire data centre in an Iranian-South African company located in Iran and supported it for 9 months on a deputation in Iran. · Supported oracle database in about 25 different clients of IFS Solutions where I got good exposure in RAC, ASM, Dataguard, database duplication and RMAN with proven ability in design, implementation and support of various high availability solutions for diverse group of companies running Oracle 9i, 10g & 11g using Data Guard, RMAN. The other tools that I worked with were DBCA, EXP/IMP, expdp/impdp, Backup/Recovery, LSNRCTL, NETCA, NETMGR, dbv, orapwd, oradim, LSNRCTL, ASMCA, ASMCMD, RMAN, srvctl. I was also well versed in Oracle Architecture Concepts, working on OEM/XManager/Telnet, Database Backups and Recovery like entire Database/Datafiles/Tablespaces using RMAN, User managed recovery, Production ,UAT and Test databases, installation of Oracle (9i, 10g, 11g) on platforms like windows, HPUX, Linux, Solaris & AIX, remote administration of database tools through VPN connection, teamviewer and RDC static IP. Successfully recovered production databases of 3 different clients.