Database Administrator
Europe,
United Kingdom,
London
Permanent
Job ID: 2024
Job Description
[c. £150-200k Comp Package, Hybrid Working]
Seize an extraordinary opportunity with our client, a global investment leader. As a Database Administrator, you will elevate their database capabilities, shape strategic technology decisions, and scrutinise data output. Working with Orchestrade, a top-tier booking and risk management system, you will be the cornerstone of this groundbreaking, technology-driven ecosystem.
Key Responsibilities:
- Acquire knowledge of preferred technology tools and principles, and familiarise yourself with existing databases, codebase, and functionalities
- Analyse data output by Orchestrade (OT) itself
- Learn about existing solutions deployment and resourcing
- Contribute to existing issues in the code repository through merge-requests, and address existing solution shortcomings
- Set up sufficient monitoring capabilities for minimal downtime and decision-making metrics
- Provide routine operational maintenance, including installations, upgrades, patches, DR tests
- Troubleshoot live service issues to resolution, with post-mortem write-ups and root cause analysis
Key Requirements:
- 3+ years experience in a similar role
- Problem-solving skills under high pressure
- Expertise in ANSI SQL, DDL, DML, data normalisation, and transactions
- Experience with Microsoft SQL Server and MongoDB
- Understanding of profilers, query analysers, optimisers, and different types of indexes
- Understanding of data warehousing architectures, including partitions and schema design
- (Desired) Prior experience with PostgreSQL
Apply for this role
All fields marked with * are required.