Sybase DBA

Test Triangle Ltd; Greater London; Sur place; GBP 90 000 - 120 000; Plein temps

Résumé du poste

Zohorecruit seeks a seasoned Sybase DBA to design, implement, and maintain Sybase ASE and IQ databases across Linux/Unix platforms. You will lead performance tuning, capacity planning, and high-availability configurations while performing routine maintenance and security management.

The role requires strong hands-on experience with backup/recovery, data warehousing support, and cross‑platform migrations, including on-prem to cloud.

Qualifications

• Extensive hands-on experience delivering large-scale Sybase infrastructure migrations.
• Experience with on-prem to cloud migrations and cross-platform moves.
• Strong skills in performance tuning, maintenance, and capacity planning.
• Experience with high-availability and disaster recovery setups.

Responsabilités

• Design, implement, and maintain Sybase ASE & IQ databases across Linux/Unix.
• Performance tuning, query optimization, index management, and capacity planning.
• Routine maintenance: housekeeping, reorgs, DBCC checks, statistics updates.
• Manage privileges, security configurations, user/role management, auditing.
• Backup and recovery strategies using dump/load, replication, or backup server.
• Maintain terabyte-scale IQ databases and optimize bulk loading (BCP, IQ load utilities, ETL).
• Configure and support high-availability solutions: Replication Server, Warm Standby, etc.
• Support data warehouse workloads, BI, analytics, archival.
• Knowledge of database migrations on-prem to cloud and cross-platform moves.
• Collaborate with developers, applications and infrastructure teams; on-call rotation.
• Experience with outplace migrations and replication server configuration.
• Senior Sybase DBA with 10+ years experience in global, high-availability environments.

Connaissances

Sybase ASE

Sybase IQ

Performance tuning

Backup & recovery

High availability

Security & auditing

DB migrations

Data warehousing

ETL tools

On-call support

Outils

BCP

IQ Load Utilities

Dump/Load

Description du poste

• Design, implement, and maintain Sybase ASE & Sybase IQdatabase instances, including installation, configuration, upgrades, andpatching across Linux/Unix platforms.
• Perform Sybase & IQ database performance tuning, queryoptimization, index management, and capacity planning to ensure optimalthroughput and minimal downtime.
• Perform routine Sybase database maintenance activities likehousekeeping, reorgs, DBCC checks, index maintenance, statistics updates, andspace management.
• Manage Sybase & IQ database privileges and securityconfigurations to enforce security best practices, including user/rolemanagement, database encryption and auditing.
• Hands‑on experience in backup & recovery. Shouldimplement restore strategies using dump/load, replication, or backup server.
• Maintain large-scale IQ databases with terabyte-levelstorage and ensure optimal bulk loading performance using BCP, IQ loadutilities, or ETL tools.
• Configure and support high‑availability solutions such asSybase Replication Server, Warm Standby, MSA, Failover Clustering, and disasterrecovery strategies.
• Sybase IQ Data warehouse support reporting, BI workloads,data analytics, and archival.
• Should have knowledge on Sybase database migrations acrossOn-prem to cloud and cross-platform migrations.
• Support production issues with on-call rotation and workclosely with developers, application and infrastructure teams.
• Should have worked on Sybase outplace migrations withreplication 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 indelivering large-scale infrastructure/data center migration andinfrastructure/data center upgradation/modernization projects within the globalhigh availability banking /financial services environment.