Senior Database Administrator

Treasure Island Resort & Casino; Welch Township (MN); On-site; USD 95,000 - 140,000; Full time

Job summary

Treasure Island Resort & Casino is seeking a Senior Database Administrator to lead relational database operations, optimize performance, and ensure robust backup and disaster recovery for a high-transaction environment. You will oversee BI databases, cubes, and data integrity across Prairie Island and Treasure Island sites.

Required are a 4-year IT degree or equivalent, 5+ years of DBA experience in VLDB environments, and strong skills in SSRS, SSIS, and SSAS, with project management

Qualifications

• Bachelor’s or higher with IT focus, or equivalent experience.
• Experience with enterprise-level backup/recovery in VLDB environments.

Responsibilities

• Plan, implement and manage databases and BI environments.
• Lead backup, restore, and disaster recovery processes.
• Monitor and optimize database performance and capacity.

Skills

Detail-oriented

Organized

Project management

Communication

Problem solving

Education

4-year IT degree or related field

Tools

SQL Server Reporting Services

SQL Server Integration Services

SQL Server Analysis Services

Job description

Essential Duties And Responsibilities

• Hire, schedule, train, coach, and evaluate staff and conduct performance reviews
• Direct daily work activities and inspect completed work for conformance to standards
• Monitor relational databases to optimize database performance, resource use and physical implementations of databases
• Address database integration issues including migration between disparate databases, integration, maintenance/ conversion, capacity planning issues and new applications
• Monitor and manage database backups and logs
• Install, maintain and upgrade database software and restore and/or recover data as required
• Maintain business intelligence environment databases and cubes, including disaster recovery, validation, and assisting in design of new cubes and future development
• Plan, coordinate, implement and maintain policies and procedures and security measures to ensure database integrity and safeguard information in computer files against accidental or unauthorized damage, modification or disclosure
• Approve, plan and supervise the installation and testing of new products and improvements to transactional and reporting database systems
• Advise with regard to server environment on which databases reside specific to performance and capacity analysis
• Coordinate with Network team to ensure server consistency and performance benchmarks are achieved
• Provide on call service 24/7, as needed, and emergency support and restoration of systems
• Provide support to multiple Prairie Island and Treasure Island locations

Knowledge And Certification, Skills And Abilities

• 4-year IT degree or related field; or equivalent combination of comparable work experience, on-the-job training, IT certifications and/or education
• 5 years relational DBA experience in a highly transactional VLDB environment including the implementation of enterprise-wide backup / recovery solutions and lead database role or related lead technical position
• Demonstrated Project Management experience
• Database programming experience working in a large multi-application environment resulting in the integration of disparate systems, enterprise level reporting and enhanced system functionality
• Experience working with Reporting Services, Integration Services, and Analysis Services

Preferred

• Current Project Management Certification
• Microsoft SQL Certification
• Supervisory experience

Skills

• Accurate and detail-oriented
• Highly organized and ability to adapt quickly to changing priorities
• Strong project management skills
• Excellent written, verbal, and interpersonal communication skills
• Excellent problem solving skills

Abilities

• Ability to work fast and efficiently
• Ability to follow established dress code policies and practice good personal hygiene
• Ability to interact with guests, coworkers and management in a professional and courteous manner
• Ability to independently complete multiple tasks in a professional manner
• Ability to manage projects in a timely and efficient manner
• Ability to speak in a clear, concise and pleasant voice

Required Training

• Treasure Island guest service training
• Department orientation
• Any position-related training as determined by department manager

PHYSICAL DEMANDS

• Must be able to sit for long periods of time with occasional walking and standing
• Must have the ability to independently lift up to 25+ pounds occasionally
• Must be able to perform repetitive hand and wrist motions

WORKING ENVIRONMENT

• Work is performed primarily in the administration building but may include going onto the gaming floor, which includes flashing lights, frequent loud noises and cigarette smoke, and outdoor IT set-up for guest and team member events
• Must be willing to work a flexible schedule including all shifts, weekends and holidays
• Extensive computer use