What are the responsibilities and job description for the MS Access and SQL Server Developer - Hybrid - Contract - Concord, NH - B3847B. position at Technovision, Inc.?
Job Details
Our direct client is looking for a MS Access and SQL Server Developer for a Hybrid contract position Concord, NH
IMPORTANT NOTE:
- The IDEAL candidate will be available to work in a hybrid schedule with 2-3 days onsite work weekly (exact weekly schedule to be worked out between client/selected resource). Client will consider fully remote work for a strong candidate, however, local candidates who are willing to work in a hybrid role will be given preference.
- LOCAL Candidates submitted are expected to be able to attend an in-person interview if selected to interview for the role.
- All candidates must have a experience of database and database application upgrade and support, with front-end applications and back-end support. Do not submit them if they do not meet the minimum requirements listed.
- 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. If they are not comfortable working in this environment, DO NOT SUBMIT THEM.
Job Description:
Client is in need of 2 resources skilled in MS Access/MS SQL application development and support to work with the current development team to support and upgrade the current portfolio of critical agency applications.
Selected resource will be responsible for working with the current development team to support and upgrade the current portfolio of critical agency applications with the potential to transition into the development leadership role.
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.
- 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.
- Skills in developing complex VBA scripts.
- Strong communication and collaboration with both IT peers and agency personnel of varying levels of technical knowledge.
- Commitment to the highest customer service and ethical standards
Technologies:
- MS Access Applications, MS Access Database (ACCDB), MS SQL Server development (TSQL), MS SQL Server administration, MS Access ADP, Visual Basic for Applications (VBA)
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
- Strong technical experience in MS Access and MS SQL Server based application development and support, to include end user support of applications - Required
- Hands on experience migrating from legacy database applications for both on premise and cloud environments - Required
- Experience developing and supporting MS Access Applications, MS Access Database (ACCDB), MS Access ADP - Required
- Experience with MS SQL Server development (TSQL) - Required
- Experience with MS SQL Server administration - Highly desired
- Visual Basic for Applications (VBA) - Experience developing complex VBA scripts. - Required
- Previous experience working with development team delivering with Agile methodologies - Required
- Strong understanding of test processes especially user acceptance testing - Required
- Exceptional communication is required as resource will collaborate with both IT peers and agency personnel of varying levels of technical knowledge. - Required
- Salesforce PSS and Apex - Plus to have
- SharePoint - Plus to have
- Power BI - Plus to have
- PowerApps - Plus to have
- Jira - Nice to have
- GitHub - Nice to have
- Previous experience with eliciting business and functional requirements is a plus - Nice to have
Question 1: Have you uploaded professional REFERNCES as required, detailing all required information as specified within the requisition details? If you have not submitted the references as specified, your candidate will not be considered for screening.
Question 2: Respond to this question with a link to your candidate's LinkedIn Profile.
Question 3: Ideal candidate will work in HYBRID onsite schedule for this position. While fully remote will be considered for a strong candidate, LOCAL candidates willing to work in a hybrid schedule will be given preference. Please confirm you understand this and have discussed this with your candidate.
Question 4: Please SPECIFY the CITY and STATE in which your candidate is CURRENTLY located (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 WHICH WILL CONFIRM TRUE ADDRESS - your candidate will not be considered/will be removed from consideration for the position).
Question 5: IF SUBMITTED CANDIDATE IS LOCAL - Please confirm they agree to work onsite in a hybrid schedule for this role. If submitted candidate is not local, note "N/A" in the response field.
Question 6: IF SUBMITTED CANDIDATE IS LOCAL - They are expected to be able to attend an in-person interview. Please confirm you've discussed this with your local candidate and they accept this requirement. If candidate is not local, note "N/A" in the response field.
Question 7: For remote work - client will provide selected resource with a laptop to use for the contract work. Candidate must have the ability to successfully work remotely - this includes the appropriate internet connectivity. Internet cost and any additional equipment beyond the state-provided laptop that is desired by candidate is at candidate's own expense and will not be reimbursed by CAI or the Client. Please confirm you have discussed these requirements with the candidate and they accept the requirements.
Question 8: Candidates must be located within the US, must be legally able to work in the US, and remote candidates must be able to work on the State of NH's Eastern Time Zone business hours. The candidate must be able to participate in web/video meetings as needed while remote. Please confirm you have discussed these requirements with the candidate and they meet/accept the requirements.
Question 9: 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. If those details are not included as required, your candidate will not be considered for screening.
Question 10: This position is expected to work 37.5 hours per week (NOT a 40-hour work week). Please confirm you have discussed this with your candidate and you accept this requirement.
Question 11: 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.
Location: Hybrid (2-3 days onsite per week), Concord, NH
Type: Contract
Please send resume to "jobs at etechnovision dot com" with B3847B in Subject for immediate consideration.