Database Administrator

University of Pittsburgh
United States
2 days ago
Apply on cfopitt.taleo.net
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

Tech stack

JavaScript (Programming Language) Microsoft Excel Artificial Intelligence Business Analytics Applications Audit Trail Big Data Computer Programming Databases Data Cleansing Data Dictionary Data Governance Data Infrastructure
+39 more
Extract Transform Load (ETL) Data Transformation Data Normalization Data Security Data Sharing Data Visualization Relational Databases Database Queries Linux Electronic Data Capture Systems Theories R (Programming Language) Groovy Image Management Python (Programming Language) Laboratory Information Management Systems PostgreSQL Metadata Standards Microsoft SQL Server Windows Servers MySQL Operational Data Store Power BI Software Tools Microsoft Copilot DataOps Shell Script SQL Stored Procedures SQL Databases Systems Integration Tableau (Software) Data Ingestion Fast Healthcare Interoperability Resources Database Optimization Epic Beaker Electronic Medical Records Health Level Seven International Restful APIs Visual Basic Language

Job description

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.

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

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

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., * 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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on cfopitt.taleo.net
Prepare application

Good distractions

Loading talks and stories from around this role…