Database Specialist Ii ((Sql Dba

LOCATION OF POSITION

Maryland State Police Information Technology Division 1201 Reisterstown Road Pikesville, MD 21208

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.

• Database Administration
• 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
• Perform other duties as required

Experience:

Two years of experience in designing, developing, implementing, maintaining, and controlling database management systems for computers, testing, implementing, and maintaining applications systems and programs using generally accepted computer programming languages, or maintaining and modifying operating systems for computers.

Notes:

• 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 that includes coursework in database management systems for the required experience.
• 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.
• Substitute 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 that includes coursework in database management systems for two years of experience designing, developing, implementing, maintaining and controlling database management systems for computers for the required experience.
• 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.

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

NOT APPLICABLE.

In accordance with Section 2-204(b)(6) of the Public Safety Article, candidates for this classification may be subject to an initial drug screening and a complete criminal background investigation to include a polygraph examination before permanent appointment can be made. A criminal conviction may be grounds for rejection of the candidate. Employees in this classification may be subject to call 24 hours a day and, therefore, may be required to provide the employing agency…