Database Administrator

Job Overview

A.Y. McDonald Mfg. Co. is a leading manufacturer of water works brass, plumbing valves, pumps and water systems, and natural gas valves and meter bars. The company was founded in 1856 and is committed to taking care of the customer – our boss, through our growing investments of education, automation, and innovation. A career at A.Y. McDonald Mfg. Co. comes with a family friendly culture, on-the-job training, advancement opportunities, and the chance to make a difference every single day.

Summary:

A.Y. McDonald Mfg. Co. is seeking a highly skilled and experienced SQL Server Database Administrator to join our IT team. The SQL Server Database Administrator will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server systems, to ensure the availability and consistent performance of our corporate applications. This is a high-visibility role that requires a deep understanding of both hardware and software, as well as a solid sense of how to maintain high availability and performance of the database systems.

Primary Responsibilities:

• Install, configure, and maintain SQL Server systems across multiple environments to ensure high levels of data availability.
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes.
• Assist developers with complex query tuning and schema refinement.
• Perform scheduled maintenance and support release deployment activities after hours.
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Other duties as assigned.

Qualifications and Skills:

• Bachelor’s degree in computer science, Information Technology, or related field.
• 5+ years of experience as a SQL Server DBA or similar role.
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
• Experience with backups, restores, and recovery models.
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
• Experience working with Windows server, including Active Directory and proper disk configurations.
• Experience with Azure cloud services is a plus.
• Familiarity with SSRS and SSIS.
• Good communication and documentation skills.

Benefits:

Benefits include major medical (BCBS), Delta dental and vision, company sponsored basic life insurance and short-term disability. Voluntary life insurance, accidental death and dismemberment, and long-term disability available. Competitive 401(k) with company matching, generous PTO, 10 paid holidays, and company giveaways, family picnics, and more!

A pre-employment Background Check and 6 panel (no THC) Drug screen required.

A.Y. McDonald Mfg. Co. is an equal opportunity employer

This position is on-site at our Dubuque, Iowa facility