Job Details

SQL DBA

NEW YORK-10010, NY, US
07/04/2019

-


Required Skills

    DBA skills
Company

Infinity Consulting Solutions, Inc

Experience

5 to 10 Year(s)

Job Description

Senior SQL DBA

Department Overview

The Technology Team currently consists of 35 individuals, of which 21 are dedicated to development and 14 are focused on systems engineering and technology support.

Working directly with all areas of the Firm, the Technology Department plays a critical role in maintaining a seamless infrastructure and in developing proprietary solutions tailored to the Firm's investment activities and operations.

In particular, the Development group is heavily involved in building custom tools for risk management, research, trading, cash and position reconciliation, pricing, P&L attribution, collateral management, fund accounting, and investor relations.

The Infrastructure group is responsible for enhancing and maintaining the Firms network and server infrastructure and providing global support for our end users.

SQL DBA:

Job Description

This is a mid to senior level SQL Server DBA role who would share the responsibilities with other DBAs to manage the firm's prod, and non-prod database environment, a centralized job scheduler hosting a few thousand jobs, as well as an array of third party application and system tools, and the workflow of many different datasets.

Requirements

Core Skills

5-10+ years of experience in Database Administration for SQL Server, with the latest experience in SQL 2017 on windows 2016+, preferably in hedge fund or another financial services industry.

Efficient with all aspects of core DBA skills, such as backup/restore, database design,
SQL development, performance tuning, replication, compression, partitioning, security, clustering, HV/DR, resource monitoring, database maintenance.

Familiar with native or third-party SQL monitoring and troubleshooting Tools.

Experience with job automation tools, Activebatch a plus

Basic understanding of hedge fund portfolio data such as positions, transactions, securities, market data, and PnL

Complementary Skills

Any working knowledge of the following systems would be a big plus:

Vertica, Teamcity, PostgresSQL, Tableau, Advisorware, SVN / Git, Wall Street Office, Linux.

Any experience in managing the process workflow for various datasets such as S&P CapIQ,
Bloomberg, Markit, Factset, etc would also be helpful.

Any exposure to Olap Cube would also be a plus, but not absolutely required.

Work ethics/Others

Fast learner, having strong desire to learn new systems that are not necessarily SQL related

Proactive in monitoring and responding to jobs failures and server health issues at all times, including evenings and weekends.

Humble, detail-oriented, careful, motivated, able to get along and work with all kinds of people and be very willing to help others in the firm.

Good communication and documentation skills.




SQL DBA
Information Technology

No Preference
FullTime Job
Other
1

Candidate Requirements
-
Bachelors

Walkin Information
-
-
-

Recruiter Details
Doug Klares
1350 Broadway, Suite 2205, NEW YORK-10018, NY, US
-