ECI/Database Developer

Description

The ECI Database Developer manages enterprise data by installing/maintaining ECI software systems for information sharing between AOPC's case management systems and external agencies. This includes creating data stores and T-SQL code that align with best practices.

Primary Duties

• Designs, implements and maintains database code objects, including stored procedures and views in Sybase Adaptive Server Enterprise environments.
• Collaborates with application developers to create and maintain database code objects, following database standards and best practices.
• Participates in designing the data model for new applications and making changes and improvements to existing ones.
• Communicates regularly with the supervisor on tasks, system issues, and project statuses.
• Manages and conducts thorough testing of database objects and scripts.
• Performs peer code reviews of database objects and scripts to ensure proper use of enterprise standards and best practices.
• Creates and updates technical documents and specifications related to database objects and scripts.
• Participates (with a team of six) in an on-call weekly rotation to support critical systems outside regular working hours.
• Facilitates the development of cross-court functionality by understanding the data hub database design and the design of internal court case management systems.
• Identifies SQL code performance issues and optimizes SQL code for performance.
• Maintains and increases understanding of the general database design and application capabilities.

Minimum Qualifications

• Bachelor’s degree with an IT-related major or minor, PLUS
• Two years of IT experience involving the analysis, design, and programming of database objects in overall application support, OR
• An equivalent combination of education, experience, and/or training may be considered.

Additional Requirements/Preferences

• Extensive experience in client-server application development using T-SQL for coding stored procedures and database scripts with a good understanding of relational database concepts required.
• Advanced working knowledge of SAP (formerly Sybase) Adaptive Server Enterprise preferred.
• Satisfactory criminal background check required.

Additional Information

• Excellent benefits program including comprehensive, low-cost medical, dental, vision, and prescription plans for employees and eligible family members beginning on the first day of employment; 13 paid holidays, 12 paid sick days, and 12+ paid vacation days per year; salary increases; student loan forgiveness plan; employee assistance programs; and retirement plans.
• Free parking.
• Two telework days per week available after initial training period

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.