SQL DBA
dunnhumby - Cincinnati, OH

This job posting is no longer available on dunnhumby. Find similar jobs: SQL Database Administrator jobs - dunnhumby jobs

dunnhumby is the premier loyalty marketing agency in the world.

We put genius into making sure our clients and our people get to know and treat their essential customers better than anyone else.

We work with leading retailers, such as Tesco, Kroger, Macy’s, Casino, along with their suppliers, Procter & Gamble, Unilever, Kraft, Sony, Estee Lauder, to put the customer at the heart of their decisions.

Core Delivery is the shared services organisation of dunnhumby which serves and supports 7 dunnhumby businesses (markets) and over 20 retail installations globally.

We create and operate standard and flexible technology platforms which support a suite of products delivering business solutions for our retail and manufacturer clients.

Core Delivery serves the markets who in turn serve our clients.

Core Delivery must deliver value to the markets.

Value is defined as our markets benefiting from a shared services function versus having to manage and create such capability on its own.

As a result, each market should benefit from lower costs, collective thought and greater innovation.

Our Technology Services Centre (TSC), which is part of Core Delivery, is responsible for the selection, implementation and ongoing management of all technology assets globally.

We operate multiple data centres and manage some of the largest databases in the world.

Within TSC we research and implement the latest technologies that will provide our employees and clients improved service and value.

The Senior Database Administrator will join Technology Services Centre (TSC), which is part of Core Delivery, and will be responsible for the implementation, upkeep, monitoring, and tuning of our world class database platforms.

We operate globally in multiple data centres and manage some of the largest databases in the world.

Key Responsibilities

·

Implementation and administration of MS SQL Server databases

·

Provide backup support of Oracle databases on Exadata X3-8 appliances and RAC environments

·

24x7 support for databases to ensure the highest standards of availability, reliability, and performance

·

Work collaboratively or independently

to resolve complex MS SQL Server issues

and ensure project milestones and SLA targets are met

Coordinates and performs SQL Server database installation, patching, and upgrades

·

Develops/Documents procedures and scripts

to automate repetitive or complex tasks

·

Design, develop, and maintain documentation for database environments, standards, and processes

·

Use judgment, creativity and expert technical knowledge to obtain and recommend database solutions

·

Meticulous attention to detail with an appreciation for the relationship between database/system reliability and company success

Mentors junior team members

Supports maintenance outages throughout the year

Monitors, reports, and tunes for performance for multiple environments including development, test, and production environments

·

On-call responsibilities on a rotating basis

Knowledge & Qualifications

Essential

·

Bachelor’s degree, preferably with a technical major such as computer engineering, information technology or computer science

·

Knowledge of ITIL Service Management Framework

·

Knowledge of multiple SQL Server Versions (i.e. 2000, 2005, 2008, 2008 R2, 2012)

·

In-depth experience with SQL Server Clustering in windows 2003 and 2008.

·

Knowledge of Database Replication, Mirroring and Log Shipping

·

Worked in OLTP & OLAP environment that includes Production (24x7), QA and development databases in MS SQL Server.

·

Experience in TSQL and Windows (2003/2008) and SQL Database performance and tuning

including SSIS packages and SSAS cubes

·

Experience with VLDB

·

Experience in the application of disaster recovery principles, practices and techniques, especially on MS SQL Server environments

·

Knowledge of multiple SQL Server Versions (i.e. 2000, 2005, 2008, 2008 R2, 2012)

Desirable

·

Experience with SQL Server Analysis Services, Reporting Services, and Integration Services.

·

Experience using HP Data Protector

·

Knowledge of Business Intelligence and Data Warehousing design principles and industry best practices

·

Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables and Operational Data Store (ODS).

·

Knowledge of MicroStrategy Business Intelligence Reporting and cube building.

·

Good working knowledge of job scheduling and monitoring tools

·

Experience in performing database migrations

·

Experience implementing/configuring Oracle RAC environments on ASM

·

Experience with SQL development, including stored procedures, queries and indexing

·

Experience upgrading SQL Server environments

Work Experience

Essential

·

10+ years of experience in Information Technology

·

7+ years of DBA experience

·

5+ years MS SQL Server DBA experience

·

3+ years Oracle 10g (or higher) DBA experience

·

2+ years of experience with Red Hat or Unbreakable Oracle Linux OS

Desirable

·

Certification on MS SQL Server (MCTS, MCITP, MCM)

·

OCP Certification at 10g or above

Behavioural Competencies

Essential

·

Strong interpersonal and communication skills

·

Adaptable and flexible

·

High energy and self-motivation

·

Ability to work on multiple projects / tasks and prioritize work in a fast-paced environment

·

Willingness to learn the business and new technology

·

Team-oriented work ethic that includes willingness to help others

·

Ability to mentor developers and database administrators

·

Excellent written communication and documentation

Required Skills

dunnhumby - 18 months ago - save job - block
Recommended Jobs
BI ETL Developer
Rainmaker Resources, LLC - Cincinnati, OH
Rainmaker Resources, LLC - 28 days ago

PostgreSQL DBA
Resolvit, LLC - Cincinnati, OH
Resolvit, LLC - 1 day ago

SQL DBA
SmartSource - Cincinnati, OH
CareerBuilder - 12 days ago
About this company
5 reviews
dunnhumby is the world’s leading customer science company. We analyse data and apply new insights from more than 400 million customers...