Location: Pittsburgh,PA, USA
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.
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 include:
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. 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.
EOE