Demo

Database Administrator (Closes 3/10/2025)

Allegheny County
Pittsburgh, PA Full Time
POSTED ON 3/3/2025
AVAILABLE BEFORE 6/2/2025

At Allegheny County Department of Human Services (ACDHS), our mission is to improve the welfare of the County's most vulnerable residents. We operate, influence, and fund essential services worth over $1 billion that more than 200,000 residents depend on each year, including treatment for mental health and addiction, homeless housing, and child and older adult protective services. Over the past 20 years, we have built a national reputation for being on the cutting edge

of state and local governments using analytics and technology to deliver more effective and efficient public services. Above all, we are convinced that there remain significant opportunities for data and technology to improve the lives of our clients.

The Database Administrator manages and maintains ACDHS databases in on-premise and hybrid cloud environments. This role is responsible for ensuring data integrity, security, and availability while supporting business operations with efficient database solutions. The ideal candidate will have expertise in database architecture, design, backup and recovery, and performance tuning, along with strong problem-solving skills. This position may work after normal business hours

including on-call. This role provides an opportunity to work with innovative technologies, collaborate with a

talented team, and contribute to improving the lives of residents through data-driven solutions.

Essential Duties and Responsibilities

  • Manage and maintain Oracle databases within a Windows and hybrid cloud environment.
  • Administer databases in hybrid environments, including Azure and Oracle Cloud

Infrastructure (OCI).

  • Ensure high availability and performance of database systems.
  • Support the evaluation, integration, and administration of open-source databases such as
  • PostgreSQL.

  • Monitor database performance, implement changes, and apply new patches and versions
  • when required.

  • Leverage Infrastructure-as-Code (IaC) tools (e.g., Terraform) for provisioning and
  • automation.

  • Develop and implement database policies and procedures to ensure the integrity and
  • availability of databases and their accompanying software.

  • Ensure compliance with regulatory frameworks such as HIPAA, and NIST.
  • Implement and maintain robust database security practices, including access controls,
  • encryption, and auditing.

  • Maintain documentation of database configurations, procedures, and standards.
  • Collaborate with other IT professionals and stakeholders to ensure database systems are
  • aligned with organizational goals.

  • Research and recommend emerging database technologies to improve efficiency and
  • reduce costs.

  • Contribute to cross-functional initiatives and support evolving organizational needs as
  • required.

    Knowledge, Skills, and Abilities

  • Extensive experience with Oracle databases in a Windows and hybrid cloud environment.
  • Expertise in Oracle RAC, Data Guard, and multi-tenant architectures.
  • Proven ability to manage complex database systems and ensure high availability.
  • Experience with open-source databases, such as PostgreSQL.
  • Familiarity with backup and recovery tools, such as RMAN.
  • Knowledge of scripting languages and automation frameworks.
  • Hands-on experience with hybrid cloud platforms like Azure and Oracle Cloud
  • Infrastructure.

  • Effective communication skills, with the ability to collaborate across teams and articulate
  • technical concepts to non-technical stakeholders.

    Job Location

    This is an onsite, office position based at the Allegheny County Department of Human Services

    in downtown Pittsburgh, PA.

    Education and Experience Requirements

  • Bachelor's degree in computer science, Information Technology, or a related field.
  • 5 years of experience in database administration.
  • Certifications (e.g., OCP, PostgreSQL) are a plus.
  • Why Allegheny County DHS?

  • It is innovative. Most recently, the national attention and awards we've gotten are for how DHS integrates data and uses it to improve the safety and well-being of children through tools that support front-line staff in making decisions (using predictive analytics).
  • DHS is committed to equity - for our staff, our providers, and community members.
  • You can make a big impact here. We stand out as one of the best human services organizations in the country. But we need problem-solvers, innovators, and terrific leaders to make sure we are smart in how we use our funding so that we reach the people who most need our help to make their lives better.
  • DHS strives to be the kind of place where a diverse mix of talented people want to come to grow and do their best work."

  • From the organization's statement on Equity and Inclusion
  • AN EQUAL OPPORTUNITY EMPLOYER -M / F / V / D

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Database Administrator (Closes 3/10/2025)?

    Sign up to receive alerts about other jobs on the Database Administrator (Closes 3/10/2025) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $93,716 - $124,745
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $112,672 - $149,113
    Income Estimation: 
    $98,475 - $115,895
    Income Estimation: 
    $150,731 - $188,044
    Income Estimation: 
    $176,131 - $238,730
    Income Estimation: 
    $172,979 - $241,697
    Income Estimation: 
    $118,976 - $146,289
    Income Estimation: 
    $115,719 - $153,093
    Income Estimation: 
    $137,343 - $165,639
    Income Estimation: 
    $135,811 - $184,429
    Income Estimation: 
    $120,390 - $162,969
    Income Estimation: 
    $66,897 - $84,160
    Income Estimation: 
    $74,161 - $98,561
    Income Estimation: 
    $92,249 - $117,370
    Income Estimation: 
    $88,359 - $121,264
    Income Estimation: 
    $113,076 - $148,099
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Allegheny County

    Allegheny County
    Hired Organization Address Pittsburgh, PA Full Time
    Minimum Requirements: High School diploma or its equivalent AND a Pharmacy Technician Certificate OR One (1) year of exp...

    Not the job you're looking for? Here are some other Database Administrator (Closes 3/10/2025) jobs in the Pittsburgh, PA area that may be a better fit.

    Database Administrator

    Pittsburgh Regional Transit, La Belle, PA

    Database Administrator

    Pittsburgh Regional Transit, East Pittsburgh, PA

    AI Assistant is available now!

    Feel free to start your new journey!