About the Role
We are seeking a senior Sybase DBA with extensive hands-on experience in delivering large-scale infrastructure/data center migration and upgradation/modernization projects within a global high availability banking/financial services environment. This role involves supporting production issues with on-call rotation and collaborating with development, application, and infrastructure teams.
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.
- 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, including user/role management, database encryption, and auditing.
- 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.
- Support Sybase IQ Data warehouse reporting, BI workloads, data analytics, and archival.
- Support Sybase database migrations across On-prem to cloud and cross-platform migrations.
- Support production issues with on-call rotation.
- Work closely with developers, application and infrastructure teams.
- Perform Sybase outplace migrations with replication server configuration.
- Perform Sybase database decommission.
Requirements
- 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.
- Experience with Sybase Replication Server, Warm Standby, MSA, Failover Clustering, and disaster recovery strategies.
- Experience with BCP, IQ load utilities, or ETL tools.
- Experience with Shell/Perl/Python scripting for automation.
- Experience with Sybase database migrations (On-prem to cloud, cross-platform).
- Experience with Sybase outplace migrations with replication server configuration.
- Experience with Sybase database decommission.
- Experience supporting production issues with on-call rotation.
- Ability to work closely with developers, application and infrastructure teams.
Skills
- Sybase ASE
- Sybase IQ
- Linux/Unix
- Database performance tuning
- Query optimization
- Index management
- Capacity planning
- Database maintenance
- Security configurations
- Backup & recovery
- Restore strategies
- Bulk loading
- BCP
- IQ load utilities
- ETL tools
- High-availability solutions
- Sybase Replication Server
- Warm Standby
- MSA
- Failover Clustering
- Disaster recovery
- Shell scripting
- Perl scripting
- Python scripting
- Data warehouse support
- Reporting
- BI workloads
- Data analytics
- Archival
- Database migrations
- On-prem to cloud migration
- Cross-platform migration
- Outplace migrations
- Database decommission
Experience Level
- 10+ years of experience for a senior Sybase DBA role
