What are the responsibilities and job description for the Database Administrator (Closes 2/28/2025) position at Allegheny County Department of Human Services?
Job Description
Job Description
Salary : $90-$99k / annually
At Allegheny County Department of Human Services (ACDHS), our mission is to improve thewelfare of the Countys most vulnerable residents. We operate, influence, and fund essentialservices worth over $1 billion that more than 200,000 residents depend on each year, includingtreatment for mental health and addiction, homeless housing, and child and older adult protectiveservices. 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 andefficient public services. Above all, we are convinced that there remain significant opportunitiesfor data and technology to improve the lives of our clients.
The Database Administrator manages and maintains ACDHS databases in on-premise and hybridcloud environments. This role is responsible for ensuring data integrity, security, and availabilitywhile supporting business operations with efficient database solutions. The ideal candidate willhave 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
Bachelors 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 weve 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.
AN EQUAL OPPORTUNITY EMPLOYER -M / F / V / D
Salary : $90,000 - $99,000
