About this role
Role Summary • Takes up technical tasks and support day to day BAU tasks/Incidents/RFC’s. • Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise. • Proposes service improvements for all Sybase/PostgreSQL services supported throughout the organization. • Provides technical knowledge, supports services both proactively and reactively to maintain the availability and reliability of database system infrastructure in accordance to the SLA. • Actively engages during any high severity issue and drives for issue resolution. • Reviews technology changes to identify potential risks. • Supports his/her team during diagnosis when technical issues rise in his/her scope of expertise. • Is aware of the global IT structure so that he/she anticipates interrelationships within the organization. • Engages with technical peer, Development team, Service managers, Architect and project teams on technology roadmap and projects. • Facilitates transformation projects and suggest future directions for new areas of improvement and enhancements. • Guarantees the production readiness. • Is available and able to drive technically, any complex or high severity incidents that occur within the scope of their role. • Actively engages to understand new technologies and technology trends and reviews them with a view to incorporate them into Bank operations. Technical Expertise • Must have strong technical knowledge in Sybase ASE, Replication server and Postgress. • Backup and restore of databases. • Tuning databases and application queries and perform server access/login management. • Performance tuning, troubleshooting, and resolving database integrity issues. • Experience to Production Server Environment. • Should have handled database installations, upgrade & patching as Sybase and Postgress DBA. • Application DBA Exposure. • Sybase ASE 15.x/Postgress 12.x and above database administration experience. • Knowledge in Replication, Clustering in Sybase/Postgress 12.x and above. • Exposure to new features of current ASE/PostgreSQL version. • Development support/ debugging BAU issues. • OS level activities related to database tasks. • Log, scheduled Job Management through Control-M or similar products. • Schema Object, Partition Management. • Expertise in handling Database Maintenance related to Index and DBCC. • Manage Capacity planning of entire Sybase and Postgress estate. • Unix, Linux experience is desired. • Experience in writing - Ansible, DB Scriptingand Shell scripts. Shift/Oncall & Weekend Support Flexible towork in shifts/ weekends/On-Call support as follows: Shift Timings Morning Shift 4.30AM to 1.30PM Afternoon Shift 11.30AM to 8.30PM Afternoon Shift 1 12.30PM to 9.30PM ** Evening Shift 2.30PM to 11.30PM Evening Shift 1 3.30PM to 12:30AM ** • 11.30 PM Night to 4.30 am on weekdays after end of the evening shift work (Apr to Oct). • 12.30 Midnight to 4.30 am on weekdays after end of the evening shift 1 shift work (Nov to Mar). • 00:00 AM to 11:59PM on both Saturday and Sunday. • Weekend Support - Mandatory to work on every 3rd Saturday of given month. (Timings From time to end time to be mentioned ) PublicHoliday Support – Paris Holidays (Client Holiday) will be followed as public holidays and not India holidays. Process & Tools • ITSM tool- HP Service Now – Ticketing tool for INC/SR/Change/Problem tickets. • Inhouse tools. • HP OMI for monitoring. • Strong knowledge on ITIL Process &Practices. Key Competencies • 5yrs (Min) to 8yrs of relevant experience in Sybase database administration. • The candidate should have worked in a SLA driven environment. • Ability to work in a flexible, team-oriented and constantly changing environment. • Good Oral and Written communication skills. • Good knowledge on PowerShell/Python and T-SQL Scripting. • Having Sybase/Postgress certification will be added advantage. • Having previous banking BAU support will be added advantage.
Also in Operations