Database Specialist II

State of Maryland • Baltimore County, MD

2d

About The Position

This position will serve within the Information Technology Division of the Support Services Bureau. This position is critical to the continuity of operations for Delta Plus as well as other applications and data management. Positional duties include development, operation, maintenance, backups, and migration of relational database systems for the department. This position requires the educational background and professional experience to develop, implement, maintain, and control database systems. The position will primarily work with SQL databases but will also have interactions with Oracle and Access databases.

Requirements

• Two years of experience, designing, developing, implementing, maintaining and controlling database management systems for computers and, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining and modifying operating systems for computers.
• Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and thirty credit hours from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science or other information technology-related field to include course work in database management systems for the of experience designing, developing, testing, implementing and maintaining applications systems and programs using generally accepted computer programming languages or maintaining and modifying operating systems for computers.
• Candidates may substitute two years experience operating computer systems; or scheduling, controlling input and output or maintaining a tape library to process data on computer systems; or converting data from project specifications by developing program code using generally accepted computer programming languages on a year-for-year basis for graduation from an accredited high school or possession of a high school equivalency certificate.
• Candidates may substitute the possession of a Bachelor's degree from an accredited college or university in Computer Information Technology, Management Information Systems, Computer Science or other information technology related field to include course work in database management systems for two years experience designing, developing, implementing, maintaining and controlling database management systems for computers for the required experience.
• Candidates may substitute U.S. Armed Forces military service experience as a commissioned officer in Database Administration classifications or Database Administration specialty codes in the Information Technology field of work on a year-for-year basis for the required experience.

Nice To Haves

• 3+ years of experience as a SQL Server DBA in a production environment
• Possession of Microsoft Certified: SQL Server Database Administrator certification (e.g. MCSA or MCSE certification)

Responsibilities

• Maintain, monitor, and optimize performance for databases and servers
• Monitor capacity and allocate space
• Perform database backup and restore
• Diagnose and resolve data quality issues
• Diagnose and resolve data access issues
• Diagnose, and resolve database software issues
• Maintain SQL Server engines by applying periodic updates and patches
• Optimize stored procedures and queries
• Maintain and enforce database permissions and security
• Maintain rest servers and SQL instances as needed for development purposes
• Create views, procedures, and functions as needed
• Setup, configure, and maintain data encryption
• Work with application developers to implement required changes
• Assist Oracle data systems staff
• Performs other duties as required

Benefits

• STATE OF MARYLAND BENEFITS

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED