Database Administrator - Virtual Practicum

DBAD 390
Closed
SAIT
Calgary, Alberta, Canada
Work Integrated Learning Coordinator
(0)
3
Timeline
  • September 1, 2020
    Experience start
  • October 2, 2020
    Mid-point status check
  • October 31, 2020
    Experience end
Experience
4/5 project matches
Dates set by experience
Preferred companies
Canada
Any
Any industries

Experience scope

Categories
Information technology Data analysis Operations Project management
Skills
project planning business services research sales & marketing marketing strategy
Learner goals and capabilities

Virtual Practicum Opportunity

Bring on one or more student from SAIT’s Fast-Track Database Administrator program to be your virtual interns, in a project-based experience. Our Fast-Track students are individuals who are changing or enhancing their current career through accelerated, skills-based hands-on training. They are a diverse group with a range of skills and interests.

Students can work on one or more project of your choosing over the practicum period, connecting with you as needed with virtual communication tools. Practicums can be paid or unpaid.

Due to COVID-19 restrictions, student placements will only occur virtually.

Learners

Learners
Certificate
Any level
16 learners
Project
320 hours per learner
Learners self-assign
Teams of 4
Expected outcomes and deliverables
  • Deliverables will vary depending on the scope of the project.
  • Access to motivated, skilled and productive candidates.
  • Savings on recruitment costs and improved retention, with an appropriate employment match.
  • A concentrated pool of experienced, talented professionals with which to maintain your competitive advantage in the marketplace.

Students are available for a minimum of 40 hours and up to 320 hours with your organization starting any time after May 4, 2020.

Project timeline
  • September 1, 2020
    Experience start
  • October 2, 2020
    Mid-point status check
  • October 31, 2020
    Experience end

Project Examples

Requirements

What can our students do for your company?

Students can complete a substantial project for your organization over the practicum period. We suggest providing a starting project, but as the placement goes on there may be other duties or projects the student is asked to complete as well. Providing a central project creates structure for the internship and gives the student (and company) a tangible goal.

Possible projects could be:

  • Designing the blueprint for your system. (Including a Data Model (ERD)).
  • Building a database to match the design that is determined by analyzing your processes and needs through interviews.
  • Creating tables (including constraints, views, sequences etc.),
  • Loading the data including the use of SQL*Loader, Datapump and external tables.
  • Creating representative users with proper privileges, quota etc.
  • Configuring auditing and reporting.
  • Defining a solid Backup & Recovery Plan including hands on testing
  • Networking your databases.
  • Database tuning to keep it at an optimal level of performance.

At the time of placements students have skills in Oracle SQL and PL/SQL, database architecture and administration, Oracle network administration, backup and recovery, Oracle performance tuning, data warehousing and data mining, Windows server and Linux operating systems.

What Do We Ask of You As A Virtual Practicum Employer?

  • Use reasonable efforts to enable the student to receive broad exposure to the business carried on at your company.
  • Require the student to perform only such tasks as reasonably fall within the scope of the student's training and abilities.
  • Sign a straightforward practicum employment agreement outlining the above-mentioned responsibilities.
  • Complete a brief "Employer Work Term Evaluation Report" for the student at the end of the work experience term.

Additional company criteria

Companies must answer the following questions to submit a match request to this experience:

  • Q - Checkbox
  • Q - Checkbox
  • Q - Checkbox
  • Q - Checkbox