Hari Prakash Chintala Email and Phone Number

● Providing 24*7 Oracle Production Database Administration and technical support services for web infrastructure.● Identification, scheduling and application of Quarterly database patches for Oracle Databases.● Identification, scheduling and applying Quarterly WebLogic patches for existing middleware infrastructure.● To perform Monthly OCI OS patching for OCI compute instances and DBAAS OS patching for database servers● Work with the Development, Build, and Operations teams to provide project support.● Provide support for day-to-day deployment of code (Java), and data models on lower and Prod environments.● Optimized queries and reduced user’s resource load increasing efficiency.● Ensure backup and recovery strategy for all PROD and non-PROD environments.

• Performed Database Backup, restore and recovery using CommVault.• Managing and Monitoring Table space level issues and Database space issues.• Performed Schema and Table refreshes.• Performed database decommissions.• Generated Reports in ServiceNow on Weekly Basis for Database Tracks (Oracle, SQL, DB2).• Experienced in working with Application, Network and Unix teams to resolve issues related to servers and databases.• Managing alerts and scheduling Blackouts through OEM 12c and OEM 13C.• Managed Mount point alerts.• Regular Monitoring of Database, Alert log Files and trace files.• Work on user requests related to Roles, Privileges and Profiles as per Business Requirement.• Applying latest releases of the RDBMS patches using Opatch utility from Oracle to the Production.• Verify all scheduled Backup and Restore jobs have run successfully without any issues using CommVault.• Excellent Team management, Oral and Written communication skills.• Monitoring database for locks/table space/temp issue.• Monitoring DiskGroup space utilization.• Regular DBA Activities such as setting up users, assigning roles, privileges, monitoring the database server load.• Working with Oracle support team to resolve critical issues.• Performing weekend maintenance activities.• Setup and maintain Standard Operating Procedure Documents.• Provide Technical and functional KT to new Hires.

• Performed all types of refreshes using Export, Import and Data pumps.• User Administration, DB files and temp files administration.• Monitored and Managed Table space level issues and Database space issues.• Experience in performing DB RAC Cloning using RMAN .• Performed Database Backup, restore and recovery using Recovery Manager (RMAN).• Database Upgradation from Oracle 11g to Oracle 12c• Performed database decommissions.• Experience in generating AWR, ADDM reports through OEM and manually.• Have experience working on Incidents, Service requests RITMs and Change requests depending on SLA’s.• Regular Monitoring of Database, Alert log Files and trace files.• Worked on user requests related to Roles, Privileges and Profiles as per Business Requirement.• Monitoring Schema object (Tables and indexes) growth.• Monitor users and transactions• Verify all scheduled jobs have ran successfully without any issues.• Worked in taking RMAN COLD and HOT backup manually and through OEM.• Monitoring database for locks/table space/temp issue.