Database Administrator
UNITECH CONSULTING PTE. LTD. · Singapore ·
- Category
- Devops
Maintains Sybase/PostgreSQL databases, ensuring reliability and performance via troubleshooting, tuning, and proactive improvements. Supports incident resolution, upgrades, and engages with teams on tech roadmaps.
- 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.
Requirements
- Must have strong technical knowledge in Sybase ASE, Replication server and Postgres.
- 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/Postgres 12.x and above database administration experience.
- Knowledge in Replication, Clustering in Sybase/Postgres 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.