Govt. IT - Database Administrator

POSITION SUMMARY:

The Database Administrator, under the direction of the Data and Applications Manager, is responsible for installing, monitoring, supporting and securing all the enterprise databases and data repositories across the tribe’s government, gaming & hospitality, health and enterprise divisions. Works closely with other IT resources, organization managers and key application stakeholders to create strategies and operational designs for database and data optimization.

ESSENTIAL FUNCTIONS: (includes, but is not limited to, the following)

Database Management and Administration:

• Install, configure, maintain, and optimize database systems supporting the organization's diverse enterprise applications across various divisions (Government & Membership Services, Gaming & Hospitality, Health Care, and Enterprises).
• Ensure the security, integrity, availability, and performance of all managed databases, adhering to established data governance policies and procedures.
• Implement and manage database backups and recovery procedures to minimize data loss and downtime in case of system failures.
• Monitor database health, identify performance bottlenecks, and implement optimization strategies to ensure efficient database operations.
• Collaborate with Data Governance Administrator, BI Analysts, and other IT teams to design and implement data pools, lakes, and warehouses for centralized data storage and analysis.
• Participate in data cleansing processes to ensure data quality and consistency across various data sources.
• Develop and maintain Extract, Transform, Load (ETL) processes to integrate data from disparate sources into data warehouses for efficient reporting and analysis.
• Support the integration of Business Intelligence (BI) tools with databases to facilitate data-driven decision making within the organization.
• Participate in initiatives for cloud migration and integration of databases and data storage solutions.
• Manage and maintain databases stored in cloud environments, ensuring security, compliance, and scalability.
• Partner with IT teams to leverage cloud-based data processing tools and platforms to support organizational needs.
• Configure database security settings and user access controls, adhering to data governance regulations and best practices.
• Work with Application Specialists and Data Governance Admin to define access levels and permissions for users based on their roles and responsibilities.
• Monitor database activity for suspicious behavior and implement measures to prevent unauthorized access and data breaches.
• Work collaboratively with the IT Data & Applications team (Data & Application Administrators, Project Managers, etc.) and other IT teams (Application Specialists, BI Analysts) to ensure seamless integration of databases with applications and overall IT infrastructure.
• Communicate effectively with technical and non-technical audiences, providing guidance and support on database-related matters.
• Stay up to date on industry best practices, emerging database technologies, and security threats to ensure continuous improvement in database management

CONTACTS:

Immediate peers, peers in other departments, immediate supervisor/manager, managers in other departments, executives, Board of Directors, customers and outside vendors/service providers.

PHYSICAL REQUIREMENTS:

Position heavy with lifting of 100 pounds maximum and frequent lifting/carrying up to 50 pounds. Physical factors include constant use of color vision, typing; frequent standing, walking, sitting, reaching, use of hearing, driving, bending; occasional pushing/pulling, climbing, stooping, kneeling, crawling, manual handling, use of smell, near/midrange/far vision and field of vision. Working conditions include occasional exposure to weather, wet/humidity, noise and air quality. Potential hazards include constant computer use and occasional exposure to electric shock, high exposed places, chemicals and equipment. The IT Department is a 24/7 operation; working nights, weekends, holidays and on-call should be expected.

REQUIREMENTS:

Education: Bachelor’s degree in Computer Information Systems Management or similar IT field required or five years of demonstrated experience database administration.

Experience: No additional experience required.

Certification/License: Must have a valid driver’s license and be insurable by the Sault Tribe Insurance Department. Must comply with annual driver’s license review and insurability standards with the Sault Tribe Insurance Department. Must undergo a Criminal background investigation done under the rules of the National Indian Gaming Commission. Must comply with the Sault Tribe’s Drug-Free Workplace Policy which may include random drug tests.

Knowledge, Skills, and Abilities: In-depth knowledge of relational database management systems (RDBMS) with a focus on Microsoft SQL Server, Microsoft Databases, and experience with all relevant database platforms used by the organization required. Thorough understanding of data security best practices, data access control mechanisms, and data governance policies and procedures required. Must have working knowledge of data warehousing concepts, data integration techniques (ETL processes), and Business Intelligence (BI) tools. Must have familiarity with cloud-based database storage and data processing solutions required. Must have knowledge of database performance optimization techniques and tools for troubleshooting and improving database efficiency. Proven skills in database installation, configuration, maintenance, and optimization required. Expertise in implementing and managing database backup and recovery procedures to ensure data availability required. Ability to analyze database performance metrics, identify bottlenecks, and troubleshoot database-related issues required. Skills in developing and maintaining ETL processes to integrate data from various sources into other applications, downloads or data warehouses required. Must have proficiency in writing and executing SQL queries for data manipulation, retrieval, and analysis. Must have excellent written and verbal communication skills to collaborate effectively with technical and non-technical audiences. Strong analytical and problem-solving skills to diagnose and resolve complex database issues required. Must have a keen eye for detail to ensure accuracy in database configuration, data management, and adherence to data governance policies. Must have proven ability to work collaboratively with the IT Data & Applications team (Data & Application Administrators, Project Managers, etc.) and other IT teams (Application Specialists, BI Analysts) to ensure seamless database integration within the IT infrastructure. Strong desire to stay up to date on emerging database technologies, cloud solutions, and security best practices required. Ability to prioritize tasks, manage multiple projects, and meet deadlines in a fast-paced environment. Required. Must maintain strict confidentiality of all tribal data and business operations. Native American preferred.

This job description outlines the general scope and level of responsibilities associated with the position. It is not intended to be an employment contract, nor does it represent a comprehensive list of all duties, responsibilities, or requirements. The Sault Ste. Marie Tribe of Chippewa Indians reserves the right to modify, add, reassign, or combine job duties or positions, in whole or in part, at any time.