Locatin: Lansing, MI
Duration: 1 year (with an option to extend to 3 years)
Positions: 1
• At least five years experience with Oracle 11i Applications
• At least three years experience with Oracle Database Administration,
including Oracle Advanced Security and Oracle Connect Manager.
• At least five years experience with Oracle Advanced Replication
• Oracle DBA Masters Certificate
• At least five years experience with Oracle Forms and Reports
• At least one year experience with HP-UX System Administration
• At least five years experience with C and ProC Programming
• At least five years experience with Korn Shell Programming
• At least five years experience with JAVA Programming
• At least three years experience with SED and AWK utility programming
• Knowledge of Qualified Voter File Systems preferred
A. Brief Description of Work
This request is for one (1) Senior Database Administrator to assist DTMB and MDOS with Oracle database administrative services for the Qualified Voter File (QVF) and MDOS Inventory systems.
B. Background on the work requested
The QVF and Inventory systems are two very critical systems for the Michigan Department of State. They are required to be available and functional in order to support the Branch Office operations and the Elections in Michigan. The technology used for the systems is Oracle and it requires specialized Database Administrator's support and expertise. The Michigan Department of State Saleable and Non-Saleable Inventory system is a computer system accessed by state employees from a remote location in downtown Lansing. The system manages the sales and inventory for vehicle registrations for the State of Michigan. An Oracle database and suite of Oracle Manufacturing software written in several languages to include Java, C, SQL/Plus, and Oracle Forms and Reports are implemented in this system. The Qualified Voter File (QVF) Voter Registration system is a computer system comprised of a large central database and approximately 468 client databases at different locations in the state. Software to implement the system is the Oracle Database and custom applications written in various languages to include PL/SQL, SQL and C. The QVF Voter Registrations system utilizes the Updateable Snapshot Replication feature of the Oracle database to integrate and manage data from election officials and other state sources.
C. Objectives
• The contractor shall continue the maintenance and support of the QVF
and Inventory systems. This includes archiving data, database tuning, assisting end users with issues, troubleshooting and fixing any issues with server processes, performing data clean up as needed
• Complete Business Application Modernization (BAM) project for QVF
server processes.
• Complete the Disaster Recovery project for QVF.
• Complete the Inventory system hardware & software upgrade project.
Oracle database will be upgraded to 11g and the Oracle Application Suite will be upgrade to Oracle Applications Release 10.2.
• Provide software development support for the QVF Michigan Voter
Information Center (MVIC) website.
• Provide knowledge transfer to DTMB Employees to enable them to
continue development and maintenance of these systems.
D. Agency technical environment for the work
The QVF is an Oracle 10g Database maintained on an HP Server running UNIX.
The Inventory is an Oracle 9 Database, with Oracle E-Business Suite 11.5, maintained on an TRU64 Unix Server.
QVF server processes software is written in Proc C, C, PL/SQL, Java, KSH, and UNIX utilities such as AWK and SED.
E. Description of the requested work, including deliverables and
knowledge transfer
The Contractor shall conduct ongoing system maintenance, enhancements and upgrade activities to the QVF databases, Inventory database, and QVF server processes. Additionally, the Contractor shall conduct knowledge transfer sessions with MDTMB on the supported systems. The Contractor shall be responsible for the following duties:
• Monitor databases, server processes and deploy break fixes under the
direct supervision of DTMB and MDOS staff.
• Provide all documentation and all source code for all supported
systems to DTMB and MDOS.
• Clone production systems to development environments as required to
allow for the implementation and testing of new features, required upgrades, and problem resolution, and trouble shoot performance problems on both systems.
• Assist developers in the use of efficient codes and appropriate
technologies and platforms.
• Manage the fragmentation and chaining for Oracle tables.
• Update system specific documentation as needed.
• Create change recommendation documents as required.
• Attend business requirements meetings and review requirement
documents with MDTMB and MDOS for any new development projects.
• Provide monthly status reports.
• Respond to authorized service requests at the request of DTMB and
MDOS Project Managers.
• Move code changes from development and testing into the production
environment. The move to production is dependent upon a successful User Acceptance Test and will follow the established Request for Change (RFC) process.
• Schedule and conduct sessions with DTMB staff to review in details
the supported systems.
Deliverable(s)
1• All Supported Systems Documentation, including new Developments.
2. A minimum of one (1) electronic copy will be provided to DTMB and
MDOS project manager.
3. The documentation of components, features, and use of the hardware/
software shall be detailed such that resolution of most problems can be determined from the documentation, and most questions can be answered.
4. All system, operational, user, change, and issue documentation must
be available in electronic format, accessible to State users, updated regularly, with unique numerical identifiers for each section and be consistent with the most current version of the application(s).
5. All system, operations, user, change and issue documentation is to
be organized in a format, which is approved by the State and facilitates updating and allows for revisions to the documentation to be clearly identified. Sample documentation will be provided.
No comments:
Post a Comment