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