Sybase Database Administrator L2

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.