SUMMARY

** ***** ** ********** ** Infrastructure service division with primary skill as database administrator in technologies ORACLE DBA, SAP HANA DBA.

Lead experience in handling team of more than 20 multi skilled DBA resources.

Experience of working at client location, handle escalations, meet SLA and deadlines, maintaining offshore and onsite coordination, ensure knowledge transition, create and maintain SOPs, client engagement, build trust & relationship with customer.

Thorough knowledge in ITSM processes Incident management, change management, Problem

Management.

Open for technical challenges, Flexible to learn and work on any technology. Keen to work on cloud solutions like AWS, Azure, GCP and OCI.

EDUCATION & CERTIFICATION

Bachelors of Technology from KMCET, JNTU University, Hyderabad, India in 2010.

Oracle Certified associate

ITIL

Profession scrum master certified (PSM 1)

PROFESSIONAL HIGHLIGHTS

Experience in design, administration, analysis and implementation stages of Oracle versions 8i to 21c .

Hands-on experience in implementation of Oracle RAC and Data-Guard across data centers in Private

Cloud.

Setup oracle database end to end monitoring including installation of oracle enterprise manager, install agents, create, and implement monitoring templates.

Test and implement Oracle database refresh strategies using RMAN. Document and standardize the process as per requirements.

Test and implement SAP HANA and MS SQL database backups and restore strategies.

Create & maintain scripts to do daily, nightly and weekly maintenance jobs based on the required frequency levels with help of OEM job scheduler or enterprise-wide solution like control M.

Suggest, test & validate back out strategies for activities like database maintenance activities like patching, upgrades and installations, document and standardize the process.

Install & uninstall, upgrade and configure SAP HANA platform edition version 1 SP 12 on multi-node HP hardware.

Upgrade SAP HANA database from version 1 to 2 on virtual machines and physical appliances.

Implemented and managed SAP HANA physical appliances, Enable HA with syncmem and DR with async

replication mode with delta-data-shipping operation mode.

Setup proper monitoring and alerts with thresholds for SAP HANA databases in SAP HANA studio and SAP

Solution manager.

Migrated SAP HANA version 1 and 2 from physical hardware to Virtual machines eventually saving

operational cost and enable data-center migrations.

Executed separate Project Code with End to End planning, preparation, implementation of SAP Oracle & HANA Upgrades to meet customer systems are up to date by upgrading legacy environment to supported versions and customer well appreciated for the work that was dealt Independently .

Setup monitoring solution for database server using enterprise-wide monitoring tools like BMC Patrol.

Maintain and track progress on each continuous improvement task in Jira/Kanban, support task in ticketing tools like BMC Remedy, Service-Now, Infoman.

PROFESSIONAL EXPERIENCE

EMPLOYER- TATA CONSULTANCY SERVICES Duration: Oct’22 – Present

Project: Enbridge Inc – Technical Lead DBA

Location: Houston, Texas, USA. Duration: Oct’22 – Present

Responsibilities:

Work with architects of all infrastructure team to understand the requirement.

End to End Project Code execution for SAP Upgrade Project

Upgrade SAP Oracle Databases from 11.2.0.3 to 19c

Upgrade SAP HANA Databases from SAP HANA 1.0 to SAP HANA 2.0

Create Low level and high-level design document.

Install Oracle cluster or RAC on 5 nodes on virtual machines.

Install 5-node RAC standby, one in local data center and another in remote data center.

Document and standardize process.

Guide and instruct team for installations and try to automate wherever possible.

Help team to fix any issues while installations.

EMPLOYER- TATA CONSULTANCY SERVICES (TCS) Duration: Oct 2017 – Present

Project: Dow Chemicals – Technical Lead DBA

Location: Hyderabad, India Duration: Nov 2017 – Sept 2022

Responsibilities:

Work with architects of all infrastructure team to understand the requirement.

Create Low level and high-level design document.

Install Oracle cluster or RAC on 5 nodes on virtual machines.

Install 5-node RAC standby, one in local data center and another in remote data center.

Document and standardize process.

Guide and instruct team for installations and try to automate wherever possible.

Help team to fix any issues while installations.

EMPLOYER – INFOSYS LTD Duration: Nov 2015 - Oct 2017

Project: ConAgra Brands – Senior Oracle database administrator.

Location: Hyderabad, India Duration: Nov 2015– Oct 2017

Description: The project consists of on-going maintenance and support of the infrastructure assets for ConAgra Brands. It includes complete E2E RUN operations of all the Data Center elements Windows and Linux Servers Database Servers Network Storage.

Technologies/Environment: SAP and NON- SAP Oracle 11g and 12c with data guard. OEM 12c and 13c. SAP Hana version 1 and 2 on Multi-node HP appliance and single node Hitachi appliance.

OS: SuSE Linux 11.3, 12.1, 12.3, 12.4

Tools: SAPA HANA Studio, SAP HANA cockpit, BMC Patrol, BMC Remedy, Control - M, BRTOOLS, OEM, SAP Solution Manager, Kanban.

