Highlights
Skill Required / Desired Amount of Experience Expertise Rating Move MS SQL Server Database Management Required 6 Years SQL Server Tuning Required 3 Years Upgrading E-ZPass tolling databases Required 2 Years Diagnosing and resolving deadlocks and blocking in Tolling production workloads Required 3 Years Tuning Very Large Databases (2 TB+) including index optimization, long-running workload analysis, and minimizing resource contention Required 2 Years Experience working with SSIS, SSRS & SSAS Required 3 Years Coding & debugging Transact SQL Required 1 Years Expertise in installing, upgrading, patching and migrating SQLServer databases Required 4 Years DB Administration on Azure Cloud, Snowflake, and/or Databricks Nice to have 1 Years . Minimum 3–4 years of hands-on experience upgrading SQL Server tolling environments from SQL Server 2012 to SQL Server 2019, including compatibility evaluations, Query Tuning Assistant, and Database Migration Assistant.
Numbers & Facts
| Location | Mechanicsville, VA |
| Industry | Staffing/Employment Agencies |
| Company Size | 500 to 999 employees |
| Website | http://www.ampcus.com |
Description
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: Senior MS SQL Database Administrator
Location(s): Mechanicsville, VA
(Hybrid)
Job Summary
The SQL Server / Cloud DBA will join the Tolling Engineering and Operations Team to administer and support SQL Server and cloud databases. The role also includes help desk and application support responsibilities as part of a rotation with the team.
Key Responsibilities
- Administer and support SQL Server and cloud databases.
- Monitor databases to maintain and ensure database uptime and availability.
- Troubleshoot application/database issues related to connectivity, access, security, etc.
- Tune long-running SQL.
- Review and refine existing database tasks and processes to better align with team priorities.
- Leverage and utilize O/S scripting utilities in support of database maintenance, diagnosis, and support.
- Review existing database implementations and propose, execute, and/or direct necessary changes.
- Perform SQL Server installations, including SQL Server 2022 and 2025+ with failover clustering.
- Support SQL Server databases, including administration, support, and tuning.
- Work with SQL clustering, mirroring, and high availability.
- Work with large SQL databases.
- Write Transact-SQL.
- Install, upgrade, patch, and migrate SQL Server databases.
- Work on a Windows platform.
- Apply data modeling principles.
- Work with Azure Cloud.
- Support technologies including SSIS, SSAS, and SSRS.
- Work with Engineering and Operations professionals.
- Communicate clearly and effectively, both verbally and in writing.
- Independently perform a variety of complicated tasks using experience and judgment to plan and accomplish goals.
Required Qualifications
- At least 6 years of experience with Microsoft SQL Server databases.
- At least 1 year of Azure, Snowflake, or Databricks experience. A certification is acceptable in lieu of experience.
- Master’s degree in computer science, information systems, or other applicable and/or equivalent skills, knowledge, and/or work history.
- Demonstrated experience communicating effectively using standard requirements and design artifacts.
- Minimum 3–4 years of hands-on experience upgrading SQL Server tolling 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 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 DBA.
- Expertise with SQL clustering, mirroring, and high availability.
- Experience tuning SQL Server databases.
- Expertise installing, upgrading, patching, and migrating SQL Server databases.
- Experience working on a Windows platform.
- Experience working with Azure Cloud.
Preferred Qualifications
- Experience with SQL Server 2019+.
- Experience with cloud databases, including Azure, Snowflake, and/or Databricks.
- Exposure to SSIS, SSAS, and SSRS.
- Knowledge of data modeling principles.
Additional Requirements
- Fingerprint-based background check required.
- Contractor must continue education at their own expense to stay current with required technologies.
- Candidates must physically reside within the United States for the duration of the assignment.
- Offshore IT contractors are not permitted.
- Candidate must be available for both webcam and in-person interviews.
Skills:
| Skill | Required / Desired | Amount | of Experience | Expertise Rating | Move | |
| MS SQL Server Database Management | Required | 6 | Years | |||
| SQL Server Tuning | Required | 3 | Years | |||
| Upgrading E-ZPass tolling databases | Required | 2 | Years | |||
| Diagnosing and resolving deadlocks and blocking in Tolling production workloads | Required | 3 | Years | |||
| Tuning Very Large Databases (2 TB+) including index optimization, long-running workload analysis, and minimizing resource contention | Required | 2 | Years | |||
| Experience working with SSIS, SSRS & SSAS | Required | 3 | Years | |||
| Coding & debugging Transact SQL | Required | 1 | Years | |||
| Expertise in installing, upgrading, patching and migrating SQLServer databases | Required | 4 | 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.
About Company
Ampcus Inc is a global technology and business consulting firm specializing in Digital Transforrmation, Big Data, Analytics, Cyber Security, Testing, IV&V, Infrastructure Management and Enterprise Solutions. Ampcus Inc is an SBA 8(a) certified Women and Minority Owned global Provider of broad range of consulting Services. From strategy to execution, our disciplined yet flexible approach starts and ends with our clients. By listening hard and working harder, their goals become our goals. We are an ISO 9000, ISO 20000, ISO 27000 and CMMi Level certified company.
Ampcus consultants have significant business, engineering and technology experience. Our consultants have over 20 years of business experience and an average of over 10 years of engineering and technology experience. This means that the project teams understand how systems work and how the technology impacts the business processes of organizations.
We believe that success of an engagement is determined by strong project management, clear communication and mutual commitment working collaboratively. Our methodology begins by listening to the customer needs, then working with their teams to gain a clear understanding of the requirements, while providing a knowledge transfer of best practices for the organization. As a recognized leader providing customized software services, management and engineering solutions to companies around the world, our ability to deliver is a "granted" that makes companies put their trust in us to answer their day-to-day business challenges and put them on a path for greater success. We are the choice for our clients because we look at our clients business from a growth perspective.
Industry: Information Technology and Services
Specialties: Digital Transformation, Big Data and Analytics, Infrastructure Management Services, Testing and IV&V, Cyber Security, Active Directory and E-mail Infrastructure, Project Management, Training, and ERP, CRM. EAI, BI