05 Nov
|
British Columbia Institute of Technology
|
Burnaby
05 Nov
British Columbia Institute of Technology
Burnaby
Database Administrator (Senior Systems Analyst)
Position Title Database Administrator (Senior Systems Analyst)
Who We Are
At BCIT , putting people at the core of everything we do is paramount. This idea is the foundation of BCIT’s People Vision , which describes the Institute’s goals and priorities in respect to our people. In a complex and uncertain world, it’s vital our people feel valued, supported and connected. BCIT champions a culture of innovation and global progress through people’s imagination and creativity. With a competitive compensation package, great work-life balance, and career advancement opportunities, see why we’ve earned the title of one of BC’s Top Employers for over ten years running.
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
- 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
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.
- Solid 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
- 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
📌 Database Administrator (Burnaby)
🏢 British Columbia Institute of Technology
📍 Burnaby