Sybase DBA Planner (NCS/Job/ 3741)
Job Skills
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 and 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 exp for
senior Sybase DBA role
