BHANU CHANDER

Overall 8.5 years of IT experience Including 6years in Oracle Database Administration in production Support. This covers in-depth understanding of software development aspects, database aspects, customer orientation, quality aspects and the associated processes existing in the organization. Monitoring Oracle11g, 12c and 19c database on AIX, Linux and Windows platforms as Core DBA. Experience on Dataguard Setups, and Fixing bugs, applying Patches, Managing ASM Databases, and Performance issues on RAC Databases. Expertise in performing DR DRILLS for planned maintenance activities. Experience in database administration like Datapumps, RMAN, and Physical standby databases using Data Guard Failover and Switchover. Provided 24/7 DBA on-call support for Production databases. Also supported development and test instances. Cloning databases using various methodologies like – cold, hot refresh, EXP/IMP and RMAN on different platforms. Good knowledge of Oracle Architecture. Experience in Active Dataguard activities. Experience in managing security and access to databases by granting and revoking appropriate privileges to the users. Expertise in tools like DST, DMA, DSP.

• CITI Bank, WIPRO Technologies, 02/2023, Till Date, Providing 24
• 7 supports for 10g, 11g, 12C and 19c databases handling the incident tickets which has to be resolved within SLA and implementing the requests to change the requested changes to the databases. Monitoring 11g, 12c and 19c OEM continuously to make sure no database services to be down. Plan and co-ordinate with team members to have a smooth operational activities., Operational Support involves effectively monitor and resolve critical issues of customers oracle instances. Our team of support spans across database, technical, operating system with strict adherence to the predefined service level agreements in providing 365
• 24
• 7 remote support for critical production databases and development databases. Resolve Incidents and Service requests in the ticket queue and proactively resolve DB related problems, based on alerts triggered. Creation of Tablespaces, user maintenance, database security imposition by creating and granting of roles and privileges, performance tuning, backups (Hot/Cold/Logical) using RMAN. Responsible for administration and supporting Oracle 10g, 11g, 12c and 19c Databases. Expertise in tools like DST,DMA,DSP,Confluence page. Expertise in weekend activities like Grid level patching. Currenty working on complete cloud environment database which is fuly automated. Cloning the database using RMAN and Hot backup. Performance-tuning services for clients with ADDM, AWR, and troubleshooting databases using oracle utilities. Configure LISTENER & TNSNAMES files & troubleshooting. Review alert logs files to check for any problems related to databases. Working with Space Management Alerts (Data file, max extents and database file system alerts. Example: Archive log file system alerts.). Working with traditional and data pump utility for the selective data export and import on production/test/dev on client/online team request basis. Using STATSPACK/AWR to generate the report to check the performance and ADDM report recommendations. Creation of Clone Databases for non-production environments using RMAN and User managed backups according to the client requirements. Maintaining the process related documents up-to-date for important database activities such as Server down time, DR Activities, timing of RMAN backups, errors in the alert log files and Known Issues etc. Performing database refresh with Prod copy as per the requirement using RMAN duplicate. Experience on Dataguard Setups, and Fixing bugs, applying Patches, Managing ASM Databases, and Performance issues on RAC Databases. Expertise in performing DR DRILLS for planned maintenance activities. Experience in database administration like Datapumps, RMAN, and Physical standby databases using Data Guard Failover and Switchover. Implementation support to Installation of Oracle RDBMS software, client software in Production Servers and Development Servers in Linux platforms. Production Database Support Monitoring sessions and DC to DR Log sync. Applying CPU and PSU patches in oracle database. Configuring Dataguard Setup Physical standby database.
• Shared Service Support, CtrlS Data Center, 01/2018, 04/2022, Create database User, Profile, Role for security purpose. To configure database into archive log mode. Handling issues raised from end users through HPSM (Ticketing tool). Configuring LISTENER and DATABASE LINK. Configured Auditing to audit information about database activity. Cloning of Production to Dev/Test servers using hot backup and recovered the database as per the business requirement. Rebuilding indices and gathering stats for better performance Applied Oracle RDBMS patches using opatch utility. Proactively monitor 11g &12c Oracle environments for multiple customers. Resolve database incidents to ensure database availability and stability. Coordinated Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery. Devise strategy for Backups, recovery. Involved in Physical & Logical Backups (Export / Import)/data pump for Schemas based, Full Database. Physical standby database convert into Snapshot standby database for DR application testing. Upgrading oracle database from 11.2.0.3 to 11.2.0.4 Configured Physical Standby Database 11gr2 Administrating RAC Database and cluster ware using SRVCTL and CRSCTL Configuring Dataguard Setup Physical standby database. Performed hot and cold backups, logical backups and user managed recoveries and RMAN recoveries. Performance-tuning services for clients with ADDM, AWR and troubleshooting databases using oracle utilities. Monitoring and managing the Table spaces and data files. Monitoring the performance of the databases viewing Alert log files & Trace files. Rotation On calls support 24X7. Used HPSM change managements and task requests for any changes performed on production. Attending Major Incident calls and resolving issued within time period. Monitoring production OEM support for performance and high availability. Resolving archive log gaps using RMAN incremental backup. Configuration Oracle Physical standby database using Hot backup and RMAN backups. Physical standby database convert into Snapshot standby database for DR application testing. Weekly once analyzing the index structure and rebuild it due to performance. Monitoring and managing their Disaster Recovery (DR) server. Responsible for the archive log shipping from Production to DR and the recovery of the same. Physical Standby & ADG standby rebuild on affected databases performed.

B.Tech (CSE)-JNTU

Nationality: Indian

I hereby declare that all information stated above is true to the best of my knowledge. Signature (Bhanu Chander M )