DescriptionTop Skills' Details5 Years Database and database application upgrade and support experience - front-end applications and back-end support
5 Years Experience supporting application database migrations involving MS Access and MS SQL Server
5 Years Experience developing and supporting MS Access Applications, MS Access Database (ACCDB), MS Access ADP
5 Years Strong technical experience in MS Access and MS SQL Server based application development and support, to include end user support of applications
5 Years Experience with MS SQL Server development (TSQL)
5 Years Development experience utilizing SSIS
5 Years Experience with MS SQL Server administration
5 Years Visual Basic for Applications (VBA) - Experience developing complex VBA scripts.
3 Years ASP.net development experience
IMPORTANT NOTES - PLEASE READ:
- LOCAL CANDIDATES REQUIRED- This is a HYBRID position requiring 4 days/week ONSITE. Only apply if you are willing to work 4 days/week onsite as required.
- ONSITE INTERVIEW- Candidates must be willing and able to go to the client location for an ONSITE, IN-PERSON interview if selected for interview.
- KEY SKILLS -The dominant skill set needs are Access & SQL Server, including Access ADP knowledge and SSIS. The job is to rewrite Access ADP applications that link to SQL Server backend to Access ACCDB format, then migrate them to different servers.
- HOURS PER WEEK - Position will have a 37.5-hour work week, NOT a 40-hour work week
- READ and RESPOND APPROPRIATELY to all items in the Questions section of the requisition. If you do not answer the questions appropriately, your candidate will not be considered for screening.
- DEGREES/CERTIFICATIONS ON RESUME- Any education, degrees, and certifications listed on the resume MUST contain valid degree/certification details, INCLUDING date the degree/certification was acquired or candidate will not be considered. Please confirm those details are included correctly on the submitted resume
- EXCEPTIONAL COMMUNICATION SKILLS REQUIRED- Exceptional communication skills, both written and verbal, are required to be considered for this position.
Description
Selected resource will be responsible for working with the current development team to support and upgrade the current portfolio of critical agency applications. The person in this role will be responsible for rewriting Access ADP applications that link to SQL Server backend to Access ACCDB format, then migrating those applications to different servers.
Specifically, you will:
- Work closely with the current agency development team to update the portfolio of applications from the MS Access project file format (ADP) to MS Access database file (ACCDB) and from MS SQL Server 2008 to MS SQL Server 2016 or higher, including the use of SSIS jobs. There is potential to develop using ASP.net as well.
- Contribute to the determination of the future technical path for the agency application portfolio.
- Help maintain best practices for documentation and code management.
- Work closely with our internal developers and service providers to ensure the applications are stable and reliable.
- Work to provide our customers with the best transformation experience possible.
What is required:
- Strong technical skills in MS Access and MS SQL Server based application development and support, to include end user support of applications.
- Experience with Access ADP and SQL SSIS jobs
- Skills in developing complex VBA scripts and ASP.net development.
- Strong communication and collaboration with both IT peers and agency personnel of varying levels of technical knowledge.
Work experience:
- Previous experience supporting application database migrations involving MS Access, MS Access project file format (ADP), ACCDB, and MS SQL Server and creating and updating SSIS jobs
- Previous experience developing VBA application scripts
- Strong understanding of test processes especially user acceptance testing
- Hands on experience migrating from legacy database applications for both on premise and cloud environments
- Commitment to the highest customer service and ethical standards
- Experience and knowledge of MS SQL Server administration
- Previous experience working with development teams delivering with Agile methodologies
- Previous experience with eliciting business and functional requirements is a plus
- Experience/knowledge of cloud technologies, specifically GitHub, Salesforce, Jira, SharePoint.
Technologies
- Required - MS Access Applications, MS Access Database (ACCDB), MS SQL Server development (TSQL), MS SQL Server administration, SSIS, MS Access ADP, Visual Basic for Applications (VBA), ASP.net
- Nice to have - Salesforce PSS and Apex, GitHub, Jira, SharePoint, Power BI, PowerApps
Additional Skills & Qualifications- Exceptional communication is required as resource will collaborate with IT peers and agency personnel of varying levels of technical knowledge.
- Previous experience working with development team delivering with Agile methodologies
- Strong understanding of processes including user acceptance testing
- Experience communicating end user needs and requests to technical staff.
- SharePoint
- GitHub
- Salesforce PSS and Apex
- Jira
- Power BI
- PowerApps
- Previous experience with eliciting business and functional requirements is a plus
Job Type & LocationThis is a Contract position based out of Concord, NH.
Pay and BenefitsThe pay range for this position is $60.00 - $70.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: Medical, dental & vision Critical Illness, Accident, and Hospital 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available Life Insurance (Voluntary Life & AD&D for the employee and dependents) Short and long-term disability Health Spending Account (HSA) Transportation benefits Employee Assistance Program Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace TypeThis is a hybrid position in Concord,NH.
Application DeadlineThis position is anticipated to close on Mar 6, 2026.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.