
Hedge Fund #072
A Career with Hedge Fund’s Infrastructure Technology Team
As Hedge Fund reimagines the future of investing, our Technology group is constantly improving our company’s IT infrastructure, positioning us at the forefront of a rapidly evolving technology landscape. We’re a team of experts experimenting, discovering new ways to harness the power of open source solutions, and embracing enterprise agile methodology. We encourage professional development to ensure you bring innovative ideas to our products while satisfying your own intellectual curiosity.
Our Technology Infrastructure Team engineers and operates the foundational technology platforms that power our firm’s applications and businesses. Our disciplines span a broad array of technologies from datacenter infrastructure to large scale cloud services, with the shared goal of providing the most reliable, performant, modern technology platforms to improve time-to-market for our business. We also deliver end-user technology solutions to support the evolving collaboration and productivity needs of our global teams. Our team focuses on innovation and challenging the current state of our infrastructure technology in a fast-paced, dynamic, and collaborative working environment.
We are looking for a ‘Hands on the Keyboard’ Database Engineering Manager in the NYC Metro Region. This is a combined Engineering & development role focusing on the support and continuous improvement of the Database Platforms Infrastructure at Firm. It is expected that the candidate can will lead the development of our automation platform as it evolves.
The environment is fast-paced with rapidly changing focus from development projects, troubleshooting critical situations and defining new architectures and standards. Being an open and communicative resource within the wider technology team is a key part of the role.
Professional Experience:
This is a Player / Coach role, this role is expected to be hands on the keyboard 70% of the time and 30% management of team of 8 Database engineers.
Help Hedge Fund define and implement modernization strategy in the database space to enhance performance, stability and resiliency to better serve financial markets and institutions
Design and implement a robust, flexible, automated enterprise level database Monitoring and Alerting system to enhance proactive monitoring, enable earlier warning and reduce major incidents. Events and features monitored for any database platform: server status, instance restart, long running transactions, blocking sessions, space usage, user privileges and logins, replication lag, backup failures, job failures, security parameters baseline, compute credits usage, etc.
Lead the team in engineering and establishing processes to automate and standardize database changes (code changes and patching, upgrade) by leveraging Jenkins Pipelines, or other similar tech)
Integrate database security in code.
Strong Experience with developing DBA administration scripts using T-SQL, stored procedure, Python and Power Shell scripts for database management automation
Lead team in Architecting and establishing a standard global database inventory for databases on all platforms for metadata management, auditing and compliance, patching, security baseline, user entitlement management, reduced database compliance management time by 90%
Candidate Profile
Ø A seasoned SQL Database Expert in all aspects of database technologies with versatile expertise in providing global database Architecture, Engineering, Deployment, & support of critical systems in 24×7 environments.
Ø Candidate should have at least Total 7+ years of MS SQL Server database Architectural, Engineering, & administration experience. Performance tuning expert with MS SQL Server 2016/2014/2012/2008/2005.
Ø Highly experienced in the field of Architecting, Engineering, Administration and development of the Microsoft SQL Server platform
Ø Able to write and troubleshoot complex T-SQL and execution plans
Ø Aptitude for building ambitious automation projects
Ø Experience with C#, Powershell, Python and Javascript o other languages will be considered if the candidate is willing to adapt
Ø Well-versed in a git-based workflow for coding and configuration
Ø Prior exposure to other database platforms, especially Postgres and Redis (preferred)
Ø Platform/OS: Linux, Windows
Ø Exceptional and unique Server and Query performance tuning and troubleshooting expertise to diagnose and resolve perplexing database problems.
Ø End-to-end database system architectural, engineerin,g and operational support of global 24×7 critical business applications running on various database platforms (MS SQL Server, PostgreSQL, MongoDB, MySQL);
Ø Database migrations from one platform to another, on-prem database transformation to on-cloud