Database Administrator - London, United Kingdom - Symmetry Investments

Symmetry Investments
Symmetry Investments
Verified Company
London, United Kingdom

2 weeks ago

Tom O´Connor

Posted by:

Tom O´Connor

beBee Recruiter
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 Yorkbased 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 mergerequests
  • 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 mínimal 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 postmortem 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

  • A meeting with a member of the team for an open discussion on your background, experiences and how you may fit into the team.
  • 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.
More jobs from Symmetry Investments
See all jobs of Symmetry Investments