Database Specialist Ii; Sql Dba

Introduction

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

20

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.

• 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, 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,…