Database Manager

Turning Stone Resort Casino; Town of Verona (NY); On-site; USD 100,000 - 130,000; Full time

Job summary

Turning Stone Resort Casino in the Town of Verona is seeking a Database Manager responsible for overseeing the design, maintenance, and implementation of database management systems. The ideal candidate will have extensive experience in managing technical resources, ensuring optimal database performance, and complying with quality controls.

Applicants should possess a degree in Computer Science or related field, along with at least 12 years of database development experience. Familiarity with Unix scripting and a range of operating systems is essential for this role.

Qualifications

• Must have at least 12 years experience in Database development and management.
• Demonstrates experience with installs and configurations.
• Experience with Unix scripting such as Perl, Bash and Korn.

Responsibilities

• Oversee database function and management systems.
• Manage technical resources to support database systems.
• Design and implement data architectures and standards.

Skills

Database development

Unix scripting

Windows 20xx

AIX

Linux

Networking

Organizational skills

Verbal and writing skills

Education

Degree in Computer Science or related field

Tools

Active Directory

VMware

IBM SAN/disk technologies

Job description

Job Description

• Effectively oversees and is responsible for the database function; ensuring the design, maintenance and implementation of database management systems.
• Effectively manages technical resources and applicable staff to ensure optimal support of database systems. Monitors the overall function of the team and ensures the proper training of staff.
• Determines the overall design of the enterprise wide data/information architecture and balances the need for access against security and performance requirements. Designs and constructs data architectures, operational data stores and data marts while focusing on enterprise wide data modeling and database design.
• Defines data/information architecture standards, policies and procedures for the organization, structure, attributes and classification of data elements, and applies accepted data content standards to technology projects.
• Consistently takes appropriate proactive measures to ensure the stability, availability and reliability of areas under responsibility.
• Provides 3rd Level Support for all Database related issues and ensures trouble calls are resolved in accordance with Service Level Agreements.
• Ensures all assigned staff complies with Help Desk Ticket resolution timelines.
• Facilitates consistent business analysis, data acquisition, access analysis and design as it applies to the enterprise data architecture and quality control.
• Supports database management systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the enterprise level.
• Designs, specifies, and documents database schema configurations according to Customer needs and Engineering guidelines; consults with outside support resources as appropriate.
• Prepares charts and diagrams to explain database operations to be used for training others in proper use.
• Independently reviews, plans and evaluates the deployment and efficiencies of the database infrastructures, QA strategy, and Configuration policies and procedures.
• Follows and promotes the development life cycle process, ensuring that Quality control and Change Management practices are adhered to.
• Is proactive in providing and promoting the importance of documentation, accurate records of work performed, project tracking, and management reporting. Reviews documentation provided by all staff members for accuracy and quality.
• Works collaboratively with IT team members to implement necessary changes, upgrades and enhancements to the environment.
• Assists the Director of IT Operations in the development of philosophies and strategies to support the IT mission.
• Continually researches and develops standards, proposals and processes to promote growth, maturity, and effectiveness of the IT Department.

Minimum Qualifications

• A degree in Computer Science or other related technical field and/or a minimum equivalent experience of 15 or more years working in an IT environment.
• Must have at least 12 years experience in Database development and management.
• Demonstrates experience with installs and configurations.
• Must have experience with Unix scripting such as Perl, Bash and Korn.
• Must have experience with the following operating systems: Windows 20xx, AS/400, AIX, Linux and UNIX.
• Must have working knowledge of Active Directory, VMware, IBM SAN/disk technologies and networking.
• Must have excellent organizational, verbal and writing skills. Must be able to perform well under pressure.
• Must have demonstrated experience working with gaming and/or hospitality systems.

Desired Qualifications

• Experience in managing technical resources.
• Certification in Relational Databases or MS SQL.