Information Technologist I-IV

Job Posting Number: 
6246-18
Opening Date: 
2/7/2018
Closing Date: 
2/22/2018
Job Location: 
Jefferson City - Cole County
Merit Type: 
Merit
Salary Range: 
$1,274.00 – $2,720.00 semi-monthly
Benefits: 
Position receives State benefits including health care, retirement, and vacation
IT Specialty: 
Database Administration
Required Skills: 
DB2
LINUX
SQL

To Apply

Send Resume, cover letter, complete transcripts and DD214 (if applicable) to: 

Human Resources Service Center

301 West High Street
Harry S Truman Building, Room 430
Jefferson City, MO 65101
opportunities@oa.mo.gov
Essential Functions and Responsibilities: 

This position requires a beginning, intermediate, or semi-advanced level of technical knowledge and skills of an Application DBA using IBM DB2 Linux/Windows. This position is responsible for understanding business needs, database design and modifications, writing and maintaining stored procedures, maintaining and executing ETL packages, performance tuning and indexing, SQL script creation, review, and tuning, and database documentation.
 

Job Knowledge, Skills, and Abilities: 

Comprehensive knowledge of IBM DB2 DBMS, Operational Data Store (DB2 Advance), IBM Data Studio, DB2 tools, Toad, SQuirreL, Embarcadaro, SQL, Database Monitoring (Splunk), with core competencies in data modeling, normalization vs. de-normalization, SQL coding, testing, and tuning, use of performance monitoring tools, extract, transform, load (ETL), stored procedures, triggers, functions, source code management, and impact analysis.

Important Information

Applicants must meet the following qualifications: 
Information Technologist I
Information Technologist II
Information Technologist III
Information Technologist IV

NOTE: YOU MUST INCLUDE A COPY OF YOUR MOST CURRENT TRANSCRIPTS, resume, and email to address provided.

Please include the job posting number when applying for this position.

Review the required skills and qualifications before applying for this position.

Applicants need to be eligible to work in the United States.

Information Technologist I-IV

Source URL: https://oa.mo.gov/job-opportunity/6246-18/information-technologist-i-iv