Role summary
The Sybase Database Administrator (DBA) is responsible for designing, implementing, and maintaining SAP Sybase ASE databases and related replication infrastructure, ensuring high availability, performance, security, and recoverability of business‑critical systems.
Key responsibilities
- Install, configure, and maintain Sybase ASE databases (12.x–16.x) across development, test, and production environments.
- Perform database upgrades, patching, and migrations in line with change and release management processes.
- Monitor database health, capacity, and performance; identify bottlenecks and perform query and index tuning.
- Implement and manage backup, restore, and disaster recovery procedures, including warm/hot standby and replication setups.
- Configure and support Sybase Replication Server for high availability, failover, and data distribution.
- Maintain database security including user, role, and privilege management and compliance with internal controls.
- Troubleshoot and resolve production incidents, performance issues, and failed jobs within agreed SLAs, including 24x7 on‑call coverage as required.
- Work closely with application and development teams on data modeling, schema design, stored procedures, and release validations.
- Automate routine administrative activities using shell scripting and SQL utilities; improve monitoring and alerting.
- Maintain documentation for database environments, standards, procedures, and runbooks.
Required skills and experience
- Strong hands‑on experience administering SAP Sybase ASE in large, mission‑critical environments (typically 5–8+ years).
- Solid knowledge of Sybase architecture (engines, devices, segments, tempdb, locking, transaction logs, query optimizer).
- Proven experience in performance tuning, query optimization, and index strategy for OLTP and/or data warehouse workloads.
- Expertise in backup and recovery strategies, disaster recovery planning, and high‑availability/replication configurations.
- Strong skills in Unix/Linux (and/or Windows) OS for database installation, filesystem/storage layout, and scripting.
- Good understanding of ITIL‑based incident, problem, and change management processes.
- Effective communication and stakeholder management skills to work with application teams, architects, and operations.
Nice‑to‑have (optional)
- Exposure to other RDBMS platforms (Oracle, SQL Server, PostgreSQL, MySQL).
- Experience in financial services or other low‑latency, high‑volume transaction environments.
- Knowledge of automation/orchestration tools and job schedulers such as Autosys or similar.