SQL DBA
NEW YORK-10010, NY, US
07/04/2019
-
Required 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
-