Title: Sybase DBA
Job Description:
Roles and Responsibilities
Design, implement, and maintain Sybase ASE & Sybase IQ
database instances, including installation, configuration, upgrades, and
patching across Linux/Unix platforms.
Perform Sybase & IQ database performance tuning, query
optimization, index management, and capacity planning to ensure optimal
throughput and minimal downtime.
Perform routine Sybase database maintenance activities like
housekeeping, reorgs, DBCC checks, index maintenance, statistics updates, and
space management.
Manage Sybase & IQ database privileges and security
configurations to enforce security best practices, including user/role
management, database encryption and auditing.
Hands-on experience in backup & recovery. Should
implement restore strategies using dump/load, replication, or backup server.
Maintain large-scale IQ databases with terabyte-level
storage and ensure optimal bulk loading performance using BCP, IQ load
utilities, or ETL tools.
Configure and support high-availability solutions such as
Sybase Replication Server, Warm Standby, MSA, Failover Clustering, and disaster
recovery strategies.
Automate database administrative tasks using
Shell/Perl/Python scripts.
Sybase IQ Data warehouse support reporting, BI workloads,
data analytics, and archival.
Should have knowledge on Sybase database migrations across
On-prem to cloud and cross-platform migrations.
Support production issues with on-call rotation and work
closely with developers, application and infrastructure teams.
Should have worked on Sybase outplace migrations with
replication server configuration.
Should have worked on Sybase database decommission with 10+
years of experience for a senior Sybase DBA role.
The candidate should have extensive hands-on experience in
delivering large-scale infrastructure/data center migration and
infrastructure/data center upgradation/modernization projects within the global
high availability banking /financial services environment.
