Lead Database Administrator - SQL Server Focus

Pay Rate: Starting at $83,200. Pay is negotiable

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
• Strong project management skills
• 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
• Extensive computer use