SQL Server DBA

Overview

Hybrid
Depends on Experience
Contract - W2
Contract - 12 Month(s)

Skills

Database Administration
Microsoft SQL Server DBA
Regulatory Compliance
Scripting
Stored Procedures
High Availability
Management
Microsoft SQL Server
Performance Tuning
Database
Database Design
Disaster Recovery
Documentation
Encryption
Auditing
Backup
Capacity Management
Clustering
Collaboration
Data Security
Accessibility
Recovery
System Documentation

Job Details

Title: SQL Server DBA

Location: Dimondale, MI(Hybrid)

Duration: 12+ Months

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

Candidate must be available for an in-person interview for 2nd round

Required Skills

Skill Type

Skill Name

Certification Education License Other Skill

Bachelor's degree required

Certification Education License Other Skill

4+ years of Database administration specifically on SQL Server 16 and upwards

Certification Education License Other Skill

Expertise in High Availability (HA) and Disaster Recovery (DR) solutions

Certification Education License Other Skill

Experience with Transparent Data Encryption within SQL Server

Certification Education License Other Skill

Over 2+ years of experience creating, updating and maintaining systems documentation

Job Description:
Looking for a SQL Server DBA (Database Administrator) to manage and maintain SQL Server database systems, ensuring their performance, security, and availability. Also handle tasks like installation, configuration, monitoring, backup, and recovery, while also addressing performance tuning, security, and user access.
Here's a more detailed breakdown of a this position s responsibilities:
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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About Trilogy International, Inc