Database Administrator (On-Site)

Description

A FULL HOUSE OF TOTAL REWARDS

• Competitive Pay: Starting salary of $85,620 - $94,183/year, depending on experience, with opportunities for annual performance-based increases. The role offers a potential career earning trajectory reaching up to $123,294/annually max over time. 
• Full Coverage: 100% employer-paid medical, dental, vision, and prescription coverage, plus competitive family rates starting after 60 days, with additional benefits such as 401(k), employer-paid life insurance, and long-term disability.
• Generous PTO: Accrue 21 days of PTO in your first year, growing to 33 days after five (5) years, with an option to cash out twice annually.
• Everyday Perks: Free meals, parking, paid breaks, 40c/gallon gas discount, and exciting giveaways like concert and sports tickets.
• Growth & Support: Access to tuition reimbursement, certification programs, and Employee Assistance Program.

Note: This is an on-site role in Snoqualmie, WA. 

PURPOSE

This role is responsible for providing operational database services and support for Snoqualmie Casino & Hotel’s systems. This includes maintaining the integrity, security, and availability of all database systems and applications. The Database Administrator will monitor system performance, troubleshoot issues, and ensure effective backups and disaster recovery plans are in place.

ESSENTIAL DUTIES / RESPONSIBILITIES

• Database Management: Install, configure, upgrade, and maintain database servers and applications to ensure optimal performance and reliability.
• System Monitoring and Troubleshooting: Continuously monitor system health and performance metrics, and troubleshoot/resolve any service outages or issues, including after-hours support.
• Security and Compliance: Implement and enforce database security measures, ensure regulatory compliance with gaming regulations, and maintain strict confidentiality of sensitive data.
• Backup and Recovery: Develop, test, and manage backup and recovery plans, ensuring business continuity and disaster recovery preparedness.
• Documentation and Reporting: Write and maintain comprehensive documentation, including data standards, metadata definitions, and custom reports using SQL Reporting Services.
• Technical Support and Development: Provide on-call technical support, assist with hardware builds and maintenance, and develop custom utilities and applications to support database functions.
• Project Management and Mentorship: Lead database-related projects, mentor junior staff, and collaborate with internal teams to deliver effective service solutions.
• Gaming Application Administration: Administer and support gaming applications, ensure effective log management, and provide advanced data analytics for decision-making processes.
• Process Improvement and Efficiency: Identify opportunities for process improvements, develop and refine procedures, and contribute to the overall efficiency and effectiveness of database operations.

Requirements

Education and Experience:

• Bachelor’s degree in Computer Science, Information Technology, or a related field. MSSQL, MCDBA, MCTS, MCTP, or MVP certification may be considered in lieu of education.
• Four (4) years of experience in IT operations with a strong understanding of database structures, theories, principles, and practices.
• Two (2) years of experience in Database Administration for MS SQL Server, with demonstrated experience:
• Troubleshooting and resolving database problems.
• Performance Tunning and Optimization (PTO) using native monitoring and troubleshooting tools.
• Implementing operational automation using scripts.
• Managing High Availability (HA) and Disaster Recovery (DR) options.

Skills and Abilities:

• Technical Proficiency: Advanced knowledge of MS SQL Server, including installation, configuration, maintenance, and troubleshooting. Expertise in Performance Tuning and Optimization (PTO) using native monitoring and troubleshooting tools.
• Security and Compliance: Strong understanding of database security, access controls, and regulatory compliance requirements, particularly in the gaming industry.
• High Availa