Summary
Overview
Work History
Education
Skills
Production Issues Handled
Projects Handled
Timeline
Generic
Sharayu Nemade

Sharayu Nemade

Pune

Summary

Dynamic Lead Infrastructure Engineer with over 8 years of experience at Mphasis Limited, excelling in Oracle SQL and PL/SQL. Proven track record in resolving critical production issues and enhancing monitoring solutions. A collaborative team player committed to delivering high-quality support in 24/7 environments, ensuring operational excellence and stakeholder satisfaction.

Overview

9
9
years of professional experience

Work History

Lead Infrastructure Engineer

Mphasis Limited
Pune
09.2023 - Current
  • Provided L2 and L2.5 support to client, resolving application issues efficiently.
  • Conducted thorough analysis of workflow monitor logs to identify production issue causes.
  • Investigated Production Max run job issues by analyzing procedures and identifying problematic SQL queries.
  • Compared database table columns across applications to address critical production data discrepancies.
  • Created change requests for tablespace or service downtime, following up with stakeholders for approvals.
  • Identified recurring production bugs, created problem tickets, and assigned tasks to relevant teams.
  • Initiated and participated in IT bridge calls and MIM calls to address high-impact business issues.
  • Monitored job statuses using Control-M, handling job-related issues effectively.

Senior Associate Engineer

Amazon
Pune
07.2016 - 09.2023

Providing L2 and L2.5 support to the client.

  • Receive and resolve application issues from users.
  • Trying to get the exact cause for Production issues by analyzing the workflow Monitor session log and then linking it to Workflow Manager and then Workflow designer to get the mapping details between source and target.
  • Trying to get the exact cause for Production Max run job issues by analyzing the Procedure and find out the culprit SQL queries.
  • Handling Key violation errors while data load from file to Oracle database through Informatica and Oracle Procedures.
  • Comparing of Database table columns from different applications by looking into interface document to solve critical production data issues.
  • Creating Change request for Table space or service down issues. Taking follow-up with all stake holders to get the approval for the Change release.
  • Identify the repeated bug in Production environment and create the problem ticket and assign the problem task to the concerned team by putting the initial analysis in the problem description and take follow-up later till closure.
  • Initiate and actively participate in IT bridge calls and MIM calls to resolve the issues, which has high impact on business.

Education

B.E - Computer science and engineering

RTMNU University

Skills

  • Linux operating system
  • Oracle SQL and PL/SQL
  • SQL Server management
  • ServiceNow platform
  • SQL Developer tools
  • Putty terminal emulator
  • Control-M scheduling
  • Postman API testing
  • Kibana data visualization
  • Grafana monitoring solutions
  • Geneos monitoring tool

Production Issues Handled

  • Performing deployment tasks as per the client's requirements in production and pre-production environments
  • Received old business date file.
  • Database connectivity issue.
  • Table space issue or service down issue.
  • Need to deliver downstream files manually by running the application flow manually.

Projects Handled

  • Convergent Billing Solution, Banking, Agastha, USA, 15, UNIX, Oracle, Shell Scripting, Service Now, SQL Developer, Putty, Control-M, Geneos
  • Integrated Data Service & Investments Book of Records, Banking, JPMorgan Bank, America, 10, UNIX, Oracle, Shell Scripting, Service Now, SQL Developer, Putty, Postman, Splunk, Kibana, Geneos

Timeline

Lead Infrastructure Engineer

Mphasis Limited
09.2023 - Current

Senior Associate Engineer

Amazon
07.2016 - 09.2023

B.E - Computer science and engineering

RTMNU University
Sharayu Nemade