Database Administrator

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.

Essential Functions
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.

Minimum Qualifications
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 PostgreSQL) 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. Experience: Minimum of five years (5) experience with programming, programming languages (C#, HTML , Java, PHP , Python, R, SQL ). Minimum of three years (5) experience in Database management frameworks and systems ( IBM Db2, Oracle Database, Microsoft Access, Microsoft SQL Server). Experience in the Epic/Wisdom system. Experience with one or more of the primary database management products, including: IBM Db2, Microsoft SQL Server, MongoDB, Oracle, PostgreSQL Redis, MySQL Education: Bachelor's degree in computer science, information technology, management information systems, or a similar field. Epic Operational Database Administrator ( ODBA ) 100 certification or accreditation or must be obtained within 6 months of hire. Working Conditions: Full-time, eight hours per day, five days per week Occasional overtime, after-hours, and/or weekend availability may be required to meet business deadlines. Occasional travel may be required.

Preferred Qualifications
Ability to: Manage time, organize duties/projects, and set priorities to meet multiple deadlines while maintaining precise attentiveness to detail in all work activities. Understanding BI tools and analytics helps DBAs make informed decisions. Troubleshoot issues, diagnose problems and find efficient solutions. Experience: Prior experience in a health or educational environment is helpful. Education: Master's degree in information technology or database administration helpful. Other: Experience and sensitivity in working with people of diverse backgrounds and cultures. Demonstrated experience in advancing social justice, equity, and inclusion in a university setting. Ability to engage and integrate culturally responsive practices and knowledge in their work.

Work Schedule
Monday-Friday, 8 hours

---