DB2 Database Administrator

About CLS:

CLS is the trusted party at the centre of the global FX ecosystem. Utilized by thousands of counterparties, CLS makes FX safer, smoother and more cost effective. Trillions of dollars’ worth of currency flows through our systems each day.

Created by the market for the market, our unrivalled global settlement infrastructure reduces systemic risk and provides standardization for participants in many of the world’s most actively traded currencies. We deliver huge efficiencies and savings for our clients: in fact, our approach to multilateral netting shrinks funding requirements by over 96% on average, so clients can put their capital and resources to better use.

CLS products are designed to enable clients to manage risk most effectively across the full FX lifecycle – whether through more efficient processing tools or market intelligence derived from the largest single source of FX executed data available to the market.

Our ambition to make a positive difference starts with our people. Our values underpin everything that we do at CLS and define our working environment:

• Pivotal purpose
• Trusted guardian
• Targeted innovation
• Facilitate connections
• Delivering excellence
• Inclusive culture

Job information:

• Functional title - Assistant Vice President, DB2 Database Administrator
• Department - Infrastructure Management
• Corporate level - Assistant Vice President
• Report to - Director, Infrastructure Database Support
• Location - London, UK

Job purpose:

Provide 2nd line operational support for the CLS internal Middleware, DB2 and Oracle database infrastructure and systems in the company’s 24x7 hosted environment. Provide remote and on-site shift support as part of the on-call support rotation. Work closely with other support teams to ensure that the database environments are fully supported and maintained in order to meet the needs of the business.

Essential Experience:

• Production operational support experience for IBM DB2 (11.1/11.5) within an Enterprise Linux environment.
• Must have an understanding of database disaster recovery/high availability technologies including DB2 HADR, QREP.
• Experience of supporting AWS RDS databases.
• Ability to plan and implement technical changes without unexpected disruption to the service and with some oversight.
• Ability to write Korn/awk shell / Python scripts for database maintenance and monitoring.
• Database performance tuning for bufferpools, indexes, access plan optimisation.
• Experience of providing production support activities for business critical databases/applications.
• Good documentation and technical writing skills.
• Must have excellent analytical and problem solving skills.
• Experience in working with ITIL ticket systems such as ServiceNow and an understanding of priorities and SLA’s.
• Ability to collaborate effectively with other operational support teams in to support the service.
• Experience of providing cross training on technologies and operational processes to colleagues.
• Have excellent time management and organisational skills.
• Knowledge of ITIL framework (understanding of Incident, Problem, Change).

Desired Experience:

• Knowledge of Banking systems and related industry standard practices
• Operational Support experience of Microsoft SQL Server in an Enterprise Windows environment.
• Experience in working and configuring monitoring systems such as Dynatrace.
• Working knowledge of PostgreSQL and Oracle

Responsibilities:

Operational

• Provide operational support for the IBM DB2 Server, Postgres and Oracle database environments. Responsibilities include database backup/restores, daily checks, maintenance tasks and building new database instances and applying service packs. Manage and escalate problems as appropriate.
• Investigate defects or problems, work with internal CLS Development team and external vendors to identify solutions and support any fixes that are required as part of service improvement.
• Provide support for database and InfoSphere QREP recovery exercises.
• Follow the CLS Change Management procedure and other standard practices in installing, configuring and supporting databases and related items in Test and Production environments.
• Ensure that the BAU Service is prioritised and all faults, incidents and problems are responded to in an efficient manner without negatively impacting SLAs and reporting metrics in place.
• IBM DB2 Performance tuning analysis and alerting.
• Work with Security Analysts to support DB2 security policies.
• Install, upgrade or maintain software at a time when the impact to the business is minimised.
• Execute the failover for the database and application services as required. Participate in regular Disaster Recovery testing activities.
• Create, maintain and review operational process and support documentation.
• Provide 24/7 on-call cover on a rotational shift basis.
• Participate in planned weekend work as required.

Strategic

• Ensure CLS internal database systems are managed to the highest standard by following industry best practice.
• Demonstrate good problem management ownership and prevention of SLA breach under Incident/Problem Management processes.
• Where appropriate, contribute to the development of existing and new IT process and procedures to enhance service transition and service operation lifecycle stages.

Leadership

• Through example and behaviour, strive to provide peer leadership to other team members ensuring a level of excellence is achieved in delivering the service.
• Participate in the successful release and transition of new database services into support, meeting the team’s service acceptance criteria

Success Factors

• Possess a strong service-oriented mind set who can consistently deliver a high level of service to the business.
• Proactive individual who can take the lead in engaging with the business users and to support the environment with minimal oversight.
• Self-motivated to exceed management expectations and objectives.
• Demonstrate strong technical, analytical and problem solving skills.
• Able to manage their time effectively and prioritise their own workload in order to meet changing demands from the business.
• A high level of presentation and communications skills with the ability to communicate confidently with both business and technical staff at all levels.
• Ability to engage with the business to effectively support the environment with minimal oversight.

Qualifications / certifications:

Essential

• Bachelor’s degree or equivalent
• Prior IT operational support experience across business critical Production infrastructure, applications and database services.

Desired

• IBM DB2 certification
• AWS Certified Database — Specialty
• ITIL certification