Job Listing Details

The State of Montana is an equal opportunity employer.

Job Listing Detail
 
Database Analyst

*Applications must be received by Midnight Mountain Time on the closing date.

13286-14BF

For more information contact:

State Agency:
Transportation
2701 Prospect Avenue
Helena, MT 59620
Phone:(406)444-6148
Fax:(406)444-7685
TTY:Montana Relay Service at 711
E-mail:erask@mt.gov

- OR -

Local Montana Job Service Workforce

Position 54181101
1
Helena
Full-Time Permanent
Daytime
7/10/2014
8/1/2014
Transportation
Information Services
Technical Operations
MPEA
035
7
Yes
$72,489.00
Yearly
Additional Salary Information:


Applicant Pool:If another department vacancy occurs in this job title within six months, the same applicant pool may be used for the selection.

Special Information:

MDT employees are encouraged to reach their full potential on the job. The work we do at MDT has a direct impact on our community and the quality of life here in Montana. We work with communities to deliver custom transportation solutions. As an organization, we provide flexible hours, alternative work schedules, and a relaxed family-friendly environment to help MDT employees balance their personal and professional interests.

 

Please note the following:

• Applicants selected for an interview are required to pass an assessment test to determine skill and aptitude level for technical abilities.

• As a condition of employment, the successful candidate will be required to sign a release form, which authorizes the department to conduct a fingerprint background check.

 For further details please contact Human Resources 444-6054

All documentation required establishing preference or as required as part of the application must be submitted by the closing date to be considered during the selection process.

 


Successful applicant(s) will be subject to:
Criminal History Background Check
Duties:

The Database Analyst 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 set. Operative leads in analysis, design, modeling and development, while participating in the implementation and maintenance of database solutions across a variety of technology platforms. Position 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; assists developers in determining the logical database model using normalization methodologies and entity/relationship modeling; determines how applications systems could interface with other existing or proposed application systems or networks. The Database Analyst develops and maintains the enterprise application data model and is able to demonstrate the impact of new strategy implementations including, where necessary, the incorporation of data models from other State agencies. The incumbent also works with developers to define the data stores and/or complete the database definitions.

 


 

Competencies:

Skill in program planning and implementation, data collection and analysis, reading comprehension, active listening, writing, and speaking, active learning, service orientation, operations analysis and quality control. Must have excellent technical, conceptual, deductive and inductive reasoning, analytical, critical thinking, problem-solving, and technical project management skills in order to interact effectively with the full spectrum of contacts on an ongoing basis and the ability to work under demanding deadlines; act independently, operating with only general direction. Development and implementation of standards, policies and procedures, discern and recommend appropriate information processes and technology options. Need proficiency in MS Office (Word, Excel, Outlook), keyboarding and scripting. Candidate needs to be skilled in compiling and comparing information, researching, analyzing data and interpreting technical manuals to ensure best practice implementations are needed. Documentation skills are a must; thorough knowledge of Oracle RDBMS and related tools; basic knowledge of SQL database, Linux and shell scripting; security understanding (Microsoft active directory and or Oracle database), and understanding of virtual technology (VMware and or storage).
 

Education/Experience:

Preferred: Bachelor’s Degree in Computer Science or related field AND four (4) years of related IT experience, two (2) or more of those years should be focused on Data Architecture or Oracle RDBMS and its related tools. The IT experience includes in-depth knowledge of application development technologies, tools, and methodologies; ability to provide technical leadership and command respect at all levels of the organization. Other experience requested is a demonstrated ability to translate highly complex and ambiguous problems into actionable components. Specific experience in business analysis from the data perspective, and experience with blueprinting and developing conceptual, logical and physical data models at the enterprise level is desirable.

Other equivalent combinations of education and experience may be considered.
 

Supplemental Questions: None Required
Additional Materials Required:
  1. Transcripts