Database Administrator |On|site|

Job highlights
Identified by Google from the original job post
Qualifications
Minimum QualificationsKnowledge 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 design principles, normalization, indexing, and schema optimization
Ability to:Proficiency in SQL is essential
DBAs use SQL to manage, query, and manipulate databases
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
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
Physical RequirementsThe 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
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
Benefits
Full TimeNumber of Months
$41.71 - $47.54 per hour
Responsibilities
Position Summary InformationPrimary PurposeUnder 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
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
Database management frameworks and systems (IBM Db2, Oracle Database, Microsoft Access, Microsoft SQL Server)
Principles of report writing system security, coding, debugging, and installations
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
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 QualificationsAbility 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
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
Job description
Posting DetailsPosition InformationJob Title
Database Administrator (On-site)Union LevelDepartment
Information Systems (SF) (22 - 12205)Campus
San FranciscoPosting Number
201303735PFull or Part Time
Full TimeNumber of Months
12Work SchedulePosition End DateOpen Date
07/0+/2024Close DateOpen Until Filled
NoSpecial Instructions to ApplicantsFor 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 visa sponsorship.Position Summary InformationPrimary PurposeUnder 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 QualificationsKnowledge 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 QualificationsAbility 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.
Physical RequirementsThe 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, candidate's qualifications, internal equity, as well as market and organizational considerations when extending an offer.Background Check StatementAll applicants who receive a conditional offer of employment are required to execute a release and authorization for a background screening.AA/EEO Policy StatementUniversity 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, ****** orientation, medical condition, pregnancy, gender identity, gender expression, or mental or physical disability.