To provide management, technical support and high availability for the College’s enterprise applications, databases and data warehouses.
To perform the role of an Application DBA for Enterprise Systems. Provides exceptional client-centered service on a consistent basis to all stakeholder groups.
1. Systems Database Administration
a. Installs, configures, patches and upgrades databases and related products.
b. Establishes and maintains Backup and Recovery procedures.
c. Implements and maintains database security (user access, roles and privileges) and Audit functions.
d. Plans for storage and capacity.
e. Monitors, tunes and optimizes the performance of databases.
f. Establishes, configures and maintains High Availability and Disaster Recovery
procedures for databases.
g. Implements required security policies to databases.
h. Liaises with vendor support for technical and project related issues.
2. Application Database Administration
a. Installs, configures, patches and upgrades enterprise applications.
b. Monitors and manages application jobs pertaining to applications.
c. Creates and updates database objects.
d. Writes database procedures and scripts where required.
e. Assists developers with database activities and tuning of database queries.
3. Other Database Related Duties
a. Provides management and support for Ministry and College data warehouses.
Actively involved in the design and creation of data stores and data cubes.
b. Creates and maintains ETL (Extract, Transform and Load) scripts for data
c. Provides and supports the integration between Enterprise databases and third party software.
4. Other Related Duties
a. Provides information, technical assistance and support to users.
b. Attends internal and external meetings.
c. Maintains and upgrades technical currency by attending courses and training
d. Delivers training to users and peers as needed.
To Be Successful in this Role You Will Need
1.A Bachelor’s Degree in Computing Science or equivalent IT program from a recognized post-secondary educational institution supplemented by a minimum of five years’ relevant experience in database administration in an Oracle environment, or an equivalent combination of education, training and experience.
2.Good knowledge of applications in the organization and strong understanding of the business.
3.Experience with :
4.Demonstrated knowledge of :
5.Good knowledge and thorough understanding of web technologies.
6.A demonstrated ability to :
7.Good working knowledge of the English language (verbal and written).
8.Proven record, including continual training, upgrading and / or certification, in Database Administration of an Oracle based system and of emerging technologies and tools.