Milgard Manufacturing LLC
Senior MSSQL Database Administrator (West)
Milgard Manufacturing LLC, Tacoma, Washington, us, 98417
Pay Range:
$102K – $127K annual salary range, depending on experience
This is an onsite position, located in Tacoma, WA.
We are currently looking for a Senior MSSQL Database Administrator in Tacoma, WA. In this role you will be responsible for ensuring the stability, integrity, and efficient operation of the MSSQL, MySQL, or any related database as required that support core organizational functions. This includes designing, installing, configuring, administering, and fine-tuning database components across the organization in a timely and efficient manner. There is a considerable focus and emphasis for this role in the support of Microsoft Azure with a focus on Azure Synapse and data analytics.
Responsibilities
Azure (60%)
Azure Analytics and Infrastructure Engineering
Promote changes in Azure DevOps to production Synapse environment
Manage Synapse pipelines and coordinate with other infrastructure team members to deliver data
Manage, build and design Azure infrastructure to support business demand
Troubleshoot data issues related to Enterprise BI platform in Azure Synapse and Power BI
Non-Azure (40%)
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
Install and configure new SQL Servers
Deploy database change scripts provided by third party vendors or internal Development and Business Analysts post approvals
When performance issues arise, determine the most effective way to increase performance including server configuration changes, or index/query changes
Document the company’s database environment
Manage/plan database capacity and storage, disk space and monitor database growth
Monitor and pro-actively identify locks/blocking and resolve concurrent issues
Monitor database server health and create alerts to capture poor server performance issues
Manage database security as defined and dictated by the company
To do a great job in this position, experience should include:
On-call troubleshooting experience with at least one production SQL Server for a year.
Finding DMV queries to answer questions about server-level performance
Using tools like (Extended Events, DTA) and (SQL Profiler, DMV, Data Collection) to diagnose server reliability and performance issues
The following skills aren’t strictly necessary, but will make you a well-rounded candidate for bonus points:
Tuning T-SQL queries to improve performance
Requirements
Technical Skills
Database Management Systems (DBMS):
Proficiency in various DBMS such as SQL Server, Oracle, MySQL, PostgreSQL, and NoSQL databases like MongoDB and Cassandra.
SQL and PL/SQL:
Advanced knowledge of SQL for querying and managing databases.
Proficiency in PL/SQL or T-SQL for writing stored procedures, triggers, and functions.
Database Design and Architecture:
Expertise in designing database schemas, normalization, and indexing strategies.
Experience with data modeling tools and techniques.
Performance Tuning and Optimization:
Skills in identifying and resolving performance bottlenecks.
Experience with query optimization, indexing, and database tuning.
Backup and Recovery:
Knowledge of backup strategies and tools.
Proficiency in disaster recovery planning and implementation.
Security and Compliance:
Understanding of database security best practices.
Experience with data encryption, access controls, and regulatory compliance (e.g., GDPR, HIPAA).
Scripting and Automation:
Proficiency in scripting languages like Python, PowerShell, or Bash for automating database tasks.
Experience with automation tools and frameworks.
High Availability and Clustering:
Knowledge of high availability solutions such as clustering, replication, and database mirroring.
Experience with failover and load balancing techniques.
Data Warehousing and ETL:
Understanding of data warehousing concepts and design.
Experience with ETL (Extract, Transform, Load) processes and tools.
Monitoring and Maintenance:
Proficiency in using monitoring tools to ensure database health and performance.
Skills in routine maintenance tasks like reindexing, statistics updates, and log management.
Soft Skills
Problem-Solving:
Strong analytical skills to diagnose and resolve complex database issues.
Communication:
Ability to communicate effectively with technical and non-technical stakeholders.
Skills in writing clear and concise documentation.
Project Management:
Experience in managing database projects, including upgrades, migrations, and implementations.
Team Collaboration:
Ability to work collaboratively with other IT teams, developers, and business units.
Experience in mentoring and training junior DBAs.
Attention to Detail:
High level of accuracy and attention to detail in managing database configurations and changes.
Adaptability:
Ability to adapt to new technologies and methodologies.
Willingness to continuously learn and improve skills.
Additional Skills
Cloud Databases:
Experience with cloud-based database solutions such as AWS RDS, Azure SQL Database, and Google Cloud SQL.
Big Data Technologies:
Understanding of big data frameworks like Hadoop, Spark, and their integration with traditional databases.
DevOps Practices:
Familiarity with DevOps tools and practices for continuous integration and continuous deployment (CI/CD) pipelines.
The MITER Brands benefits package includes coverage of health, wealth, and wellness for you and your eligible spouse/dependents. We offer a competitive salary and benefits package, including a 401k with company match and generous paid time off to help you balance your life.
MITER Brands, also known as MI Windows and Doors, Milgard and PGT are an equal-opportunity employer. The company does not discriminate based on religion, race, creed, color, national origin, sex, age, disability, handicap, veteran status, sexual orientation, genetic information, or any other applicable legally protected category.
#J-18808-Ljbffr
$102K – $127K annual salary range, depending on experience
This is an onsite position, located in Tacoma, WA.
We are currently looking for a Senior MSSQL Database Administrator in Tacoma, WA. In this role you will be responsible for ensuring the stability, integrity, and efficient operation of the MSSQL, MySQL, or any related database as required that support core organizational functions. This includes designing, installing, configuring, administering, and fine-tuning database components across the organization in a timely and efficient manner. There is a considerable focus and emphasis for this role in the support of Microsoft Azure with a focus on Azure Synapse and data analytics.
Responsibilities
Azure (60%)
Azure Analytics and Infrastructure Engineering
Promote changes in Azure DevOps to production Synapse environment
Manage Synapse pipelines and coordinate with other infrastructure team members to deliver data
Manage, build and design Azure infrastructure to support business demand
Troubleshoot data issues related to Enterprise BI platform in Azure Synapse and Power BI
Non-Azure (40%)
Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
Configure SQL Server monitoring utilities to minimize false alarms
Install and configure new SQL Servers
Deploy database change scripts provided by third party vendors or internal Development and Business Analysts post approvals
When performance issues arise, determine the most effective way to increase performance including server configuration changes, or index/query changes
Document the company’s database environment
Manage/plan database capacity and storage, disk space and monitor database growth
Monitor and pro-actively identify locks/blocking and resolve concurrent issues
Monitor database server health and create alerts to capture poor server performance issues
Manage database security as defined and dictated by the company
To do a great job in this position, experience should include:
On-call troubleshooting experience with at least one production SQL Server for a year.
Finding DMV queries to answer questions about server-level performance
Using tools like (Extended Events, DTA) and (SQL Profiler, DMV, Data Collection) to diagnose server reliability and performance issues
The following skills aren’t strictly necessary, but will make you a well-rounded candidate for bonus points:
Tuning T-SQL queries to improve performance
Requirements
Technical Skills
Database Management Systems (DBMS):
Proficiency in various DBMS such as SQL Server, Oracle, MySQL, PostgreSQL, and NoSQL databases like MongoDB and Cassandra.
SQL and PL/SQL:
Advanced knowledge of SQL for querying and managing databases.
Proficiency in PL/SQL or T-SQL for writing stored procedures, triggers, and functions.
Database Design and Architecture:
Expertise in designing database schemas, normalization, and indexing strategies.
Experience with data modeling tools and techniques.
Performance Tuning and Optimization:
Skills in identifying and resolving performance bottlenecks.
Experience with query optimization, indexing, and database tuning.
Backup and Recovery:
Knowledge of backup strategies and tools.
Proficiency in disaster recovery planning and implementation.
Security and Compliance:
Understanding of database security best practices.
Experience with data encryption, access controls, and regulatory compliance (e.g., GDPR, HIPAA).
Scripting and Automation:
Proficiency in scripting languages like Python, PowerShell, or Bash for automating database tasks.
Experience with automation tools and frameworks.
High Availability and Clustering:
Knowledge of high availability solutions such as clustering, replication, and database mirroring.
Experience with failover and load balancing techniques.
Data Warehousing and ETL:
Understanding of data warehousing concepts and design.
Experience with ETL (Extract, Transform, Load) processes and tools.
Monitoring and Maintenance:
Proficiency in using monitoring tools to ensure database health and performance.
Skills in routine maintenance tasks like reindexing, statistics updates, and log management.
Soft Skills
Problem-Solving:
Strong analytical skills to diagnose and resolve complex database issues.
Communication:
Ability to communicate effectively with technical and non-technical stakeholders.
Skills in writing clear and concise documentation.
Project Management:
Experience in managing database projects, including upgrades, migrations, and implementations.
Team Collaboration:
Ability to work collaboratively with other IT teams, developers, and business units.
Experience in mentoring and training junior DBAs.
Attention to Detail:
High level of accuracy and attention to detail in managing database configurations and changes.
Adaptability:
Ability to adapt to new technologies and methodologies.
Willingness to continuously learn and improve skills.
Additional Skills
Cloud Databases:
Experience with cloud-based database solutions such as AWS RDS, Azure SQL Database, and Google Cloud SQL.
Big Data Technologies:
Understanding of big data frameworks like Hadoop, Spark, and their integration with traditional databases.
DevOps Practices:
Familiarity with DevOps tools and practices for continuous integration and continuous deployment (CI/CD) pipelines.
The MITER Brands benefits package includes coverage of health, wealth, and wellness for you and your eligible spouse/dependents. We offer a competitive salary and benefits package, including a 401k with company match and generous paid time off to help you balance your life.
MITER Brands, also known as MI Windows and Doors, Milgard and PGT are an equal-opportunity employer. The company does not discriminate based on religion, race, creed, color, national origin, sex, age, disability, handicap, veteran status, sexual orientation, genetic information, or any other applicable legally protected category.
#J-18808-Ljbffr