DATABASE SPECIALIST II
Recruitment #21-004480-0009
Department | MSP - Support Services Bureau |
---|---|
Date Opened | 11/23/2021 09:20:00 AM |
Filing Deadline | 12/8/2021 11:59:00 PM |
Salary | $54,279.00 - $87,106.00/year |
Employment Type |
Full-Time
|
HR Analyst | William Boniarski |
Work Location |
Baltimore County
|
Introduction
GRADE
LOCATION OF POSITION
Maryland State Police
Information Technology Division
1201 Reisterstown Road
Pikesville, MD 21208
POSITION DUTIES
Database Administration: Supervise and support Department personnel in the following tasks: Maintain and monitor database and server performance; Perform maintenance of databases; Perform database backups and restore; Monitor systems capacity and allocate space according to overall needs; Diagnose and resolve data problems for system users; Diagnose and resolve data storage, data access and data software problems; Document database back-up policy and procedure; Design and document database recovery solutions; Maintain SQL Server engines by applying periodic upgrades and patches.
Planning and Development: Perform system analysis of existing database system and recommend strategies for improvement and migration into Oracle; Prepare long and short range plans for conversion of existing file structures to a Department standard; Evaluate and recommend technology-based solutions or alternatives for end users; Develop and update policy, procedures and manuals regarding the use of Department database systems.
Perform additional information systems-related duties as circumstances require.
MINIMUM QUALIFICATIONS
Education: 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.
Experience: One year of experience designing, developing, implementing, maintaining and controlling database management systems for computers.
Notes:
1. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate plus 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 required education.
2. Candidates may substitute graduation from an accredited high school or possession of a high school equivalency certificate and one additional year 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 for the required education.
3. Candidates may substitute possession of 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 high school education.
4. 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 education.
DESIRED OR PREFERRED QUALIFICATIONS
Preferred Qualifications:
1. SQL Server Certification (MCSA or MCSE)
2. Three years minimum as a SQL Server DBA
3. Experience working with law enforcement databases
4. Knowledge/Experience in writing complex T-SQL scripts, stored procedures, functions and views
5. Knowledge/Experience in creating SSIS packages
6. Experience with Backup and Recovery of SQL Databases
LICENSES, REGISTRATIONS AND CERTIFICATIONS
SPECIAL REQUIREMENTS
Employees in this classification may be subject to call 24 hours a day and, therefore, may be required to provide the employing agency with a telephone number where the employee can be reached.
In accordance with Section 2-204(b)(6) of the Public Safety Article, Candidates for position in this classification will 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.
SELECTION PROCESS
The selection process for this recruitment will involve a rating of the training and experience provided on the application. Applicants who meet the minimum qualifications will be placed on an eligible list in the BEST QUALIFIED, BETTER QUALIFIED, and QUALIFIED categories. The list will be used by the hiring manager to select the individual to fill this vacancy. The list will be valid for one year.
EXAMINATION PROCESS
The examination will consist of a rating of your education, training and experience related to the requirements of the position. You may be required to complete a qualifications supplement, or the rating may be based on your application. Report all experience and education that is related to this position.
BENEFITS
FURTHER INSTRUCTIONS
NOTE: Currently, applicants are limited to uploading one file. As a result, it is strongly urged that those applying upload ALL required and additional documents (undergraduate and graduate transcripts, resumes, etc.) as one file. If you are unable to apply online, you may submit an application via mail. The Maryland State Application Form can be found online.
Completed applications, required documentation and any required addendums may be mailed to:
Maryland State Police
Human Resources Division
1201 Reisterstown Road
Pikesville, MD 21208
ATTN: William Boniarski
william.boniarski@maryland.gov
It is the policy of the Maryland State Police to comply with all applicable federal and state laws prohibiting employment discrimination and to provide equal employment opportunity to all employees and applicants for employment without regard to age, ancestry, color, gender, identity and expression, genetic information, marital status, mental or physical disability, national origin, race, religious affiliation, belief or opinion, sex, sexual orientation or any other protected status.