Job Summary
Systems Programmer (PostgreSQL/Sybase) is a technical Administrator role within the Database team and will be responsible for managing, administration and supporting the Sybase & PostgreSQL Database technologies for the bank.
Person will be the technical point of contact for the Run team. He/She will be a technical L3 resource for Sybase & PostgreSQL database services. As such, he/she will provide support for all production support activities within the Database team in Singapore. He/She is accountable for the overall health and stability of the technical solutions within his scope. He/She has to effectively work with technical peers such as architects, peer Administrators and project teams on technology road maps and projects. He/She will work with L3/Service Manager to gain control over the scope of technical activities, develop best practices and gain knowledge over all aspects of support.
Sybase & PostgreSQL team in Singapore is responsible for day-to-day operational services on the infrastructure of Europe (mainly France, UK) and Asia remotely from Singapore. France infrastructure represents approximately 80% of the worldwide production activities of CA-CIB in Singapore.
Team works in Europe time zones and this role will be aligned primarily to Paris working hours. Flexible rotations are followed based on the nature of duties.
The operational support of the team covers the following technical scope:
- Sybase & PostgreSQL DB advanced performance tuning both Server & DB level
- Sybase ASE and Replication, PostgreSQL cluster and streaming replication & Cross platform migrations
- Very good Experience in high availability & DR solutions – Storage and DB level replication
- Encryption Solutions: SSL
- Administratorise in Backup & recovery solutions
- Database Audit Monitoring solutions
- Vulnerability Management
- Automations – Python, Shell script,Perlscript, Ansible
Job Detailed Description
The Programmer has a wide spectrum of responsibilities and actions. Person will be responsible for following (but not limited to) responsibilities in day-to-day work:
As the Programmer of the team, he/she:
- act as the last level of escalation for the team members
- own Incident, Problem and change management process for the team
- assigns technical tasks and manages delegation
- animates the team to encourage collaboration and sharing of practices
- participates to recruitment process for the team
As the Programmer of his/her scope of activity, he/she:
- Is actively involved in incident management (fault investigation, resolution escalations of all monitoring alerts and user initiated problem calls/tickets) and request management
- Is the final technical approver for any changes into Sybase and PostgreSQL technology and is accountable for any technical changes in the environment from a RUN/BAU perspective
- Is involved in projects like End of Life, New Builds, migrations and technical upgrades of the solution managed by the team
- Participates in global Infra events (like Power down and DR Tests)
- Ensures activity is performed in compliance with norms, standards, processes and procedures
- Ensures documentation is up to date and relevant for use
- Lead the continuous improvement initiatives
- Responsible to drive and deliver root cause for any high severity issues
- Focus on automation and optimum use of the team to improve efficiency
- Maintain appropriate knowledge to ensure to be fully qualified to undertake the role.
- Complete all mandatory training as required to attain and maintain competence
- Comply with all applicable legal, regulatory and internal Compliance requirements, including, but not limited to, the Singapore Compliance manual and Compliance policies and procedures as issued from time to time
Candidate Profile
- At least a Bachelor’s degree in any of these faculties:
- Computer Science
- Information Technology
- Programming & Systems Analysis
- Science (Computer Studies)
Working Hours
- Work schedule is mainly focused to support Asia and EMEA (Paris) time zone; however, may have to support during non-offce hours for critical incidents or escalation as per the assigned on-call support requirements;
- Rotational Shift schedule is followed;
- Work Hours: 2 PM – 11 PM SGT (with 1 week of General shift 9 AM – 6 PM SGT)
Functional
- 5 - 8 years of Applications/Systems Programmer (PostgreSQL/Sybase) experience in administration and management of IT Database technologies primarily Sybase ASE & Replication , PostgreSQL cluster with replication solutions;
- Should be a bachelors/masters/engineering graduate or equivalent technical degree in Information Technology or Computer Science;
- Knowledge of different domains of IT Security;
- Working & hands-on experience in administering the DB technologies;
- Must have experience in working in similar Production setup in Run (Operations) mode;
- Ability to apply risk based approach while working on assigned responsibilities;
- Experience in defining, implementing, and enforcing Database Security policies for data security solutions;
- Must have working experience in a Large enterprise level environment, working experience in financial organization is preferred;
- Excellent in analytical, communication and documentation skills;
- Ability to organize work and be able to prioritise work as per the needs of Production Operation’s needs;
- Must have strong understanding of ITIL processes and comfortable working in process oriented environment;
- Ability to work independently and as well as a part of team and is able to work under minimal supervision;
- Should have time management skills and able to manage work in fast moving environment;
- Knowledge of French language is preferred, as required to liaise with Stakeholders in France
Technical
- Hands-on experience on Configure and maintain database servers and processes
- Experience of High Availability (HA) and Disaster Recovery (DR) options for Sybase and PostgreSQL technology
- Deployment, integration and administration experience of various components of DB technologies:
- Must have experience in defining, designing and configuring Database solution as per the business requirements;
- Deploy, upgrade and troubleshooting knowledge on Sybase and PostgreSQL technology solution;
- Scripting knowledge (Python, Powershell, TSQL, Ansible, Shell) is desirable;
- Professional Certifications:
- SAP and EDB certified is highly preferred
- Cloud ceritication
- Must be experienced to cover the scope as mentioned in the SKILLS MATRIX section of this document.
Interested applicants, please email your resume to Shaun Quek Yew Meng
Email: [email protected]
CEI Reg No: R1660732
EA Licence No: 99C4599
