Sybase DBA

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.