DATABASE SPECIALIST II

Introduction

It is important that all

experience be fully documented. Failure to ANSWER ALL SUPPLEMENTAL QUESTIONS

SPECIFICALLY AND ACCURATELY may cause the candidate to be rejected.

PLEASE FILL OUT THE APPLICATION

COMPLETELY.

➢ The application is part

of the examination process. Your answers will determine your eligibility

to participate in the next phase of the selection process.

➢ Clearly describe your

qualifications in detail. Credit cannot be given for education, training,

experience, knowledge, skills, and abilities that you fail to indicate.

➢ Do not leave any answer

spaces blank; if a question does not apply, write 'N/A'.

➢ Although you may attach a

resume to further describe your qualification, it does not substitute for

completing the application form. An incomplete application form may result in

disqualification. Do NOT write 'see resume' in your work history or

responses to supplemental questions.

➢ Failure to comply with

these instructions may result in disqualification.

➢ Read the Job Announcement

carefully for specific filing instructions, supplemental questions, and final

filing dates.

GRADE

20

LOCATION OF POSITION

Maryland State Police

Information Technology

Division

1201 Reisterstown Road

Pikesville, MD 21208

Main Purpose of Job

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.

POSITION DUTIES

Duties include but are not

limited to:

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;

Performs other duties

as required

MINIMUM QUALIFICATIONS

Experience: 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.

Notes:

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

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

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

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

DESIRED OR PREFERRED QUALIFICATIONS

Preference will be given to

applicants who possess the following preferred qualifications. It is important

that you include clear and specific information on your application regarding

your qualifications.

1.

3+ years of experience as a SQL

Server DBA in a production environment

2.

Possession of

Microsoft Certified: SQL Server Database Administrator certification (e.g. MCSA

or MCSE certification)

LICENSES, REGISTRATIONS AND CERTIFICATIONS

NOT APPLICABLE.

SPECIAL REQUIREMENTS

In accordance with Section

2-204(b)(6) of the Public Safety Article, candidates for position in 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 with a telephone number where the

employee can be reached.

SELECTION PROCESS

Only candidates who meet the minimum qualifications will

be considered for this classification. Therefore, it is essential that you

provide complete and accurate information on your application. Successful

candidates will be placed on the Eligible List categorized as BEST QUALIFIED,

BETTER QUALIFIED or QUALIFIED and remain eligible for consideration for at

least one year from the date of examination. The list will be used by the

hiring manager to select employees. 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

STATE OF MARYLAND 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: Tiffany R. Hazel

For questions regarding this recruitment, contact tiffany.hazel@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.

TTY Users: call via Maryland Relay.

We thank our Veterans for their service to our country

and encourage them to apply.

As an equal opportunity employer, Maryland is committed

to recruiting, retaining, and promoting employees who are reflective of the

State’s diversity.

Bilingual applicants are encouraged to apply.