DATABASE SPECIALIST

State of New Hampshire; New Hampshire; On-site; USD 47,000 - 65,000; Full time

Benefits offered by this job

Dental Plan

Flexible Spending Accounts

Wellness Program

Life Insurance

Generous leave plan

Job summary

The State of New Hampshire, Department of Corrections, Division of Administration is seeking a Database Specialist in Concord. The role focuses on directing and coordinating SQL database design, development, security, and maintenance for Inmate Services and agency staff applications.

Candidate experience should include data management, complex querying, and performance monitoring. This is a full-time on-site position with comprehensive total compensation information available; security

Qualifications

• Equivalent combination of 10 years of education and experience after high school.
• At least 3 years in systems analysis for late generation medium/large online systems or networks.

Responsibilities

• Oversees and performs creation and modification of programs, interfaces, and documentation for Inmate Services-related applications.
• Develops and maintains data marts, cubes, views and complex queries for operations and analysis.
• Audits data management adherence, validates access and identifies data anomalies.
• Directs database plans and system solutions for functionality, capacity and performance.
• Develops and administers data security and backup/recovery procedures.
• Defines and modifies software/hardware systems, integrating new systems with existing databases.
• Researches new data solutions and interfaces with internal/external customers for data needs.
• Implements access monitors and security alerts; provides logs for investigations.
• Assesses hardware/software utilization for capacity planning and future needs.

Job description

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 [e-mail] or at 603-271-5653.

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: https://www.das.nh.gov/hr/benefits.aspx

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: https://www.das.nh.gov/jobsearch/compensation-calculator.aspx

Want the specifics? Explore the Benefits of State Employment on our website: https://www.das.nh.gov/hr/documents/BenefitBrochure.pdf

https://www.das.nh.gov/hr/index.aspx

EOE

TDD Access: Relay NH 1-800-735-2964