database administrator London, England
Symmetry Investments
Full Time
London, England
50000 - 24000 GBP ANNUAL Today
Job description
About Us
Symmetry Investments is a global investment company with offices in Hong Kong, Singapore, London, Jersey and Cayman Islands. We have been in business since 2014 after successfully spinning off from a major New York-based hedge fund.
At Symmetry Investments, we seek to engage in intelligent risk-taking to create value for our clients, partners and employees. We derive our edge from our capacity to generate Win-Wins – in the broadest sense. Win-Win is our fundamental ethical and strategic principle. By generating Win-Wins, we can create unique solutions that reconcile perspectives that are usually seen as incompatible or opposites, and encompass the best that each side has to offer:
We integrate fixed-income arbitrage with global macro strategies in a novel way.
We invent and develop technology that focuses on the potential of human-machine integration.
We build systems where machines do what they do best, supporting people to do what people do best.
We are creating a collaborative meritocracy: a culture where individual contribution serves both personal and collective goals - and is rewarded accordingly.
We value both ownership thinking AND cooperative team spirit, self-realization AND community.
The Role
- Working closely with many different Symmetry colleagues to expand and enhance the existing database capabilities
- Contributing to technology strategic decisions with respect to data models and databases
- Analysing and understanding the data output by a third party booking and risk management system used by Symmetry
The First 3 to 6 Months
- Learn how Symmetry would like people in Technology to get things done in terms of both tools to use and principles to apply
- Spend time becoming familiar with the existing key databases, codebase and the functionality it provides
- Learn about how existing solutions are deployed
- Meet the team members and start to build working relationship
- Pick up existing issues in the code repository and contribute in the form of merge-requests
- Work with the DB working group to understand shortcomings of existing solutions and participate in discussions, prototyping, implementation, testing and support of next generation DB technologies
- Ensure DBs are appropriately resourced re storage, memory and CPU allocation for both performance and resilience
- Put in place and/or appropriately configure sufficient monitoring capabilities to ensure minimal downtime and metrics to help make informed decisions
- Provide routine operational maintenance including installations, upgrades, patches, DR tests, etc.
- Troubleshoot live service issues to resolution with post-mortem writeups and root cause analysis
Requirements
- Adept at problem solving under high pressure
- Expert at ANSI SQL, DDL, DML, data normalisation and transactions
- Prior experience with Microsoft SQL Server and MongoDb
- Prior experience with PostgreSQL is strongly desirable
- Solid understanding of profilers, query analysers, optimizers and different types of indexes together with their pros and cons
- Solid understanding of data warehousing architectures, including partitions and schema design
What to Expect from our Interview Process
Our interview process is not a cookie cutter process and changes based on the candidate. In general, you should expect:
- An introductory meeting and an aptitude assessment. The aptitude assessment is not a pass/fail test, and we do the same aptitude assessment for all candidates coming to Symmetry - so it cannot be a test of competency for a certain role. We're trying to understand what you're good at and what you're bad at, to try to form a role around your strengths and weaknesses.
- A meeting with a member of the team for an open discussion on your background, experiences and how you may fit into the team.
A meeting with someone technical. We're not looking for everyone to be a software developer, but we do like having technical people meet candidates to see how they approach complex problems, how they can break them down and solve them, and how they learn.
Iteration from there, based on the feedback from the interviews and any further interviews to try to figure out where you'd best fit within Symmetry and what role we can create for you.
Symmetry Investments
www.symmetryinvestments.com
Hong Kong, Hong Kong
Unknown / Non-Applicable
51 to 200 Employees
Company - Private
