Pittsburgh Regional Transit is seeking a Database Administrator to design, develop, create, maintain, support, integrate, and interface Port Authority of Allegheny County d/b/a Pittsburgh Regional Transit (PRT) databases and applications, as directed.
Essential Functions:
- Participate in data analysis, database design, development, and implementation.
- Ensures all databases are properly backed up and recoverable. Implements and maintains a disaster recovery plan.
- Monitors database and system performance, diagnosing and resolving issues as necessary, and taking corrective action.
- Integrates, interfaces and replicates data, as directed. This includes internal systems, external systems, and web interfaces.
Job Requirements:
- BS Degree in Computer Science, Information Science or related field from an accredited school. Related experience may be substituted for the education on a year-for-year basis.
- MS SQL Server and/or Oracle database experience.
- 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.
Preferred Attributes:
- Knowledge of MS SQL Server and strong SQL querying skill using TSQL.
- Knowledge of data warehousing concepts and technologies.
- Knowledge of PowerShell and Python.
We offer a comprehensive compensation and benefits package. Interested candidates should forward a cover letter (with salary requirements) and resume at https://Careers.RidePRT.org .
