*Location: Des Moines, Iowa* *Duration: 6+*
*Interview mode: Phone then F2F* *Position Description: * *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. *The 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 LINQ 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 schemas. *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 executables* 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. *TECHNICAL / FUNCTIONAL SKILLS* *REQUIRED/ DESIRED* *MIN. YRS * *YRS DONE* *LAST USED* *Project / Tools Where Used* *HIGHEST PRIORITY * *FROM TOP* *DOWN* Experience supporting real-time, SOA (Service Oriented Architecture) based applications using web-service and a service bus to interact with other systems *Required* *5* Design and develop databases (normalized/de-normalized) using core database objects and application/functional specific schemas. *Required* *5* Database Schema/table/column design and development *Required* *5* Creating database objects used within the application. *Required* *5* Experience using LINK (alternate to three tier architecture) *Required* *5* Developing/editing and implementing stored procedures and other executables *Required* *5* Experience SQL Server Integration Service Packages (SSIS) *Required* *5* Work with batch schedulers to implement in Control M scheduling software *Highly Desired* *1* Thanks Regards *Swami A* Technical Recruiter *Ennovace Inc* Ph: 214-541-9378 F: 972-262-9006 sw...@ennovace.com www.ennovace.com 1801 S O'connor Rd Irving TX 75061 In my absence please contact Steven at ste...@ennovace.com (214-541-9081) Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intendedrecipient(s) and may contain confidential and privileged information.Any unauthorized review, use,disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@ennovace.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mails to you. We are sorry for the inconvenience. Thank you Regards *Swami A *Sr. Marketer Ennovace Inc Ph: 214.541.9378 F: 724.264.5637 sw...@ennovace.com www.ennovace.com 1801 S O'connor Rd Irving TX 75061 -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.