Need : Transactional SQL DBA

Hi there

 

Please let me know if you have any resources available if YES please send it me with his update resume & contact information ASAP to Srinivas.chitalu@parthotechnologies.com  Thank you!

 

 

Job Title : Transactional SQL DBA

 Location : MN, IL, MO, KS, NE, SD I will look at local first!

Duration :  6+ months

 

 

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. 

 

 

1.    Experience supporting real-time, SOA - based applications using web-services and a services bus to interact with other systems - required 5 years

 

2.    Database design (normalized/de-normalized) using core database objects and application/functional specific schemas - required 5 years

 

3.    Database schema/table/column design and development - required 5 years

 

4.    Creating database objects within the application - required 5 years

 

5.    Experience using LINK - required 5 years

 

6.    Developing/editing and implementing stored procedures and other executables - required 5 years

 

7.    Developing database maintenance plans - required 5 years

 

8.    Experience SQL Server Integration Services packages - SSIS - required 5 years

 

9.    Work with batch schedulers to implement in Control M scheduling software - highly desired 1 year

 

 

 

 

 

 

Thanks & Regards,

 

Srinivas

--
You received this message because you are subscribed to the Google Groups "US Jobs: Requirements, Clients and Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to recruiters-r-us+unsubscribe@googlegroups.com.
To post to this group, send email to recruiters-r-us@googlegroups.com.
Visit this group at http://groups.google.com/group/recruiters-r-us.
For more options, visit https://groups.google.com/d/optout.