Tolling Senior Ms Sql Dba

Senior MS SQL Database Administrator SQL Server / Cloud

Location: Mechanicsville, VA (Remote)
Duration: 9+ months, with potential for extension or full-time conversion
Interview: Phone or in-person

We are seeking an experienced Senior MS SQL Database Administrator (DBA) to administer, maintain, and support Microsoft SQL Server and cloud database environments. The role involves database performance tuning, high availability, installation, upgrades, patching, migration, troubleshooting, and ongoing database operations. The selected candidate will also participate in application support and help desk activities as part of a team rotation.

• Administer, maintain, and support Microsoft SQL Server databases and cloud database environments.

• Monitor database performance, uptime, availability, and overall system health.

• Troubleshoot database and application issues involving connectivity, access, security, and performance.

• Perform SQL Server performance tuning, query optimization, and troubleshooting of long-running SQL queries.

• Install, upgrade, patch, and migrate SQL Server databases.

• Configure and support SQL Server high availability, failover clustering, mirroring, and related database infrastructure.

• Support SQL Server installations, including SQL Server 2022 and newer versions.

• Develop and maintain Transact-SQL (T-SQL) queries, scripts, and database maintenance procedures.

• Use operating system scripting utilities to support database maintenance, diagnostics, and troubleshooting.

• Review existing database implementations and recommend or implement improvements.

• Apply data modeling principles and maintain effective database structures.

• Support cloud database technologies, including Microsoft Azure, Snowflake, and/or Databricks.

• Assist with application support and help desk activities as part of a team rotation.

• Collaborate with engineering and operations teams and communicate technical findings clearly.

• At least 2 years of experience with Microsoft SQL Server database administration or support.

• At least 1 year of experience with Azure, Snowflake, or Databricks; a relevant certification may be accepted in lieu of experience.

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent skills, knowledge, and work experience.

• Experience working with SQL Server clustering, mirroring, and high-availability configurations.

• Experience with large SQL databases, T-SQL, performance tuning, installations, upgrades, patching, and migrations.

• Experience working in a Windows environment.

• Familiarity with database connectivity, access management, security, troubleshooting, and data modeling.

• Ability to work independently on complex technical tasks and collaborate with engineering and operations teams.

• Strong written and verbal communication skills.

• Ability to document technical requirements, designs, and database changes.

• Experience with SQL Server 2019 or newer.

• Exposure to SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).

• Experience with cloud database platforms, including Azure, Snowflake, and/or Databricks.

• Experience supporting database environments that use failover clustering and high-availability configurations.

• Fingerprint-based background check is required.

• Must be willing to complete ongoing professional education to maintain current technical knowledge.