What We Do

We are building the predictive analytics platform to make the world more productive, reliable, safe and secure. We take data from an expanding range of industries and combine our strengths in data science and software development to deliver solutions with actionable insights to companies worldwide. This creates quantifiable efficiencies for businesses, and dynamic challenges for us.

What You'll Do:

As an operations database administrator, you’ll own our production MS SQL databases. You will be responsible for configuration, uptime, capacity planning, account creation and maintenance, backups/restores, high availability planning and testing. You will work with the DevOps team for creation of new automation and builds and you’ll work with the data operations team for data quality and availability. You will also work with the Site Operations team to establish and enhance monitoring of all MS SQL production systems. You’ll be focusing on reliability, performance, capacity, and the tuning of MS SQL at Uptake.

Responsibilities

• Own the configuration and maintenance of all MS SQL datastores in production, staging and QA environments.
• Proactively monitor events, investigate issues, analyze solutions, and drive problems through to resolution using a wide variety of Ops tools and monitoring platforms to gain knowledge, understanding, and enable persistent monitoring of database availability, performance, and capacity
• Establish and maintain accounts and access controls to all production MS SQL databases.
• Perform data grooming and put retention policies into action.
• Maintain our database monitoring systems and develop new metrics/monitoring dashboards as additional coverage events become necessary.
• Be on call for potential downtime problem solving and root cause diagnosis.
• Provide developer support for data model and query pattern best practices.

Qualifications

• Required
• Excellent understanding of MS SQL in a production environment
• Experience with Postgres is preferred
• Knowledge of and experience with database tuning, access controls (Authentication, Authorization, Audit Logging), monitoring.
• Knowledge of and experience with Idera and Redgate tools
• Knowledge of MS SQL replication for multi-DC, high availability and global synchronization.
• Ability to work collaboratively in a fast-paced, entrepreneurial environment

• Preferred
• Experience working with Agile methodologies (preferred)
• Excited by Big Data technologies and interested in integrating statistics and analytics to make our systems perform even better.
• Knowledge of AWS technologies - EC2, S3
• Experience with a distributed log tool such as Graylog or Splunk
• Experience with automation tools: TeamCity, Octopus Deploy, Puppet, Chef, Docker, Jenkins

Why Work Here

We build and deliver, then explore to build more. Curiosity and flexibility enable everything we do, and we get stronger as we make each new industry smarter. As a team, we bring our diverse backgrounds, beliefs and experiences to solve problems no one has yet to solve, at a speed no one has yet to experience. We support and challenge one another to bring out a new best in each of us, and we might have a little fun along the way.