Sybase DBA

Job description:
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 is expected to possess banking domain expertise, hands-on experience with UBS processes, and previous involvement in Migration Factory project. These are key requirements for the role.

Work arrangement
No