Job Description

Position : SQL Server DBA
Location : Lansing, MI (Hybrid)
Duration : 12 months of contract (Possible to Ext.)

Description:

Top Skills & Years of Experience:

• 4+ years of Database administration specifically on SQL Server 16 and upwards
• Expertise in High Availability (HA) and Disaster Recovery (DR) solutions
• Experience with Transparent Data Encryption within SQL Server
• Over 2+ years of experience creating, updating and maintaining systems documentation

Core Responsibilities:

• Database Management: Installing, configuring, and upgrading SQL Server database systems.
• Performance Optimization: Tuning database performance, optimizing queries, and managing indexes.
• Security: Managing user access, permissions, and implementing security policies.
• Backup and Recovery: Implementing and maintaining backup and recovery strategies for data protection.
• Monitoring: Monitoring database health, performance, and availability.
• Troubleshooting: Diagnosing and resolving database-related issues.
• Documentation: Creating and maintaining documentation for database configurations and procedures.
• Collaboration: Working with developers and other IT professionals to support database needs.

Specific Tasks:

• Database Design and Implementation: Assisting in the design and implementation of new databases, including schema design, and creating database objects like tables, views, and stored procedures.
• High Availability and Disaster Recovery: Implementing solutions like Always On Availability Groups or clustering for high availability and disaster recovery.
• Capacity Planning: Monitoring database growth trends and planning for future capacity needs.
• Automation: Developing and maintaining scripts for automating routine database tasks.
• Patch Management: Applying SQL Server patches and updates to keep the system secure and up-to-date.
• Security Auditing and Compliance: Ensuring the database environment adheres to security policies and regulations.
• Reporting: Generating reports and visualizations related to database performance and usage.

In essence, this position acts as a gatekeeper for the organization's data, ensuring its integrity, accessibility, and security within the SQL Server environment.

Job Tags

Similar Jobs