Senior SQL Database Administrator

With ClubReady in Chesterfield MO US

More jobs from ClubReady

Posted on June 11, 2019

About this job

Job type: Full-time
Experience level: Mid-Level, Senior
Role: Database Administrator, System Administrator
Industry: Computer Software, Sports Technology
Company size: 51-200 people
Company type: Private

Technologies

sql, tsql, azure, powerbi, visual-studio, sysadmin

Job description

ClubReady, LLC is a leader in providing club management software and professional services for the health, fitness, and personal training industry. Based in St. Louis, we have a 10-year track record of success with an exponential growth trajectory. With a fast-paced start-up-like environment, we look for internally motivated people who will thrive in a setting that is collaborative, fun, and focused on growing our business.

Position Overview: ClubReady is seeking a Senior Database Administrator that loves working with large transactional database systems powering SaaS platforms. This candidate must be able to work alongside other DBA’s and Senior Software Engineers to coach, implement and review all database related activities. They will work with a variety of software stakeholders to implement known best patterns and practices in database design.

Responsibilities:

  • Design and develop database objects, tables, stored procedures, views, triggers and SSIS packages
  • Implement, review and tune table indexes as needed
  • Performance tuning the stored procedures and T-SQL
  • Assist developers with complex query tuning and schema refinement
  • Analyze, solve, and correct issues on production systems in real time, providing problem resolution end-to-end
  • Ability to read, understand and resolve issues within query plans to improve performance

Requirements:

  • Bachelor’s degree in Computer Science or equivalent
  • In-depth knowledge of standard concepts, practices and procedures related to database management
  • 7+ years of experience in software development, using Microsoft SQL Server, T-SQL, and T-SQL language (queries, views, procedures), SQL Server Database Design, Stored Procedure Design and implementation. Must know SQL inside and out.
  • Experience coding complex stored procedures (using T-SQL)
  • Experience with developing SSIS packages
  • Proven analytical problem solving and debugging skills
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc
  • Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
  • Providing database support for development and deployment of database scripts in Development, Test, and Production environments
  • Monitoring performance and managing parameters to provide fast query responses to front-end users
  • Familiarity with BI technologies (e.g. Microsoft Power BI)
  • Familiarity with Database performance monitoring tools (eg. SQL Sentry, Solarwinds DPA)
  • Excellent English communication skills (written and verbal)

Technical Environment:

  • SQL Server 2017
  • Azure SQL
  • Azure Cosmos DB
  • SSIS
  • SSRS
  • Power BI
  • T-SQL

Tools & Processes:

  • Visual Studio
  • Azure DevOps
  • Azure
  • Git
  • SCRUM
  • CI/CD
  • SQL Sentry
  • SQL Server Management Studio
  • SQL Server Data Tools

Apply here