Database Administrator at Pittsburgh Regional Transit
Pittsburgh, PA 15222
About the Job
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
https://careers.portauthority.org
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
https://careers.portauthority.org
Salary
71,500 - 107,300 /year