MS Access & SQL Server App Developer

Short Description:

Client is in need of 1 resource skilled in MS Access (inc. ADP), MS SQL (including SSIS), and  ASP.net app dev & support to work w/the current dev team to support and upgrade critical agency applications.

Complete 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

IMPORTANT NOTES - PLEASE READ:

• 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

• 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

• PROFESSIONAL REFERENCES REQUIRED UPON SUBMITTAL -When submitting your candidate, include a Word document that includes contact info for THREE professional references for your candidate - upload this in the same section on the Reference tab as you upload the Resume and RTR. 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 AND must note where, when, and how the reference worked with the submitted candidate. If you do not include the required references at time of submittal OR we find the references provided have been falsified, your candidate will be removed from consideration.
• ENVIRONMENT - 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. 

• EXCEPTIONAL COMMUNICATION SKILLS REQUIRED- Exceptional communication skills, both written and verbal, are required to be considered for this position.