Senior SQL Server Database Engineer

Careers at Bloomberg

New York, NY

Posted Oct 31, 2018 - Requisition No. 71659

Senior SQL Server Database Engineer

Bloomberg runs on data. It's our business, our product, and the reason why thousands of companies partner with us. We've surpassed petabytes of data, with no end in sight.

Our team:

The Bloomberg Database Engineering team maintains large-scale, highly transactional databases with a focus on high availability and performance. We have over 25k database instances that run on MySQL, PostgreSQL, Oracle, Db2, and SQL Server. To manage these effectively, we operate a DBaaS (Databases-as-a-Service) platform which empowers our developers to manage their own databases.

What's in it for you:

On our team you will manage rapidly growing, complex and highly available SQL Server server infrastructure. You will need to define best practices for automated procedures in deploying and scaling the environment. You will also serve as a lead technical resource in the implementation and oversight of the database system. We expect you to know SQL Server database system inside and out and be a little bit obsessive about automation.

We'll trust you to:

  • Develop best practices and automated procedures for deploying and scaling databases
  • Design, build, and automate new solutions centered around the Kubernetes container orchestration platform and its ecosystem of projects
  • Ensure performance, security, and availability of SQL Server databases
  • Troubleshoot database-related application performance issues
  • Educate application developers on writing efficient queries and database schemas
  • Develop and work on large scale open source telemetry systems to monitor SQL Server
  • Have experience in performance tuning, backup/recovery, and capacity planning
  • Write and maintain scripts to automate complex tasks

You need to have:

  • In-depth experience working with SQL Server and knowledge of internal architecture
  • Expert knowledge on Always-On technology
  • Strong Windows systems, clustering and scripting proficiency
  • Familiarity with backup and recovery strategies
  • Familiarity working with Linux
  • BA, BS, MS, PhD in Computer Science, Engineering or related technology field

We'd love to see:

  • Familiarity with other databases (MySQL / PostgreSQL)
  • Familiarity with Kubernetes
  • Proven experience in a programming and/or scripting language (e.g. Python, Go, Java, Ruby)
  • Open source experience is a plus (a well curated blog, upstream accepted contribution or community presence)
  • Experience with hardware benchmarking and performance optimization
Similar jobs