Responsibilities:

Configure and maintain database servers and processes, including monitoring of system health and

performance, to ensure high levels of performance, availability, and security.

Provide 24x7 support of oracle databases running mission critical applications.

Oracle - Fix performance issues like explain plan change, query tuning using tuning advisors, space issues,

bug fixes, Agent, listener, DB Link.

Work with multiple infrastructure teams to build life stage dev and test DB environment for developers.

Install and configure ORACLE database version 11.2.0.4, 12.1.0.2, 12.2.0.1 in SAP and NONSAP Landscape on SuSE Linux 11.3, 12.1, 12.4 versions.

Install and configure Oracle dataguard of versions 11g and 12c using RMAN duplicate.

Oracle database security and user management, capacity planning, Space management using BRTOOLS

for SAP Oracle databases.

Install and configure OEM 13c, Upgrade OEM from 12c to 13cR1 and R2.

OEM Agent migration to different directory on same server, upgrade, install, decommission.

Oracle quarterly refresh using RMAN point in time restores.

Responsible for license management for HANA, Oracle database version/patch maintenance.

Configure oracle database backups using DDboost plugins on data domain servers & maintain retention as per client requirements.

Monitor OEM alerts, backup and any other Job failures, find root cause and provide permanent fix.

Design and implement cost effective solutions in data center with client required RPO and RTO timings.

Monitor replication in Hana studio and fix errors like latency, Delta merge etc.

Enable & Disable HANA traces to troubleshoot performance issues, Analyze trace log file, work with SAP support to do bug fixes, performance issues like index server crash.

Resolve HANA memory contention problem by identifying highly utilized memory areas including HEAP memory, Delta storage of tables in memory, row store and column store tables memory utilization.

HANA memory offline defragmentation, reorganization, moving table to different nodes in 5-node HANA BW physical appliance.

Configure alerts/monitoring of HANA databases in solution manager and integration of alerts with BMC to generate incidents with required severity.

Coordinate with business owners for downtime during infrastructure maintenance activities like OS upgrade from SLES 11 to SLES 12 on DB servers & infrastructure changes like increase RAM & CPU.

EMPLOYER – SYNTEL Pvt Ltd Duration: June 2013 - Nov 2015

Project: Guitar Center – System Engineer

Location: Pune, India Duration: June 2013 -Nov 2015

Technologies/Environment: Oracle 8, 9i, 10g OLTP & OLAP databases including production and non- production, MySQL, and MS-SQL.

OS: Linux and Windows.

Tools: BMC Remedy, TSM, OEM 10g, 12c.

Responsibilities:

Global support and maintenance of Oracle 8, 9i, 10g databases.

Handle Issues related to Backup failures, OEM alerts like tablespace full, mount point full, block corruption, ORA 600 and 7445 alerts.

Automated script to monitor tablespaces in all databases above threshold and add space manually.

Work with oracle support for bug fixes and apply DB patch.

Work with developers on their access related issue, performance issues, package creation, and move packages from lower landscape to production using PVCS.

Oracle database upgrade from 9i to 10g, OMS agent management and upgrade.

Restore database from RMAN backup using point in time recovery.

Create and maintain Heterogeneous DB links from Oracle to MSSQL database.

Responsible for functional tasks on Oracle apps 11i, SCM module & Hyperion like addition of users and assigning roles.

Responsible for maintaining documents, SOP for the team, KT for new team members.

EMPLOYER – SYNTEL Pvt Ltd (Contract) Duration: May 2010 - May 2013

Project: Guitar Center – Junior Oracle DBA

Location: Pune, India Duration: June 2010 -May 2013

Technologies/Environment: Oracle 8, 9i, 10g OLTP & OLAP databases including production and non- production, MySQL, and MS-SQL.

OS: Linux and Windows.

Tools: BMC Remedy, TSM, OEM 10g, 12c .

Responsibilities:

Global support and maintenance of Oracle 8, 9i, 10g databases.

Handle Issues related to Backup failures, OEM alerts like tablespace full, mount point full, block corruption, ORA 600 and 7445 alerts.

Automated script to monitor tablespaces in all databases above threshold and add space manually.

Work with oracle support for bug fixes and apply DB patch.

Work with developers on their access related issue, performance issues, package creation, and move packages from lower landscape to production using PVCS.

Oracle database upgrade from 9i to 10g, OMS agent management and upgrade.

Restore database from RMAN backup using point in time recovery.

Create and maintain Heterogeneous DB links from Oracle to MSSQL database.

Responsible for functional tasks on Oracle apps 11i, SCM module & Hyperion like addition of users and assigning roles.

Responsible for maintaining documents, SOP for the team, KT for new team members.

Personal Details:

Name: Sudhakar Reddy Avula

Email ID: adwhlg@r.postjobfree.com

Mobile: +1-713-***-****

Address: Houston, TX

DoB: 15th Feb 1989

Nationality: INDIAN

WP / Visa Type: H1B

Contact this candidate