Sql Server Database
Resume:
PROFILE SUMMARY
Over **+ years of IT experience in Sybase ASE, Sybase Replication Server, SQL Server Database Administration worked on AIX, Solaris, Red Hat Enterprise Linux, Windows, HP-Unix.
Installing and configuring ASE, Replication Server, SQL Server 2016/2017/2019 and 2022, applying service packs, patch levels, security patches and cumulative updates.
Experience in implementing security and object permissions like maintaining, creation of users, configuring permissions and assigning roles to users.
Upgrading the Sybase ASE dataservers, Sybase Replication Server process, SQL Server databases and instances from lower version to higher version involving on-prem to on-prem and cloud environments(AWS & Azure).
Troubleshooting failures and recovering databases from the point of crash by using upto minute recovery strategies.
Performing and automating database refresh tasks from Pre-Prod to Dev/UAT dataservers and instances.
Resolving the disk space issues and finding the root cause for permanent fixes.
Expertise in performance tuning and fixing the root cause of the issues.
Experience in identifying I/O and memory bottlenecks.
Experience in identifying and fixing deadlocks in Sybase ASE and SQL Server.
Extensive experience in SSL in Sybase ASE and TDE in SQL Server.
Good experience in implementing and troubleshooting HADR for Sybase ASE using Data Movement (DM).
Good experience in implementing and troubleshooting High Availability of database servers using Log shipping, Database Mirroring, Transactional Replication, SQL Failover clusters and Always On.
Establishing weekly maintenance plans such as integrity check, rebuilding indexes, update statistics and monthly maintenance plans such as clean up history etc. to run the databases efficiently.
Performing Always On cluster installation and adding the nodes in the respective servers in SQL Server 2016,2017, 2019 and 2022 versions.
Implemented 3-Node HADR/Always-On across the different data centres, 2-Node in production for HA and 1-Node in DR site.
Experience in handling large OLTP, OLAP and MIXED databases upto 10 TB.
Great understanding on Sybase ASE, Sybase Replication Server, SQL Server Architecture.
Have good work experience in setting Windows fail over cluster for Always On.
Experience with AWS, Azure Managed instance.
Have experience in setting up SQL server environment in Azure.
Have expertise knowledge & experience in migrating the databases to Azure cloud using Backup/Restore with blob container, DAM and DMS services.
Having very good knowledge on ITIL practices like incident management, change and problem management.
Provided support on 24x7 database support and on-call to the client.
Experience in cross platform and database migration to other RDBMSs.
Worked on database monitoring tools like Embarcadero, SolarWinds, Proactive DB.
Worked on database backup tools involving Commvault, Tivoli and Native SQL Server backups.
TECHNICAL SKILL SET- SYBASE ASE, REPLICATION SERVER, SQL SERVER DBA
ASE versions 15.5, 15.7, 16.0, 16.1
Replication Server versions 15.7, 16.0
SQL Server versions SQL Server 2016, 2017, 2019
ASE tools Embarcadero (DB Artisan), DBCC, MDA, sp_sysmon
SQL server tools SQL Server Management Studio, SQL Profiler, Performance
Monitor, SQLCMD, Database Tuning Wizard, Microsoft Clustering Services (MSCS), SQL Server Upgrade Advisor, DMV's and DBCC Commands
DR Configuration HADR, Sybase Replication, Log Shipping, Mirroring, Clustering
Operating Systems AIX, RHEL, Unix, Windows Server 2003, 2008 R2, 2012, 2016 and 2019
Ticketing Tools Remedy, Service Now
Other Essential Software Microsoft Office Word, Excel
Scripting Shell, PowerShell and T-SQL
Azure Tools/Services IaaS, PaaS, DMS, Azure Migrate, Azure SQL, DMS
TECHNICAL CERTIFICATIONS
C_TADM54_75: Sybase ASE 16.0
Getting Started with Support from SAP (Support Accreditation)
Generative AI at SAP
WORK EXPERIENCE
Company
S4 Consultants
Period
May 2025 - Present
Role
SAP Sybase DBA
Responsibilities
Senior DBA for all customers of S4.
Sybase ASE:
Strong understanding of the architecture of Sybase Adaptive Server Enterprise
Exceptionally proficient in installations, upgrades, migrations, configuring, and monitoring
Experience in Sybase HADR using data movement feature
Testing new features in the internal systems and preparing POC before implementing them at client site
Preparing SOPs for complex architectures, internals of ASE and help team during major incidents
Proficient in identifying and resolving performance bottlenecks and recommending developers and users for optimal use of queries
As a database administrator suggests storage requirement for better performance
Automating most common tasks like monitoring errorlogs, health checks using shell scripting
Coordinating with SAP product support for stack traces, SIGNAL 10 & 11 errors
Sybase Replication Server (RS) :
Strong understanding over the architecture of Sybase Replication Sever
As a Replication Server Administrator proficient in installing/setting up and managing “Table level, Warm Standby, MSA and Multipath Replication”
Exceptionally proficient in designing the data flow between homogeneous/heterogeneous RDBMSs using Sybase Replication Server
Setting up master database level Replication
Performance and tuning of RS, managing disk/queues
Troubleshooting thread down and latency issues
Managing failover and failback activities if scheduled for a customer
Working with SAP product support regarding complex issues through proper channel
MS-SQL Server :
Strong understanding of SQL Server's architecture and SQL Managed Instance (MI)
Installing, upgrading SQL Servers in the client environment as well as in Hyperscalars
Performing regular database health checks
Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
Refine and automate regular processes, track issues and document changes
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Configure and maintain instances to ensure high levels of performance, availability, and security
Be a part of various DR solutions at customer end and maintaining SOPs for the same
Effectively coordinate with all the stakeholders (internal teams and clients) for query tuning and schema refinement to enhance performance
Fulfil user requests ranging from access control, backup, restore to performance and tuning
Provide 24/7 support for critical production issues
Environment
ASE 15.5, 15.7, 16.0, 16.1, SQL Server 2017, 2019, AWS, Azure
Company
ITS
Period
Dec 2019 - Present
Role
SAP Sybase DBA
Responsibilities
Senior DBA for all customers of S4 using Sybase products for their core banking applications.
Sybase ASE:
Strong understanding of the architecture of Sybase Adaptive Server Enterprise
Exceptionally proficient in installations, upgrades, migrations, configuring, and monitoring
Experience in Sybase HADR using data movement feature
Testing new features in the internal systems and preparing POC before implementing them at client site
Preparing SOPs for complex architectures, internals of ASE and help team during major incidents
Proficient in identifying and resolving performance bottlenecks and recommending developers and users for optimal use of queries
As a database administrator suggests storage requirement for better performance
Automating most common tasks like monitoring errorlogs, health checks using shell scripting
Coordinating with SAP product support for stack traces, SIGNAL 10 & 11 errors
Sybase Replication Server (RS) :
Strong understanding over the architecture of Sybase Replication Sever
As a Replication Server Administrator proficient in installing/setting up and managing “Table level, Warm Standby, MSA and Multipath Replication”
Exceptionally proficient in designing the data flow between homogeneous/heterogeneous RDBMSs using Sybase Replication Server
Setting up master database level Replication
Performance and tuning of RS, managing disk/queues
Troubleshooting thread down and latency issues
Managing failover and failback activities if scheduled for a customer
Working with SAP product support regarding complex issues through proper channel
Sybase IQ :
Strong understanding on installation of Sybase IQ
Creating new databases and dbspaces
Creating and dropping users, tables and other tasks related to user management
Assigning and un-assigning login policies to the users
Performing backup and restore
Troubleshooting issues
Environment
ASE 15.5, 15.7, 16.0, 16.1, SQL Server 2016, 2017, 2019, AWS, Azure
Company
DXC.technology
Period
February 2019 - December 2019
Role
Technology Consultant III
Responsibilities
Responsible for technical support and decommissioning in iBuild vertical.
Sybase ASE DBA:
Work as a lead, which may be multifunctional addressing complex issues and leading L4 escalations by using proper methodology, tools, and procedures
Responsible for cross platform migration of the Sybase ASE dataservers
Performed dry run before handing over the dataservers to application team
Participate, propose, and lead complex customer and internal projects related to the bank’s applications
Provide review/advice to projects inside/outside responsibility areas
Involving in decommissioning of the Sybase ASE dataservers and Replication Servers
Cross skilling the colleagues on Sybase ASE database administration activities
Sybase Replication Server (RS) DBA:
Installing/setting up and managing Table level, Warm Standby, MSA and multipath Replication.
Decommissioning Sybase Replication Servers
Supporting performance issues
Environment
ASE 12.5, 15.5, 15.7, 16.0 16.1, SRS 15.7, 16.0, Service Now
Client
IBM
Period
October 2016 – February 2019
Role
Technical Services Specialist
Responsibilities
Lead to provide L1-L3 levels of support for the AVIS Budget and Car Rental.
Sybase ASE DBA:
Lead team which requires all kinds of support for the Sybase ASE dataservers of the enterprise
Responsible for upgrades, patching activities
Troubleshooting the performance issues and issues related to maintenance jobs
Responsible for setting up Tivoli situations for monitoring databases and capacity planning
Provide review/advice to projects inside/outside responsibility areas for the internal projects
Manage relationship with project stakeholders, keeping stakeholders informed over progress to manage expectations on all project requirements and delivery
Responsible for external audits
Responsible for setting up DR for the requested Sybase ASE dataservers of production every year at a new location
Member of Change Advisory Board (CAB)
Environment
ASE 12.5, 15.7, 16.0, Service Now
Company Name
Atum IT
Period
February 2016 – October 2016
Role
SAP Consultant
Responsibilities
Responsible for providing L1 & L2 level support for the systems of State Revenue - Queensland.
Sybase ASE DBA:
Installing and configuring SAP ASE -16.0 on Linux and Windows operating systems
Proficient in creating devices and using them for databases
Tuning databases to attain greater performance and user management
Performing maintenance activities like reorg rebuild, update stats and dbcc
Using SAP solution manager for database administration and monitoring
Using ESP ticketing tool to track the issues
Environment
ASE 12.5, 15.7, 16.0, SRS 15.7, 16.0, Service Now
Company Name
Polaris FT
Period
August 2015 - February 2016
Role
Associate Consultant
Responsibilities
L1 and L2 level support the applications of the bank that are using SYBASE ASE and MS-SQL RDBMSs.
Sybase ASE DBA:
Creating devices and adding space to the databases
Tuning jobs related to database and log backups
Troubleshooting backup and load errors by monitoring error logs
Performing defrag activity every quarter
Monitoring metadata configuration parameters and modifying them when threshold is reached
Diagnosing dataserver problems
Learning MS-SQL database administration
Using ‘Citi Market Place’ ticketing tool to track the issues
Environment
ASE 15.5, 15.7, 16.0, Citi Market Place
Company Name
Tata Consultancy Services
Period
April 2013 - August 2015
Role
Senior Process Associate
Responsibilities
L1 level support to monitor SAP Sybase ASE dataservers.
Sybase ASE DBA:
•Good knowledge of Sybase ASE architecture
•Starting and stopping of dataservers and backup server processes
•Performing database and log backups
•Scheduling jobs through cron
•Creating devices and adding space to the databases
•Space management - file systems, data, and log segments
•Monitoring I/O, CPU and memory used at dataserver and operating system level
•Checking the status of login, resetting password, and granting permissions to users
•Following SAP SCN to understand various issues
Environment
ASE 15.5, 15.7, 16.0, Citi Market Place
Contact this candidate