Database Administrator II

University of Pittsburgh

Pittsburgh (Allegheny County)

On-site

USD 90,000 - 130,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

University of Pittsburgh seeks a Database Administrator II to manage the ADC Alliance data infrastructure. The role focuses on data acquisition, organization, processing, and secure, scalable storage for AI research across participating institutions.

The ideal candidate will design and optimize SQL-based systems, support data standardization, and help build dashboards using Power BI/Tableau to support analytic efforts.

Qualifications

  • Bachelor's degree required.
  • 2+ years of relevant experience.
  • Experience with SQL databases and data modeling.

Responsibilities

  • Supports acquisition, organization, processing, and management of data from participating institutions.
  • Administers data capture and image management systems and coordinates data ingestion.
  • Ensures data quality through QA, auditing, and documentation.

Skills

SQL
Python
R
Data modeling
ETL

Education

Bachelor's Degree

Tools

Power BI
Tableau
MS Excel
SQL Server
PostgreSQL
MySQL

Job description

Job Description - Database Administrator II (26007070)

Database Administrator II

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

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

Life in Pittsburgh • Pittsburgh

On-site
USD 90,000 - 120,000
Database Administrator II – AI Data Platform
Database Administrator II – AI Data Platform

Life in Pittsburgh • Pittsburgh

On-site
USD 90,000 - 120,000
Data Coordinator III
Data Coordinator III

University of Pittsburgh • Pittsburgh

On-site
USD 36,000 - 60,000
Administrative Assistant II
Administrative Assistant II

University of Pittsburgh • Pittsburgh

On-site
USD 42,000 - 54,000
DATA ANALYST
DATA ANALYST

University of Alabama, Birmingham • Birmingham (AL)

Hybrid
USD 48,000 - 77,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
DBA/Datawarehouse Architect
DBA/Datawarehouse Architect

University of Pittsburgh • Pittsburgh

Hybrid
USD 70,000 - 90,000
Systems Analyst - Pittsburgh, PA
Systems Analyst - Pittsburgh, PA

VetJobs • Pittsburgh

Hybrid
USD 65,000 - 90,000
Digital Imaging Specialist
Digital Imaging Specialist

University of Pittsburgh • Pittsburgh

On-site
USD 52,000 - 76,000
Database Administrator III
Database Administrator III

Kansashealthsystem • Kansas

On-site
USD 100,000 - 150,000