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 Inc. is responsible for managing the Microsoft SQL Server environment that supports various critical business applications. This hybrid role requires three days of onsite work in Ann Arbor, MI, and involves ensuring the performance, availability, and security of database systems. The administrator will analyze business requirements, implement database technologies, and provide ongoing support and maintenance for database operations.

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 high levels of performance, availability, 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 throughput.
• Responsible for day-to-day database support and maintenance activities.
• Setup and design backup and recovery solutions according to disaster recovery scenarios.

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.