Title: IT Database Administrator
Requisition Id: 2166
Salary: $56,400.00 - $70,392.00
Salary Grade: S10
Job Location: Conservation Headquarters (JEFFE1)
Closing Date: April 7, 2023
Our Culture: The Missouri Department of Conservation supports a family culture focused on diversity of thought, where all employees openly share ideas and turn their passion into purpose.
To learn more about the job, feel free to contact the hiring supervisor- Timothy M Bixler at timothy.bixler@mdc.mo.gov or at 573 5224115x3220.
Summary/Objective
Benefits Include: Paid vacation, sick leave and holidays, Health insurance, Flexible schedule, Employment development and training, Clothing allowance, State retirement plan, Employee Credit Union, Deferred compensation saving and investment plan, Tuition reimbursement, Cafeteria program, Paid life insurance, Paid accidental death and dismemberment insurance, Employee wellness and assistance programs, State Discounts.
The IT Database Administrator is responsible for maintaining and managing existing databases for the Department of Conservation statewide.
Essential Job Duties
- Monitor DBA helpdesk que, responsible for timely responses and resolutions of tickets.
- Diagnose and troubleshoot application database errors.
- Create, document, and administer extract, transfer, and load processes.
- Data Modeling, query building, View/Function/Procedure Programming ability.
- Develop and/or update architecture documents, ETL documents, and ERDs.
- Plan Effective strategic server and software upgrades that keep the enterprise GIS and SQL Servers and databases functioning at a high degree.
- Act as a liaison between IT and the business units to identify, define and document project requirements during application development process.
Ancillary Job Duties
- Aid in the planning, development, and implementation of data and metadata standards and protocols for all Department Divisions.
- Aid in the development and delivery of training courses related to database management systems and software.
- Stay current with trends in the information technology sector in general.
Education and Experience
- Bachelor’s Degree in Computer Science, Geographic Information Systems, Data Science, or related field.
- At least four (4) years of progressively responsible professional experience or similar managing Enterprise level database platforms.
- Must maintain a valid, current driver’s license.
- May need to work evenings and weekends.
Knowledge, Skills and Abilities
- Strong reading, writing, speaking, critical thinking, and problem-solving skills.
- Self-starter, excellent organizational and time management skills.
- Strong foundation in the TSQL language
- Solid understanding of ETL Tools such as SSIS, SFTP transfers etc.
- Understanding of records management, including data collection and analysis, metadata creation, and database maintenance.
- Understanding of computers, including use of Microsoft Office products and other productivity tools, analytics tools (SSRS, Tableau, etc.), ESRI products, and SQL Server is desirable.
- Ability to develop new insights into situations and apply innovative solutions that make improvements.
- Ability to accept change and new information and cope with job pressure and stress.
- Ability to make independent decisions and act quickly and decisively on the determined course of action.
- Ability to work effectively as a team member and assist in resolving conflicts.
- Ability to demonstrate good work habits including being dependable and efficient and meeting deadlines.
Work Environment
- Regularly work in a standard office environment.
Physical Abilities
- Remain stationary up to 70% of the time.
- Regularly communicate and exchange accurate information.
- Constantly operate a computer and other office productivity machinery.
- Clarity of vision at 20 inches or less.
- Regularly lift up to 5 pounds.
- Regular attendance is a necessary and essential function.
Disclaimer
This job description is not intended to be all-inclusive; an employee will also perform other reasonably related job responsibilities as assigned by immediate supervisor and other management as required. The Missouri Department of Conservation reserves the right to revise or change job duties as the need arises. This job description does not constitute a written or implied contract of employment. Management reserves the right to change job descriptions, job duties, functions, and requirements.
Exemption Status/Special Notes
This position has been determined to be Exempt according to the Fair Labor Standards Act. Employees must agree to accept compensatory time in lieu of cash payments in accordance with the Department's Compensatory Time Off and Overtime Policy.
Salaried and hourly employees are expected to use a mobile device-cellular phone for Department business, as needed.
MDC promotes a Tobacco-Free (smoke and smokeless) working environment.
The Department of Conservation will only hire United States citizens and aliens authorized to work in the United States. All new employees will be required to complete an "Employment Eligibility Verification" (Form I-9) and produce requested documentation after employment.
Candidates seeking initial employment or re-employment must submit to a drug screen following offer of employment.
All persons employed with the state of Missouri shall file all state income tax forms and pay all state income taxes owed.
Nearest Major Market: Jefferson City
Nearest Secondary Market: Columbia Missouri