Database Administrator (On-site)

$86,757 - $98,883/Yr

University of the Pacific - San Francisco, CA

Full-time - Mid Level

San Francisco, CA

Educational Services

About the position

The Database Administrator at the University of the Pacific plays a crucial role in managing and optimizing the institution's database systems under the supervision of the Associate Dean of Information Technology. This position involves analyzing user needs, reviewing system capabilities, and initiating necessary process and system improvements. The Database Administrator will utilize their expertise in SQL, Oracle, and other database administration skills to ensure data integrity, system architecture, programming, and database design, particularly focusing on the operational database administration of the Electronic Health Record (EHR) system. In this role, the Database Administrator will act as a liaison between the vendor supporting the EHR system and other systems, ensuring the maintenance and security of the school's databases. This includes responsibilities for data integrity, security, confidentiality, maintenance, training, user interaction, and project management for installations and updates. The position requires designing the digital infrastructure for the school’s database systems, which is essential for efficient database resource utilization. The Database Administrator will analyze existing applications and systems to determine necessary modifications or enhancements, perform pre-implementation tasks such as upgrades and capacity planning, and create periodic and special reports to provide information on project status and system enhancements. Additionally, the role involves organizing and reviewing documentation for applications, database systems, software, hardware, and processes, including backup and recovery procedures. The Database Administrator will also monitor system and application upgrades and research new technologies relevant to the position. Collaboration with system administrators, application and network administrators, and other stakeholders is vital to ensure optimal database performance and integration with other systems. The Database Administrator will perform all other duties as assigned by the Associate Dean of Information Technology, contributing to the overall success of the IT department and the university's mission.

Responsibilities

• Act as liaison between the vendor supporting the EHR system and other systems.
• Maintain the school's databases and ensure data security, integrity, and confidentiality.
• Design the digital infrastructure for the school's database systems.
• Utilize Oracle, SQL, and other database administration skills for support and consultancy.
• Analyze existing applications and systems for needed modifications and enhancements.
• Perform pre-implementation tasks such as upgrades, capacity planning, installation, and implementation activities.
• Create, update, and submit periodic and special reports on project status and system enhancements.
• Organize and review documentation for applications, database systems, software, hardware, and processes.
• Monitor and make available all system and application upgrades to users.
• Research new technology and keep abreast of new tools applicable to the position.
• Maintain documentation of all data requests and developed reports.
• Collaborate with system administrators and other stakeholders to ensure optimal database performance and integration.
• Perform all other duties as assigned by the Associate Dean, Information Technology.

Requirements

• Minimum of five years of experience with programming languages (C#, HTML, Java, PHP, Python, R, SQL).
• Minimum of three years of experience in database management frameworks and systems (IBM Db2, Oracle Database, Microsoft Access, Microsoft SQL Server).
• Proficiency in SQL is essential for managing, querying, and manipulating databases.
• Understanding of various DBMS platforms such as Microsoft SQL Server, Oracle Database, MySQL, and PostgreSQL.
• Knowledge of computer programming languages and operating system software (Linux, macOS, Microsoft Windows, UNIX).
• Ability to safeguard sensitive information and implement access controls to ensure data privacy.
• Experience in handling data backups, disaster recovery planning, and restoration procedures.

Nice-to-haves

• Understanding of BI tools and analytics to make informed decisions.
• Prior experience in a health or educational environment is helpful.
• Master's degree in information technology or database administration is preferred.