*Hello this is an urgent requirement.*
* *
*Position:* SQL Server Architect
*Location:* Columbia, SC
*Duration:* 3 Months
*Rate:* DOE
*Year of Exp: 10 yrs*
*Primary Skills:*
*Category Name
Required
Importance Level Last Used Exp*
Administrative Technical Writing Yes
1
Administrative Written Comm. Skills Yes
1
Database Platforms Database Upgrades Yes
1
Database Platforms SQL Server Yes
1
Specialties Data Modeling Yes
1
*Current situation:** *
Client is currently using a client server system for its SACWIS (Children
and Adults Protective Services System or CAPSS-II) that is primarily built
upon a Visual Basic VB6 "fat" client that connects to the ADABAS database
via a Web Services component (WS), that connects to a Business Services
class (BS) who then connects to a Natural Business Services (NBS) class that
accesses the classes that access the database tables. There are a few
(probably a half dozen) administrative functions that are only used in the
DSS central offices that are still old "3270 green-screen" functions that
will also have to be dealt with. For the VB components, the WS returns a
serialized XML string to the VB application. The BS is a collection of VB
instructions that use classes from the NBS to access data according to the
application needs and then transform it into an XML stream; there are about
400 BS classes. The ADABAS environment is hosted on an IBM mainframe class
system. . The ADABAS environment is hosted on an IBM mainframe class system.
The current VB6 applications have been reengineered and rewritten using MS
.NET VB and have now "gone live" as of August 18 2008; the ADABAS database
will continue in its current state.
*Concern:*
Once the new application is installed there is concern over the continued
use of the ADABAS database environment and the mechanism used to access the
database. It is highly restrictive and consumes significant resources during
its operation as well as being limited in its flexibility for future
applications changes as well as database adjustments. The desire is to
replace the ADABAS database with a MS SQL Server database sunning on Wintel
Servers supporting the application via SQL using stored procedures. The
following diagram represents the desired structure.
Additionally there are a number of batch reports written with Natural and
Construct from Software AG that operate against the ADABAS database that
will also need to be converted/rewritten to operate in the .NET environment,
as well as a few "3270 green-screen" functions that will need to be dealt
with. A standard reporting tool like Cognos, Crystal reports or Actuate may
be used for the reporting functions.
*Objectives:** *
• To verify the wisdom and business case for migration of the soon to be
implemented SACWIS (CAPSS-II) system from a Software AG ADABAS database
environment to a Microsoft SQL Server environment by June 30, 2009, or to
recommend a viable alternative to same.
• To verify the impact this will have on the overall project, the approach
for finishing the CAPSS system, and the overall state of the project.
• To validate the methodology being recommended for this migration.
• To validate the estimates of resources needed.
• To validate the timeframes needed for doing this migration and testing.
• To validate the hardware and software environment needed to run this
migrated system in the operational phase.
• To validate the skills and numbers of staff needed to run this migrated
system in the operational phase.
• To fine-tune estimates of resources and timeframes expected for each task
in the proposed work plan.
• To assist in selecting an enterprise reporting tool for use in the
conversion project.
• To assist in preparing a detailed work plan for the migration, with
resources needed, time estimates, and deliverables for each task in the work
plan.
*Please send me your consultant's updated resume*
Best regards,
Ajay Tiwari
UBICS, Inc.
333 Technology Dr
Pittsburgh PA 15317
Phone: 412 385 1616 / 412 385 1617
Fax: 724 743 4149
[EMAIL PROTECTED]
www.ubics.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"oracle" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/oracle
-~----------~----~----~----~------~----~------~--~---
