ShepHertz - Technical Consultant - Sybase/DBA

Job Title : Sybase ASE & RS DBA (Consultant Technical Lead DRE) Team Size (If Applicable) 71 (All technologies) Shift (If Applicable) 24-7 (Morning, Second & On-call on Night and during weekends) Location : Bangalore, Chennai Department / Project Overview : - GTS/PAS/DRE Team provides 24 - 7 production database support to all the MKT/GDI & Retail Banking customers across SG group. - Project includes incidents, requests & changes management on all the Retail applications hosted on multiple technologies including Oracle, MSSQL, Informix, DB2, Teradata & Open Source RDBMS (PostgreSQL, MongoDB & MYSQL). - The project is responsible for the complete life cycle management of databases including Migrations, Upgrades etc. - Additionally the project supports all the maintenance operations, performance analysis & troubleshooting, patching & DRP exercises. Role / Job Summary Expert on Sybase ASE, RS & IQ with good technical knowledge Years of Experience : 15 to 18 years - 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 (ref:hirist.tech)

Location: chennai, IN

Posted Date: 5/9/2025