Careers

Job postings

opening

Back to Job postings

Posting number 2019.090
Position Database Administrator I
Department Information Technology Services
Location Abbotsford
Contract type Staff, 100% full-time, Permanent
Start date As soon as possible
Review date May 14, 2019
Salary scale $5,463.75 - $6,355.60 per month (Staff pay group 12)

About UFV

The University of the Fraser Valley (UFV) is nationally recognized for its emphasis on teaching excellence, experiential and applied education, community engagement, and Indigenization. UFV is the school of choice for over 15,000 students. With six campuses and centres, UFV offers undergraduate and graduate programs in the arts, sciences, and professional studies, as well as trades and technology education, university preparation, and continuing education.

At UFV, we are dedicated to changing lives and building community. Our educational goals are to prioritize learning everywhere; be flexible and responsive; collaborate across boundaries; develop local and global citizenship; and integrate experiential learning. A British Columbia “Top Employer”, we are committed to providing a welcoming, inclusive and dynamic learning and working environment that is fair and respectful of everyone. Our culturally diverse employee and student populations reflect the local, national, international and Indigenous communities we serve. If you see yourself as a lifelong member of a community that values and nurtures innovation and creativity, cultivates leadership and citizenship, and where success builds on success, you belong at UFV.

Posting details

The Office of the CIO (OCIO) comprises the IT Services (ITS) and Business Transformation Office (BTO). The unit is experiencing a period of exciting transformation and growth with the goal of improving the technology experience and service delivery to UFV’s students, faculty, and staff.

Reporting to the Manager, IT Applications, the Database Administrator I works as part of a team to ensure the operational effectiveness of the university’s central enterprise systems and databases. Members of this team maintain administrative, teaching and student-facing systems critical to business operations of the university (e.g. payroll, finance, student registration). These systems are required to be in operation 24 hours per day, 365 days of the year.

The Database Administrators are responsible for all aspects of database administration including design, planning, installation, configuration, support, security, monitoring and performance tuning of UFV’s entire portfolio of enterprise databases, which include Oracle, Microsoft SQL and MySQL databases.

Duties & Responsibilities

The Database Administrator I researches, assesses and recommends the future direction of database technology at UFV, builds decision briefs for senior leadership and performs independent analysis and recommendations of new technologies. The Database Administrator I performs complex operational duties and tasks that need independent judgement to resolve often in in high-pressure situations. The Database Administrator I exhibits a high level of problem-solving ability, originality, creativity and resourcefulness when planning and implementing projects and solving optimization, performance and capacity related issues.

The Database Administrator also contributes to the implementation of back-up and recovery procedures, maintaining system documentation and logs and assisting in troubleshooting and diagnosing production problems.

Database Administration

Contributes to the design, installation, configuration, security and maintenance of enterprise databases and applications.

  • Working closely with IT leadership and the Applications, Servers, Systems and Storage teams, identifies technical solutions to critical UFV business needs.
  • Evaluates and optimizes database configuration and access, resolves database performance and capacity issues and performs database recovery and database back-ups.
  • Installs, configures and maintains ERP applications.
  • Monitors and maintains the integrity and security of enterprise systems.
  • Installs new database software releases and system upgrades, and evaluates and installs database patches.
  • Contributes to the development, implementation, administration and maintenance procedures for ensuring the security and integrity of databases.
  • Contributes to the development, implementation and testing of Disaster Recovery (DR) and Business Continuity Plans (BCP).
  • Provides guidance to other enterprise system staff as it relates to the design, development, support and administration of key information systems in the context of database connectivity, performance and security.

Problem Resolution & System Operations

Provides support to clients; identifies, researches and resolves technical issues; tracks and monitors problems and escalations to ensure timely resolution.

  • Monitors the status of alerts, tickets and processes to ensure timely completion of tasks and resolution of issues.
  • Suggests policy recommendations to senior management to improve service delivery to the clients and reduce server and database maintenance costs, and improve overall technical and team performance.
  • Analyzes usage patterns of databases for fraud and intrusion detection and determining optimal IT service availability.
  • Creates scripts/rules to automate database tasks and effectively monitor the overall health and security of databases.
  • Works with vendor resources to facilitate access and implement changes to vendor-managed systems.
  • Works cooperatively with the Change Advisory Board and Business Transformation Office teams to ensure that established processes are followed.

