SQL Database Administrator (REF34567P)

Domino's Pizza - Ann Arbor, MI

Full-time

Ann Arbor, MI

Food Services and Drinking Places

About the position

The SQL Database Administrator at Domino's Pizza is responsible for managing the Microsoft SQL Server environment that supports various critical business applications and enterprise data warehousing. This role involves ensuring high performance, availability, and security of database systems, as well as providing support for client applications and resolving issues. The position requires a hybrid work model, with three days of onsite work in Ann Arbor, Michigan.

Responsibilities

• Manage Microsoft SQL Server environment supporting transactional systems and enterprise data warehouse.
• Review and analyze business requirements and define system specifications.
• Install, configure, administer, and maintain database servers and processes.
• Monitor system health and performance to ensure optimal performance and security.
• Apply data modeling techniques to meet integration and performance expectations.
• Independently analyze, solve, and correct issues in real time.
• Refine and automate regular operational processes, track issues, and document changes.
• Assist developers with complex query tuning and schema refinement.
• Perform scheduled maintenance and support release deployment activities.
• Implement new database technologies to improve performance and reliability.
• Responsible for day-to-day database support and maintenance activities, including backups and restores.
• Setup and design backup and recovery solutions according to disaster recovery scenarios.
• Provide support for client applications and resolve client issues.

Requirements

• Bachelor's degree or equivalent in Computer Science, Information Systems, or related field and 3 years of database administration experience with SQL Server.
• Master's degree or equivalent in Computer Science, Information Systems, or related field and 2 years of database administration experience with SQL Server in lieu of a Bachelor's degree.
• 2 years of hands-on production operations management experience with SQL Server 2016/2017.
• 2 years of operations and management experience with data warehouse or online transactional environments.
• 1 year of deployment and production operations experience with NoSQL and NewSQL platforms.
• Database platform production operations experience with SQL Server 2012 - 2017.
• Experience working on SQL Server AlwaysOn Availability Groups (AAG) and Distributed AAG (DAAG).
• Experience managing operations of large databases (5-8TB).
• Experience with batch and PowerShell scripting.
• Production operations management experience with managing Greenplum environment.