Database Administrator

Job Location:

• The office for this position is located at the Department of Labor, 421 E. Dunklin Street Jefferson City MO, 65109.

Why you’ll love this position:

Join our close-knit team supporting the Department of Labor and Industrial Relations!

As an application database administrator, you will be building and maintaining objects (such as tables, sequences, procedures, triggers, functions, etc.) in database systems and ensuring data security. Your role will also entail troubleshooting issues in our applications as related to the database and providing quick resolutions. The ideal candidate will be able to work individually as well as collaborate with developers, system admins, and end-users to maintain databases.

This position is with the Office of Administration, Information Technology Services Division (OA-ITSD), supporting the Department of Labor and Industrial Relations (DOLIR).

ITSD Core Values - We Innovate and Partner with Passion, Respect, and Integrity, United as #OneTeam.

• Identify and implement database requirements for new or existing applications by working collaboratively with other teams.
• Support users and developers by resolving data-related technical issues and troubleshooting queries by guiding them with best practices.
• Provide technical direction and guidance in designing, developing, and tuning of SQL for extracting data, inserting data, altering data, creating and or altering data structures, and improving performance.
• Perform database refreshes when necessary.
• Review and ensure database-related items conform to standards.
• Analyze data in the database to ensure data integrity.
• Execute regular database maintenance tasks, including database defragmentation and database replication.
• Create and update relevant documentation, such as data dictionaries, database objects, and user manuals.

• Bachelor's degree in Computer Science, Information Technology, or a related field (experience may be substituted).
• 3-5 years of experience in database administration or in a similar role.
• Experience in database backup, disaster recovery planning, performance optimization, and data security.
• Knowledge of database management systems such as MySQL, SQL Server, and DB2.
• Knowledge of Postgres and non-relational database management systems is a plus.
• Successful background check results are required for employment in this position. This may include background checks involving a candidate’s name and/or fingerprints and other screenings as needed for the specific position.

Lack of post-secondary education will not be used as the sole basis denying consideration to any applicant.

Knowledge of data modeling and design. Ability to think methodically and critically. Ability to identify, evaluate, and resolve database performance issues. Ability to organize work assignments and multi-task.

The classification for this position is Data Analyst : click for more information.

The State of Missouri offers an excellent benefits package that includes a defined pension plan, generous amounts of leave and holiday time, and eligibility for health insurance coverage. Your total compensation is more than the dollars you receive in your paycheck. To help demonstrate the value of working for the State of Missouri, we have created an interactive Total Compensation Calculator. This tool provides a comprehensive view of benefits and more that are offered to prospective employees. The Total Compensation Calculator and other applicant resources can be found here .

If you have questions please contact: ITSDRecruiting@oa.mo.gov

• 

• State of Missouri

Show more