DATABASE SPECIALIST II
Recruitment #23-004480-0001
Department | MSP - Support Services Bureau |
---|---|
Date Opened | 2/27/2023 11:20:00 AM |
Filing Deadline | 3/20/2023 11:59:00 PM |
Salary | $63,556.00 - $98,523.00/year |
Employment Type |
Full-Time
|
HR Analyst | Tiffany Hazel |
Work Location |
Baltimore County
|
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
LOCATION OF POSITION
Main Purpose of Job
POSITION DUTIES
Monitor database performance
Perform routine maintenance of databases
Perform database backups and recovery
Install, configure, patch and maintain Oracle software on Unix
environment focusing on Red Hat Linux platform
Manage the file system on Red Hat Linux platform
Configure and maintain Oracle Data Guard and Oracle Audit Logs
Monitor systems capacity and allocate space according to overall
needs
Implement CLIENT database security standards for Oracle database
environment
Tune database parameters for optimal system performance
Assist developers and DBAs in detecting performance problems
including analysis of SQL and PL/SQL code
Provide continuous monitoring, troubleshooting, historical and
real time performance monitoring of the Oracle environments
Diagnose and resolve data problems for system users, storage
problems, access problems, and software problems
Document database back-up policy
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
qualification(s). Include clear and specific information on your application
regarding your qualifications.
5+ years of professional
experience as an Oracle DBA
Significant experience with
Oracle 12c and 19c architecture and database design on Linux
Experience with development and
other solution teams on DB architecture and design
Knowledge/experience in writing
and optimizing SQL and PL/SQL scripts, stored procedures, functions and views
Knowledge/experience with
Oracle Multitenant architecture (CDB/PDB)
Experience with backup,
recovery, patching, upgrades, tuning, capacity planning and optimization of
database environments
Experience using Oracle Data
Guard
Knowledge of
Oracle database administration on ODA platforms
LICENSES, REGISTRATIONS AND CERTIFICATIONS
SPECIAL REQUIREMENTS
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.
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
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
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.