Job Description
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
Job Tags