body > .skiptranslate { display: none !important; } body { top: 0px !important; } /* adjust search box style based content translation display */ @media (max-width: 1024px), (max-width: 1024px) { html:not(.-ignore-tablet-styling) .search-container .search fieldset.active { margin-top: 177px; } }‌‌View‌CollapseSkip to Main ContentADA ComplianceCareersLoginLogoutUser ProfileSearchThe Unified JudicialSystem of PennsylvaniaThe UnifiedJudicial Systemof PennsylvaniaOpinions Search court opinions and postingsCases of Public Interest Find information on casesCourt of Judicial Discipline New postingsDocket Sheets Search, view and print court docket sheetsPay Traffic Ticket or Court Costs Securely pay fines, costs, and restitutionE-Filing Electronically file documents with the courtsForms Access Unified Judicial System formsPublic Records Access public records and policiesContact Us Access Judiciary contact informationCareers Review open job listingsSign Up for Court News and Updates Sign Me UpTranslation DisclaimerDisclaimerMenu Resources SearchCourtsSupreme CourtSupreme Court JusticesDocket SheetsCourt Opinions and PostingsSupreme Court Prothonotary's AddressesCalendarCommittees, Boards & Advisory GroupsSuperior CourtSuperior Court JudgesDocket SheetsCourt OpinionsSuperior Court Prothonotary's AddressesCalendarCommonwealth CourtCommonwealth Court JudgesDocket SheetsCourt Opinions and PostingsCommonwealth Court Prothonotary's AddressCalendarCourts of Common PleasCommon Pleas President JudgesCommon Pleas JudgesDistrict Court AdministratorsIndividual County CourtsDocket SheetsMinor CourtsMagisterial District JudgesPhiladelphia Municipal Court JudgesPittsburgh Municipal Court JudgesDocket SheetsJudicial AdministrationCommunicationsInformation TechnologyOperationsLanguage AccessInterpreter ProgramOffice of Children & Families in the CourtsProblem-Solving CourtsElder Justice in the CourtsJudicial District SecurityBudgetHuman ResourcesBenefitsJob OpeningsJudicial EducationNews & StatisticsNewsCases of Public InterestNews ReleasesMedia ResourcesResearch & StatisticsReportsArchiveLearnAutism and the CourtsHuman TraffickingProtection OrdersHow the Courts OperateHistoryHow Judges Are ElectedLegal GlossaryJury DutyCivics Outreach and EducationBack to TopCourtsQuick LinksCases of Public InterestCourt NewsDocket SheetsOpinionsE-FilingCareersSupreme CourtSupreme Court JusticesDocket SheetsCourt Opinions and PostingsSupreme Court Prothonotary's AddressesCalendarCommittees, Boards & Advisory GroupsSuperior CourtSuperior Court JudgesDocket SheetsCourt OpinionsSuperior Court Prothonotary's AddressesCalendarCommonwealth CourtCommonwealth Court JudgesDocket SheetsCourt Opinions and PostingsCommonwealth Court Prothonotary's AddressCalendarCourts of Common PleasCommon Pleas President JudgesCommon Pleas JudgesDistrict Court AdministratorsIndividual County CourtsDocket SheetsMinor CourtsMagisterial District JudgesPhiladelphia Municipal Court JudgesPittsburgh Municipal Court JudgesDocket SheetsJudicial AdministrationQuick LinksCases of Public InterestCourt NewsDocket SheetsOpinionsE-FilingCareersCommunicationsInformation TechnologyOperationsLanguage AccessInterpreter ProgramOffice of Children & Families in the CourtsProblem-Solving CourtsElder Justice in the CourtsJudicial District SecurityBudgetHuman ResourcesBenefitsJob OpeningsJudicial EducationNews & StatisticsNewsCases of Public InterestNews ReleasesMedia ResourcesResearch & StatisticsReportsArchiveLearnAutism and the CourtsHuman TraffickingProtection OrdersHow the Courts OperateHistoryHow Judges Are ElectedLegal GlossaryJury DutyCivics Outreach and EducationBack to TopOpinions Search court opinions and postingsCases of Public Interest Find information on casesCourt of Judicial Discipline New postingsDocket Sheets Search, view and print court docket sheetsPay Fine or Fees Securely pay fines, costs, and restitutionE-Filing Electronically file documents with the courtsForms Access Unified Judicial System formsPublic Records Access public records and policiesContact Us Access Judiciary contact informationCareers Review open job listingsSign Up for Court News and Updates Sign Me UpHomeJudicial AdministrationHuman ResourcesJob OpeningsECI/Database DeveloperECI/Database DeveloperPostedMay 15, 2024DepartmentInformation TechnologyCategoryProfessionalLocationMechanicsburgStatusFull-Time HireScheduleM-FStarting Salary$87,250 - $105,009DescriptionThe 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 DutiesDesigns, 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 QualificationsBachelor’s degree with an IT-related major or minor, PLUSTwo years of IT experience involving the analysis, design, and programming of database objects in overall application support, ORAn equivalent combination of education, experience, and/or training may be considered.Additional Requirements/PreferencesExtensive 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 InformationExcellent 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 periodUnified Judicial System Hiring PolicyThe 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. or Return to Job ListPrint PageSidebarHuman ResourcesJob OpeningsBenefitsThe Unified judicial system of PennsylvaniaCareersLoginSearchBack to TopCourtsSupreme CourtSupreme Court JusticesDocket SheetsCourt Opinions and PostingsSupreme Court Prothonotary's AddressesCalendarCommittees, Boards & Advisory GroupsSuperior CourtSuperior Court JudgesDocket SheetsCourt OpinionsSuperior Court Prothonotary's AddressesCalendarCommonwealth CourtCommonwealth Court JudgesDocket SheetsCourt Opinions and PostingsCommonwealth Court Prothonotary's AddressCalendarCourts of Common PleasCommon Pleas President JudgesCommon Pleas JudgesDistrict Court AdministratorsIndividual County CourtsDocket SheetsMinor CourtsMagisterial District JudgesPhiladelphia Municipal Court JudgesPittsburgh Municipal Court JudgesDocket SheetsJudicial AdministrationAdministrative Officeof Pennsylvania CourtsCommunicationsInformation TechnologyOperationsLanguage Access & Interpreter ProgramOffice of Children & Families in the CourtsProblem-Solving CourtsElder Justice in the CourtsJudicial District SecurityBudgetHuman ResourcesJob OpeningsBenefitsJudicial EducationNews & StatisticsNewsCases of Public InterestNews ReleasesMedia ResourcesResearch & StatisticsReportsArchiveLearnAutism and the CourtsHuman TraffickingProtection OrdersHow the Courts OperateHistoryHow Judges Are ElectedFAQsLegal GlossaryJury DutySubmit comments and inquiries ‌‌ ‌ ‌Contact Us ‌Mailing Address:PennsylvaniaJudicial Center601 Commonwealth AvenueP.O. Box 61260Suite 1500Harrisburg, PA 17106Physical Address:PennsylvaniaJudicial Center601 Commonwealth AvenueSuite 1500Harrisburg, PA 17120Get DirectionsAOPC Philadelphia1515 Market StreetSuite 1414Philadelphia, PA 19102‌ ‌ ‌‌ ‌ ‌Follow the Unified Judicial System on Twitter@PACourts© 2024 The Unified Judicial System of Pennsylvania