MS Access and SQL Server Developer - Hybrid - Contract - Concord, NH - B3847B

Our direct client is looking for a MS Access and SQL Server Developer for a Hybrid long term contract in Concord, NH

IMPORTANT NOTES:
- LOCAL CANDIDATES REQUIRED- This is a HYBRID position requiring 4 days/week ONSITE. Only submit LOCAL candidates who 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
- REFERENCES - Please send a Word document that includes contact info for THREE professional references. These references must be supervisory references from past employment, and at least one of the three must be a supervisor from employment where the candidate worked in a role similar to what is being requested for this position. References must include the full name, phone number, and email address for the reference
- These roles support the NH Fish & Game Dept - candidates MUST be comfortable working in an environment that supports and encourages hunting, fishing, trapping, wildlife management, and shares a building work area with Law Enforcement. This includes a physical office environment that may be decorated and housing taxidermy mounts and animal pelts. Ensure you discuss this environment with your candidate BEFORE submitting them.
- EXCEPTIONAL COMMUNICATION SKILLS REQUIRED- Exceptional communication skills, both written and verbal, are required to be considered for this position.

J0B 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:
- Hands on experience migrating from legacy database applications for both on premise and cloud environments
- Commitment to the highest customer service and ethical standards

SKILL MATRIX:
- Database and database application upgrade and support experience - front-end applications and back-end support - Required
- Experience supporting application database migrations involving MS Access and MS SQL Server - Required
- Experience developing and supporting MS Access Applications, MS Access Database (ACCDB), MS Access ADP - Required
- Strong technical experience in MS Access and MS SQL Server based application development and support, to include end user support of applications - Required
- Experience with MS SQL Server development (TSQL) - Required
- Development experience utilizing SSIS - Required
- Experience with MS SQL Server administration - Highly desired
- Visual Basic for Applications (VBA) - Experience developing complex VBA scripts - Required
- ASP.net development experience - Required
- Exceptional communication is required as resource will collaborate with IT peers and agency personnel of varying levels of technical knowledge - Required
- Previous experience working with development team delivering with Agile methodologies - Required
- Strong understanding of processes including user acceptance testing - Required
- Experience communicating end user needs and requests to technical staff - Required
- SharePoint - Strong Plus to have
- GitHub - Strong Plus to have
- Salesforce PSS and Apex - Plus to have
- Jira - Plus to have
- Power BI - Nice to have
- PowerApps - Nice to have
- Previous experience with eliciting business and functional requirements is a plus - Nice to have

Question 1: Respond to this question with a link to your candidate's LinkedIn Profile.
Question 2: ONSITE 4 days per week REQUIRED with one day of remote work per week - This 4 days/week onsite is not negotiable. Local candidates who accept this requirement should be submitted. Confirm your candidate understands and accepts this onsite requirement.
Question 3: Resource will be required to attend an in-person interview if selected to interview. Please confirm the resource understands this requirement.
Question 4: Please specify your candidate's FULL ADDRESS of their current residence. (If not specified or if location specified is determined to be untrue at any point during the screening/interview/onboarding process - including during background check where address will be verified - your candidate will not be considered/will be removed from consideration for the position).
Question 5: This position is expected to work 37.5 hours per week (NOT a 40-hour work week) and is expected to run for approximately 24 weeks in duration. Please confirm you have discussed this with your candidate and you accept these requirements.
Question 6: Is the candidate comfortable with working in an environment that supports and encourages hunting, fishing, trapping, wildlife management, and sharing a building work area with Law Enforcement? This includes an environment that may be decorated with taxidermy mounts and animal pelts. Please confirm you have discussed this environment with the candidate and they are comfortable working in this type of atmosphere.
Question 7: This position requires an additional CJIS level background check with fingerprinting which will be coordinated by the agency with the selected candidate. If contractually required background checks run by the vendor for the selected candidate come back clear, candidate can start with limited access while awaiting CJIS results. Continued employment will be contingent upon CJIS check coming back clear. Confirm you discussed this with your candidate and they accept this requirement.

Location: Hybrid (4 days/Week), Concord, NH
Type: Long term contract

Please send resume to "jobs at etechnovision dot com" with B3847B in Subject for immediate consideration.