Summary

Overview

Work History

Education

Skills

Timeline

DODDA SRI AYYAPPA

SYBASE DBA

Hyderabad,TG

Summary

6+ years of experience as Sybase Database Administrator in Telecommunications, enterprise and Health care sectors. 3+ years of experience in GE support project(Predix L2 support)

Overview

years of professional experience

Work History

Developer

Cigna - Health Care and Insurence

06.2025 - 12.2025

Creating the Splunk Dashboards.
Creatin User Stories Based on the P1,P2 Incedence Analysis for Process Improvemnet and Automated Jobs.
Modifying existing splunk dashboards.
Creating dahboard queries for monitoring.

Sybase to AZURE Cloud Migration

LSEG under MICROSOFT

10.2023 - 05.2025

Take the list of the schema need to be migrate and also take the DB & Schema Size.
List of the objects in every schema.
Create PG migration role and provide access to migration Team.
Providing the need access to the migration Team.
Finding and resolving the issues from Sybase side while migrating.
Domain: Enterprise Solution
Project Scope: L2 Support

L2 Support

Predix Platform

06.2021 - 10.2023

As per the day to day activities we have to handle the Incidents, problems, defects, RCA's, User stories.
Handling the P1's (priority Incidents) which will impact the user/user applications.
Creating and modifying the monitoring alerts for the applications.
Creating the User stories based on the P1,P2 indents analysis for the process improvement or automated jobs creation.
Have to do the daily/weekly based follow-ups with the Engineering teams on assigned Defects/User stories/RCA's.
Handling the P1,P2,P3,P4 Indents which is raised by user and also change the High/Low priority of the incidents based on the Impact.
Domain: Cloud based platform
Project Scope: L1 & L2 Support

Sybase to Postgrace Migration

Elementcorp

01.2021 - 05.2021

Take the list of the schema need to be migrate and also take the DB & Schema Size.
List of the objects in every schema.
Create PG migration role and provide access to migration Team.
Providing the need access to the migration Team.
Finding and resolving the issues from Sybase side while migrating.
Domain: Enterprise solutions
Project Scope: L1 & L2 Support

GE-Health care

02.2020 - 04.2020

Changing locking schema as per the client requirement (All page to Data row)
Providing Training session to Required Team.
Upgrading the client application versions.
Monitoring the health of the system.
Monitoring the backups and loads.
Domain: Health care
Project Scope: L1 & L2 Support

Avis Budget Group

02.2018 - 02.2020

To support the applications that are using the databases - SYBASE ASE
Creating devices and adding space to the databases
Set up new ASE database options as per the following process
Creating logins and adding roles and privileges to them as per business requirement.
Set up new ASE database options as per the process requirements
Working with secured copy (scp) and bulk copy (bcp) commands
Creating and managing logins, user account handling like lock, unlock, resetting password.
Modifying ASE configuration parameters whenever need arises adhering to process
Troubleshooting hung processes using lct_admin commands
Resolved database suspect issues
Domain: Airlines
Project Scope: L1 & L2 Support

Vodafone

05.2015 - 01.2018

To support the applications that are using the databases - SYBASE ASE
Very thorough and clear understanding of Sybase ASE Architecture - including ASE internal threads and system databases
Good understanding on how an SQL query gets executed internally.
Installation and configuration of ASE-16.0 on Oracle Enterprise Linux 6.
Diagnosing server problems i.e., monitoring locks, blocking processes, resolving and reporting them as appropriate.
Performing user management, backups, load and refresh activities as per client requirement.
Troubleshooting tempdb full errors.
Configuring, binding, monitoring and troubleshooting tempdb databases.
Performing weekend maintenance activities like REORG, Update Statistics, DBCC and other planned tasks.
Troubleshooting Procedure cache full issues
Checking the availability of space in file systems, data and log segment of a database.
Troubleshooting slow running query upon user complaints
Domain: Telecommunication solutions
Project Scope: L1 Support