Source description
About the role
As a Sybase DBA, your role involves designing, implementing, and maintaining Sybase ASE & Sybase IQ database instances across Linux/Unix platforms. This includes tasks such as installation, configuration, upgrades, and patching. You will be responsible for performance tuning, query optimization, index management, and capacity planning to ensure optimal throughput and minimal downtime. Routine maintenance activities like housekeeping, reorgs, DBCC checks, index maintenance, statistics updates, and space management also fall under your responsibilities. Key Responsibilities: - Manage Sybase & IQ database privileges and security configurations to enforce security best practices. - Implement backup & recovery strategies using dump/load, replication, or backup server. - Maintain large-scale IQ databases with terabyte-level storage and ensure optimal bulk loading performance. - 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 reporting, BI workloads, data analytics, and archival for Sybase IQ Data warehouse. - Handle Sybase database migrations across On-prem to cloud and cross-platform migrations. - Provide support for production issues with on-call rotation and work closely with developers, application, and infrastructure teams. - Work on Sybase outplace migrations with replication server configuration. - Execute Sybase database decommission with a focus on ensuring a seamless process. Qualifications Required: - 7 to 12 years of experience as a Sybase DBA. - Proficiency in Sybase ASE & Sybase IQ database management. - Strong knowledge of Sybase database migrations, high-availability solutions, and backup & recovery strategies. - Experience in handling large-scale IQ databases and automating administrative tasks. - Ability to work on outplace migrations and database decommissioning. (Note: Additional details of the company were not present in the provided job description.) As a Sybase DBA, your role involves designing, implementing, and maintaining Sybase ASE & Sybase IQ database instances across Linux/Unix platforms. This includes tasks such as installation, configuration, upgrades, and patching. You will be responsible for performance tuning, query optimization, index management, and capacity planning to ensure optimal throughput and minimal downtime. Routine maintenance activities like housekeeping, reorgs, DBCC checks, index maintenance, statistics updates, and space management also fall under your responsibilities. Key Responsibilities: - Manage Sybase & IQ database privileges and security configurations to enforce security best practices. - Implement backup & recovery strategies using dump/load, replication, or backup server. - Maintain large-scale IQ databases with terabyte-level storage and ensure optimal bulk loading performance. - 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 reporting, BI workloads, data analytics, and archival for Sybase IQ Data warehouse. - Handle Sybase database migrations across On-prem to cloud and cross-platform migrations. - Provide support for production issues with on-call rotation and work closely with developers, application, and infrastructure teams. - Work on Sybase outplace migrations with replication server configuration. - Execute Sybase database decommission with a focus on ensuring a seamless process. Qualifications Required: - 7 to 12 years of experience as a Sybase DBA. - Proficiency in Sybase ASE & Sybase IQ database management. - Strong knowledge of Sybase database migrations, high-availability solutions, and backup & recovery strategies. - Experience in handling large-scale IQ databases and automating administrative tasks. - Ability to work on outplace migrations and database decommissioning. (Note: Additional details of the company were not present in the provided job description.)
More at Wroots Global Private Limited