Job ID: JOB_ID_3838
Job Description:
The role of a Database Administrator 3 is to provide essential Infrastructure DBA support for all SQL Server applications. This position is a replacement for an intermediate-level DBA who is leaving the team, ensuring continuity of support for large and complex applications, including several Tier 1 level applications supporting areas like the Bureau of Labs and Cancer Registry.
- Note: Local to MI. Local DL is a Must.
- Note: 10+ Years of Experience required.
- Location: Elliot Larsen Building 320 S Walnut St., Lansing, Michigan, 48933 (2 days a week: Mon, Tue)
- Projected End Date/Duration: 1 Year from projected start date, with possible extension.
- Hours/Week: 40
Key Responsibilities:
- Provide 24×7 software and hardware support for complex applications across multiple versions of SQL Server.
- Offer high availability and Disaster Recovery support, adhering to industry and DTMB development standards.
- Develop and submit plans for installation, patch management, maintenance, upgrades, and support for Database systems.
- Evaluate the impact of changes and new technologies, recommending solutions for persistent problems.
- Serve as Agency Services liaison to external consultants.
- Follow and enforce database standards, policies, and procedures.
- Research and draft guidelines within the boundaries of current policies and standards.
- Monitor space allocation across databases and perform adjustments in test and development environments as necessary.
- Calculate disk space requirements for existing and/or new installations.
- 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 strategies to release unused space or repair fragmentation in test and development environments.
- Execute scripts for creating and modifying database objects (tables, views, constraints, indexes, etc.).
- Monitor database back-ups to ensure recoverability and troubleshoot backup errors.
- Monitor database jobs and scheduled processes in development, test, and production environments, participating in troubleshooting.
- Monitor database environments for issues and problems with database functionality, connectivity, or downtime.
- Follow standards and guidelines for database space allocation based on best practices and business requirements.
Required Skills:
- 4+ years of Database administration specifically on SQL Server 16 and upwards.
- Expertise in HA and DR solutions.
- Experience with Transparent Data Encryption within SQL Server.
- Over 2+ years of experience creating, updating, and maintaining systems documentation.
Education:
A 4-year college degree (Bachelors) in Computer/Information Sciences/Technology. An associate degree may suffice for candidates with extensive experience.
Special Requirements
Local to MI. Local DL is a Must. Hybrid work schedule acknowledged and confirmed by candidate. Resumes kept to 4-5 pages. Video interview via MS Teams, potential second-round onsite interview.
Compensation & Location
Salary: $90,000 – $140,000 per year (Estimated)
Location: Lansing, MI
Recruiter / Company – Contact Information
Email: .sikarwar@stellentit.com
Recruiter Notice:
To remove this job posting, please send an email from
.sikarwar@stellentit.com with the subject:
DELETE_JOB_ID_3838