The Production Services Team is looking for an Engineer to join their team to provide reliable platforms and services for trading systems, including SQL and NoSQL databases, messaging middleware, reference data distribution, and observability and alerting solutions. The role involves administering, configuring, maintaining, and deploying an existing environment of 150+ servers, diagnosing full stack problems, and collaborating with various teams to increase and expand the database environment.
Requirements
- Experience with large databases with tens of millions of rows and terabytes of data.
- Experience with multiple database systems, including MongoDB, Oracle, Postgres, InfluxDB and Microsoft SQL Server.
- Experience with Linux and Windows operating systems.
- Hands on experience with SQL development, shell scripting, and Python.
- Experience with ETL tools such as Informatica a plus
- Experience with DevOps and CI/CD tools such as Perforce, GitLab, TeamCity, Jenkins, or Ansible a plus
Responsibilities
- Supporting production operation of over 150 database servers used across a wide variety of systems and end-users.
- Supporting, operating, troubleshooting, and enhancing ETL processes to support both core business functionality and application specific needs.
- Design and implement highly available fault tolerant database platforms to support existing and new applications and use cases.
- Working with stakeholders to design and implement new Database Technologies that are supporting our Front Office Trading Systems.
- Working with stakeholders to continuously improve our systems, including software and hardware upgrades, reliability improvements, monitoring and alerting, and performance tuning in order to meet ongoing business needs.
- Working with developers and end-users to improve the efficiency and performance of their database operations, including SQL tuning and write operations.
- Working with other teams to assist with diagnosing and remediating production incidents.
Other
- Strong leadership, communication and project management skills are required
- 3-5 years of experience in a Database Administration Role
- Ability to learn and maintain a legacy code base
