Database Administrator (On-site)

• 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.

• 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.

• 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.

• 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

• 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.

• 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.

• 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.

• Prior experience in a health or educational environment is helpful.

• Master's degree in information technology or database administration helpful.

• 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 performed primarily in a general office and classroom/conference room environment.
• Exposure to cooler temperatures and noise within a server room environment can be anticipated.
• Position requires sitting, standing, and walking most working hours with occasional bending, stooping, squatting, reaching, and grasping.
• Frequent use of computer keyboard and telephone.
• Ability to lift 40 lbs.

University of the Pacific is an affirmative action and equal opportunity employer dedicated to workforce diversity. In compliance with applicable law and its own policy, Pacific is committed to recruiting and retaining a diverse faculty and staff and does not discriminate in its hiring of faculty and staff, or in the provision of its employment benefits to its faculty and staff on the basis of race, color, religion, national origin, ancestry, age, genetic information, sex/gender, marital status, military and veteran status, sexual orientation, medical condition, pregnancy, gender identity, gender expression, or mental or physical disability.