Database Administrator 3

State of Montana • Helena, MT

9d

About The Position

The Technical Project Services (TPS) team, part of Montana DNRC’s Water Resource Division (WRD), is responsible for providing maintenance, tuning, database and 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 TPS team offers technical project management support to agency, division, and stakeholder workgroups. This role involves coordinating and collaborating with various WRD workgroups, DNRC division workgroups, and external partners such as the Montana Water Court, Flathead Reservation Water Management Board, Montana Fish, Wildlife, & Parks, private consultants, water right owners, attorneys, and the public. The position offers an opportunity to shape the core of DNRC's Water Rights Information System by taking ownership of key databases and systems, leading modernization efforts including migration to Oracle Cloud Infrastructure, and designing/maintaining database and system architectures. It also involves supporting secure, stable operations through performance monitoring, troubleshooting, and building business continuity/disaster recovery capabilities, as well as supporting information security practices. The role requires partnering with program staff, GIS professionals, developers, contractors, and other technical teams to understand business needs and develop practical technical solutions, supporting integrations between WRIS, GIS, and document systems, and communicating effectively with both technical and non-technical audiences. Furthermore, there is an opportunity to explore innovation and future platforms by experimenting with AI and automation tools in database and system workflows and contributing ideas to modernization projects.

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.
• Cover Letter - Please explain how your education and experience help you meet the identified Knowledge, Skills and Abilities.
• Resume - Include all the work experience you have held that would help you qualify for this position including duties and dates of employment (month & year).

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.
• Coordinate and collaborate with all WRD workgroups, a subset of DNRC division workgroups, and external partners.
• 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 in everyday decision‑making.
• Monitor performance, troubleshoot issues, and recommend improvements that keep systems running smoothly and securely for users in multiple divisions and offices.
• Help build and maintain business continuity and disaster recovery capabilities so DNRC can protect data and restore services quickly when needed.
• 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