Job Title: SQL Server DBA & User Support Specialist  
Engagement Type: Part-Time Contract (0–20 hours/week estimated)
Location: Remote, English speaker
Reports To: CIO
Job #:  6769

Position Overview

We are seeking a hands-on SQL Server DBA & User Support Specialist to provide part-time remote support for a Microsoft-based data environment.

This role blends database administration, documentation, and end-user support. The ideal candidate is technically strong in Microsoft SQL Server, methodical in documenting systems architecture, and comfortable interacting directly with business users.

This is an execution-focused role — not strategy or enterprise architecture. You will support and maintain an existing SQL Server environment while improving documentation, user access governance, and operational clarity.

Core Responsibilities

1. SQL Server Administration

• Administer Microsoft SQL Server databases (on-prem or cloud-hosted)

• Manage database schemas, objects, and permissions

• Create, modify, and optimize tables, views, stored procedures, and indexes

• Monitor database performance and troubleshoot issues

• Perform user provisioning and deprovisioning

• Maintain backup/restore processes and data integrity

2. Database Documentation & Schema Mapping

• Document database structure, schema relationships, and dependencies

• Create visual database architecture diagrams using:

  • Microsoft Visio (preferred), or

  • Lucidchart, Draw.io, ER/Studio, or similar tools

• Identify and map:

  • Tables and key relationships

  • Data flows

  • Security roles and access controls

• Produce clear documentation for CIO-level review and future maintainability

3. User Access & Security Administration

• Add, modify, and remove database users

• Manage roles and permissions in SQL Server

• Audit user access periodically

• Maintain least-privilege principles

• Coordinate with IT leadership on governance standards

4. End-User Support

• Provide SQL-related user support

• Assist internal users with:

  • Query troubleshooting

  • Reporting data validation

  • Access issues

• Translate technical issues into business-friendly explanations

• Escalate structural concerns to the Fractional CIO when appropriate

5. Reporting & Communication

• Provide regular status updates to the Fractional CIO

• Maintain documentation repository

• Recommend improvements to structure, performance, or governance

• Flag risk areas (data redundancy, access exposure, schema inconsistency)

Required Technical Skills

• Strong experience with Microsoft SQL Server

• Proficiency in:

  • T-SQL

  • Stored procedures

  • Index optimization

  • Schema design

• Experience with:

  • SQL Server Management Studio (SSMS)

  • SQL Server security roles & permissions

• Ability to document systems visually (Visio or equivalent)

• Experience supporting business users directly

Preferred Qualifications

• Experience with:

  • Azure SQL / Microsoft Azure ecosystem

  • SQL Server Reporting Services (SSRS)

  • Power BI data sources

  • Microsoft Active Directory integration

• Prior experience reporting to a CIO or IT leadership

• Experience in a small-to-mid-sized business environment

• Exposure to data governance or compliance frameworks

Soft Skills

• Organized and documentation-oriented

• Clear communicator (written and verbal)

• Independent, self-directed work style

• Able to balance technical work with user-facing support

• Professional, responsive, and accountable

Engagement Details

• Part-time (estimated 10–20 hours per week)

• Flexible scheduling

• Remote work

• Contract engagement

• Hourly compensation commensurate with experience

Ideal Profile

This role is well-suited for:

• An experienced SQL DBA seeking flexible consulting work

• A mid-to-senior database professional who enjoys hands-on execution

• A technical professional comfortable wearing both DBA and support hats