DATABASE SPECIALIST

State of New Hampshire Job Posting NH Department of Corrections Division of Administration 64 South Street Concord, NH 03301

DATABASE SPECIALIST

Position # 40224 $34.14/hour - $46.63/hour See total compensation information at the bottom of announcement. The State of New Hampshire, NH Department of Corrections, Division of Administration has a full-time vacancy for Database Specialist. Summary Acts as lead application development specialist to direct, oversee, monitor and coordinate the selection, design, development, security, performance and maintenance of Microsoft SQL databases. Assumes responsibility for data that is accessed and updated by Inmate Service applications such as education, recreation and industries in addition to data that is accessed and updated by agency staff.

YOUR EXPERIENCE COUNTS

Each additional year of approved formal education may be substituted for one year of required work experience and/or each additional year of approved work experience may be substituted for one year of required formal education.

MINIMUM QUALIFICATIONS

Education/Experience: Equivalent combination of 10 years of education and experience after completion of high school. Education and experience must be in computer science, computer programming, systems analysis, or a related field, with at least 3 years in systems analysis associated with late generation medium or large scale on-line computer systems or computer networks. License/Certification: None Other Requirements: Must pass security and background screenings required for correctional environments Trainee Option: Not applicable

PREFERRED QUALIFICATIONS

None

AFTER-HIRE REQUIREMENTS

None

CAREER ADVANCEMENT OPPORTUNITIES

In-Band Advancement Available: Yes No Criteria: None Broad Group Level Advancement Available: Yes No Criteria: None

DISCLAIMERS

The supplemental job description lists the essential functions of the position and is not intended to include every job duty and responsibility specific to the position. An employee may be required to perform other related duties not listed on the supplemental job description provided that such duties are characteristic of that job title. When applicable, the work of an employee in trainee status in this position shall be overseen by a fully qualified individual. An employee in trainee status shall meet the minimum qualifications within the period of time specified on the SJD, not to exceed one year of being hired into this position. Responsibilities DETAILED TASKS (STANDARD): None

DETAILED TASKS (AGENCY/POSITION-SPECIFIC):

Oversees, monitors, directs and performs the creation and modification of computer programs, interfaces, and documentation for the creation and maintenance of applications with the primary focus to automate Inmate Services including but not limited to education, recreation and industries areas. Develops and maintains data marts, cubes, views and complex queries for operations; performs research, analysis and statistical reporting for internal and external business needs. Audits and evaluates agency adherence to data management policies including validating access and data and identifying and reviewing data anomalies. Directs personnel in formulating database plans and system solutions to assure functionality, capacity and performance efficiency to allow for daily operations and for research and data analysis. Develops and administers policy and procedures to ensure data security and data integrity including procedures for backup and recovery. Identifies, defines, designs, constructs, and modifies software and hardware systems, including integrating new systems with existing databases while maintaining current database structures. Researches and develops new solutions to existing problems or new requirements relating to the network, including interfacing with a variety of internal and external customers to identify data requirements and provide data for operational needs. Implements software and processes to monitor user access and provide alerts for security issues. Provides logs for access and data changes to legal counsel and investigation staff for investigation and litigation purposes. Continually reviews utilization of hardware and software for forecasting changes that will take place in any and all aspects of the database and information retrieval needs of the agency, providing short and long-term capacity planning allowing the agency adequate lead time to secure funding and to plan and implement needed changes. For further information please contact DOC-Recruitment at View email address on click.appcast.io or at View phone number on click.appcast.io.

TOTAL COMPENSATION INFORMATION

The State of NH total compensation package features an outstanding set of employee benefits, including: HMO or POS Medical and Prescription Drug Benefits: The actual value of State-paid health benefits and the amount of employee health benefit contributions may vary depending on the type of plan selected and the bargaining unit with which a position is associated. See this link for details on State-paid health benefits: Value of State's share of Employee's Retirement: 12.87% of pay Other Benefits Dental Plan at minimal cost for employees and their families ($500-$1800 value) Flexible Spending healthcare and childcare reimbursement accounts State defined benefit retirement plan and Deferred Compensation 457(b) plan Work/life balance flexible schedules, paid holidays and generous leave plan $50,000 state-paid life insurance plus additional low-cost group life insurance Incentive-based Wellness Program (ability to earn up to $500) Total Compensation Statement Worksheet: Want the specifics? Explore the Benefits of State Employment on our website: EOE TDD Access: Relay NH View phone number on click.appcast.io #J-18808-Ljbffr State of New Hampshire