Database Administrator (Senior Systems Analyst)

British Columbia Institute of Technology (BCIT) - Burnaby, BC (30+ days ago)

Apply Now

BCIT’s Information Technology Systems is seeking a regular, full-time (1.0 FTE) Database Administrator (Senior Systems Analyst). As a member of our Solution Delivery team, the Database Administrator is responsible for ensuring that the Oracle database environments are built and maintained at optimum levels to provide a stable environment for enterprise applications at the institute. Working with our other DBAs, your work will directly support our Ellucian Banner ERP systems (versions 8.x and 9.x), deploying and administering both Ellucian- and BCIT-generated code.
As a member of our DBA team, you will administer, create, troubleshoot and support Oracle databases and related software. Knowledge of other applications, such as Ellucian Banner ERP, that are typical in post-secondary environments will be very beneficial.

Duties & Responsibilities

DUTIES & RESPONSIBILITIES:
Maintenance, patching and upgrading of Oracle 12c databases.
Perform database backup and recovery, database tuning and performance management.
Assist in applying patches and upgrades.
Create and maintain accurate and concise documentation related to the installation, configuration and maintenance of all supported systems.
Participate in all areas of the systems development life cycles.
Participate in projects, including planning, executing and closing phases.
Design and develop scripts to automate processes.
Write code as necessary to meet specified business requirements.
Work independently and within the team to carry out tasks from start to finish.
Maintain security of Banner/Oracle systems.

BENEFITS OF WORKING AT BCIT:
Being a part of BC’s Top 100 Employers, and a member of the CCDI.
A generous Total Compensation package which includes extended health and dental benefits and a superb pension plan.
Access to Professional Development Funds and opportunities for career development.
Increase your knowledge with Tuition waivers for BCIT courses.
Enjoy subsidized parking and discounted access to our fitness facilities (including classes like Yoga and Zumba).
Additional Wellness and Employee Assistance programs.

Qualifications

QUALIFICATIONS:
Minimum two-year diploma in Computer Systems or bachelor’s degree in communications, science, business; and minimum six years of current, practical experience, of which at least four demonstrate database administration experience, preferably in an educational setting.
An equivalent combination of education, training and experience may be considered.
Effective oral and written communication skills.
Must have demonstrated specific current IT knowledge.
Proven commitment to providing and maintaining the highest level of customer service.
Proven analytical and problem-solving skills.
Strong organizational skills and the ability to meet changing priorities and multi-task while meeting strict deadlines.
Must be a team player and work well with cross-departmental teams.
Ability to learn quickly and apply new knowledge and techniques.
Commitment to regular ongoing professional development (including specific IT skills, professional associations, and current industry trends).
High level of professionalism and ethics.
Strong attention to detail, customer focused, ability to learn and adapt quickly and with ease.
Well-organized with a methodical approach to work.
Good sense of humour and an ability to prevent absurdity from affecting a commitment to results.
Energetic, motivated self-starter with the ability to learn quickly.
Fierce desire to meet deadlines.

Required Skills:
Oracle 12c
Unix Shell Scripting
SQL/PLSQL
TOAD or SQL Developer
AIX and Linux

Experience In The Following Would Be An Asset:
Ellucian Banner ERP (familiarity with C, Cobol, Java)
Ellucian Solution Manager
Application Navigator
Windows Server
Container Databases
Tomcat and Weblogic
Data Integrity concepts
SQL Query optimization
JIRA and Git/Stash
Jenkins
TSM (Tivoli Storage Manager)
Experience in ODI and Data Warehouse

Salary Range $65,835 to $87,365 per annum.
Additional Salary Information

Salary prorated based on percentage and term of appointment. Salary based on education, experience and placement criteria as outlined in the Collective Agreement.

Position Details

Posting Category Information Systems / Technology
School/Service Area Information Technology Services
Campus Location Burnaby campus
Bargaining Unit BCIT Faculty and Staff Association (FSA)
Job Status Regular
Full-Time/Part-Time Full-Time
Number of Vacancies 1
Anticipated Start Date 03/02/2020
Anticipated End Date
Competition Information

Competition Number 20FSA99
Competition Open Date 02/01/2020
Competition Close Date 02/17/2020
Open Until Filled? No
Quicklink for Posting http://careers.bcit.ca/postings/2392