University of Pittsburgh logo

University of Pittsburgh

Database Administrator II

🇺🇸 Pittsburgh, Pennsylvania 🕑 Full-Time 💰 TBD 💻 Information Technology 🗓️ November 17th, 2026
SQL Python ETL

Edtech.com's Summary

University of Pittsburgh is hiring a Database Administrator II. The role supports the data infrastructure of the AI Data Commons Alliance, a global network of institutions that securely share de-identified data to build and validate AI tools for pathology and laboratory medicine, within the Department of Pathology's Computational Pathology and AI Center of Excellence. The administrator manages the data contributed by participating institutions, from ingestion and preprocessing through quality checks and reporting to investigators.

Highlights
  • Oversee the acquisition, organization, and processing of de-identified data contributed by Alliance member institutions, coordinating data ingestion and tracking and supporting each site's data-sharing and AI development needs.
  • Evaluate business requirements and build data ingestion processes and data models, supporting the databases and related services behind the Alliance.
  • Audit operational data regularly, keep accurate records, and send monthly collection reports to the appropriate investigators.
  • Design, query, optimize, and maintain large datasets covering whole slide images, laboratory medicine data, consent, workflow metadata, and chain-of-custody, enforcing data dictionaries and metadata standards such as MIABIS, ICD-O, SNOMED, and CAP protocols.
  • Administer electronic data capture and image management systems, handling upgrades, patches, vendor communications, and change control, and write scripts in JavaScript, Groovy, Python, or R to customize modules, calculate KPIs, and automate routine tasks.
  • Create dashboards, QA/QC reports, and specimen tracking tools for multi-site operational transparency, and provide inventory reports to data analysts and scientists on request.
  • Maintain the AI Data Commons Alliance website so its information stays accurate and up to date.
  • Bachelor's degree and two years of relevant experience, with a combination of education and experience considered in lieu of either requirement.
  • Strong SQL skills, including queries, views, stored procedures, and indexing, plus an understanding of relational databases such as SQL Server, PostgreSQL, and MySQL, ETL processes, and Linux and Windows server environments with basic shell scripting.
  • Preferred experience with HL7, FHIR, and REST API integrations between laboratory, medical record, and research systems such as REDCap and Epic/Beaker, and with analytics tools such as Power BI, Tableau, or R/Shiny.

Database Administrator II Full Description

Database Administrator II
Med-Pathology - Pennsylvania-Pittsburgh - (26007070)

The Computational Pathology and AI Center of Excellence (CPACE) aspires to become the premier center for artificial intelligence (AI) in pathology and laboratory medicine, establishing the gold standard for clinical studies, innovation, education, research, and ethical governance in AI and machine learning. CPACE's mission is to transform medicine by leveraging AI to enable earlier, more efficient, and more accurate disease detection, ultimately improving patient care and clinical outcomes.
A key initiative supporting this mission is the AI Data Commons (ADC) Alliance, a global collaborative network that brings together institutions to securely share de-identified data for the development, validation, and implementation of AI-driven solutions addressing unmet needs in pathology and laboratory medicine. Participating institutions benefit from collaborative innovation and shared intellectual property ownership arising from their contributions.
CPACE is seeking a full-time Database Administrator to support the development, management, and operation of the ADC Alliance's data infrastructure. This individual will be responsible for overseeing the acquisition, organization, processing, and management of data contributed by participating institutions. Key responsibilities include administering electronic data capture and image management systems, coordinating data ingestion and tracking, performing data preprocessing and quality assurance, and supporting data standardization, integrity, security, and accessibility. The position will play a critical role in establishing and maintaining a scalable, reliable, and secure data environment that enables collaborative AI research and development across the ADC Alliance.

Job Summary
Supports multiple moderately complex services/databases; manages and maintains databases. Plans and maintains database architecture and reporting. Troubleshoots databases.

Essential Functions
Administrative
  • Work with the CPACE team including ADC Alliance members to support participating site data sharing needs and AI development efforts.
  • Provides monthly collection reports to appropriate investigators.
  • Evaluates business requirements, creates data ingestion processes and modeling, and supports databases and relevant services.
  • Ensures the quality of operational data by conducting regular audits and maintaining accurate records.
  • Maintaining the ADC Alliance website to ensure all information is accurate and up to date.
  • Performs additional administrative duties and responsibilities as assigned by the supervisor.
  • Working knowledge of common software tools and databases relevant to pathology and laboratory medicine data is preferred.
  • Some knowledge of Microsoft Office Suite and Visual Basic is preferred.
  • Basic experience using commercial artificial intelligence work aids (e.g., MS Co-Pilot).
Database Management
  • Ability to design, query, optimize, and maintain large datasets related to whole slide images, laboratory medicine data, consent, workflow metadata, and chain-of-custody.
  • Experience in enforcing data dictionaries, controlled vocabularies, and metadata standards (MIABIS, ICD/O, SNOMED, CAP protocols).
  • Familiarity with ETL (extract-transform-load) processes for cleaning, harmonizing, and migrating legacy datasets.
  • Ability to design and maintain audit logs, data traceability, and user-access rules in compliance with relevant security standards.
  • Supports data analysts and scientists with research and consulting by providing inventory reports as requested.
  • Understanding of relational databases (e.g., SQL Server, PostgreSQL, MySQL) and data normalization practices.
  • Proficiency in writing SQL queries, views, stored procedures, indexing strategies, and optimizing performance for high-volume data operations.
  • Experience in data visualization with MS Excel or other platform.
Data Capture / Image Management System (IMS) Administration & System Integration
  • Hands-on experience administering databases including but not limited to IMS platforms is desirable.
  • Experience writing or modifying scripts (JavaScript, Groovy, Python, R) to customize modules, calculate KPIs, or automate routine tasks.
  • Skill in managing upgrades, patches, vendor communications, and change-control processes.
  • Understanding of HL7, FHIR, and RESTful API integrations between LIMS, EMR, research systems, REDCap, EPIC/Beaker, and enterprise data warehouses is desirable.
  • Ability to create dashboards, QA/QC reports, and specimen tracking tools for multi-site operational transparency.
  • Familiarity with barcode systems and whole slide image scanning applications.
Technical & Programming Skills
  • Competency in SQL, Python, R, or similar languages used for data transformation and reporting.
  • Experience with data visualization or analytics platforms (Power BI, Tableau, R/Shiny).
  • Comfortable working in Linux/Windows server environments, including basic shell scripting.
Physical Effort
This position is mostly sedentary but some walking between collaboration spaces may be required.

The University of Pittsburgh is an equal opportunity employer / disability / veteran.

  • Assignment Category: Full-time regular
  • Bargaining Unit Eligibility: This position is bargaining unit eligible
  • Job Classification: Staff.Database Administrator II
  • Job Family Information: Information Technology
  • Job Sub-Family: Database
  • Campus: Pittsburgh
  • Minimum Education Level Required: Bachelor's Degree
  • Minimum Years of Experience Required: 2
  • Will this position accept substitution in lieu of education or experience? Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.
  • Work Schedule: Monday - Friday, 8:30 a.m. - 5:00 p.m.
  • Work Arrangement: On-Campus: Teams that work on campus, in an office, or in a lab.
  • Hiring Range: TBD Based Upon Qualifications
  • Relocation Offered: No
  • Visa Sponsorship Provided: Yes
  • Background Check: For position finalists, employment with the University will require successful completion of a background check
  • Child Protection Clearances: Not Applicable
  • Required Documents: Resume
  • Optional Documents: Cover Letter