Junior DBA with MDOT exp is a must

Scope of Work: The purpose of this work order is to obtain resources to provide services and support for the MS

SQL Servers and Oracle/UNIX Linux database operations, maintenance, and mission critical business applications. In addition, all resources will support other client/server and web base systems, provide guidance concerning application security, and give continual supportive information concerning best practices in planning, designing, and implementing emerging database management technology solutions.

Role – Database Management Specialist (Junior) - 1 position

$50 - $60/hr max C2c

Statewide Agile Resources and Teams 2024–Labor Category – Database Management Specialist (Junior)

Position Description: The Database Management Specialist (Junior) shall provide highly technical expertise and support in the use of DBMS. This individual shall evaluate and recommend available DBMS products to support validated user requirements. This individual is responsible for performing the following tasks:

A. Defining file organization, indexing methods, and security procedures for specific user applications;

B. Developing, implementing, and maintaining database back-up and recovery procedures for the processing environments; and

C. Ensuring that data integrity, security, and recoverability are built into the DBMS applications.

Education: This position requires a Bachelor’s degree from an accredited college or university with a major in computer science, information systems, engineering, business, or a related scientific or technical discipline; or three (3) years of equivalent experience in a related field.

General Experience: The proposed candidate must have at least three (3) years of experience in DBMS systems analysis and programming.

Specialized Experience: The proposed candidate must have at least one (1) year of experience in using current DBMS technologies, application design utilizing various database management systems, and experience with DBMS internals.

Duties and Responsibilities:

1. Ensure servers are current with DBMS patches and security updates
2. Configure and tweak the hardware and software, perform integration testing, create and restore server images, create and implement plans to rollover the MDOT MTA’s statewide systems from testing to production.
3. Install and upgrade database server and other related software on the MDOT MTA’s specified hardware to provide functional capabilities for the critical systems.
4. Assist MDOT MTA’s business side system administrators on database issues/errors and assist users and application developers with SQL database design, queries, stored  procedures and tuning.
5. Conduct routine maintenance tasks on the database servers for proactive monitoring like deleting log files, dump files, error correcting.
6. Troubleshoot problems related to availability of data to system users, space, database software, dataflow, and data storage or data access.
7. Attend internal MDOT MTA staff meetings as requested with network team, project managers, business users, developers and upper management.
8. Work in cooperation with the current Network Management Systems contractor as well as other contract vendors and MDOT MTA team members.
9. Create or review Configuration Change Requests, Work Breakdown Structures, Implementation Plans, and Testing Plans for Microsoft SQL Server database projects.
10. Create or provide appropriate input to monthly project status reports.
11. Participate in the creation of or review hardware and software requirements for database systems.
12. Configure a backup job to run on a specified schedule.
13. Restore data files or tables from a previous backup session.
14. Perform other related duties as assigned by MDOT MTA management.