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

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.

Sybase Database Administrator L2