Database Administrator; On-site

Applicant Eligibility

For Applicants Seeking Job Opportunities within the University, Internal:
Internal applicants will be considered within the first five (5) business days of the posting period. External:
External applicants will be considered on the sixth (6) business day of the posting period.

This position is not eligible for a visa sponsorship now or in the future.

Primary

Purpose:

Under the general supervision of the Associate Dean, Information Technology, analyzes and anticipates user needs and reviews system capabilities; initiates process and system improvements as necessary; utilizes SQL, Oracle, and other database administration skills to provide support, data integrity, system architecture, programming, and database design including but not limited to our EHR operational database administration.

University of the Pacific recognizes that diversity, equity, and inclusion is foundational to the success of our valued students and employees. We prioritize policy and decision‑making that demonstrates awareness of, and responsiveness to, the ways socio‑cultural forces related to race, gender, ability, sexuality, socio‑economic status, etc., impede or propel students, faculty, and staff.

• Act as liaison between our vendor supporting our EHR system and other systems; maintaining the school’s databases and keeping data secure, including data integrity, security, confidentiality, maintenance, training, user interaction, and project management for installations and updates.
• Responsible for designing the digital infrastructure for a school to build its database systems; effective database architectural design creates a platform for efficiently utilizing database resources.
• Utilize Oracle, SQL, and other database administration skills to provide support and consultancy on systems.
• Analyze existing applications and systems to determine needed modifications and/or enhancements; perform pre‑implementation tasks such as upgrades, capacity planning, installation, and implementation activities.
• Create, update and submit periodic and special reports to provide information (e.g., project status, description of new computer systems, enhancements to existing systems, etc.).
• Organize and review documentation for applications, database systems, software, hardware, and processes, including backup and recovery procedures, database design, and data dictionary.
• Monitor and make available (via web and e‑mail) 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; write and maintain documentation for applications and systems.
• Collaborate with system administrator and application, network administrators, and other stakeholders to ensure optimal database performance and integration with other systems.
• Perform all other duties as assigned by the Associate Dean, Information Technology.

Knowledge of:

• Computer programming languages (C#, HTML, Java, PHP, Python, R, SQL).
• Operating system software (Linux, macOS, Microsoft Windows, UNIX).
• Principles of training, technical documentation, and project management.
• Database management frameworks and systems (IBM Db2, Oracle Database, Microsoft Access, Microsoft SQL Server).
• Principles of report writing, system security, coding, debugging, and installations.
• Database design principles, normalization, indexing, and schema optimization.

Ability to:

• Proficiency in SQL is essential. DBAs use SQL to manage, query, and manipulate databases.
• Understanding various DBMS platforms (such as Microsoft SQL Server, Oracle Database, MySQL, and Postgre
  
  SQL).
• Safeguard sensitive information, implement access controls, and ensure data privacy.
• Maintain a high level of confidentiality of materials and information.
• Handle data backups, disaster recovery planning, and restoration procedures.
• Optimize database performance by monitoring queries, indexing, and resource allocation.
• Effective communication for collaborating with developers, stakeholders, and other team members.

• Minimum of five (5) years…