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
11
11
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
Education
Bachelor of Technology - Electronics and Communication Engineering
Sri Prakash College Of Technology
KAKINADA05-2015
Skills
Databases: Sybase ASE 157, 160
Timeline
Developer
Cigna - Health Care and Insurence
06.2025 - 12.2025
Sybase to AZURE Cloud Migration
LSEG under MICROSOFT
10.2023 - 05.2025
L2 Support
Predix Platform
06.2021 - 10.2023
Sybase to Postgrace Migration
Elementcorp
01.2021 - 05.2021
GE-Health care
02.2020 - 04.2020
Avis Budget Group
02.2018 - 02.2020
Vodafone
05.2015 - 01.2018
Bachelor of Technology - Electronics and Communication Engineering
Sri Prakash College Of Technology