Short Description:
The Programmer is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team.
Complete Description:
IN PERSON INTERVIEWS no exceptions. Interviews are going to be held 7/29 12:30. 1:15 & 2:00/
resumes are due to the manager on Thursday the 24th.
The selected Consultants will work closely with the designated I.T. supervisor, project managers, and other developers in an iterative development environment. The work scope of the consultant will include requirements gathering, application design, application development, testing, deployment and technical support.
The Consultants, in working with ODPS staff, will be responsible for rewriting legacy applications to .NET applications utilizing C#, MVC, WCF, SQL Server and other technologies.
The Ohio State Highway Patrol (OSHP) is requesting a rewrite of the Ohio Liquor Law Enforcement (OLLE) case management system. In addition to this request, the creation of an electronic citation (eCitation) module written for the current instance of OLLE is being asked for. This new eCitation module will also be instantiated within the new OLLE system once rewritten.
The new applications will implement a 3-tiered architecture and comply with ODPS coding standards.
The Programmer is responsible for analysis, design, coding, component and assembly testing of all application code owned by the Application Team. Programmers typically are involved in maintenance (including production support), enhancement and development work. Programmers have a range of skills and knowledge of the technologies used and applications supported by the Application Team. The Programmer works with the Functional Architect and Technical Architecture Specialist on an as needed basis to ensure that design and code meets customer requirements.
Years of Relevant Experience:
10 plus years
Preferred Education:
4 year college degree or equivalent technical study with advanced study preferred.
Role Description:
All roles specified plus the following:
•Proven track record of hands-on technical design and code work within large complex systems.
•Proven hands-on technical work with a variety of technologies.
•Demonstrated technical expertise integrating a variety of diverse technical environments and cross-platform technologies.
•Proven experience mentoring and performing supervisory functions for technical teams.
•Ability to make best practice recommendations based on past work.
•Proven ability to present complex technical constructs to business and non-technical users.
•Proven ability to collaborate with business users, project managers and technical architects.
During the interview process with the ODPS staff, the resource consultant must demonstrate competence/experience in their specific area(s) of project assignment. The resource’s experience must also be documented for review and verification. Offered resources not showing technical or functional competence/experience will be sufficient reason to reject the Offeror’s proposal. It is the responsibility of the Offeror to pre-screen their candidates to ensure compliance.
The ODPS has estimated that it will require one (1) full-time resource to provide up to one thousand (1000) hours for Fiscal Year 2014 (FY14), and two thousand (2000) hours in FY15 to complete this work.
Background Check must be brought in when interview conducted.
1. Strong communication/ leadership skills.
2. Strong influence, collaboration and negotiation experience.
3. Ability to collaborate with supporting resources across business and/or functional lines.
4. Have excellent oral and written skills/possess strong meeting and work session facilitation skills.
5. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
6. Have strong understanding of prioritization stemming from the elicitation of system and/or user requirements.
7. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.
8. Must be knowledgeable in the English language/speak clearly and understandably using the English language.
Skills:
Skill
Required / Desired
Amount
of Experience
Experience in Database design of relational databases and database normalization
Required
8
Years
Experience as a SQL Server database developer(writing T SQL, stored procedures, optimizing queries by execution plan etc
Required
5
Years
Experience in data cleansing/conversion using scripts in SQL server
Required
4
Years
Experience in ETL/Automations using integration services (SSIS)
Required
2
Years
Experience in Data Warehouse using SQL server 2008/2012
Required
2
Years
MUST be able to understand and enforce SQL server standards in creation and deployment of new database objects
Required
3
Years
Experience in SQL Server security and maintenance of security objects
Required
3
Years
Experience with object promotion strategies between databases in different environments-dev, test, QA,production
Required
4
Years
Experience in working with large databases of 300 GB or greater
Required
4
Years
MUST have the ability to see problems and solutions from an enterprise perspective
Required
6
Years
Experience mentoring staff not familiar with relational database concepts
Required
5
Years
Experience with flat file and index table database construction as used in mainframe databases
Required
5
Years
Excellent communication skills both oral and written
Required