Database Administrator
Physics & Astronomy - Pennsylvania-Pittsburgh - (26002620)
The Database Administrator I designs, develops, and maintains the database infrastructure, server systems, and research software platforms that support the experimental and computational workflows of a large quantum materials research group. The position is responsible for the full stack of research data infrastructure: PostgreSQL/TimescaleDB database systems, Linux server administration, high-availability clustering, web and native application development, and the security and automation layers that keep these systems operational. The work requires the theoretical and practical application of specialized knowledge in computer science, database systems, and systems administration, and is performed under the general direction of the faculty principal investigator.
Job Summary
Supports one or more low complexity services/databases; manages and maintains databases. Plans and maintains database architecture and reporting. Troubleshoots databases.
Essential Functions
* Database administration and management including installing, configuring and upgrading database management systems.
* Planning and implementing security measures to safeguard information which includes setting permissions and auditing trails.
* Creating and testing, backup, and disaster recovery strategies
* Developing and maintaining documentation ofr policies, procedures, and configurations
*Working with research team to design and implement new features and address needs.
* Adhering to all safety protocols
*Complying with University policy and procedure to keep workplace free from recognized hazards
*Prolonged sitting or standing, extensive use of keyboard and mouse, and visual acuity for monitoring screens.
Physical Effort
The physical effort required for lifting and mobility is generally low to sedentary, consisting as light office work. Occasional lifting items weighing less than 10 pounds such as laptops, monitors, or peripherals.
Assignment Category: Part-time regular
Job Classification: Staff.Database Administrator I
Job Family: Information Technology
Job Sub Family: Database
Campus: Pittsburgh
Minimum Education Level Required: Bachelor's Degree
Minimum Years of Experience Required: 1
Will this position accept substitution in lieu of education or experience: Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.
Work Schedule: Monday-Friday, 8:30am-5:00PM being very flexible. 20 hours per week.
Work Arrangement: Hybrid: Combination of On-Campus and Remote work as determined by the department.
Hiring Range: $20.50 to $25.62 per hour
Relocation_Offered: No
Visa Sponsorship Provided: Yes
Background Check: For position finalists, employment with the University will require successful completion of a background check
Child Protection Clearances: Not Applicable
Required Documents: Resume, Cover Letter
Optional Documents: Not Applicable
PI284200716