What are the responsibilities and job description for the Database Administrator II position at Pittsburgh Regional Transit?
Pittsburgh Regional Transit is seeking a Database Administrator II to design, develop, create, maintain, support, integrate, and interface all Port Authority of Allegheny County d/b/a Pittsburgh Regional Transit (PRT) databases. Works with all Information Technology and PRT personnel to accomplish PRT goals. Acts as Project Lead in data analysis, database design, development and implementation of databases. May supervise others.
Essential Functions:
Essential Functions:
- May function as Project Lead in data analysis, database design, development, and implementation of databases. May supervise others.
- Works with all Information Technology and PRT personnel to accomplish PRT goals.
- Ensures all databases are properly backed up and recoverable. Implements and maintains a disaster recovery plan.
- Provides strategic direction and guidance for all PRT databases.
- Bachelor's degree in computer science or related field from an accredited college or university. Related experience may be substituted for the education on a year-for-year basis.
- Minimum of five (5) years' experience in database administration. No certifications or licenses required.
- MS SQL Server and/or Oracle database experience.
- Superior knowledge of SQL and database scripts.
- Knowledge of RAID technology (both hardware and software driven).
- Demonstrated ability in the use of Windows.
- Knowledge of Windows.
- Knowledge of three-tier architecture.
- Knowledg
- Knowledge of PeopleSoft. 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