SQL Server Database Administrator - Consultant
New York, NY
Posted Aug 10, 2016 - Requisition No. 53252
Do you love working with SQL Server technology? Are you the SQL expert on your team? Bloomberg's Database Administrator team builds and maintains large-scale, highly transactional databases across multiple platforms. The scale of our deployments in terms of database size and number of servers is unmatched in the industry. You are a self-motivated, highly experienced SQL Server Database Administrator interested in working on exciting technical challenges. As a senior SQL consultant on our team, you will be the go-to for SQL Technology, including performance tuning of SQL Server databases and stored procedures.
We'll trust you to:
- Handle performance tuning, break/fix, space management, backup and recovery, database HA/DR setup and management
- Manage highly transactional databases servicing OLTP and DSS applications
- Act as a project manager and develop best practices and repeatable procedures for deploying databases
- Design and implement database replication strategies, including database mirroring/AlwaysOn, peer-to-peer and transactional replication
You need to have:
- 7+ years of experience working with SQL Server technology, including an understanding of internal architecture, performance tuning of SQL Server databases and stored procedures
- Hands-on experience with Window Clustering and SQL Server Clustering implementation including AlwaysOn
- Experience with data warehousing, database system and database software management (patch and version)
- Familiarity with backup and recovery strategies
- A MCITP Database Administrator certification for SQL Server 2008-2014
- Knowledge of any database programming language (C#) and scripting (Powershell/Python)