Job Description :
Client: State of OH - Direct
Rate: $60/hr on C2C
Job Title: SQL Server Developer
Location: Columbus, OH 43068
Duration: 3+ Months
Position Type: Contract
Interview Type: In-Person
Required Skills:
· MS Access /VBA - Visual Basic for Applications Nice to Have 1 Years
· Visual Studio (Window Forms, Solution, Projects) Required 4 Years
· T-SQL (Stored Procedures/Views) Required 4 Years
· C# Required 4 Years
· Object Oriented Programming Experience Nice to Have 2 Years
· ADO.Net Nice to Have 3 Years
· MS-SQL Server/Express Required 4 Years
· Telerik (WinForms/Reporting) Required 2 Years
· 4 Year Degree or Equivalent Desired 4 Years
· MS-SQL Server Tools Required 4 Years
Job Description:
The Programmer is responsible for analysis, design, coding, component and assembly testing. The focus will be on participating as a member of a development team charged with a rewrite of Dairy Main and Dairy Field applications.
The rewrite and platform refresh of the Dairy Main and Dairy Field applications will be the primary focus. The legacy dairy applications are coded in MS Access 2007 connected to SQL Server 2008 R2 databases via an OLE connection adp The corresponding SQL databases contain complex stored procedures, views, and functions which must be evaluated, modified and created. Programmer should have proficiency with SQL and interfaces (SQL Server Manager, SQL Studio Management Dairy employees manage regulatory, licensing and inspection functions via two complex compiled MS Access project ade The agency has shifted the development platform from MS Access to C The rewrite of these applications is the primary responsibility but the legacy MS Access applications may also require maintenance and support during the engagement.
The programmer must fit in teamwork environment as well as follow direction. Programmer may be responsible for all phases of the Software Development Life Cycle (SDLC); gather project business requirements, analysis of hardware/software requirements, design forms and reports, database modifications, code review, unit testing, user support and training, and maintenance. Development will be performed in a test environment and promoted to production environment upon approval by senior developer or supervisor. Programmer must use established formats, review and understand existing code, controls, SQL stored procedures and views. The programmer must adhere to agency coding standards, procedures, and complete documentation such as impact analysis and change control. Use of third party tools is prohibited without prior approval by the project programmer or supervisor. Programmer will participate in weekly developer working group meetings to discuss progress, obstacles, timelines, and goals.