Looking for SQL Developer- Phoneix - AZ
Please send resumes to sowmya@datadynamcissystems.com
if you have consultants
Job Description: Title: SQL Developer
Location: Phoenix, AZ
Duration: 9 months MAJOR TASKS Major project tasks will include SQL
coding
of conversion scripts, testing of converted data, developing quality
control
scripts to assist in analysis of the converted data and final
implementation
and follow up testing to ensure customer satisfaction with final
converted
data. Required as part of the performance of these tasks are the
following: *
Writing SQL code to convert data from conversion mapping documents *
Developing and running scripts to test the converted data * Making
modifications to scripts to correct errors found * Assisting the IR
(Indigent
Representation) DBA with the final run of these scripts into the
Production
environments * Writing updated scripts for any errors that may occur
*
Maintaining project plan updates * Monitoring due dates and upcoming
tasks *
Providing final copies of all conversion scripts and documentation on
how the
scripts were run and used to complete the conversion. * Additional
tasks as
needed ENVIRONMENT AND COMPUTER LANGUAGE The current environment runs
on a
Microsoft Server 2003 Enterprise server, utilizing IBM WebSphere
application
server, Microsoft SQL Server 2000 database, and Microsoft IIS web
server
interface. Tools which may be required to perform this work will be
MS
SQL,
Microsoft Office products such as Excel, Access, MS project and
others.
Environments from which data is to be extracted are: Time Matters
running a
SQL database, Time Matters running a Time Matters proprietary
database,
TimeSlips running a proprietary database and a custom .NET
application
running
a SQL database. REQUIREMENTS ANALYSIS The consultant will coordinate
with the
client to perform requirements analysis for each of the Phases
described. The
consultant will prepare a report documenting the results of
requirements
analysis and submit the report to the client for review and approval.
The
report should be in both hard copy format and electronic format (MS
Word).
This is due one week after the start date of the specific phase. A
progress
meeting shall be held, at this interval. DESIGN The consultant will
design
and prepare documents of the above task that will meet the
requirements and
specifications. The consultant will submit the report to the client
for review
and approval prior to beginning work on the detailed documents. The
report
should be in both hard copy format and electronic format (MS Word).
This is
due two weeks after the start date of the specific phase. A progress
meeting
(may be telephonic) shall be held, at this interval. TESTING PLAN The
consultant will prepare a testing plan which will specify all tests
to
be
performed. Testing will consist of three parts. Part One is to be
performed
solely by the consultant to determine that the conversion scripts are
accomplishing the intended result. Part Two will consist of testing
by
the
client's Technical Staff. Part Three will be business acceptance
testing by
staff. As issues are resolved, the consultant will produce and
maintain a
document showing how the errors were resolved. IMPLEMENTATION The
consultant
will work with the assistance of the Database Administrator to
implement the
tested conversion scripts into the appropriate databases. The
consultant will
verify documents provided against actual process and make appropriate
revisions to meet the requirements. Detailed comments shall be added
to the
documents to explain any variables. SYSTEM AND ACCEPTANCE TESTING In
this
phase, the converted data will be tested based on the three part
testing plan
outlined above. Any errors uncovered by system testing will be
corrected in
this phase. The consultant will prepare a report and submit it to the
client
for review and approval. The report should be submitted in both hard
copy
format and electronic format (MS Word). DELIVERABLES The consultant
shall
deliver the final version of the testing documentation and conversion
code as
well as a final report listing the specific tasks and describing how
each has
been completed.
With Regards,
Sowmya
Data Dynamics Systems