A

Arthur Grand Technologies

Senior Microsoft SQL Database Administrator

Database AdministrationConfirmed live in the last 24 hours
Full-timeRichmond, VA, USANo salary listed

About the Job

Requirements

  • At least 6 years of experience with Microsoft SQL Server databases.
  • At least 1 year of experience with Azure, Snowflake, or Databricks; a certification is acceptable instead of experience.
  • A master’s degree in computer science, information systems, or another applicable field, or equivalent skills, knowledge, or work history.
  • Demonstrated experience communicating effectively using standard requirements and design artifacts.
  • At least 3–4 years of hands-on experience upgrading E-ZPass Virginia Tolling SQL Server environments from SQL Server 2012 to SQL Server 2019, including compatibility evaluations, Query Tuning Assistant, and Database Migration Assistant.
  • Experience diagnosing and resolving deadlocks and blocking in tolling production workloads, including extended events, Query Store, and wait statistic analysis.
  • Experience tuning very large databases (2 TB+), including index optimization, long-running workload analysis, and minimizing resource contention.
  • Expertise working as a SQL Server database administrator.
  • Expertise with SQL clustering, mirroring, and high availability.
  • Experience working with large SQL databases.
  • Expertise writing Transact-SQL.
  • Experience tuning SQL Server databases.
  • Expertise installing, upgrading, patching, and migrating SQL Server databases.
  • Experience working on a Windows platform.
  • Exposure to SQL Server Integration Services, SQL Server Analysis Services, and SQL Server Reporting Services.
  • Experience working with Azure Cloud.
  • Knowledge of data modeling principles.
  • Ability to continue education at personal expense to stay current with VDOT technologies.
  • Ability to pass a fingerprint-based background check.

Responsibilities

  • Administer and support SQL Server and cloud databases for the Tolling group, with help desk and application support responsibilities in rotation.
  • Monitor databases to maintain uptime and availability.
  • Troubleshoot application and database issues related to connectivity, access, and security.
  • Tune long-running SQL.
  • Review and refine existing database tasks and processes to better align with agency and group priorities.
  • Use operating-system scripting utilities to support database maintenance, diagnosis, and support.
  • Review the existing database implementation and propose, execute, or direct necessary changes.
  • Perform SQL Server installations, including SQL Server 2022 and later with failover clustering.
  • Support SQL Server databases through administration, support, and tuning.
  • Plan and accomplish goals using experience and judgment, and independently perform a variety of complicated tasks.
  • Work with a team of engineering and operations professionals.
  • Communicate clearly and effectively, both verbally and in writing.

Desired Qualifications

  • Knowledge of SQL Server 2019 or later.
  • Experience with cloud databases such as Azure, Snowflake, or Databricks.

About the Company

Company size
Not listed
Company stage
Not listed
Total funding
Not listed
Headquarters
Not listed
Founded
Not listed

Recently Posted Jobs

Explore more opportunities at Arthur Grand Technologies

See more jobs