This position will have heavily influence of the direction of the team, and in turn the firms' data strategy.
The ideal candidate will be self-motivated, personable, and have an ability to effectively use their technical skills to design, and communicate, new solutions and approaches to the business and development teams.
This position is roughly 1/3 Operational duties, 1/3 Architecture and Design duties, and 1/3 implementation of approved solutions.
A strong skill set in Microsoft SQL Server and related tools is a must have, with additional experience in complementary Big Data solutions an advantage.
Typical Duties:
Plan architecture and infrastructure for a financial database systems environment with 60+ SQL Server instances, from 2012 - 2016
Plan new technology initiatives to add value to the business
Design installation scripts and automation; configure and write supporting documentation for a high-availability SQL Server database environment in support of financial services applications and products
Work closely with business analysts and software developers to support existing applications and create new products in a fast-paced dynamic software development environment
Mentor junior team members through training, workshops etc.
Design and assist with database backup and recovery and ensure a business continuity planning solution
Create documentation and best practices for access and controls, benchmarking, policy management, backups and recovery, performance, reliability, usability and support
Create SQL and Powershell scripts and stored procedures for recurring tasks
Automate the management of database security to ensure the integrity of all confidential participant, client and employee information
Assist and design stress testing of new applications before deployment to production servers
Develop automated policies for database code to ensure compliance with company database standards and Microsoft best practices
Provide cross training to other engineers as necessary QUALIFICATIONS:
Requires 7-10+ years of direct, hands-on experience with SQL Server
Microsoft certification for SQL Server advantageous
Experience with an investment/hedge fund or financial services company highly desired.
Must be able to work in a schedule-driven, regulated and Compliance driven environment. Timing is a critical function.
Excellent organizational, time management and communication skills are essential.
The ability to work independently and as part of a team will be critical to this role.
Must set high standards and integrity while motivating the team to succeed
Flexibility with regards to scheduling, including after hours and weekends, is required. 24x7 on call support for scheduled days required. Ability to travel to other data centers required.
Drive, energy, enthusiasm, maturity and confidence are all qualities we are looking for
#LI-MG1