Job ID: MI-138739 (97190108)
Hybrid/Local SQL Server Admin/DBA (15+) with HA/clustering, DR, Encryption, replication, backup experience
Location: Lansing, MI (DTMB)
Duration: 12 Months
Position: 1
Skills:
• 5+ years of Database administration specifically on SQL Server 16 and upwards.
• 3+ years of experience creating, updating and maintaining systems documentation.
• Expertise in HA and DR solutions.
• Transparent Data Encryption within SQL Server.
Description:
As a Database Administrator, the resource, participates in 24×7 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
Updated MI Cover Sheet (1).docx