SoHo Dragon
SoHo Dragon
SoHo Dragon is a technology consulting firm that helps organizations implement, manage, and modernize Microsoft-based systems and cloud environments. Its work spans SharePoint migrations, Dynamics 365 applications, Azure solutions, cybersecurity assessments, and AI-enabled process improvement. Through advisory services, managed support, and IT infrastructure expertise, the company helps clients strengthen governance and compliance while improving the performance of their digital operations.

Senior SQL Server and Cloud Database Administrator – Virginia Hybrid Contract

Expert database administrator supporting VDOT’s tolling environment across SQL Server and cloud platforms. The role covers administration, performance tuning, migrations, and high-availability operations.

Description

  • Support VDOT’s tolling environment
  • Administer, monitor, tune, patch, and migrate SQL Server and cloud databases
  • Maintain database uptime, performance, and availability
  • Investigate and resolve deadlocks, blocking, and performance problems with Extended Events, Query Store, and wait statistics
  • Install, upgrade, patch, and migrate SQL Server instances, including SQL Server 2012 to 2019 upgrades
  • Tune very large databases exceeding 2 TB and optimize indexes to reduce resource contention
  • Configure and maintain clustering, mirroring, and high-availability environments
  • Develop, troubleshoot, and optimize T-SQL
  • Provide support for SSIS, SSAS, and SSRS
  • Work with Azure and other cloud-based data platforms
  • Partner with Engineering and Operations teams to resolve production issues
  • Participate in help desk and operational rotation support

Requirements

  • Must be based in Virginia
  • Previous experience supporting state or federal clients
  • At least 6 years of expert-level Microsoft SQL Server DBA experience
  • 3–4 years of hands-on experience upgrading E-ZPass Virginia tolling environments from SQL Server 2012 to SQL Server 2019
  • Strong background in clustering, mirroring, high availability, and very large databases exceeding 2 TB
  • Proficiency with T-SQL, Extended Events, Query Store, DMA, and Query Tuning Assistant
  • At least 1 year of experience with Azure, Snowflake, or Databricks; a relevant certification may substitute
  • Experience supporting SSIS, SSAS, SSRS, and Windows platforms
  • Understanding of data modeling principles
  • Master’s degree in computer science, information systems, or a related field, or equivalent experience

Benefits

  • 12-month contract

Related Jobs

Kreato Global | BPO and Language Solutions

Remote English-Spanish OPI/VRI Interpreter

Kreato Global | BPO and Language Solutions
201 – 500 Employees
HealthcareHospitalityLogistics

Interpret remotely between English- and Spanish-speaking people in medical, financial, social service, and customer care settings. Provide language support for Kreato Global across Latin America.

Open
SPERTON - Where Great People Meet

Sales Executive, Elevators and Car Parking Systems

SPERTON - Where Great People Meet
51 – 200 Employees

Drive elevator and car parking system sales across Mumbai’s Western Region. Build client and dealer relationships, and manage deals from initial enquiry through project execution.

Open