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. You don’t have to be the only DBA or have DBA in your job description, but you should have been the one person that the company would call if the SQL Server service stopped working. 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.  Our medical plans include a Health Reimbursement Account (HRA) or Health Savings Account (HSA) option to help you save for health care costs. Below is a list of benefits you will enjoy while working with our company.

Medical plans with HRA or HSA options Prescription Dental Vision Company Paid Life Insurance Voluntary Life Insurance Supplemental Hospital Indemnity, Critical Illness, and Accident Insurances Company paid Short-Term Disability Company paid Long-Term Disability Paid time off (PTO), including Vacation, Personal, and 8 paid Holidays 401k retirement plan with company match Employee Assistance Program Teladoc Tuition Reimbursement Yearly Wellness Clinic

 

MITER Brands is an equal opportunity employer. Milgard Windows and Doors 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.