AOPC - Database Technician (21-20)

Description

This is beginning-level professional information technology work. Responsibilities include performing metadata administration, application security administration, and data analysis for the AOPC’s case management systems.

Primary Duties

• Monitors helpdesk ticket queues and prioritizes tasks based on severity and priority levels.
• Performs lookup value and metadata entry and maintenance to support the application.
• Understands the AOPC Administration screens and uses the application where appropriate.
• Performs user security change requests using in-house tools and template T-SQL scripts.
• Utilizes knowledge of T-SQL to perform application metadata and security maintenance activities.
• Performs testing of lookup values, metadata modifications, and application security for quality assurance.
• Performs metadata analysis to ensure the case management systems function properly.
• Assists with maintaining procedural documentation for the metadata administration and application security tasks.
• Assists team members and training staff with the collection and implementation of metadata.

Minimum Qualifications

• Associate’s Degree with an IT-related major or minor; AND
• One year of related IT experience.
• An equivalent combination of education, experience, and / or training may be considered.

Additional Requirements/Preferences

• Satisfactory criminal background check required.
• Basic knowledge and understanding of T-SQL fundamentals preferred.

Additional Information

Unified Judicial System Hiring Policy

The Unified Judicial System of Pennsylvania recruits, employs, and promotes the most qualified applicants without regard to their political affiliation, race, color, age, national origin, sex, sexual orientation, gender identity or expression, religion, disability, or other non-merit facts or considerations. Reasonable accommodations will be provided to applicants with disabilities as may be necessary to ensure that all applicants are given a fair and equal opportunity to compete for all employment positions. Applicants who need accommodation for an interview should request so in advance. UJS hiring and employment policies and procedures are intended to conform to all applicable state and federal laws governing fair and non-discriminatory hiring and employment practices and are subject to change as necessary to remain in compliance with such laws.

Applicants requiring accommodation, for any part of the application and/or interview process, should contact Human Resources at (717) 231-3309 or human.resources@pacourts.us.