Technical Service Consultant
International Turnkey Systems Group - Other locations
Total years of experience :10 years, 9 Months
Working as a Technical Service Consultant at ITS, Kuwait for Sybase Databases.
Working on SAP Sybase Database case management and customer issues.
Handling critical database issues.
Raising cases over SAP Support based on customer issues.
)
Professional 6 months of experience in Sybase ASE 12.5, 15.7 & 16 & Replication includes troubleshooting, daily DBA Tasks, working on user requests/incidents, Performance issue, UAT/DEV refresh tasks. In addition to that experience in Replication, Critical Issue handling, Change Requests execution
Database Technologies
Sybase ASE, Replication
Operating Systems
Solaris, Red Hat Linux,
Tools & Utilities
ISQL, Putty, Control-M, Netcool, ComVault
Sybase ASE, Replication & IQ
Operating Systems
Solaris, Red Hat Linux,
Tools & Utilities
ISQL, Putty, Control-M, Tectia
Sybase ASE, Replication & MSSQL
Operating Systems
Solaris, Red Hat Linux, Microsoft Windows
Tools & Utilities
ISQL, Putty, DBartisan, Control-M, Sybase Central, SSMS
WORK/RESPONSIBILITIES:
•SYBASE ASE (12.X, 15.X)
•CONFIGURING SERVER PARAMETER FOR PERFORMANCE.
•CREATING DEVICES AND DATABASES.
•TAKING REGULAR DATABASE AND TRANSACTION LOG BACKUP.
•TRANSFERRING THE DATA USING BCP.
•CREATING LOGINS, ADDING USERS TO RESPECTIVE DATABASE AND MANAGING THE LOGINS BY GRANTING AND REVOKING PERMISSIONS.
•MAINTAINING THE INTEGRITY AND CONSISTENCY OF DATABASES USING DBCC COMMANDS.
•RUNNING REBUILD INDEX AS WEEKEND ACTIVITY.
•RUNNING UPDATE STATISTICS FOR THE BETTER PERFORMANCE.
•DEALING WITH THE TEMPDB AND USER LOG ISSUES.
•REFRESHING DATABASES IN DEV SERVER FROM PROD DUMPS.
•REPLICATION (15.0) (TABLE LEVEL)
•STARTING AND SHUTTING DOWN THE REPLICATION SERVER.
•MONITORING THE REPLICATION SERVER ERROR LOG AND TRYING TO FIX THE ISSUES.
•WORKING ON REPLICATION ISSUES LIKE THREAD DOWN, DISK SPACE MONITORING.
•MSSQL SERVER 2000, 2005, 2008, 2012
•CREATING AND MANAGING APPLICATION DATABASES.
•TROUBLESHOOTING SERVER PERFORMANCE ISSUES.
•ERROR LOG CHECKING IN SQL AND TAKING ACTION ON IT.
•TROUBLESHOOTING CONNECTIVITY PROBLEMS.
•SOLVING DATABASE TRANSACTION LOG FULL ISSUE.
•MONITORING DATABASE GROWTH AND TAKING NECESSARY ACTIONS.
•KILLING BLOCKED OR HUNG PROCESSES.
•TROUBLESHOOTING APPLICATION ISSUES.
•WORKING ON THE CASES ASSIGNED TO SUPPORT TEAM.
•CONFIGURING, MONITORING AND TROUBLESHOOTING LOG-SHIPPING ISSUES
.
(