Database Administrator 3

State of Montana • Helena, MT

8d • Onsite

About The Position

This position is within the Technical Project Services (TPS) team, part of Montana DNRC’s Water Resource Division (WRD). The TPS team is responsible for providing maintenance, tuning, database & environment architecture development, systems integrations, analyses, and reporting for the Water Right Information System (WRIS) Database and WRIS ecosystem. They also provide Geographic Information System (GIS) expertise, analyses, map production, and geospatial application development to WRD and its primary business partners. Additionally, the team provides technical project management support to agency, division, and stakeholder workgroups. The TPS team coordinates and collaborates with all WRD workgroups, a subset of DNRC division workgroups, and external partners including the Montana Water Court, Flathead Reservation Water Management Board, Montana Fish, Wildlife, & Parks, private consultants, water right owners, attorneys, and the public. This role will shape the core of DNRC's Water Rights Information System by taking ownership of key databases and systems that power WRIS and other water resources applications, ensuring reliable, secure access to critical information across the state. The position will lead and support modernization efforts, including migration to Oracle Cloud Infrastructure, to enable DNRC to deliver faster, more resilient services. The role involves designing and maintaining database and system architectures that make complex information easier to manage, report, and use. The Database Administrator will support secure, stable operations by monitoring performance, troubleshooting issues, and recommending improvements. They will also help build and maintain business continuity and disaster recovery capabilities, and support information security practices by managing access, permissions, and patching. Collaboration with program staff, GIS professionals, developers, contractors, and other technical teams is essential to understand business needs and translate them into practical solutions. The role supports integrations between WRIS, GIS, and document systems for seamless workflows and requires clear communication with both technical and non-technical audiences. The position will also explore innovation and future platforms by experimenting with Artificial Intelligence (AI) and automation tools in database and system workflows to enhance monitoring, streamline processes, and support future platform modernization.

Requirements

• Knowledge of multi-tier architecture, enterprise infrastructure, and systems integration across server, storage, network, and operating environments.
• Knowledge of relational database security principles, including authentication, authorization, auditing, and broader enterprise security practices.
• Knowledge of database design concepts such as normalization, transactional integrity, data warehousing, dimensional modeling, and alternative data models.
• Skill in virtualization, containerization, and cloud concepts, including platforms such as VMware, Hyper-V, Docker, Oracle Cloud Infrastructure, and related technologies.
• Skill in using database views, monitoring tools, performance analysis methods, and scripting or automation tools to support efficient database and system administration.
• Ability to assess technical risk, support continuity of service, and use sound judgment to maintain stable and secure environments.
• Ability to communicate clearly, manage competing priorities, and work effectively with both technical teams and business partners.
• Attach both a cover letter and resume at the time of application.
• Mark each attached document as Relevant.

Nice To Haves

• Experience with Oracle Cloud Infrastructure

Responsibilities

• Provide maintenance, tuning, database & environment architecture development, systems integrations, analyses, and reporting for the Water Right Information System (WRIS) Database and WRIS ecosystem.
• Provide Geographic Information System (GIS) expertise, analyses, map production, and geospatial application development to Water Resource Division (WRD) and WRD’s primary business partners.
• Provide technical project management support to agency, division, and stakeholder workgroups.
• Take ownership of key databases and systems that power WRIS and other water resources applications, ensuring reliable, secure access to critical information across the state.
• Lead and support modernization efforts, including migration to Oracle Cloud Infrastructure.
• Design and maintain database and system architectures that make complex information easier to manage, report, and use.
• Monitor performance, troubleshoot issues, and recommend improvements that keep systems running smoothly and securely.
• Help build and maintain business continuity and disaster recovery capabilities.
• Support information security practices by managing access, permissions, and patching in alignment with state and agency policies.
• Partner with program staff, GIS professionals, developers, contractors, and other technical teams to understand business needs and turn them into practical, well-designed technical solutions.
• Support integrations between WRIS, GIS, and document systems to create seamless workflows for staff and stakeholders.
• Communicate clearly with both technical and non-technical audiences, helping bridge the gap between business requirements and system capabilities.
• Experiment with Artificial Intelligence (AI) and automation tools in database and system workflows to enhance monitoring, streamline processes, and support future platform modernization.
• Contribute ideas and insights to ongoing modernization projects and help DNRC stay current with emerging technologies and best practices.

Benefits

• Generous paid leave (vacation, sick, holidays). Vacation leave increases with years of service.
• Health, dental, vision, life insurance, and flexible spending accounts.
• Access to free employee medical clinics and telehealth.
• Retirement plans (Defined Benefit and Defined Contribution plus an optional 457b Plan).
• Public Service Loan Forgiveness - may qualify you for student loan forgiveness.
• Longevity pay with continued state service.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed