Contract: $79,018 - Health Resources and Services Administration - May. 18, 2009
0% voted satisfied - 100% voted not satisfied - 2 vote(s) cast
Award Description: Database Administrator Contract Support for BCRS's Scholarship and Loan Programs: The purpose of this contract is to provide database administration, maintenance and end-user support, and server support to the end-users for the systems and applications supporting the program functions for the Bureau of Clinician and Recruitment Service (BCRS). The Office of Information Technology (OIT), Health Resources, and Services Administration (HRSA) have the responsibility to develop, maintain and provide Information Technology services and support for numerous programs and enterprise applications used throughout HRSA. Compubahn provided contract support for the following BCRS systems that require ongoing operations and maintenance support. • Nursing Information System (NIS) ? Nursing Education Loan Repayment Program (NELRP) ? Nursing Scholarship Program (NSP) • NHSC Online Application ? National Health Service Corps Loan Repayment Program (NHSC-LRP) ? National Health Service Corps Scholarship Program (NHSC-SP) • BCRSIS Payment Authorization Workflow • BCRS Banking Information Capture • Faculty Loan Repayment Program (FLRP) To address the challenges and to provide continued production support for day-to-day activities, it is important to have a strong maintenance and operations plan that is consistent with HRSA’s enterprise level vision and existing IT infrastructure. The objective is to ensure that HRSA meets its objectives related to these systems. • Ensure that HRSA’s NIS, NHSC and FLRP continue to provide database support for submission and processing of yearly on-line applications • Ensure that the NIS, NHSC and FLRP support business functions through system support and maintenance which includes appropriate access to portions of the databases to enable work required in the external environment for applicants and internal environment for case management processing. Functionality features such as database administration, performance monitoring, Data backup/recovery, transactional reporting dependent on contractual obligations must be monitored. • It is vital to monitor and maintain the continuity of real time data update and real time data distribution. In addition, security conditions must be met ascertaining that the BCRS systems are in compliance with federal e-government initiatives, regulations and guidelines. • Ensure proper access to system data thus increasing accountability. • Ensure BCRSIS Funding Obligation Workflow enables program leaders to smoothly and efficiently submit obligation of funds requests for scholarship and loan repayment. • Ensure awardees of all BCRS programs can electronically submit their banking information and data collection is made consistent to all programs.
Project Description: Quarterly activities for this project included the following activities: • Met with the designated program personnel, project lead and identified staff as needed or weekly during the duration of the project. • Deployed database components based on the approved mock-ups. • Reviewed current sources of data, devised and implemented any changes. • Gathered requirements, and proposed a plan for migrating historical data, and for consolidating and migrating funding action data from three formats (Excel, and paper); • Continued to use SQL Server 2005 database architecture for enhancement and implementation of the BCRS systems to the extent possible. This is consistent with the technology adopted by HRSA Office of Information Technology (OIT). • Maintaining BCRS logical and physical data model along with the data dictionary in an appropriate environment approved by HRSA. • Performing database administration activities including installation of new versions, patches, database backup and monitoring of various automated services. • Increased turnaround time of awards during peak periods by supporting bulk uploads in the backend and creation of planning data on an as-needed basis. • Providing tier 2 support for all database and technical in a rapid manner without compromising quality. • Administering all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. • Enforcing and maintaining database constraints to ensure integrity of the database by creating appropriate foreign keys and primary keys on all tables. Similarly appropriate indexes are created to optimize data retrieval performance. • Reducing the usage of triggers in the database ensures intuitive and clear coding of business logic within stored procedures. • Performing ongoing tuning of the database instances, implementing backup/recovery, restructures, reorganization, security, and user validation. • Managing external and internal user accounts, roles and privileges.
Jobs Summary: As a result of the American Recovery and Reinvestment Act (AARA) of 2009, Health Resources and Services Administration (HRSA) and Bureau of Clinician Recruitment Service (BCRS), have decided to enhance the systems and applications that support the BCRS’ scholarship and loan programs in order to process a significantly higher number of scholarship and loan applications than they were designed to do. These BCRS systems are very critical to HRSA’s mission to improve the nation’s health by assuring reasonable access to comprehensive quality health care for all. This created one job for a database administrator through which Compubahn supported HRSA in database administration, reports, and application programming and ensured that HRSA met its objectives related to these systems. Bureau of Clinician Recruitment and Service (BCRS) play a major role in accomplishing the Health Resources and Services Administration’s (HRSA) mission of providing leadership and direction to programs and activities which made major impact in: • Improving the health of the Nation's underserved communities and vulnerable populations by coordinating the recruitment and retention of caring health professionals in the healthcare system and supporting communities' efforts to build more integrated and sustainable systems of care. • Supporting students and clinicians with a desire to serve by identifying clinical experiences in underserved areas, job placement assistance and scholarship and educational loan repayment opportunities. • Supporting the development of health professions faculty to train the next generation of health care professionals. • Supporting HRSA grantees, other safety net providers, and critical nursing shortage facilities with technical assistance and support to develop effective recruitment and retention programs in their communities, including the utilization of the various scholarships, loan repayment and recruitment programs administered through the bureau. (Total jobs reported: 1)
Project Status: Less Than 50% Completed
This award's data was last updated on May. 18, 2009. Help expand these official descriptions using the wiki below.