Senior Database Administrator
Summary
The Senior Database Administrator manages, optimizes, and secures relational databases and business intelligence environments for a casino resort. This role involves leading staff, overseeing database performance, and ensuring system availability in a 24/7 environment.
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