drjobs Database Administrator

Database Administrator

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Helena, MT - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Education:

  • Associate degree emphasizing basic database management principles.

Experience:

  • Two years of experience managing maintaining and securing database systems.
  • Experience working on at least one digital transformation project including data migration.
  • Other combinations of education certification or experience may be substituted.

Preferred Experience:

  • SQL and Access database management
  • ESRI GIS geodatabase management related to mapping
  • Data analytics tools such as Tableau or Microsoft Power BI.

The following documents must be submitted to be considered for this position (be sure to mark each attachment as relevant):

  • Cover Letter
  • Resume
  • State of Montana Application (online)

This position is open until filled. The first review of applications will be Monday July 21 2025.

The State of Montana has a decentralized human resources (HR) system. Each agency is responsible for its own recruitment and selection. Anyone who needs a reasonable accommodation in the application or hiring process should contact the agencys HR staff identified on the job listing or by dialing the Montana Relay at 711. Montana Job Service Offices also offer services including assistance with submitting an online application.

State government does not discriminate based on race color national origin religion sex sexual orientation gender identity or expression pregnancy childbirth or medical conditions related to pregnancy or childbirth age physical or mental disability genetic information marital status creed political beliefs or affiliation veteran status military service retaliation or any other factor not related to merit and qualifications of an employee or applicant.

The Montana Historical Society (MTHS) seeks an energetic and talented IT professional for the full-time position of IT Database Administrator. We are growing creating a world-class Heritage Center that will be a destination a gathering place and a space to tell the stories of Montana to all. The Montana Historical Society preserves Montanas past shares our stories and inspires exploration to provide meaning for today and vision for tomorrow. We are looking for an individual that will contribute to that mission by offering the public exciting and innovative ways to experience Montanas history.

The ideal candidate is a motivated team member who loves supporting MTHSs programs with valuable IT work embraces the positions role in managing data assets throughout their lifecycle from collection to consumption to accomplish the mission of MTHS and is excited to be a part of the behind-the-scenes IT efforts that support the Montana Heritage Center opening in December 2025 and the ongoing operations of the MTHS.

Function: The Information Technology office is one of six sections within the Administration Program of MTHS. Under the direction of the IT Systems Administrator this position shares responsibility for MTHSs many IT activities and will be responsible for the design implementation and maintenance of the structures processes and policies related to the data framework used to support the needs of the agency. These activities include database management data transformation data analysis data analytics data mapping data security privacy and governance. Among other tasks the ability to embrace and have enthusiasm for new MTHS technology have great time management skills along with a welcoming and friendly attitude is important to this position.

Representative Duties:

  • Database Administration: Inventory plan analyze design implement test secure monitor maintain and document databases according to applicable policies rules regulations and procedures.
  • Data Analytics: Clean transform and integrate data in an easy-to-understand consumable format for reporting and visualization. Provide guidance for setting metrics. Resolve data discrepancies and provide data analysis support as needed.
  • Governance: Ensure all databases are designed and configured in accordance with the enterprise data model. Participate in enterprise initiatives and work groups. Collaborate with business teams to ensure IT meets the business objectives related to data. Create follow and enforce applicable policies rules and regulations. Document internal processes and procedures.

Knowledge of:

  • Database management principles with a solid understanding of relational and spatial database concepts.
  • Database design modeling and data flow infrastructure.
  • Cloud platforms (e.g. AWS Azure Google Cloud) and their implications for data storage processing and analytics.
  • Data formats such as CSV JSON and XML. SQL and Python scripting language.
  • SQL Server Reporting Services and Report Builder/Designer
  • Technologies such as Snowflake for handling large volumes of data including databases data warehouses data lakes and stream processing.
  • Advanced knowledge of Excel utilizing pivot tables and macros.
  • Policies standards and best practices for ensuring data quality integrity security privacy and compliance.
  • Managing Personally Identifiable Information (PII) and how to apply data anonymization techniques including data redaction nulling masking pseudonymization generalization swapping perturbation and encryption to protect sensitive data.

Skills in:

  • Operation in the use of computer hardware and software.
  • Organizational skills and attention to detail.
  • Analysis and problem resolution

Ability to:

  • Communicate complex ideas clearly and concisely both oral and written form.
  • Establish and maintain effective working relationships with employees other agencies the media and the public.
  • Act independently or as a member of a team.
  • Adjust to changing circumstances and new information.
  • Compile data from various sources using ETL processing techniques and configuring API integrations.
  • Handle structured unstructured and geospatial data.

Minimum Physical/Mental Requirements:

  • May require 8 or more hours a day working with IT systems.
  • May require more than a 40-hour workweek and on-call to perform systems upgrades and address issues during off-hours.
  • Occasional need to lift move and install computer hardware up to 25 lbs.
  • May require occasional contact with the public.

Required Experience:

Unclear Seniority

Employment Type

Full Time

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.