SQL Database Administrator

Detroit IT; Troy (MI); On-site; USD 80,000 - 100,000; Part time

Job summary

Detroit IT is looking for a Sr. SQL Database Administrator based in Metro Detroit, MI. The role involves maintaining databases, solving SQL Server issues, and ensuring performance standards. Candidates should have a BS in IT or Computer Science and at least 3 years of experience in SQL Administration.

The ideal candidate will be proficient in T-SQL and have experience working with large databases. Responsibilities include setting up backups, creating stored procedures, and troubleshooting SQL Server outages.

Qualifications

• Minimum of 3 years’ experience as a SQL Server Database Administrator.
• Strong T-SQL and SQL Server skills.
• Experience working with large databases.

Responsibilities

• Experience setting up backups and recovery scripts.
• Troubleshoot SQL Server service outages.
• Ability to create stored procedures for maintenance.
• Experience with Mirroring, Logshipping, Service Broker, and Partitioning.
• Document the company’s database environment.

Skills

SQL Server Administration

T-SQL

Database Tuning

PowerShell

Education

BS in Information Technology or Computer Science

Job description

Job Description

Title: Sr. SQL Database Administrator

Location: Metro Detroit, MI

Duration: contract

Department: Information Systems

Job Summary:

The Database Administrator is responsible maintaining systems, tuning, aiding in design and solving database issues for systems running SQL server 2008 R2 and SQL Server 2012.

Job Responsibilities:

• Experience setting up backups and recovery scripts.
• Troubleshoot SQL Server service outages as they occur.
• Ability to create stored procedures to facilitate processing and maintenance.
• Experience working with very large databases.
• Ability to automate everyday tasks using stored procedures, PowerShell or other language.
• Experience with Mirroring, Logshipping, Service Broker, Partitioning, Change Data Capture, Clustering and other options for SQL Server.
• Understanding of tuning.
• Install and configure new SQL Server instances.
• When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
• Document the company’s database environment.
• SSIS experience for loading data into systems (ETL).
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).

Qualifications

• BS in Information Technology or Computer Science or equivalent experience.
• Minimum of 3 years’ experience as a SQL Server Database Administrator.
• Strong T-SQL and SQL Server skills.
• Experience working with large databases.