Junior Database Management Specialist

Junior Database Management Specialist

Location: 6 St. Paul Street, Baltimore, MD (Only Local to Maryland)

Duration: 5-year project: 2-year base term plus three 1-year options

Openings: 1 position

Interview: In-person interview required

Resume requirement: One-page resume only

Pay rate: ./hr on W2

Labor category: Statewide Agile Resources and Teams 2024 - Database Management Specialist (Junior)

Provide technical expertise and support in the use of database management systems (DBMS), including evaluation and recommendation of available products to meet validated user requirements.

• Define file organization, indexing methods, and security procedures for specific user applications.
• Develop, implement, and maintain database backup and recovery procedures for processing environments.
• Ensure data integrity, security, and recoverability are built into DBMS applications.

Bachelor's degree from an accredited college or university in computer science, information systems, engineering, business, or a related scientific or technical discipline; or 3 years of equivalent experience in a related field.

At least 5 years of experience in DBMS systems analysis and programming.

At least 3 year of experience using current DBMS technologies, designing applications using various database management systems, and working with DBMS internals.

• Ensure servers are current with DBMS patches and security updates.
• Configure and tweak the hardware and software, perform integration testing, create and restore server images, create and implement plans to transition the MDOT MTA's statewide systems from testing to production.
• Install and upgrade database servers and related software on MDOT MTA's specified hardware to support critical systems.
• 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.
• Perform routine database server maintenance and proactive monitoring, including deleting log files and dump files and correcting errors.
• Troubleshoot problems related to availability of data to system users, space, database software, dataflow, and data storage or data access.
• Attend internal MDOT MTA staff meetings as requested with network team, project managers, business users, developers and upper management.
• Work in cooperation with the current Network Management Systems contractor as well as other contract vendors and MDOT MTA team members.
• Create or review Configuration Change Requests, Work Breakdown Structures, Implementation Plans, and Testing Plans for Microsoft SQL Server database projects.
• Create or provide appropriate input to monthly project status reports.
• Participate in creating or reviewing hardware and software requirements for database systems.
• Configure a backup job to run on a specified schedule.
• Restore data files or tables from a previous backup session.
• Perform other related duties as assigned by MDOT MTA management.