Job Title : SQL Developer
Duration : 1+ Years
Location : Des Moines, IA
Interview : Face to Face
The Department is currently implementing a new Eligibility system for Medicaid, TANF (Financial Assistance) and Food Assistance programs.
The Department is currently implementing a new Eligibility system for Medicaid, TANF (Financial Assistance) and Food Assistance programs. This implementation leaves several Department systems used in support of the new eligibility system in need of upgrading to meet the Federal Service Oriented Architecture guidance. Many of the remaining systems are mainframe systems that are being moved into the Client Server domain. Our Client Server environment is predominately Web (IIS/.Net) and SQL Server. The SQL environment is being upgraded to SQL 2012.
We are in need of an experienced SQL developer. The experience should be centered around design, development and implementation of databases used to support web-based transactional applications. Ideally, the candidate will have experience supporting real-time, SOA-Based applications using web-services and a services bus (Oracle Service Bus) to interact with other systems. Additional experience using LINK would be beneficial. The activities this person will be involved with include database design (normalized/de-normalized) using core database objects and application/functional specific schema's. The day to day activities include;
1. Working with web (.Net) developers interacting with the database in the design and development of the application.
2. Database schema/table/column design and development.
3. Creating database objects used within the application.
4. Developing/editing and implementing stored procedures and other executable's.
5. Developing database maintenance plans
6. Developing automation of database batches where necessary. It will likely involve developing SQL Server Integration Services packages and working with batch schedulers to implement in Control M scheduling software.
This multi-year effort is starting with the existing applications within DHS that have been significantly impacted by the implementation of a new Eligibility Determination system in support of the Affordable Care Act. This modernization effort will continue within other areas of DHS and it is expected that this person will migrate to the other areas within DHS to support these efforts over time.
| Skill | Required | Required Experience | Experience |
| Experience supporting real-time, SOA-Based applications using web-services and a services bus to interact with other systems
| Required | 5 Years |
|
| Database design (normalized/de-normalized) using core database objects and application/functional specific schema's
| Required | 5 Years |
|
| Database schema/table/column design and development
| Required | 5 Years |
|
| Creating database objects used within the application.
| Required | 5 Years |
|
| Experience using LINK
| Required | 5 Years |
|
| Developing/editing and implementing stored procedures and other executable;s
| Required | 5 Years |
|
| Developing database maintenance plans
| Required | 5 Years |
|
| Experience SQL Server Integration Services packages - SSIS
| Required | 5 Years |
|
| Work with batch schedulers to implement in Control M scheduling software
| Highly Desired | 1 Years |
|
DevCare Solutions
Award Winner
"Inc 5000: Fastest Growing Companies in America"
"Columbus Business First: Fastest Growing Private 50 Companies in Columbus"
"Certified Minority Business Enterprise - MBE"
---
You received this message because you are subscribed to the Google Groups "Best IT Consulting Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to best-it-consulting-group+unsubscribe@googlegroups.com.
To post to this group, send email to best-it-consulting-group@googlegroups.com.
Visit this group at http://groups.google.com/group/best-it-consulting-group.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment