Database Administrator (Senior Systems Analyst)

Position Summary

BCIT’s Information Technology Services department is seeking a temporary, 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. 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 AND RESPONSIBILITIES:

• Maintain, patch, and upgrade Oracle 19c databases.
• Perform database backup and recovery, database tuning, and performance management.
• Create and maintain accurate and concise documentation related to the installation, configuration, and maintenance of all supported systems.
• Participate in all phases of the systems development life cycle.
• Participate in projects, including the planning, execution, 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 the security of Banner and Oracle systems.
• Manage users, roles, and privileges in accordance with the principle of least privilege, and administer Transparent Data Encryption (TDE) and Unified Auditing.

Qualifications QUALIFICATIONS:

Required Qualifications:

• Minimum two-year diploma in Computer Systems or bachelor’s degree in communications, science, or business, and a minimum of six years of current, practical experience, including at least four years of database administration experience, preferably in an educational setting.
• Oracle certification applicable to supported versions.
• An equivalent combination of education, training and experience may be considered.
• Effective oral and written communication skills.
• Must demonstrate current IT knowledge relevant to the position.
• 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.

Required Skills:

• Oracle 19c
• Linux/UNIX Shell Scripting
• SQL and PL/SQL
• RMAN

Experience in the following would be an asset:

• Ellucian Banner ERP (familiarity with C, Java)
• Container Databases
• Tomcat
• SQL query optimization
• JIRA and Git/Stash
• Jenkins
• Oracle Data Integrator (ODI) and data warehouse environments
• Cloud technologies
• Oracle Data Guard and Real Application Clusters (RAC)
• Python scripts, shell scripts, stored procedures, or Infrastructure as Code (IaC) used to automate routine maintenance tasks.

Attributes:

• Strong attention to detail, customer focus, and the ability to learn and adapt quickly.
• Well-organized with a methodical approach to work.
• Good sense of humour and the ability to maintain focus and productivity in challenging situations.
• Energetic and motivated self-starter with the ability to learn quickly.
• Demonstrated commitment to meeting deadlines.

Additional Information Benefits – Why you’d love working with us

• Competitive pay
• Minimum of twenty-five days of vacation (or more, depending on your position)
• Competitive employer-paid extended health and dental plan – take a look at our benefit plans!
• Defined benefit pension plan with employer contributions
• Flexible hybrid work arrangements available
• Professional Development funds and resources
• Access to most BCIT Flexible Learning courses free of charge
• Wellness and Employee Assistance programs
• Complimentary membership with free access to the Fitness Centre, Gymnasium, and more
• Eligibility requirements apply, benefits may vary depending on the employee group the position belongs to and whether the position offered is temporary or part-time. For more information on our generous benefits, click here!

BCIT is committed to equity, diversity, and inclusion and to promoting opportunities in hiring individuals who have been historically underrepresented in our workforce, BCIT, and the larger community. We strongly encourage Indigenous Peoples, women, racialized persons, persons with disabilities and those who identify as 2S/LGBTQIA+ to apply. While all qualified candidates are encouraged to apply, Canadian citizens and permanent residents will be given priority.

Accessibility is an integral part of BCIT’s commitment to equity and inclusion. If you require an accommodation for any part of the application or hiring process, please Contact us using our contact form. Please note that all applications must be submitted via the careers page portal. Applications submitted through the contact form will not be accepted. For additional information, please visit our frequently asked questions (FAQs) page and learn more about how we hire.
The British Columbia Institute of Technology acknowledges that our campuses are located on the unceded traditional territories of the Coast Salish Nations of xwməθkwəy̓əm (Musqueam), Sḵwx̱wú7mesh (Squamish), and səl̓ilwətaɁɬ (Tsleil-Waututh).