Cogent+Infotech+Contract+Summary+.docx

ND STATE CONTRACT INFORMATION

CONTRACT INTRODUCTION

The contract is Information Technology professional services in a variety of IT Contract Pool Categories. The State has an ongoing need for Information Technology (IT) professionals in a variety of categories for both project-based and staff-augmentation work. Multiple vendors have been awarded contracts in each of the IT Contract Pool Categories. State agencies may use a structured work order request process to obtain IT professional services through this contract. Use the links below to see the job class definitions, experience levels and required skill sets in each of the contract pool categories, vendors awarded in each category, schedule of vendor hourly rates, and vendor contact information:

VENDOR POOL GUIDELINES

Effective August 1, 2025, this Contract will be subject to Guidelines for Multiple Award Vendor Pool Contracts - Indefinite-Delivery, Indefinite-Delivery - Multistep Competition pursuant to House Bill No. 1122 and N.D.C.C. 54-44.4. See Guidelines, Rules and Laws | Office of Management and Budget North Dakota.

State Agency/Boards/Commissions - IT Review for any category EXCEPT Project Manager - Any purchases made under this contract needs to be reviewed by NDIT. Submit an IT Review Request in the NDIT Service Portal. After logging into the portal, search “IT Review” to locate the form that needs to be completed. Once approved, continue with the ordering process in this contract summary. NDIT IT Review is not required for NDUS, K-12 or political subdivisions.

See Work Order Process below regarding the issuance of work orders to vendors. It is recommended that no work orders extend beyond the contract term listed for each vendor in the respective category.

IT Contract Pool Categories Database Administrator – Oracle

CONTRACTOR INFORMATION

Check the State contract website for the contractor and contract administrator information.

COOPERATIVE PURCHASING

This contract is a cooperative purchasing contract established pursuant to North Dakota Century Code Sections 15.1-09-34(1)(k), 54-44.4-13, and 54-59-18. Though not a party to this contract, North Dakota State Colleges and Universities, K-12 schools, city, county, and local governments, tribal agencies, transportation providers under N.D.C.C chapter 39-04.2, International Peace Garden and nonprofit organizations established on behalf of public entities are eligible to participate in this contract. Contact the contract administrator if you are not sure you are eligible to participate.

ORDERING INFORMATION

Work Order Process When an agency requires IT services, the agency will prepare a work order request describing the needed work. The work order form is available from the OMB State Contract web page, listed under contract #095.

There are several vendors within each IT Contract Pool Category, and the number of vendors an agency must solicit to submit a project proposal is determined by the estimated cost of the IT project. Vendors who are invited to submit project proposals must be priced at, or below, the rates proposed and contractually obligated.

*The Onsite rate must cover all travel related expenses other than “Short Notice” Work Order Requests. Short Notice requests are those issued to Vendors with less than 14 calendar days to project start date. In such cases, Vendors may be allowed, with the approval of the agency issuing the work order, to bill supplemental travel expenses caused by the short notice. The Vendor must provide documentation justifying the supplemental travel expense billing.

1. Projects estimated at less than $250,000:

a. Direct Assignment. An agency may issue a work order request directly to any of the awarded vendors in the appropriate pool category.

b. Competitive - An agency may elect to conduct a competitive process by requesting project proposals from two or more vendors. The agency will select the vendor project proposal that best meets the SOW requirements based upon the selection criteria stated in the work order request.

2. Projects estimated at $250,000 or more:

a. Direct Assignment - An agency may issue a work order request directly to an awarded vendor if prior approval is granted by the contract administrator.

b. Competitive - An agency must issue a work order to all of the awarded vendors in the respective category. The agency will select the vendor project proposal that best meets the SOW requirements and selection criteria stated in the work order request.

When you are ready to issue a Work Order, review the instructional document located on the OMB State Procurement website, under contract #095.

ITD Review / Approval Process Work Orders anticipated to be over $25,000 must be reviewed and approved by ITD Policy and Planning Division. Submit the Work Order to ITDProcurement@nd.gov . ITD is also available to answer questions and provide assistance to agencies in generating work orders.

1. Submit draft work order for review prior to issuing to vendor(s).

1. Submit final work order with vendor proposal for approval prior to executing the agreement.

Project Management and Change Control A change order process will be used to manage issues and changes during the life of a work order project. A change request must be in writing using a Change Order form to document the potential change. The change will be reviewed and, if acceptable to the agency, the vendor will submit an estimate of the charges and the anticipated changes in the delivery schedule that will result from the proposed change in the scope of work. A Change Order must be approved and signed by both parties prior to implementation of the change. A sample Change Order form is available from the Contract 095 web page.

Customer Satisfaction Surveys Upon completion of each work order, the requesting agency may complete a customer satisfaction survey rating the agency’s satisfaction with quality of work, cost and schedule adherence, and contract compliance. Contractors will be provided copies of the surveys completed for work they have performed under the contract.

The customer satisfaction surveys will be submitted to the Contract Administrator to be used in evaluating performance under this contract. Dissatisfaction with vendor performance indicated on agency customer satisfaction surveys may be used by the State in making a determination to terminate or restrict a vendor’s contract. The Customer Satisfaction Survey form is available as an attachment on the Contract 095 web page.

Frequently Asked Questions A list of frequently asked questions and answers is available from the Contract 095 web page.

Professional Services Contract Pool Categories Database Administrator - Oracle Category *Reminder – work orders estimated at $250,000 or greater must be sent to all vendors listed in the category.

Database Administrator - Oracle Create and manage database objects according to business requirements

· Performs review and tuning of SQL code

· Performs database tuning and monitoring

· Monitor and audit database access

· Perform capacity planning

· Ensures database integrity; schedules database backup; provides for database recovery

· Supports development databases including refresh from production databases

· Transfers and maintains production program code

· Assists programmers or writes conversion programs to support changes in database structure; applies conversions, and verifies integrity of converted data

· Assists in providing twenty-four hour coverage for database support

· Maintains current procedure manuals for the maintenance of databases on existing systems

· Provides extensive troubleshooting and problem solving of database and application development issues for applications

· Works with vendors in support of database and administration toolsets enhancements that are beneficial to State applications

· Installs new and upgrades existing databases and administration toolsets; coordinates with development on testing and implementing enhancements and new features/functions

· Assists and trains State’s application development and technical staff in database technologies and methods

Database Administrator – Oracle Experience

· Requires four years of experience in this classification in the last five years

· Experience in design, implementation, and manipulation of database management systems, data warehouses, and multidimensional databases. Experience with design of relational databases and data manipulation.

· Experience in Oracle RAC infrastructure support and troubleshooting

Database Administrator – Oracle Skill Set

· Primary technical skill set includes Oracle RDBMS, Structured Query Language, ODBC, JDBC, and XML

· Secondary technical skill set includes COGNOS, SAS, and Informatica

· Interpersonal skill set includes strong analytical, problem solving skills, be able to work well with people and possess strong communication skills as needed to mentor others, communicate highly technical information to non-technical and technical users, written and verbal English language proficiency image1.png