Junior Database Management Specialist

Interon IT Solutions; Baltimore (MD); On-site; USD 80,000 - 110,000; Full time

Job summary

Interon IT Solutions seeks a Database Management Specialist (Junior) to provide technical expertise in DBMS usage, evaluate products, and meet user requirements for Maryland statewide systems.

The role covers defining file organization, implementing backup/recovery, ensuring data integrity, security, and recovery readiness in production environments. Collaboration with network and management teams is essential.

Qualifications

• Bachelor's degree in a related field or 3 years of equivalent experience.
• At least 5 years of experience in DBMS systems analysis and programming.
• At least 3 years of experience using current DBMS technologies and designing applications.

Responsibilities

• Ensure servers are current with DBMS patches and security updates.
• Configure hardware/software, perform integration testing, and transition statewide systems from testing to production.
• Install and upgrade database servers and related software to support critical systems.
• Assist DBMS users and developers with SQL design, queries, stored procedures and tuning.
• Perform routine database server maintenance and proactive monitoring.

Skills

DBMS analysis

SQL

Backup and recovery

Security procedures

Education

Bachelor's degree or 3 years experience

Tools

Microsoft SQL Server

Server imaging

Job description

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)

Position Overview

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.

Required qualifications

Education

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.

General Experience

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

Specialized Experience

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

Duties And Responsibilities

• 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.