Job Title

Role / Job Summary –Expert on Sybase ASE, RS & IQ with good technical knowledge Years 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/PostgreSQL Mandatory 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