Summary
Overview
Work History
Education
Skills
Certification
Passport
Education Summary
Timeline
Generic

Naresh Sathrawada

Hyderabad

Summary

Oracle DBA with extensive experience at CITI, specializing in Oracle E-Business Suite R12.2 and Ansible automation. Enhanced database performance and security, achieving a 30% increase in system efficiency. Expertise in problem-solving and collaboration, contributing to successful project outcomes. Proficient in CI/CD processes, facilitating seamless integration and deployment.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Senior Specialist-Cloud & Infr

CITI
Hyderabad
04.2022 - Current
  • Resolved customer tickets through thorough problem analysis and functional flow assessment.
  • Conducted weekly maintenance on Oracle Applications and databases to ensure reliability.
  • Performed troubleshooting for WCI/WCC, Vertex, WCP, Autosys, and NDM (C:D).
  • Conducted regular health checks of applications and databases to maintain peak performance.
  • Managed application and database patching to uphold security standards.
  • Monitored alerts daily to prevent potential issues before escalation.
  • Executed DBA activities to facilitate efficient database management.
  • Utilized Ansible pages for automation and streamlined job scheduling in AppDynamics.

Oracle DBA

Curiaglobal
03.2021 - 04.2022
  • Performed monthly maintenance of EBS applications to ensure optimal functionality.
  • Handled customer tickets by analyzing problems and providing effective solutions.
  • Managed cloning processes from production to non-production environments (RAC-RAC, RAC-Non-RAC).
  • Conducted regular health checks of applications and databases to maintain performance.
  • Executed application and database patching activities to mitigate vulnerabilities.
  • Monitored daily alerts to proactively address issues and streamline operations.
  • Implemented code migrations while ensuring minimal disruption to services.
  • Created and modified shell scripts for task automation as required.

Oracle Apps DBA

ATT
05.2018 - 03.2021
  • 24/7 with Maintenance and implementation.
  • Regular health check of Application and Database.
  • Resolving issuese like concurrent manager and forms.
  • Applying adpatches on maintenance.
  • Assigning roles , profile options , printer setup.
  • Updating connect direct parameters in source system.
  • War file Deployment in Weblogic environment.
  • Resolving performance issues and mainting Weblogic environment.
  • DBA Activities like table Reorgs / table partision / DB refresh and Performance Tuning.
  • Performed SQL Tuning.
  • Regular DBA Activities.
  • Coordinating with different teams and identifying RCA.
  • Resolving Golden gate issues.
  • Performing mothly maintenance activity.
  • Database Refresh (Schema Refresh).

DBA Lead

ATT
Hyderabad
04.2014 - 05.2018
  • Providing Production support for all the Production EBS system and 35 consolidated Production Databases.
  • Managing 24
  • 7 Production Support with Onshore-Offshore model.
  • Monitor all database instances and respond to any alerts for space, resources, Errors, etc.
  • Maintenance and Troubleshooting of Oracle Applications and Database.
  • Extensively worked on latest Online patching tools of Oracle applications (adop) and cloned multiple instances of oracle applications R12.2.5 using adcfgclone.
  • Performed cloning as per the requirement.
  • Creating/modifying shell scripts as & when required for task automation.
  • Tuning Long Running Jobs.
  • Applied E-Business Suite application patches and Bug fix patches as per the requirement.
  • Set up user profiles and roles as per the access level of user for the data and application security.
  • To accept requests (Tickets) through Clarify application from user network for any problem related to Database Administration and to resolve the same within SLA (Service Level Agreement) like space issue, network access issue, problems related to backup and performance etc.
  • Periodic performance monitoring and fine-tuning of Databases/Application.
  • Single node & Double node cloning of as per client requirements.
  • Expert Tuning of Oracle Application and Database.
  • Code migration in oracle database using sql loader.
  • Weblogic Administration 10g, 11g &12c, Weblogic Deployments.
  • Tackling the user issues accessing Applications if any.

Oracle Apps DBA

SCANIA
Hyderabad
05.2012 - 03.2014
  • Monitoring Concurrent Manager & its operations like starting, stopping the concurrent managers & troubleshooting problems, resolved the view log/out files issues of concurrent requests.
  • Well versed in Oracle Applications Utilities like adadmin, adctrl, adsplice, adpatch, adconfig, merge patch, adrelink.
  • Monitoring alerts on daily basis.
  • Analyzing patch impact and applying Application patches including pre-requites.
  • Performed adding or resizing on data files on Table Spaces.
  • Creating users and assigning roles and responsibilities.
  • Resolving concurrent manager related issues.
  • Refresh the Database.
  • Installation of R12 in single node and multi node instances.

Education

Master of Science - Computer Science

JNTU
Hyderabad
01-2011

Bachelor of Science - Computer Science & Engineering

Narayana Engg College
Nellore
01-2008

Skills

  • Oracle E-Business Suite R121 and R122
  • Oracle database versions 10g, 11g, 12c, and 19c
  • SQL Server and MongoDB
  • RHEL, OEL and HP-UX operating systems
  • Windows OS
  • WebLogic application server
  • GoldenGate data integration
  • OEM 13c monitoring
  • RMAN backup and recovery
  • Ansible automation
  • Git version control
  • NDM file transfer
  • AppDynamics performance monitoring
  • Toad database management

Certification

  • 1Z0-1072-F, Oracle Cloud Infrastructure 2019 Architect Associate - English (ENU)
  • 1Z0-931-20, Oracle Autonomous Database Cloud 2020 Specialist - English (ENU)
  • 1Z0-1127-24, Oracle Cloud Infrastructure 2024 Generative AI Professional

Passport

K6432236, Hyderabad

Education Summary

  • M.Tech, Computer Science, JNTU Hyderabad
  • B.Tech, Computer Science & Engineering, Narayana Engg College (JNTU)

Timeline

Senior Specialist-Cloud & Infr

CITI
04.2022 - Current

Oracle DBA

Curiaglobal
03.2021 - 04.2022

Oracle Apps DBA

ATT
05.2018 - 03.2021

DBA Lead

ATT
04.2014 - 05.2018

Oracle Apps DBA

SCANIA
05.2012 - 03.2014

Master of Science - Computer Science

JNTU

Bachelor of Science - Computer Science & Engineering

Narayana Engg College

Similar Profiles

CREATE PROFILE
Naresh Sathrawada