Senior MS SQL Database Administrator

Senior MS SQL Database Administrator

All IT Solutions

United States · Mechanicsville, VA

Workplace Type — On-site

Employment Type — Contract

We are currently seeking a qualified Senior MS SQL Database Administrator to support this engagement. Please review the complete requirements, work location, employment type, and screening questions before applying. Candidates whose experience closely matches the position will be contacted directly by the AIS recruiting team.

Job Summary

All IT Solutions is seeking a Senior MS SQL Database Administrator to join a client engagement.

Responsibilities

• The client is seeking a SQL Server database /Cloud database administrator to join the Tolling Engineering and Operations Team.
• The selected candidate will administer and support SQL Server and cloud databases in the Tolling group.
• Additional help desk and application support responsibilities will be part of rotation with the Tolling team
• SQL Server 2019+
• Cloud databases (Azure, Snowflake, and/or Data bricks)
• Expertise working as a SQL Server DBA
• Expertise working with SQL clustering, mirroring and high availability
• Monitor databases to maintain/ensure database up time and availability
• Troubleshoot application/database issues related to connectivity, access, security, etc
• Tune long running SQL
• Review & refine existing database tasks and processes to better align with agency/group priorities
• Leverage & utilize O/S scripting utilities in support of database maintenance/diagnosis/support
• Review the existing database implementation and propose, execute, and/or direct necessary changes
• Perform SQL Server installations (2022,2025+ w/failover clustering)
• Support SQL Server databases (administration, support, tuning)
• Knowledgeable of data modeling principles
• Independently perform a variety of complicated tasks
• Work with a team of Engineering and Operations professionals
• Communicate clearly and effectively, both speaking and in writing

Required Qualifications

• The successful candidate will be required to continue education at own expense to stay current with client technologies
• Expertise in writing Transact SQL
• Expertise in installing, upgrading, patching and migrating SQL Server databases
• Exposure to SSIS, SSAS, & SSRS
• Master’s degree in computer science, information systems or other applicable and/or equivalent skills, knowledge and/or work history
• MS SQL Server Database Management: 6 Years
• SQL Server Tuning: 3 Years
• Upgrading E-Z Pass tolling databases: 2 Years
• Diagnosing and resolving deadlocks and blocking in Tolling production workloads: 3 Years
• Tuning Very Large Databases (2 TB+) including index optimization, long-running workload analysis, and minimizing resource contention: 2 Years
• Experience working with SSIS, SSRS & SSAS: 3 Years
• Coding & debugging Transact SQL: 1 Years
• Expertise in installing, upgrading, patching and migrating SQL c-Server databases: 4 Years
• At least 1 year of Azure, Snowflake, or Data bricks experience
• Demonstrated experience in communicating effectively using standard requirements and design artifacts
• Minimum 3–4 years hands-on experience upgrading E-Z Pass Tolling SQL Server environments from SQL 2012 to SQL 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 statistical analysis
• Experience tuning Very Large Databases (2 TB+) including index optimization, long-running workload analysis, and minimizing resource contention
• Experience working with large SQL databases
• Experience tuning SQL Server databases
• Experience working on a Windows platform
• Experience working with Azure Cloud
• Rely on experience and judgment to plan and accomplish goals

ABOUT ALL IT SOLUTIONS LLC

Headquartered in Mount Laurel, New Jersey, All IT Solutions LLC is a technology and workforce solutions company serving government and commercial organizations throughout the United States. AIS provides IT staffing and staff augmentation, cybersecurity, IT consulting, custom software development, cloud services, data engineering, artificial intelligence, application development, and related technology solutions.

AIS is an NMSDC/EMSDC-certified Minority Business Enterprise and an NYC Department of Small Business Services-certified M/WBE. We participate in E-Verify and are committed to maintaining professional, transparent, and compliant hiring practices.

EQUAL EMPLOYMENT OPPORTUNITY

All IT Solutions LLC is an equal opportunity employer. Employment decisions are made based on qualifications, merit, performance, and legitimate business requirements without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, military or veteran status, or any other characteristic protected by applicable federal, state, or local law.

Reasonable accommodations are available to qualified applicants with disabilities during the application and interview process.

RECRUITMENT NOTICE

All IT Solutions LLC is a staffing and technology services company and may receive fees or compensation from client organizations for recruiting, staffing, placement, or workforce services. Candidates are never charged an application, recruitment, placement, or interview fee by All IT Solutions LLC.

Any commercial rates, fees, or staffing arrangements are between All IT Solutions LLC and its clients and do not require payment from the candidate.

Official recruiting communications will come from an authorized All IT Solutions representative or an @allitsolutions.us email address.

Apply

Apply Now: