Relational Database Administration Engineer

Location: New York

Requisition No. 48626

The Role:

Bloomberg's Comdb2 DBA Engineering team administers Bloomberg's in-house RDBMS (known as Comdb2) that is being targeted for an open-source release and is looking to expand its staff.

This RDBMS is derived from Berkeley DB with a SQLite based query interface and support for numerous facilities including: transactions, locking, concurrency, clustering and replication along with a client library (API) able to transparently negotiate reconnection and connections to lowest-cost (and coherent) nodes (in a cluster configuration).

Specifically, the team is responsible for tasks such as development of best practices and repeatable procedures for deploying and managing databases, as well as day-to-day operational activities including break/fix, resource balancing, backup and recovery, database tuning, database replication management and coordination of schema changes. The team also works closely with the RDBMS developers and is expected to retain and foster deep understanding of this RDBMS's internals in order to respond quickly and effectively to matters ranging from design input to urgent trouble shooting. The team is also tasked with building and maintaining tools for the management of the environment.

Qualifications:

Bloomberg's DBA team is looking to add to their current talent a self-motivated and highly curious Database Administrator / Engineer with experience in SQL, IT administration, performance tuning, Database Internals, and Perl/shell programming (scripting).

The ideal Candidate will have:

  • Experience working with at least one of the commercially available relational database technologies for a minimum of 4 years
  • Knowledge of SQL and SQL performance tuning
  • Solid understanding of relational database internal architecture
  • Experience in performance tuning of databases
  • Experience with Unix and Unix tools including shell & Perl scripting
  • Experience in designing and automating repeatable processes
  • Solid verbal and written communication skills
  • Knowledge of Berkeley DB is desirable
  • Knowledge of C programming a plus
  • Experience analyzing existing RDBMS/IT/Operational systems and identifying shortcomings with concrete ideas for improvement.

Shift:

Mon-Fri, Day Shift

Weekly on call rotation approximately once every 2 months.

The Company:

Bloomberg, the global business and financial information and news leader, gives influential decision makers a critical edge by connecting them to a dynamic network of information, people and ideas. The company's strength - delivering data, news and analytics through innovative technology, quickly and accurately - is at the core of the Bloomberg Professional service, which provides real time financial information to more than 310,000 subscribers globally. Bloomberg's enterprise solutions build on the company's core strength, leveraging technology to allow customers to access, integrate, distribute and manage data and information across organizations more efficiently and effectively. Through Bloomberg Law, Bloomberg Government, Bloomberg New Energy Finance and Bloomberg BNA, the company provides data, news and analytics to decision makers in industries beyond finance. And Bloomberg News, delivered through the Bloomberg Professional service, television, radio, mobile, the Internet and two magazines, Bloomberg Businessweek and Bloomberg Markets, covers the world with more than 2,300 news and multimedia professionals at 146 bureaus in 72 countries. Headquartered in New York, Bloomberg employs more than 15,000 people in 192 locations around the world.