Description: Position Title: Database Administrator Description: The
Montana Department of Transportation (MDT) is recruiting a Database Administrator. This position works closely with application development and network operations personnel to understand the needs of their defined database schemas, assists with fine tuning their queries and supporting their developer tool sets. The incumbent leads in analysis, design, modeling, and development, while participating in the implementation and maintenance of database solutions across a variety of technology platforms. The incumbent performs database analysis of existing applications offering recommendations for revising or adapting those applications to improve database performance; independently performs complex work assignments and problem resolution across systems and processes. The incumbent performs data analysis using existing and/or creating new logical models, physical models, and data flows; and assists developers in determining the logical database model using normalization methodologies and entity/relationship modeling. The incumbent develops and maintains the enterprise application data model and can demonstrate the impact of new strategy implementations including, where necessary, the incorporation of data models from other State agencies or vendor supplied off-the-shelf solutions.The incumbent is responsible for database patching, upgrades, monitoring, tuning, and performing backups when needed.The incumbent must have experience using ETL technologies (Talend, Fivetran, etc.) and have experience with data warehouse platforms like SnowFlake.
This position is part of a career ladder with career advancement opportunities. For a full job description, please contact Sarah J. Peterson at ...@mt.gov.
Benefits of working for MDT and the State of Montana include: •Culture of public service and a commitment to work/life balance •Potential hybrid remote work arrangement available •Health, Dental, and Vision Insurance •Access to Montana Health Centers, low-cost clinics for state employees and their families •State Retirement plan and additional savings opportunities (deferred compensation) •Employees in this position receive overtime compensation or compensatory time for all time in a pay status over 40 hours in a workweek •Paid vacation, sick leave, and holidays •Eligibility for Public Service Student Loan Forgiveness •Benefits apply on first day of employment •Relocation assistance may be offered to the successful candidate at the time of offer For information on the Montana Department of Transportation's mission, vision, and values, please visit our website:
Qualifications Required Education and Experience: Database Administrator 3.1: The required knowledge and skills are typically acquired through a combination of education and experience equivalent to a Bachelor's Degree in Computer Science, Database Administration, or a closely related field such as Information Systems Design. This position requires a minimum of 6 years of related experience. The experience must include 1-3 years each of Project Management, team or project leadership and database schema development. Expertise in SQL (Standard Query Language), with working knowledge of the Oracle RDBMS, SQL, and Postgres and their associated tools.
Database Administrator 3.2: The required knowledge and skills are typically acquired through a combination of education and experience equivalent to a Bachelor's Degree in Computer Science, Database Administration, or a closely related field such as Information Systems Design. This position requires a minimum of 8 years of related experience. The experience must include 4+ years each of Project Management, team or project leadership and database schema development. Expertise in SQL (Standard Query Language), with working knowledge of the Oracle RDBMS, and Postgres and their associated tools. Alternative qualifications include: Any combination of additional related work experience and education equivalent to the minimum qualifications. This agency may use a training assignment. Employees in training assignments may be paid below the base pay established by the agency pay rules. Conditions of the training assignment will be stated in writing at the time of hire.
Knowledge, Skills, and Abilities: - Perform all DBA services for MDT RDBMS environment including patching, upgrading, issue/defect resolution, performance and health monitoring, backup/restore/failover activities, upgrade planning, coordination, and execution.
- Influence the enterprise design, integration and maintenance of enterprise databases (Oracle, SQL, Postgres, Snowflake, and other as appropriate) to meet the business needs of MDT.
- Database design and optimization.
- Understand how to plan for future operations and architecture of the system from the perspective of upgrading, data storage and access.
- Communicate and recommendation database strategy and decisions; define vision, identifies timelines and goals that would ensure the implementation of all approved technology initiatives.
- Research and exploration of options and alternatives for other data stores/databases that should be further exploited in a division-wide POC.
- Stays current on database products and their offerings including awareness of capabilities, limitations, licensing costs, releases, etc.
- Understands all features and functions of currently installed products/releases.
- Supports development of policies and procedures necessary to ensure the security and integrity of enterprise databases and other data stores.
- Participates in the design and implementation of database security models.
- Coordinates security model decisions for user access levels for each segment of the database.
- Leads the efforts for major database release level installations and/or migrations.
- Communicates features and functions knowledge with applications personnel as needed (e.g. when changes occur) ensuring changes/differences are identified.
- Collaborates in developing and maintaining the Enterprise Data Model (EDM) to serve as both the strategic and tactical planning vehicles to manage enterprise data.
- Contributes to enterprise data architecture activities.
- Key collaborator in the agency disaster recovery practices.
- Supports the MDT data architect, and the other DBA's, in their use of Snowflake.
- Generally, provides DBA level support to data warehouse efforts of the agency.
- Supports the reviews process for system design specifications, process models, data architecture and/or data flow diagrams.
Required Application Materials: - A resume detailing your qualifications and work history.
Your online application and all required materials must be submitted before midnight on the closing date. Ensure all materials submitted are selected as Relevant. If you need an accommodation with the application process, please contact the HR representative listed below.
Other Information The successful candidate must pass a fingerprint background investigation as a condition of employment. This position is being posted in accordance with the MFPE bargaining unit agreement. Non-bargaining unit employees or employees of another bargaining unit may apply. If the position is not filled with a bargaining unit applicant, the non-bargaining unit applicants may be considered. However, bargaining unit applicants will have preference. This position is covered under a Career Ladder Advancement Policy. Education and experience will determine salary. The Montana Department of Transportation is an equal opportunity employer. Women, racial and ethnic minorities, people with disabilities, and veterans and disabled veterans are encouraged to apply. People with disabilities needing assistance in the application process, or those needing this job announcement in an alternative format may call the Human Resources and Occupational Safety Division, at 406.###.####. The Montana Department of Transportation (MDT) is committed to continuous improvement of our employee safety program and our safety and health processes, and to achieving an injury-free workplace.