SQL Server Database Engineer

Careers at Bloomberg

New York, NY

Posted Sep 27, 2017 - Requisition No. 62323

Our team:

The Bloomberg Database Engineering team maintains large-scale, high transactional databases with focus on high availability and performance. Our 25k plus database instances run 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 serves 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
  • 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
  • Be an expert in performance tuning, backup/recovery, and capacity planning
  • Participate in an on-call rotation
  • Write and maintain scripts to automate complex tasks.

You need to have:

  • 5+ years of experience working with SQL Server
  • Good scripting skills and working knowledge of Powershell
  • A deep understanding of SQL Server internal architecture
  • Expert knowledge in SQL Server tunables
  • Expert knowledge on Always-On Availability Groups and Listener
  • Strong Windows systems, clustering and scripting proficiency
  • Familiarity with backup and recovery strategies

We'd love to see:

  • Familiarity with other databases (MySQL / PostgreSQL)
  • Working knowledge of Python
  • Experience with hardware benchmarking and performance optimization
Similar jobs