5-7 years of experience in database administration with expertise in SQL Server and Sybase.
Strong understanding of database structure, design, and management.
Proficiency in maintaining database security and integrity according to industry standards.
Experience with database performance optimization and tuning.
Excellent problem-solving skills in high-pressure situations.
Ability to mentor and coach junior team members.
Responsibilities
Assist with the design and architecture of databases.
Provide support and maintenance for Sybase databases.
Install, configure, and upgrade Microsoft SQL Server software.
Monitor database security and ensure compliance with DTMB policies.
Proactively update and patch database servers to maintain security.
Conduct backups and coordinate database restores as needed.
Lead efforts to optimize database performance and efficiency through tuning.
Act as a subject matter expert for incident responses related to applications and solutions.
Benefits
Access to ongoing professional development opportunities.
Participation in a supportive and collaborative team culture.
Engagement in public service-focused projects.
Potential for flexible work arrangements.
Participation in on-call rotation for additional experience.
Full Job Description
About the job Database Administrator
The Department of Technology, Management and Budget supports the business operations of the state agencies through a variety of services including Information Technology project delivery, maintenance, and support. This position is with the Agency Services area of DTMB supporting the Michigan Department of Corrections (MDOC).
We are looking for a team-oriented person with a deep understanding of database administration (SQL Server and Sybase) to help support MDOC. Above all we are looking for someone that is passionate about public service, building positive team culture, being a leader, innovative, and adheres to industry best practices. This individual must be able to troubleshoot under difficult circumstances, lead highly complex projects, implement new policies and procedures, and maintain good rapport with agency staff at all levels.
The Database Administrator Specialist takes on the role of assisting with database structure and design, implementing, and maintaining the database environment, participating in enterprise efforts as needed, and ensuring compliance with security and integrity needs across the database environment.
Assist in data architecture and database design
Provide Sybase database support
Install, configure, and upgrade Microsoft SQL software
Database Security & Integrity
o Follow, implement, and maintain DTMB Security Practices, Policies, and Procedures.
o Maintain awareness of industry best practices.
o Innovate to provide customers with appropriately secured data environments.
o Ensure appropriate Access and Availability.
o Proactively monitor and ensure all database servers are current in all patches and security updates.
Database backups and restores
Database performance optimization/tuning
Application/solution incident response SME
Provide audit responses
Drive efforts to develop team processes/procedures
Provide coaching and mentoring to junior database administrators
