Senior Software Engineer - Windows Platform/SQL Server

Senior Software Engineer - Windows Platform/SQL Server Location New York Business Area Engineering and CTO Ref # 10036357

Description & Requirements

Our Team:

Bloomberg is the industry standard for financial news and research. Bloomberg's software solutions depend heavily on the robust data infrastructure to provide clients with information to make critical decisions. Our team is designing the next generation systems for managing this piece of crucial infrastructure. Our ability to provide a world class DBaaS (DataBase as a Service) solution is essential to our clients robust access to store, retrieve and analyze massive quantities of data. Ensuring our services scale, are secure and reliable is where you come in.  

Who we are?

The Database services team provides a database-as-a-service (DBaaS) platform that engineers depend on to drive applications throughout Bloomberg. We manage several open source (Postgres, MySQL etc) and commercial (Oracle, SQL Server etc) database options, all of which Bloomberg is heavily invested in. Our solution manages 100K+ databases and is growing quickly with no end in sight. To support this scale, we are recreating our database solution with a focus on security, performance and self-service. We develop and manage the services and operational toolkits that enable application teams to easily deploy data sets and query across them. 

Who are you? 

You are an experienced Software Engineer who understands and enjoys designing and building automation workflows for SQL Server database solutions on the Windows platform. You are flexible and enjoy discussing the tradeoffs between competing solutions. You want your work to have a big impact and to build compelling products. 

We'll expect you to:

• Build SQL Server focused automation to manage at scale database configuration, version management, and push-button deployment

• Improve and automate deployment, management, and monitoring solutions for SQL Server High Availability 

• Improve Database Telemetry & Alerting Components

• Create self service components that allow for engineering teams at Bloomberg to manage database access, performance tune their system, deprecate unsupported functionality, and plan for future capacity needs.

You need to have:

• Experience writing applications that interact with SQL Server 

• 4+ years of software engineering experience in object oriented languages (eg Java/C#/Python)

• Managing Windows and SQL Server functionality via Windows Powershell scripting

• Experience with SQL Server T-SQL Query Language

• Understanding of basic database concepts

• Ability to debug and correct production problems  

• Strong communication skills

• A degree in Computer Science, Engineering or similar field of study or equivalent work experience.

We'd love to see:

• Prior experience administering SQL Server (2017 or newer) Database Clusters configured with AlwaysOn Availability groups

• Experience building distributed