Enterprise Government Database Architect

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.

• 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

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

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.

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.

Ce…