Sybase ASE

Role / Job Summary – Expert on Sybase ASE, RS & IQ with good technical knowledgeYears of Experience – 15 to 18 yearQualification / Certification – Engineering graduate / MCA / Computer Science Graduate or PG. Any relevant RDBMS certification is an added advantage. Key Responsibilities –

• Providing round-the-clock database support, including handling incidents, requests, and changes.
• Automating regular patch deployments, installations, and other routine tasks.
• Designing and developing scalable database architectures to meet business requirements, along with recommending hardware and network solutions.
• Optimizing data storage, retrieval, and indexing for improved performance efficiency.
• Ensuring data integrity, security, and compliance with industry standards.
• Collaboration with application developers, system administrators and other teams to enhance database operations and support.
• Use of Performance Monitor, optimizing queries, and tracing long-running queries, blockages, and deadlocks.
• Account management tasks include creating, deleting, and modifying profiles, as well as managing security and audit control parameters.
• Design configuration and manage Sybase ASE, RS & IQ systems.
• Knowledgeable in index defragmentation, re-indexing, updating index statistics and query tuning.
• Configuration and monitoring of Sybase replication for both homogeneous and heterogeneous environments.
• Proficient to manage DR and Resiliency strategies and underlying infrastructure architecture knowledge.
• Scheduling, monitoring, and troubleshooting Sybase Agent Jobs and Autosys maintenance jobs, as well as addressing data corruption issues at the page and table levels.
• Working closely with application developers to optimize database interactions.
• Strong background to conduct proof of concepts (POCs) for new features and enhancements to reduce costs.
• Research and recommend new database technologies through POCs.
• Proficient in documenting database structures, policies, and procedures.
• Awareness to any of 2 public cloud platforms and responsible to integration designs from Tradi environments
• Responsible for design implementation and manage cloud-based Sybase database solutions.
• Manage projects and ensure technical solutions meet business needs.

Provide guidance and mentor the team members.

• Proficient in managing migration of Sybase ASE to MSSQL/PostgreSQLMandatory Skills / Experience – Must have good team working skills balanced with ability to work in shifts (24x7 on rotation basis) / ability to work alone and a positive attitude.
• In-depth knowledge of Sybase ASE, RS & IQ architecture, configuration & performance tuning
• Proficient on Migration & Upgradation of Sybase Server (Legacy Mgt)
• Good Experience on automating regular & EBF patch deployments, installations and other BAU tasks.
• Experience on shell scripting and other programming languages to make database operations to automate.
• Experience in using Performance Monitor, optimizing the queries, tracing long running queries, blockings, and deadlocks.
• Account Management (Login Creation, Deletion, Profile Modification) & managing Security/Audit parameters.
• Performance Tuning, Query Optimization, Client/Server Connectivity
• Knowledge on index de-fragmentation, re-indexing and update the index statistics.
• Configuration & Monitoring Sybase Replication of both Homo and Hetro
• Periodical Backups of the database and timely recovery when required.

Scheduling the automated backup jobs

• Scheduling, Monitoring and Troubleshooting Sybase Agent Jobs/Autosys Maintenance Jobs &
• Trouble Shooting and fixing Data corruption (Page, table level)
• Preparing/Updating SOPs documents (Technical & Operational)
• Sybase solutions on public cloud platforms like Azure & AWS
• Strong analysis & problem-solving skills to diagnose and resolve complex database issues.
• Strong knowledge on Production Database Operations & understanding the importance of BAU
• Good Knowledge on ITIL Framework.

Experience on Incident Mgt and managing Crises calls by engaging with Vendors & Clients

• Good knowledge on Presentation skills with PPT and expert in Excel with functions & Macros
• Good Experience on Client projects/domain, End-to-End Project management, setting-up technology Roadmap.
• Preferred Experience on LEAN methodology to optimize the BAU tasks.
• Willing to accept/take responsibility and problem ownership.

Ability to work in a rapidly changing environment.

• Skill-up on new concepts, features and

Open-source technology and being Mentors. Good to have skills / Experience –

• Experience of handling very large environment, min 500 SQL Instances and TBs of database size
• Supporting PostgreSQL or MongoDB
• Shell scripting and programming knowledge
• Any Cloud Platform Certifications