Database Administrator

$71,500 - $107,300/Yr

Unclassified - Pittsburgh, PA

Full-time

Pittsburgh, PA

About the position

Pittsburgh Regional Transit is seeking a Database Administrator to design, develop, create, maintain, support, integrate, and interface all Pittsburgh Region Transit (PRT) databases, as directed. The role involves participating in data analysis, database design, development, and implementation. The Database Administrator will ensure that all databases are properly backed up and recoverable, implementing and maintaining a disaster recovery plan. Additionally, the position requires monitoring database and system performance, diagnosing and resolving issues as necessary, and taking corrective action. The role also includes integrating, interfacing, and replicating data as directed, which encompasses internal systems, external systems, and web interfaces.

Responsibilities

• Participate in data analysis, database design, development, and implementation.
• Ensure all databases are properly backed up and recoverable.
• Implement and maintain a disaster recovery plan.
• Monitor database and system performance, diagnosing and resolving issues as necessary.
• Integrate, interface, and replicate data as directed, including internal systems, external systems, and web interfaces.

Requirements

• BS Degree in Computer Science, Information Science or directly related field from an accredited school.
• Minimum of two (2) years' experience in database administration and database design.
• Experience with MS SQL Server and/or Oracle database.
• Knowledge of SQL and database scripts.
• Knowledge of the Extraction, Transformation, and Loading (ETL) process.
• Understanding of cloud-based database solutions, such as Azure SQL Database.
• Demonstrated ability in the use of Windows and Linux.
• Ability to be flexible and adapt to change.
• Demonstrated ability in the use of Microsoft Office 365, including Teams, Word, Excel, PowerPoint, and Sharepoint.
• Exemplary attention to detail and excellent written and verbal communication skills.

Nice-to-haves

• Knowledge of MS SQL Server and strong SQL querying skill using TSQL.
• Knowledge of data warehousing concepts and technologies.
• Knowledge of PowerShell and Python.

Benefits

• Comprehensive compensation and benefits package.