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 18 LOCATION OF POSITION Maryland State Police Information Technology Division 1201 Reisterstown Road Pikesville, MD 21208 Main Purpose of Job Developing and managing the Department’s Oracle databases and related documentation used to track and query data for the Maryland State Police and allied agencies.
The position will be responsible for the migration, operation, maintenance and backups of the Oracle database systems in the Department.
POSITION DUTIES Position duties include but not limited to: 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; Performs other related duties as assigned.
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 NOT APPLICABLE.
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 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 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.
If you have any questions about this recruitment, please contact the Maryland State Police at 410-653-4420.
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.