Certified SQL server Database Administrator - HYBRID (Local MI candidates ONLY)

Job Description:

***Crop to Crop resumes are accepted
Location Requirement: Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1, two days a week. Onsite days are Wednesdays and Thursdays

Local candidates ONLY. Candidates must be located within 2 hours of Lansing, MI at time of submission

Relies on experience and judgment to plan and accomplish goals, independently performs a variety of complicated tasks, a wide degree of creativity and latitude is expected.

Roles and Responsibilities :

SQL & PL/SQL Development

• Provide advanced SQL and PL/SQL coding expertise, including writing and optimizing functions, procedures, and packages.
• Review, analyze, and test code written by others to ensure performance, scalability, and adherence to best practices.
• Support application developers with SQL design and data access strategies.

Database Architecture & Design

• Collaborate with the Information Technology Solutions Architect to design robust database solutions that support enterprise applications and system interfaces across diverse platforms.
• Lead the development and enforcement of database policies, procedures, and standards related to stored procedures, packages, and functions.
• Plan and design database hosting architecture in alignment with State standards, strategic direction, and business requirements.
• Provide technical leadership in the design and management of physical database structures to ensure optimal performance and scalability.

Database Administration & Maintenance

• Install, configure, and maintain SQL Server instances across development, test, and production environments.
• Perform regular backups, restores, and recovery testing to ensure data integrity and availability.
• Monitor and maintain database performance, availability, and security using tools such as SSMS, SQL Server Agent, and third-party monitoring solutions (e.g., SolarWinds, Redgate, Idera).
• Manage indexes, partitions, statistics, and schema parameters to support peak performance.
• Apply patches, updates, and version upgrades as needed.

Monitoring, Troubleshooting & Support

• Proactively identify and resolve performance bottlenecks and system alerts.
• Analyze logs, trace data, and performance metrics to diagnose and resolve issues.
• Collaborate with IT and DevOps teams to ensure server stability and uptime.
• Oversee the creation and validation of physical database components (e.g., tables, indexes, triggers, constraints) and coordinate initial server and file system setup.

Data Integrity, Security & Governance

• Implement and manage user roles, permissions, and access controls.
• Ensure compliance with data security policies, standards, and industry best practices.
• Participate in disaster recovery planning and high availability strategies.
• Develop and enforce database models, access controls, and documentation standards.
• Work with data warehouse teams to support data transfer and transformation processes.

Top skills needed:

• Strong proficiency in T-SQL and PL/SQL, with expertise in query optimization and performance tuning.
• Experience with SQL Server Management Studio (SSMS), SQL Server Agent, and monitoring tools such as SolarWinds, Redgate, or Idera.
• Solid understanding of database security, backup strategies, recovery models, and high availability configurations.
• Familiarity with ETL processes, PowerShell scripting, and/or Azure SQL is a plus.
• Proven ability to enforce development standards across teams.
• Soft skills: Communication

Required Skills:

• SQL: 10 Years
• PowerShell: 6 Years
• Azure DevOps: 6 Years
• Scrum: 6 Years

Desired Skills:

• Someone with a combination of DBA, architect, and developer experience is a plus.