Tolling Senior MS SQL DBA

Ampcus, Inc; Mechanicsville (VA); Remoto; USD 110.000 - 150.000; Tempo pieno

Descrizione del lavoro

Ampcus, Inc is seeking an experienced Tolling Senior MS SQL DBA to join the Engineering and Operations team. The role will administer, maintain, and support SQL Server and cloud databases, ensuring uptime, performance, security, and reliability.

Responsibilities include help desk and application support within a collaborative team. The candidate will work on SQL Server 2022/2025+ versions, with failover clustering and HA configurations, and will engage in data modeling and Cloud SQL operations

Competenze

• 2+ years of experience with Microsoft SQL Server databases.
• 1+ year of experience with Azure, Snowflake, or Databricks; certs may be accepted in lieu of experience.
• Bachelor's degree or equivalent in computer science or related field.
• Experience with SQL Server clustering, mirroring, and high availability.

Mansioni

• Monitor databases to maintain uptime and availability.
• Troubleshoot connectivity, security, and operational issues.
• Tune long-running queries and optimize performance.
• Implement and maintain SQL Server installations and migrations.
• Support Azure cloud databases and cloud-based DB tasks.
• Provide help desk and application support as part of team rotation.
• Collaborate with engineering and operations to achieve project goals.
• Communicate effectively in writing and speech.

Conoscenze

MS SQL Server Database Management

SQL Server Tuning

SSIS/SSAS/SSRS

Transact-SQL

SQL Server HA / Failover Clustering

Formazione

Bachelor's degree in CS/IS or related field

Strumenti

Azure Cloud

Snowflake

Databricks

Windows Server

Descrizione del lavoro

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Tolling Senior MS SQL DBA

Location(s)

Mechanicsville, VA (Remote)

Job Summary

We are seeking an experienced SQL Server / Cloud Database Administrator to join the Engineering and Operations team. The selected candidate will administer, maintain, and support SQL Server and cloud databases, ensuring database availability, performance, security, and reliability. The role also includes help desk and application support responsibilities.

Responsibilities

• Monitor databases to maintain and ensure database uptime and availability.
• Troubleshoot application and database issues related to connectivity, access, security, and other operational concerns.
• Tune long-running SQL queries and optimize database performance.
• Review and refine existing database tasks and processes to align with team priorities.
• Utilize operating system scripting utilities to support database maintenance, diagnostics, and troubleshooting.
• Review existing database implementations and propose, execute, or direct necessary changes.
• Perform SQL Server installations, including versions 2022, 2025, and later, with failover clustering.
• Administer, maintain, support, and tune SQL Server databases.
• Support SQL clustering, mirroring, and high-availability configurations.
• Install, upgrade, patch, and migrate SQL Server databases.
• Work with large SQL databases and develop complex Transact-SQL queries.
• Support database operations on Windows platforms.
• Work with Azure Cloud and other cloud database technologies.
• Provide help desk and application support as part of the team rotation.
• Apply data modeling principles to database design and implementation.
• Collaborate with engineering and operations professionals to accomplish project goals.
• Communicate clearly and effectively, both verbally and in writing.

Required Qualifications

• At least 2 years of experience working with Microsoft SQL Server databases.
• 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.
• Demonstrated ability to communicate effectively using standard requirements and design artifacts.
• Experience with SQL Server clustering, mirroring, and high availability.
• Experience with large SQL databases and Transact-SQL.
• Experience tuning SQL Server databases.
• Experience installing, upgrading, patching, and migrating SQL Server databases.Experience working in a Windows environment.
• Ability to work independently, plan and accomplish goals, and manage complex tasks.
• Strong troubleshooting, analytical, and communication skills.

Preferred Qualifications

• Experience with SQL Server 2019 or later.
• Experience with Azure Cloud, Snowflake, and/or Databricks.
• Exposure to SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
• Knowledge of data modeling principles.
• Experience with SQL Server failover clustering and high-availability configurations.

Additional Requirements

• A fingerprint-based background check is required.The successful contractor must continue professional education at their own expense to remain current with applicable technologies.

Skills

• MS SQL Server Database Management, Required, 2, Years
• SQL Server Tuning, Required, 1, Years
• Experience working with SSIS, SSRS & SSAS, Desired, 1, Years
• Coding & debugging Transact SQL, Required, 1, Years
• Expertise in installing, upgrading, patching and migrating SQLServer databases, Required, 2, Years
• DB Administration on Azure Cloud, Snowflake, and/or Databricks, Nice to have, 1, Years

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.