Database Administrator

Pittsburgh Regional Transit is seeking a Database Administrator to design, develop, create, maintain, support, integrate, and interface all the Port Authority of Allegheny County d/b/a Pittsburgh Regional Transit (PRT) databases, as directed., * 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.

Do you have experience in Word embeddings?, Do you have a Bachelor’s degree?, * 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.

• Minimum of two (2) years of 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.

3.73.7 out of 5 stars Pittsburgh, PA 15222 $72,900 - $109,400 a year, 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 .