*Hiring: SQL Server DBA/Developer / Columbus, OHDirect ClientJob Title: SQL Server DBA/DeveloperLocation: Columbus, OHDuration: 10 MonthsClient: State of OHIn person interviewDescripation: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.PR5Years of Relevant Experience:10 plus yearsPreferred Education:4 year college degree or equivalent technical study with advanced study preferred.Role Description:All roles specified in PR4 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.Strong communication/ leadership skills. Strong influence, collaboration and negotiation experience. Ability to collaborate with supporting resources across business and/or functional lines. Have excellent oral and written skills/possess strong meeting and work session facilitation skills. Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines. Have strong understanding of prioritization stemming from the elicitation of system and/or user requirements. Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills. Must be knowledgeable in the English language/speak clearly and understandably using the English language.All roles specified in PR1,2,3,4, and including the following Required 8 Years Experience as a SQL Server Database Administrator (SQL Server 2008/2012/2014) 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 2008/2012/2014 Required 4 Years Experience in ETL/Automations using integration services (SSIS) -2008/2012/2014 Required 4 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 Highly desired 5 Years Experience with flat file and index table database construction as used in mainframe databases Highly desired 5 Years Excellent communication skills both oral and written Required Please send resume to alb...@cncconsulting.com <alb...@cncconsulting.com>*
-- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to oraapps+unsubscr...@googlegroups.com. To post to this group, send email to oraapps@googlegroups.com. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