Professional Development

  • Maintains up-to-date knowledge of database systems, concepts and technology in order to improve efficiency, enhance problem-solving and spark innovation within the team.
  • Participates in on-campus and external committees and working groups (e.g. BCNET, CUCCIO) to help share strategies to address shared challenges.
  • Attends courses, seminars, conferences and vendor exhibitions in order to stay current with industry and technological advancements, learn about first-hand experiences and case studies.
  • Studies documentation, manuals, trade publications and electronic discussion lists to keep up-to-date with and to enhance understanding and knowledge of new procedures, software, hardware and databases.

Please note system maintenance is usually required to be performed off-hours and major issues are responded to on a 24/7 basis. This position will also perform other duties as assigned.

Qualifications

  • Bachelor’s Degree in Computer Science or other relevant discipline.
  • Database certifications an asset:
    • Oracle Certified Associate (OCA) or Oracle Certified Professional (OCP).
    • Microsoft Certified Solutions Associate (MCSA): SQL Server.
  • Minimum five (5) years of related experience including a minimum of two (2) years of experience in the administration of databases and other enterprise-level software applications.
  • Proficiency in management of at least one of the following databases platforms: Microsoft SQL Server, MySQL, Oracle.
  • Experience designing, building, installing, configuring and supporting database servers using Oracle Database 11g or higher on Linux. Strong working knowledge in Linux, UNIX shell and TSQL scripting. Expertise in Windows Operating systems.
  • Experience and understanding of web/application servers such as Oracle Fusion Middleware, Tomcat and Apache preferred.
  • Experience with database performance tuning, RMAN, Data Guard an asset.
  • Knowledge of storage environments and server virtualization an asset.
  • Familiarity with university business/enterprise applications including: Ellucian Banner, Blackboard Transact, The Raiser’s Edge, CAS, Blackboard an asset.
  • Familiarity with project management methodology and processes an asset.
  • Demonstrated customer service skills.
  • Proven ability troubleshooting database performance issues.
  • High degree of attention to detail is required, as is the ability to understand complex technical concepts and the need to maintain broad and in-depth technical knowledge of all aspects of database servers and software.
  • High level of problem-solving abilities; must be able to effectively identify and resolve unusual and highly complex technical problems.
  • Ability to effectively manage multiple tasks and priorities and work under pressure to meet time sensitive and mission critical deadlines in a complex environment.
  • Ability to take initiative and work with limited direction.
  • Ability to work collaboratively.
  • Ability to provide technical assistance and advice to peers and the user community.
  • Ability to successfully contribute to complex projects: developing project work plans; monitoring tasks to a plan.
  • Excellent written and oral communications skills.
  • Strong interpersonal skills.
  • Ability to work outside of normal working hours on an emergency or pre-scheduled basis.

How to apply

The Selection Advisory Committee will begin reviewing applications on May 14, 2019; however, the position will remain open until filled.

Direct resume including evidence of appropriate qualifications referring to Posting #2019.90 to:

 

Email application to: hrinfo@ufv.ca

Human Resources
University of the Fraser Valley
33844 King Road, Abbotsford, BC, Canada V2S 7M8
Phone: (604) 854-4554
Fax: (604) 854-1538
Website: ufv.ca

Find out how to prepare your application

Please note:

  • We thank all applicants for considering UFV for employment.
  • Incomplete applications will not be processed.
  • In order to be environmentally and fiscally responsible, only short-listed candidates will be contacted for interviews.
  • Short-listed candidates may undergo a criminal record check and/or a verification of their education credentials, as required.
  • Shortlisted applicants for staff positions will be required to provide copies of their most recent evaluation summary.

All qualified candidates are encouraged to apply; however, Canadians and permanent residents will be given priority.

UFV is committed to the principle of equity in employment.


Back to Job postings

Contact Us