Database Administrator

Transact-SQL, Microsoft SSIS, Microsoft Windows Server 2012, Windows PowerShell, Microsoft SharePoint, OLAP
Full Time
Not Specified
Telecommuting not available Travel not required

Job Description

Firm Overview

Cambridge Associates was founded 40 years ago to assist nonprofit institutions with the investment of their endowment assets. Today, we are a Global organization that provides investment planning, research and management to over 990 clients including nonprofit institutions, private clients (families) sovereign wealth funds and pension plans. The firm advises on the full range of assets and strategies, including equities, bonds, real estate, venture capital, hedge funds, leveraged buyout funds, oil and gas partnerships, and many other types of investments. We monitor the performance of nearly all major institutional investment managers and conduct in depth research on those we believe have potential to add value to our clients after fees. Our clients were amongst the earliest to invest in alternative strategies such as hedge funds and private equity so we have unparalleled depth of knowledge in these areas as well as substantial committed research resources and data.

Cambridge Associates has a staff of more than 1,100 professionals, including 200 Investment Directors and 150 Investment Associates, based in nine offices located in Arlington, Beijing, Boston, Dallas, London, Menlo Park, San Francisco, Singapore and Sydney. Ours is a long term business with long term client relationships. Accordingly, we take great care in selecting employees with both the aptitude and the willingness to build a long term career in a collegial, hard-working and intellectually challenging team.

Position Overview:

The technology team supports C|A s investment consulting practice through engineering proprietary systems that uniquely position the company within the industry. Our systems form the backbone of interactions with tens of thousands of investment funds and with our clients. The firm offers a dynamic environment, competitive compensation plan and industry leading benefits.

As a Database Administrator, you will be responsible for managing a Microsoft SQL Server database environment, administration of procedures and practices regarding data access, and supporting development. This includes working with project teams to determine changes needed to the databases, and then implementing or assisting with implementation of those changes. You will be working with systems administrators, development teams and applications support staff across the organization. Performance of duties will sometimes require work outside of regular business hours.

We are looking for someone who has a strong initiative, is eager to learn and to teach, and is able to work both independently and as a team member.

Candidates must have the ability to communicate effectively with all levels of staff; and must be able to interact in a service-oriented environment.

Job Responsibilities:

Engage system/storage admins and development teams productively

Develop automation within the environment for SQL server deployment and updates, maintenance, custom software deployments, etc.

Assist with development of standards and policies around data /access security (end-user access vs dev access)

Maintain and monitor database environments for 24/7 availability. Performance of duties will sometimes require work outside of regular business hours. May be expected to act as first contact in a rotating, on-call schedule for database support.

Develop alerts, reports and automated processes for failed jobs.

Collect and analyze database and system performance measurements over time.

Optimize procedures, indexes and table schemas according to trending data.

Enforce security measures and policies by minimizing scope of exposure to logins, applying security patches and performing necessary security audits.

Review design and deployment of any data objects from development environment to production.

Troubleshoot database and hardware-related problems.

Monitor SQL Server activity, performance, error logs, event logs, space usage and security on a daily basis.

Manage and execute daily operational jobs including backups, index/statistics updates

Monitor and maintain transactional replication and Always on configurations.

Preferred Qualifications:

Bachelor s Degree a degree in a computer science, engineering, mathematics, or science preferred

5+ years related professional experience

Relevant technical certifications

Advanced knowledge of T-SQL development, SSIS, SQL internals

Experience supporting an environment with significant product and software development

Ability to proactively identify, troubleshoot and resolve live database systems issues.

Knowledge of HA and disaster recovery principles and practices, including planning, testing, backup/restore

Knowledge of Windows Server architecture and patching

Understanding and experience with transactional replication, clustering and other HA solutions

Experience installing/upgrading/patching/configuring SQL 2008/2012/2014

Knowledge of PowerShell

Knowledge and/or experience with 3rd party backup and performance monitoring tools a plus

Knowledge of SSRS and SharePoint integration a plus

Experience with SAN/Storage technologies, virtual environments and OLAP/SSAS data warehouse solutions a plus

Exposure to new database technologies such as NoSQL, in-memory databases, graph databases and/or data grids a plus

Knowledge of source control and release management systems a plus

Candidates must be eligible to work in the US without sponsorship

Key Competencies:

Critical thinking and problem solving skills

Decision-making

Team work

Stress tolerance

Ability to raise difficult issues in a constructive way

Posted By

Missy Druley

125 High Street, Oliver Street Tower 11th Fl Boston, MA, 02110

Dice Id : RTL298151
Position Id : 4959117
Have a Job? Post it

Similar Positions

Database Administrator Needed Immediately
  • Robert Half Technology
  • Alexandria, VA
SQL Database Administrator
  • ALTEK Information Technology, Inc
  • Reston, VA
Database Administrator
  • Bowhead/ UICGS
  • Fort Meade, MD
Senior SQL Database Administrator
  • Smart Synergies
  • Washington, DC
Database Administrator (Job ID: 1089)
  • Insignia Technology Services
  • Washington, DC
Database Administrator II
  • Technology Consulting Inc.
  • Herndon, VA
Database Administrator III
  • Serco, Inc.
  • Reston, VA
Senior SQL Database Administrator
  • Business Object Solutions Inc
  • Washington, DC
Database Administrator
  • Enviva
  • Bethesda, MD
SQL Server DBA
  • Definitive Logic
  • Arlington, VA
SQL Server or Sybase DBA
  • s.com
  • Herndon, VA
Senior SQL Database Administrator (DBA)
  • CoStar Realty Information, Inc
  • Washington, DC
Sr. Database Administrator (Reston, VA)
  • Altruista Health
  • Reston, VA