Pittsburgh Regional Transit
Location: Pittsburgh,PA, USA
Date: 2024-11-08T14:03:19Z
Job Description:
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
Apply Now!