Overview

This role will encompass activities for client hosted databases and our internal data warehouse and reporting systems in a big data environment.  A large focus on data quality, performance monitoring and tuning to ensure accurate and timely movement of data between database systems.  An understanding of the underlying data from a Business perspective will also be required.

Essential Duties and Responsibilities

The Application DBA role will cover the following activities

  • Responsible for DBA activities in support of MSSQL 2008 R2 -> 2016 including installation, backup and recovery, replication, log shipping, SQL Agent, monitoring and other maintenance activities
  • Proficient in database performance analysis and tuning. 
  • Develop, tune and support complex SQL queries/ stored procedures
  • Provide support for software developers by providing guidance on the development of SQL queries, and tuning them where needed
  • Be responsible for data loading and data quality
  • Understand the architecture and business logic of multiple database and data warehouse systems
  • Rotational Support

Qualifications and Experience

  • 8+ years of hands-on DBA experience;
  • Advanced knowledge of SQL Server 2008R2->2016 including statistics, indexes, partitioning, storage, memory, lock management
  • 5+ years of creating and tuning complex SQL
  • Windows Server 2008 R2/2012
  • Experience with VMWare and Networking technologies
  • Experience with cloud computing such as AWS and Snowflake
  • Scripting skills (PowerShell, Windows Batch, Other)
  • Working knowledge of ITIL or similar framework preferred
  • Bitbucket/Stash or equivalent source code control
  • Knowledge of Evault/Litespeed, Jira, Sharepoint, Sumo Logic is desirable
  • Knowledge of SQL Sentry and/or other monitoring tools

Education

Bachelor’s degree in Computer Science or related field is preferred

Communication and Cognitive Abilities

  • Excellent written and verbal communication skills with the ability to present complex technical information in a clear and concise manner to a variety of audiences
  • Dedication to meeting and exceeding customer expectations
  • Proactive problem solving capabilities

 

Read Full DescriptionHide Full Description
Confirmed an hour ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles