Sybase Lead Consultant Resume
SUMMARY:
- A trained and seasoned IT Professional with Computer Management (MCM) qualification and having a rich & extensive experience of over 24 years out of which 16 years as an SAP Sybase Database Administrator including over 5 years of International (Belgium) tenure in Database Administration/Management.
- Short Profile: A self - motivated and focused Sybase DBA with a successful track record of Database Management in diverse roles of Sybase Database Engineer & Database Administrator, having specialization as SAP Sybase ASE DBA, Sybase IQ DBA as well as Sybase Replication Server Administrator with ECDA and ECO.
- Special Mention includes
- Worked as a Sybase DBA with Confidential with the responsibilities of Database Engineering & Database Infrastructure.
- Also worked on onsite projects as a Sybase Database Engineer in Belgium, for 5 years, involving project planning, technical feasibility study, resource allocation, management coordination, budgeting, development of proof of concepts (POC) and its documentation.
- Team Leader: Deft at tasking, delegation, monitoring, feedback, skill upgrade, conflict resolution, client coordination and resource mentoring
- Team Player: Innovative & Fast Learning curve with analytical, problem solving, planning, communication, interpersonal skills & ability to adopt technical challenges
TECHNICAL SKILLS:
Operating System: Solaris 11, Linux, Windows
Databases: Sybase ASE 15.7 and 16, MS SQL Server 2014, Oracle 11g
Analytics and Data Warehousing: Sybase IQ 16.0
Data modelling and Enterprise Architecture: SAP PowerDesigner
Business Continuity Product: SAP OpenSwitch
Replication: Sybase Replication Server, ECDA, ECO (Express Connect for Oracle)
Database Management Tools: SAP Control Center, DB Artisan and Toad for Oracle
Miscellaneous Skillsets: Shell scripting, Sybase job scheduler
PROFESSIONAL EXPERIENCE:
Confidential
Sybase Lead Consultant
Responsibilities:
- Working for a Fortune 500 USA based Investment Bank Project as a Sybase DBA (L3)
- Day-to-day production operations (incident break/ fix, change, service requests).
- Troubleshooting real-time issues
- Execute activities like weekly deployments
- Responsible for resolving User-incident-tickets (P1/P2/P3), complying with the SLA.
- Provide on call support for Production servers including weekend and after hours support on a rotation basis
- Provide SAP Sybase IQ support.
- Supporting top Banking Client.
Confidential
Sybase DBA
Responsibilities:
- I was working in Business Intelligence and Data Warehousing (BI/DWH) Division as an SAP IQ DBA supporting a large European client account.
- Installation, Configuration and Upgrade of SAP IQ in Linux.
- Administer and Manage SAP IQ Server
- Troubleshooting real time issues.
- Resolve performance issues on SAP IQ Server
- Providing technical guidance & support on critical issues in SAP IQ that may impact the business.
- Upgrading SAP IQ 15.4 to Sybase IQ 16.0
- Migrating SAP IQ from Solaris Platform to Linux Platform
Confidential
Sybase Database Engineer
Responsibilities:
- I was deputed on-site at Brussels, Belgium for over last 5 years as a Sybase Database Engineer supporting Sybase ASE and Sybase Replication server
- Owning Infrastructure projects for installation, Upgrade & Support of Sybase database along with replication servers in the existing infrastructure.
- Executing the functions of project life cycle consisting of scoping, planning, technical feasibility study, resource allocation, management co-ordination, budgeting and documentations.
- Providing technical guidance & support on critical issues in Database and Replication server that may impact the operation and Best Practices in Database Operation.
- Coordinating with DBO for project implementation as well as resolving long term database & replication issues (Bug fixes) from Engineering perspective.
- Interacting with Database Operations/Application teams on Database & Replication related issues, including Performance Tuning of Database and Replication Server.
- Engaged in multiple responsibilities like new replication setup request, L3 support on Database Operation, Software License management and collaboration with application for Performance and Tuning.
- Provide Sybase replication support for building warm standby and Table Level types of replication
- Independently plan and execute large database migration activities
- Sybase installation and version upgrade from 15.0 to 15. 7
- & mentoring of Database Operations Staff on the new Infrastructure.
- Preparing Best Practices Document for the Operations Staff
- Supported Warm Standby and Table Level Replication
- Setup of OpenSwitch with replication server as a business continuity solution
- Setup of Heterogenous replication (Sybase to Oracle) using Express Connect for Oracle (ECO)
Confidential
Sr. Database Administrator
Responsibilities:
- Day-to-day production operations (incident break/ fix, change, service requests, vulnerability management).
- Provide Sybase replication support for building warm standby and MSA types of replication
- Handling databases backup, DBCC, restoration, update statistic, rebuild and reorg
- Analyzing and monitor system performance using DBCC, trace on commands, query plan output, system procedures like sp sysmon and other performance monitoring tools
- Strong Performance and Tuning capabilities and root cause analysis reporting
- Troubleshooting problems real-time issues
- Executed activities, consisting of monitoring, performance tuning, SQL tuning, database backup/restore, database refreshes, etc.
- Responsible for resolving User-incident-tickets (P1/P2/P3), as reported by the database operators/users, complying with the SLA.
- Provided round the clock support on database issues, while resolved all replication server issues as per the SLA.