Senior Database Administrator

Treasure Island Hotel and Casino; Northern (KY); Hybrid; USD 90,000 - 140,000; Full time

Job summary

Treasure Island Resort & Casino in Welch, MN seeks a seasoned Database Administrator to oversee relational databases, optimize performance, and ensure data integrity across multiple locations. You will lead backups, secure data, implement migration plans, and collaborate with network teams to maintain infrastructure and disaster recovery capabilities.

Required: 4-year IT degree, 5+ years DBA in VLDB environments, and experience with SSRS/SSIS/SSAS; strong communication and project management

Qualifications

• 4-year IT degree or related field or equivalent combination of education and experience
• 5 years relational DBA experience in a highly transactional VLDB environment with backup/recovery leadership
• Demonstrated Project Management experience
• Database programming experience in large multi-application environment with enterprise reporting
• Experience with Reporting Services, Integration Services, and Analysis Services

Responsibilities

• Hire, schedule, train, coach staff and conduct performance reviews.
• Direct daily work activities and ensure conformance to standards.
• Monitor relational databases to optimize performance and resource use.
• Address database migration, integration, maintenance, and capacity planning.
• Monitor backups and logs; perform upgrades and data restoration as needed.
• Maintain BI environment databases and cubes, assess disaster recovery planning.
• Ensure data integrity and secure information; enforce policies and procedures.
• Collaborate with network teams for server performance benchmarking.
• Provide on-call support 24/7 and emergency restoration of systems.
• Support multiple Treasure Island locations as needed.

Skills

Attention to detail

Organized

Communication skills

Problem solving

Fast learner

Guest interaction

Education

4-year IT degree

Project Management Certification

Microsoft SQL Certification

Tools

SQL Server Reporting Services

SQL Server Integration Services

SQL Server Analysis Services

Job description

Treasure Island Resort & Casino
Welch, MN 55089, USA

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

Knowledge and Certification

Required:

• 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

Required:

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

Abilities

Required:

• 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

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.