Database Administrator II

Life in Pittsburgh

Pittsburgh (Allegheny County)

On-site

USD 90,000 - 120,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

The University of Pittsburgh's CPACE seeks a full-time Database Administrator to support the ADC Alliance data infrastructure, overseeing data ingestion, preprocessing, and secure storage of high-volume pathology and lab data.

You will implement metadata standards, QA processes, and dashboards for researchers, collaborating across sites to enable AI research while ensuring data integrity, access control, and compliance. A background in SQL, Python, and BI tools is essential.

Qualifications

  • Hands-on experience administering databases including IMS platforms.
  • Scripting skills in JavaScript, Groovy, Python or R to customize modules.
  • Experience with upgrades, patches, vendor communications and change control.
  • Understanding HL7, FHIR, RESTful API integrations between LIMS, EMR and data warehouses.
  • Ability to create dashboards and QA/QC reports for transparency across sites.
  • Familiarity with barcode systems and whole slide image scanning applications.

Responsibilities

  • Administer databases including IMS platforms and ensure reliability.
  • Design data ingestion processes and data modeling for the ADC Alliance.
  • Coordinate data ingestion, preprocessing, quality assurance and security.
  • Maintain data dictionaries, metadata standards and audit logs.
  • Support data analysts with inventory reports and collaboration across sites.
  • Maintain ADC Alliance website accuracy and up-to-date information.
  • Collaborate with CPACE team and participating sites on data sharing needs.

Skills

Data quality assurance
Data governance
Data modeling

Education

Bachelor's degree in a relevant field

Tools

SQL
Python
R
Power BI
Tableau
Linux
Windows Server
ETL
RESTful APIs

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.

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.

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Database Administrator II
Database Administrator II

University of Pittsburgh • Pittsburgh

On-site
USD 90,000 - 130,000
AI Data Commons DBA II — Pathology & Imaging
AI Data Commons DBA II — Pathology & Imaging

University of Pittsburgh • Pittsburgh

On-site
USD 90,000 - 130,000
Staff Biomedical Data Manager
Staff Biomedical Data Manager

PathAI • Irving (TX)

On-site
USD 109,000 - 167,000
Staff Biomedical Data Manager
Staff Biomedical Data Manager

PathAI • United States

Remote
USD 109,000 - 167,000
Staff Biomedical Data Manager
Staff Biomedical Data Manager

PathAI • Boston (MA)

On-site
USD 140,000 - 190,000
DATA ANALYST
DATA ANALYST

University of Alabama, Birmingham • Birmingham (AL)

Hybrid
USD 48,000 - 77,000
Bioinformatics Engineer
Bioinformatics Engineer

Windber, PA • Windber (PA)

On-site
USD 90,000 - 130,000
Senior Faculty Lead, Digital Pathology Infrastructure and AI Enablement
Senior Faculty Lead, Digital Pathology Infrastructure and AI Enablement

HMFP at BIDMC, Inc. • United States

On-site
USD 269,000 - 321,000
Health insurance
Dental insurance
Vision insurance
+1
Data Scientist, Medical Imaging
Data Scientist, Medical Imaging

Axle • United States

Remote
USD 120,000 - 180,000
100% Medical, Dental & Vision Coverage
Paid Time Off and Paid Holidays
401K match up to 5%
+6
Data Engineer I- Pathology
Data Engineer I- Pathology

John Hopkin’s University • Baltimore (MD)

On-site
USD 85,500 - 149,800