- Troubleshooting, patching of ASE 15.7 and 16.0 and tuning SQL queries as per application team needs
- Problem Management: Performing root cause analysis of the repetitive problems and doing in-depth analysis of system behavior
- Implemented automation of database health check, backups, error log scanning which led to efficiency in monitoring processes
- Create knowledge articles on the problem, workaround solutions in the knowledge management repository
- Configured database servers as per SAP notes to achieve the best performance
- Responsible for outage/incident management â?? from initial troubleshoot/ resolution through to root cause analysis and driving subsequent corrective measures
- Reconfigured the entire ASE memory configuration for production servers
- Enhanced the performance of the slow running system copy
- Reconfigured ASE memory to enhance performance of an ERP server
- Performance and tuning: Used sysmon and MDA tables to identify database level bottlenecks and provided recommendations on server configuration
- Designing and scheduling the various maintaining tasks for Sybase like dbcc, reorg rebuild, update statistics
- Cross skilled on Oracle database administration
- Troubleshooting alerts received and taking appropriate actions.
- Responsible to provide resolutions for the incidents and supporting weekend changes as per business requirement 24X7
- Supported maintenance activities like reorg rebuild, update stats and dbcc checks
- Recovered a production database and made it online for the business users
- Successfully brought the server online when ASE was unable to come up after upgrade
View this Course
Certified
You have 
