Database Engineer

Vista Applied Solutions Group Inc • Full-time • Bala-Cynwyd, PA, US • 2d ago

Job Summary:

Our Team is looking for a Database Engineer to join our team. You would join a diverse team of database administrators, software developers, and production engineers that are responsible for providing reliable platforms and services for our trading systems, including SQL and NoSQL databases, messaging middleware, reference data distribution, and observability and alerting solutions. The ideal candidate will have strong leadership, communication and project management skills.

This person would join an existing group of Data Engineers to assist with the administration, configuration, maintenance, and deployment of an existing environment of 150+ servers. This role would allow you to diagnose full stack problems across multiple systems and collaborate with systems engineers, developers, database administrators, and business users to share ideas and recommendations for solutions that increase and expand our database environment.

In this role, you will be working with Teams across our entire business. In addition to providing support for these different business and Database Systems, you will be working with Front Office Trading Technology Teams to implement solutions that are at the cutting edge of our core business.

NOTE: They're doing a lot of application integration, API, ETL, data flow. Cross functional collaboration, project work, know how data systems integrate with applications.

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.
Remediating and repairing database systems and production data to ensure trading systems have access to required data and services.
Assisting in the archiving, regeneration, and repair of historical data.

Qualifications:

Bachelor’s degree in Computer Science, Computer Engineering, Information Technology or a related field
Strong Leadership, Communication, and Project Management skills are required
Minimum of 5 years of experience in a Database Administration Role (Nice to have)
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.
Ability to learn and maintain a legacy code base
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