Database Administrator 2

State of Montana•Helena, MT

2d•Onsite

About The Position

This position provides database design, development, and administration support for MBCC’s database hosting services and to assist with deployment of state standard database technology. The duties typically involve creating and configuring production databases using established procedures, database development, backup and recovery strategies, technical support, and software patch management and maintenance of relational database systems for mission-critical operations. This includes configuring database parameters; modifying database environments through coding, testing, and implementation; and running test programs to validate functionality and correct errors. Duties also include planning and implementing database security measures, managing user access and permissions, and ensuring data security protocols are in place and functioning. The position involves making strategic decisions about database design, maintenance and tuning, as well as diagnosing and troubleshooting complex database issues, monitoring database performance, and performing performance tuning. The Database Administrator also installs upgrades and patches and supports user needs by extracting data and responding to data requests using existing tools. As agency priorities dictate, the Database Administrator must be able to carry out any assignment in the section with minimal retraining and may be assigned responsibility for project components.

Requirements

A bachelor’s degree in a computer science related field
Two years experience working in a variety of database environments
Knowledge of system performance optimization and management techniques
Knowledge of principles and practices of information systems analysis, design, implementation, maintenance, and security related functions
Knowledge of 508 compliance measures and implementation strategies
Ability to provide exceptional customer service and enjoy working in a team environment
Ability to build trust and credibility in constructing effective working relationships with a variety of individuals
Ability to manage varying deadlines and multiple projects; responding positively to changes in direction, priorities, responsibilities or assignment
Ability to keep large projects, involving multiple parties, moving forward and delivering on time
Ability to provide guidance and instructions to other agency staff
Ability to evaluate program requirements relative to systems development
Ability to conduct research
Ability to exercise sound judgment in solving programs and make decisions where few precedents exist
Ability to exhibit a commitment to stay up-to-date in the IT profession
Ability to organize a dynamic workload and meet established deadlines

Nice To Haves

Specific experience in Relational database management systems (RDMS) such MS SQL Server or Oracle
Database administration, automation, business rule enforcement, web design and development, and performance optimization techniques

Responsibilities

Creating and configuring production databases using established procedures
Database development
Backup and recovery strategies
Technical support
Software patch management and maintenance of relational database systems for mission-critical operations
Configuring database parameters
Modifying database environments through coding, testing, and implementation
Running test programs to validate functionality and correct errors
Planning and implementing database security measures
Managing user access and permissions
Ensuring data security protocols are in place and functioning
Making strategic decisions about database design, maintenance and tuning
Diagnosing and troubleshooting complex database issues
Monitoring database performance
Performing performance tuning
Installing upgrades and patches
Supporting user needs by extracting data and responding to data requests using existing tools
Carrying out any assignment in the section with minimal retraining
Assigned responsibility for project components