Tolling Senior MS SQL DBA

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.

Job Title: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 versionsand 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.
• Bachelors 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: