Lead Administrator L1(Contract)

Sybase DBA Job Description
5 Days Onsite @ London
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..

Areas of responsibility

Triaging and resolution of tickets-Provide resolution to high priority incident (P2) tickets performing advanced troubleshooting and root cause analysis to ensure timely closure.

SLA Monitoring-Ensure SLA compliance for assigned technology areas and ensure proactive escalation management.

Performance tuning and optimization-Analyse system performance data coordinate findings on system behaviour and support capacity planning initiatives to enhance overall system efficiency.

Perform system Improvements-Create mitigation measures to evaluate new tools or improvements by collaborating with technical teams.

Handling disaster recovery-Perform security assessments and recovery drills and implement necessary controls to ensure compliance with established security standards.

Reporting and stakeholder engagement-Participate in weekly and monthly service review meetings provide updates on performance and issues and support stakeholder communication to ensure transparency and service alignment.

Team Management-Collaborate with team members to resolve open tickets and service requests.

Knowledge base and continuous learning Contribute to updating SOPs knowledge articles and maintaining the knowledge repository for the purpose of future ticket resolution.