Previous Job
Previous
MDOS - Database Administrator 3
Ref No.: 18-55608
Location: Lansing, Michigan
Start Date: 08/03/2018
Status New
Position # 571452
Position MDOS - Database Administrator 3
Client & Department State of Michigan- MDOS
Worksite Address Dimondale, MI 48821
Tenure 12+ Months
No. of Openings 1 (INTERVIEW TYPE: Either Webcam or In Person)
No. of submittals 2










There is no direct public transportation to this location. Candidate must have their own vehicle.
Contractor must have a valid US Driver's License and must obtain a valid Michigan Driver's License within 30 days of start of work assignment.
In-person Interviews preferred - please only submit candidates who can interview on Monday, August 13th

SKILL MATRIX:
Skill Required / Desired Amount of Experience Candidate Experience Last Used
Experience as a SQL DBA on a large scale database. Required 5 Years
Experience working with SQL database used by both front end web application and thick client. Required 5 Years
Experience with SSIS and SSRS Required 5 Years
Experience in database performance tuning. Required 5 Years
Experience monitoring SQL databases, developing databases, troubleshooting issues, and setting databases up Required 5 Years
DBA role - not developer - for greater than 5 years Required 5 Years

SHORT DESCRIPTION: This position is for one Database Administrator to support current MDOS DBA work.

COMPLETE DESCRIPTION: This analyst is responsible for the logical design and physical implementation of the applications, backups, disaster recovery, space allocation, object design and all other areas of database design, implementation, maintenance and construction. This includes database software configuration, database software installation and upgrades and supporting procedures and utility programs that run on servers for data processing and database updates. This position analyzes business processes and designs solutions through data modeling, process modeling, and event modeling techniques. They review requirements, design documents and write design documents when necessary.

They will work with program/project managers, development managers, team leads and business area experts to provide estimates. This position will work closely with the Software Architect, Project Management, other database administrators (DBA)'s, Software Developers and Quality Assurance (QA) to coordinate product releases, data structure evolution, capacity planning and forecasting.

They will be responsible for upgrading Structured Query Language (SQL) databases and applications to next supported level and move the applications and databases to the next levels, diagnose database and application performance issues and coordinate resolution with tech personnel, programming analysts, & software designers. This position will support multiple applications using a SQL/Server Database. MDOS has several red card applications that depend on SQL Server databases to be functioning correctly. There are vendor systems that the State hosts the SQL database – this position will work with vendors from time to time on support of their databases.