IT Database Administrator

POSITION SUMMARY:

Under the general supervision of the IT Director, the Database Administrator is responsible for creating, administering and troubleshooting computer databases as well as ensuring the security of information stored in various databases. Duties include using code and web architecture to design data systems, analyze and maintain existing databases and implement reporting and integration of the databases.

ESSENTIAL FUNCTIONS:

1. Develop and implement database backup and recovery strategies to ensure data reliability and minimize downtime.
2. Design and test database systems.
3. Develop database documentation.
4. Develop and implement data security policies, procedures, and best practices to protect sensitive information.
5. Work with the front-end development team and users to integrate various modules.
6. Build and maintain required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies.
7. Build analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency, customer acquisition, and various other key metrics.
8. Work with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues.
9. Work with and maintain Sage, Agilisys, Eatac, Gaming, and other database systems to integrate and produce combined reports.
10. Work with end users to fix front-end and back-end software issues.
11. Other duties as assigned within the scope and complexity of the current responsibilities.
12. Must attend any mandatory trainings designated by the Human Resources Department and/or Department Director, including Title 31.

Physical requirements:

Typically, the employee may sit for long periods to do the work. However, the work will require physical exertion such as recurring bending, crouching, stooping, stretching, reaching, or similar activities, recurring lifting of moderately heavy items such as computers and monitors.

Position Requirements:

1. Bachelor’s degree in computer science, Information Technology, or a related field required.
2. Minimum of 3 to 5 years of proven work experience as a Data Base Administrator required.
3. Strong knowledge of database management systems, such as Microsoft SQL Server, ETL and MySQL required.
4. Proficiency in writing complex SQL queries and optimizing database performance required.
5. Knowledge of Cloud Infrastructure, Sage Accounting software, Oasis 360, Agilysys POS/PMS, and Eatac inventory systems desired.
6. Must be able to obtain a gaming license through the Bay Mills Gaming Commission and maintain eligibility throughout employment.
7. Valid Driver’s License and ability to pass Motor Vehicle Records Investigation for insurability purposes, required
8. Excellent customer service skills.
9. Project leadership ability.
10. Ability to multi-task and make independent prioritization of user requests under limited direction.
11. Previous experience in training individuals in the use of software applications and operating systems.
12. Excellent verbal and written communication skills.
13. Ability to work well under pressure with minimal supervision.

Disclaimer:

This job description is intended to summarize the type and level of work performed by the incumbent and is not an exhaustive list of duties, responsibilities, and requirements. Bay Mills reserves the right to change, add, or reassign job duties or combine positions, or portions thereof, at any time. This job description is not an employment agreement or contract. This job description may be updated based on the needs of the employer.

Work Schedule:

Full-time; 52 weeks per year. In addition to regular business hours, the person in this position must be flexible around the needs of the employer, which may include occasional evening and/or weekend hours or occasional travel for employer business.