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.