DATABASE SPECIALIST II **REPOST**
|Department||MDH Deputy Secretary for Operations|
|Date Opened||10/22/2019 11:59:00 PM|
|Filing Deadline||4/10/2020 11:59:00 PM|
|Salary||$53,214.00 - $69,215.00/year, with potential growth to $85,398.00/year|
|HR Analyst||Michelle Johnson|
RECRUITMENT REPOSTED. PREVIOUS APPLICANTS NEED NOT REAPPLY.
LOCATION OF POSITION
MDH, Office of Enterprise Technology - Applications Division, Baltimore, MD
Main Purpose of Job
The main purpose of this position is to work closely with the MDH-OET Enterprise Database Administrator. This position will monitor, maintain and administer enterprise databases for and in MDH. This position will design, implement and administer numerous SQL Server instances and databases by ensuring operational integrity, establishing performance benchmarks, monitoring and analyzing system bottlenecks and proposing solutions to eliminate them. This position will participate in continuity of operations, high availability and disaster recovery exercises and perform database backup, restoration, and recovery. This position will be required to create and maintain database documentation including templates, guides, and other materials. This position will develop and execute migration plans for regular upgrades of all SQL servers to the latest version and for migrating databases to cloud platforms. In addition, this position will integrate and maintain all software and hardware components used to comprise the enterprise systems on the local and wide-area networks.
Education: 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. 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 may be substituted for the required education.
2. 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 may be substituted for the required education.
3. 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 may be substituted for high school education on a year-for-year basis.
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 and education.
DESIRED OR PREFERRED QUALIFICATIONS
The desired candidate should have experience in the following:
---Trouble shooting SQL Server performance issues
---Instance and database level security experiences
---Routine maintenance including database backups, indexing and defragmentation
---SQL server instance and database upgrading skills
---SQL Server high availability and disaster recovery experiences
---Database migration from Oracle to SQL to PostgreSQL
---Working experience on SQL Server SSIS. Creating and upgrading packages
---Developing SQL Server Reporting Service reports and administration
---Creating and maintaining SQL Server Analysis services cubes
---Generating ad-hoc queries as requested by users
---Basic understanding of HL7 structures and Rhapsody engine
---Managing and patching windows servers
---Managing sFTP servers
LICENSES, REGISTRATIONS AND CERTIFICATIONS
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 or will be furnished with a pager.
Applicants who meet the minimum (and selective) qualifications will be included in further evaluation. The evaluation may be a rating of your application based on your education, training and experience as they relate to the requirements of the position. Therefore, it is essential that you provide complete and accurate information on your application. Please report all related education, experience, dates and hours of work. Clearly indicate your college degree and major on your application, if applicable. For education obtained outside the U.S., any job offer will be contingent on the candidate providing an evaluation for equivalency by a foreign credential evaluation service prior to starting employment (and may be requested prior to interview).
Complete applications must be submitted by the closing date. Information submitted after this date will not be added.
Incorrect application forms will not be accepted. Resumes will not be accepted in lieu of a completed application.
Candidates may remain on the certified eligible list for a period of at least one year. The resulting certified eligible list for this recruitment may be used for similar positions in this or other State agencies.
Online applications are highly recommended. However, if you are unable to apply online, the paper application (and supplemental questionnaire) may be submitted to MDH, Recruitment and Selection Division, 201 W. Preston St., Room 114-B, Baltimore, MD 21201. Paper application materials must be received by 5 pm, close of business, on the closing date for the recruitment, no postmarks will be accepted.
If additional information is required, the preferred method is to upload. If you are unable to upload, please fax the requested information to 410-333-5689. Only additional materials that are required will be accepted for this recruitment. All additional information must be received by the closing date and time.
For questions regarding this recruitment, please contact the MDH Recruitment and Selection Division at 410-767-1251.
If you are having difficulty with your user account or have general questions about the online application system, please contact the MD Department of Budget and Management, Recruitment and Examination Division at 410-767-4850 or Application.Help@maryland.gov.
Appropriate accommodations for individuals with disabilities are available upon request by calling: 410-767-1251 or MD TTY Relay Service 1-800-735-2258.
We thank our Veterans for their service to our country.
People with disabilities and bilingual candidates are encouraged to apply.
As an equal opportunity employer, Maryland is committed to recruitment, retaining and promoting employees who are reflective of the State's diversity.