Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

SQL Server Developer (397 views)

Hartford, Connecticut
April 23, 2021

 

***** Direct Client Requirement*****                    

Title                           : SQL Server Developer

Location                   : Hartford, Connecticut

Rate                          : DOE /If your experience and skills match call us immediately for submission

Duration                   : 6 Months

Interview Type        : Web Cam Interview      

Job Type                  : C2C,C2H,W2

Experience              : 5+ Years

Job Description:

The CT Department of Energy & Environmental protection is in need of an individual to support migrating our legacy Microsoft Access Applications to Microsoft SQL Server. The department has roughly a dozen IT supported Access applications that were built by business units over the last 20 years (pre-Access 2013). Some of these applications support mission critical business functions and are beginning to have compatibility issues with newer versions of Access (2019 & O365). These applications have previously had the front end split from the backend. This position will be fully remote and the individual selected will be provided a virtual machine they can RDP into with the necessary tools to complete their work. The responsibilities of this position are listed below.

  1. Migrate Access backends to SQL Server
  2. Update existing front ends to point to new data sources (SQL Server)
  3. Modify front-end VBA code as needed based on any changes to DB structure during the data migration (ex: datatype changes)
  4. Modify VBA code to allow for use with either 32-bit or 62-bit versions of Office
  5. Provide guidance and mentorship to other development staff who will be working on this effort as needed
  6. Work with apps hosting team to optimize and streamline how Access databases are setup and accessed on users virtual desktops
  7. Will work under the immediate supervision of and will report to the IT Supervisor
  8. Coordinate with Business staff for testing/validation of changes
  9. Provide documentation of implemented changes

Any applicants should have a demonstrated ability to work well in a team environment and should have previous experience converting Access databases to SQL Server. In addition, the candidate should have excellent written and oral communication skills.

 Required/Desired Skills:

  • Skills – Database – Microsoft Access – Proficient – No
  • Skills – Database – Microsoft SQL Server – Proficient – No

*****Referral Bonus Available: Refer your friends or colleagues, get referral bonus******

Thanks

Siva

Siva@sohanit.com
PH:402-241-9606
Apply here or Please send to resumes@sohanit.com

Follow us on LinkedIn and Twitter for daily active requirements

LinkedIn: https://www.linkedin.com/company/sohanit-inc/?viewAsMember=true
Twitter: https://twitter.com/SohanITInc1

Position Keywords: Microsoft Access, Microsoft SQL Server, front-end VBA, IT, SQL Server

Pay Rate: DOE /If your experience and skills match call us immediately for submission

Job Duration: 6 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 3060

Don't have time now?
Get a reminder in your inbox