Database Administrator
5+ years
United States
Full-time
Remote
1 month ago
About the role
About The Company
MI Windows and Doors, operating under the umbrella of MITER Brands, is a leading manufacturer dedicated to shaping the future of residential living through innovative window and door solutions. As part of one of the nation's largest suppliers of vinyl windows and patio doors, the company boasts state-of-the-art manufacturing facilities and a commitment to quality, craftsmanship, and customer satisfaction. With trusted brands like Milgard, MI Windows & Doors, and PGT, MI Windows and Doors has established a strong reputation for delivering durable, energy-efficient, and aesthetically appealing products that enhance homes across the country. The company's culture emphasizes innovation, teamwork, and continuous improvement, making it an ideal environment for professionals seeking growth and impact in the building materials industry.
About The Role
We are seeking a skilled and dedicated Database Administrator to join our team in Tacoma, Washington. This pivotal role is responsible for maintaining the stability, security, and performance of our core database systems, including MSSQL and MySQL, which support critical organizational operations. The ideal candidate will possess a strong background in database management, with a particular focus on Azure cloud services, especially Azure Synapse Analytics and data integration solutions. You will work closely with infrastructure and analytics teams to design, implement, and optimize database environments, ensuring seamless data flow and accessibility. The role demands excellent problem-solving skills, proactive monitoring, and the ability to troubleshoot complex issues efficiently. This position offers an exciting opportunity to contribute to innovative data solutions that drive business decisions and operational excellence.
Qualifications
The ideal candidate will have at least 3-7 years of relevant experience in database administration, including hands-on troubleshooting of SQL Server environments. Experience with on-call support for production SQL Servers is essential, demonstrating the ability to respond promptly to system issues. Proficiency in analyzing DMV queries and utilizing tools such as Extended Events, SQL Profiler, and Data Collection is required. Strong T-SQL query tuning skills and expertise in database schema design, normalization, and indexing strategies are necessary to optimize performance. Knowledge of backup and disaster recovery planning, along with familiarity with data warehousing concepts and ETL processes, is highly valued. Candidates should possess a solid understanding of data modeling tools and methodologies. Certifications such as Microsoft Certified: Azure Database Administrator Associate or Certified MySQL Database Administrator are advantageous but not mandatory.
Responsibilities
Azure Analytics and Infrastructure Engineering:
Database Administration
Benefits
Our comprehensive benefits package is designed to support your health, wellness, and financial security. We offer three medical plan options, including prescription, dental, and vision coverage, to meet diverse needs. Company-paid life insurance and voluntary supplemental coverage options are available to provide additional peace of mind. Our benefits also include short-term and long-term disability insurance, paid time off (PTO), and holidays to promote work-life balance. We provide a 401(k) retirement plan with a company match to help secure your financial future. Additional perks include an Employee Assistance Program, Teladoc services, legal insurance, identity theft protection, pet insurance, tuition reimbursement, wellness clinics, and a team member discount program. We are committed to fostering a supportive environment that values your growth and well-being.
Equal Opportunity
MI Windows and Doors is an equal-opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on religion, race, creed, color, national origin, sex, age, disability, veteran status, sexual orientation, genetic information, or any other legally protected category. Our hiring practices are designed to ensure fairness and equal access to opportunities for all qualified candidates.
MI Windows and Doors, operating under the umbrella of MITER Brands, is a leading manufacturer dedicated to shaping the future of residential living through innovative window and door solutions. As part of one of the nation's largest suppliers of vinyl windows and patio doors, the company boasts state-of-the-art manufacturing facilities and a commitment to quality, craftsmanship, and customer satisfaction. With trusted brands like Milgard, MI Windows & Doors, and PGT, MI Windows and Doors has established a strong reputation for delivering durable, energy-efficient, and aesthetically appealing products that enhance homes across the country. The company's culture emphasizes innovation, teamwork, and continuous improvement, making it an ideal environment for professionals seeking growth and impact in the building materials industry.
About The Role
We are seeking a skilled and dedicated Database Administrator to join our team in Tacoma, Washington. This pivotal role is responsible for maintaining the stability, security, and performance of our core database systems, including MSSQL and MySQL, which support critical organizational operations. The ideal candidate will possess a strong background in database management, with a particular focus on Azure cloud services, especially Azure Synapse Analytics and data integration solutions. You will work closely with infrastructure and analytics teams to design, implement, and optimize database environments, ensuring seamless data flow and accessibility. The role demands excellent problem-solving skills, proactive monitoring, and the ability to troubleshoot complex issues efficiently. This position offers an exciting opportunity to contribute to innovative data solutions that drive business decisions and operational excellence.
Qualifications
The ideal candidate will have at least 3-7 years of relevant experience in database administration, including hands-on troubleshooting of SQL Server environments. Experience with on-call support for production SQL Servers is essential, demonstrating the ability to respond promptly to system issues. Proficiency in analyzing DMV queries and utilizing tools such as Extended Events, SQL Profiler, and Data Collection is required. Strong T-SQL query tuning skills and expertise in database schema design, normalization, and indexing strategies are necessary to optimize performance. Knowledge of backup and disaster recovery planning, along with familiarity with data warehousing concepts and ETL processes, is highly valued. Candidates should possess a solid understanding of data modeling tools and methodologies. Certifications such as Microsoft Certified: Azure Database Administrator Associate or Certified MySQL Database Administrator are advantageous but not mandatory.
Responsibilities
Azure Analytics and Infrastructure Engineering:
- Promote changes in Azure DevOps to production Synapse environments, ensuring smooth deployment and minimal disruption.
- Manage Synapse pipelines, collaborating with infrastructure teams to deliver robust data solutions aligned with organizational needs.
- Design, build, and maintain Azure infrastructure components to support scalable and secure data operations.
- Troubleshoot data-related issues within the Enterprise BI platform, including Azure Synapse and Power BI, to ensure data integrity and availability.
Database Administration
- Implement and monitor backup strategies to meet Recovery Point Objectives (RPO) and test restores to ensure Recovery Time Objectives (RTO) are achievable.
- Troubleshoot SQL Server service outages, including after-hours and weekends, to minimize downtime.
- Configure monitoring tools to proactively identify and resolve performance issues, false alarms, or system anomalies.
- Install, configure, and upgrade SQL Server environments, deploying approved change scripts from vendors or internal teams.
- Diagnose and optimize server, index, and query performance to maintain efficient database operations.
- Document the database environment comprehensively, including architecture, configurations, and procedures.
- Manage capacity planning, storage, and growth strategies to accommodate organizational data needs.
- Proactively address locking, blocking, and concurrency issues to ensure smooth database performance.
- Maintain database security standards, implementing access controls and monitoring for compliance.
Benefits
Our comprehensive benefits package is designed to support your health, wellness, and financial security. We offer three medical plan options, including prescription, dental, and vision coverage, to meet diverse needs. Company-paid life insurance and voluntary supplemental coverage options are available to provide additional peace of mind. Our benefits also include short-term and long-term disability insurance, paid time off (PTO), and holidays to promote work-life balance. We provide a 401(k) retirement plan with a company match to help secure your financial future. Additional perks include an Employee Assistance Program, Teladoc services, legal insurance, identity theft protection, pet insurance, tuition reimbursement, wellness clinics, and a team member discount program. We are committed to fostering a supportive environment that values your growth and well-being.
Equal Opportunity
MI Windows and Doors is an equal-opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based on religion, race, creed, color, national origin, sex, age, disability, veteran status, sexual orientation, genetic information, or any other legally protected category. Our hiring practices are designed to ensure fairness and equal access to opportunities for all qualified candidates.
Skills
Information Technology