Microsoft SQL Server Database Administrator

Job Description

Job Responsibilities:

The services provided will involve maintaining and/or creating the agency systems, Payroll and other databases as required.

The database administrator consultant is required to have professional working experience at an advance level to carry out the following job duties.

Working experience using Microsoft SQL 2012 through SQL 2017 environment.

Microsoft Clustering Services

Installation and Configuration

Operating system and interoperability

Regular maintenance

Backups and disaster recovery

Troubleshooting

Security

Performance optimization and tuning

Databases and objects administration

Scheduled jobs (tasks) management

Create Triggers

Data transfers and replication management

Design and development

Create & Review Stored Procedures for efficiency

Create Tables on production server

Create DTS\SSIS Packages

Adding fields to tables on production server

Bulk copy

Data Conversion

Data Transfer

Data Cleansing

Software Upgrade

Data Archiving

Create data dictionary

Create & Modify Data model

Documentation

Transactional Replication

Source Control, SQL Prompt & SQL Compare

Ensure proactive monitoring of the database systems to ensure secure services with minimum downtime.

Flexible work from home options available.

Full-time

Hybrid remote