Database Administrator 3 #3156362

Lansing, IL - USA

Monthly Salary: Not Disclosed

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Title: Database Administrator 3

Duration: 1 year with possible extension (NO C2C)

Location: Lansing Michigan

Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY
OPTION. Will need to be onsite from day 1 two days a week. (Mon & Tues)

Other Info:

Position Justification

(Why this resource is being procured and which MDHHS
applications/projects/other areas this resource will be working on) The
position is responsible for providing Infrastructure DBA support for all
SQL Server applications and it is replacement for an intermediate Level
DBA leaving the team. The intention is to fill this position in the gap
between the incumbent DBA leaves and the position is backfilled which
will take several months. We cannot afford not having a resource for
large and complex application that we support and in that there are
several Tier 1 level applications that belong in the Bureau of Labs
Cancer Registry etc.

Position Summary

(Detail Position Summary in Bullet Point or Descriptive Statement) As
an intermediate-level Database Administrator the resource participates
in 24x7 software and hardware support for complex applications in
several versions of SQL Server with high availabilty and Disaster
Recovery support following industry and DTMB development standards.
Helps develop and/or submit for approval plans for installation patch
management maintenance upgrades and support for the Database systems.
Evaluate impacts of change and new technology recommend solutions to
persistent problems and serves as Agency Services liaison to external
consultants.

Individual tasks related to the duty:

- Follow and enforce database standards policies & procedures.
Research and draft guidelines within the boundaries of current
policies and standards.

- Monitor space allocation across databases. perform adjustments in
test and development environments as necessary and as prescribed by
predefined standards/guidelines.

- Calculate disk space requirements for existing and/or new
installations of existing business needs

- Modify DBMS parameters based on capacity changes.

- Configure and execute database integrity checks.

- Monitor for database integrity checks.

- Install database base management software for development and test
environments.

- Install database patches and service packs for development and test
environments.

- Monitor and support clustered database environments.

- Monitor and support database replication and backup environments.

- Implement the strategy to release unused space or repair
fragmentation in test and development environments.

- Execute (run) scripts provided by Systems Analysts or Database
Architect/Designer for creating and modifying database objects
(tables views constraints indexes etc.)

- Monitor database back-ups to ensure recoverability. Troubleshoot
backup errors.

- Monitor database jobs and scheduled processes in development test
and production environments. Participate in troubleshooting.

- Monitor database environments (using alert logs trace files alert
mechanisms and other tools) for issues and problems with database
functionality connectivity or downtime.

- Follow standards and guidelines for database space allocation based
on best practices and implementation considerations based on
business requirements.

Skill Descriptions

(8-10 or more Required/Desired/Nice to Have skills in Bullet Points
identified by their ranking)

4 years of Database administration specifically on SQL Server 16 and
upwards.

Expertise in HA and DR solutions.

Transperatn Data Encryption within SQL Server.

Over 2 years of experience creating updating and maintaining systems
documentation.

Required Skills:

DBMSSQL SERVER