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 schools 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:
Bachelors 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:
Masters 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.
Physical Requirements: The physical demands described here are representative but not definitive of those that an employee must meet to perform the essential functions of this job successfully.
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.
Hiring Range: $41.71 - $47.54 per hour. We consider factors such as, but not limited to, scope and responsibilities of the position, candidates qualifications, internal equity, as well as market and organizational considerations when extending an offer.
Background Check Statement: All applicants who receive a conditional offer of employment are required to execute a release and authorization for a background screening.
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.
Copyright 2024 Jobelephant.com Inc. All rights reserved.
University of the Pacific is a mission-driven organization, focused on creating the next generation of leaders in a wide array of disciplines through student-centered teaching and research that blends learning in classrooms, laboratories and studios with real-world experiences partnering with organizations across northern California. No matter the job, every employee at Pacific is part of contributing to the mission of California’s first university, which ranks in the Top 20 in the West and Top 100 in the U.S.