Systems and Application Database Administrator
Douglas College
New Westminster, Canada
2d ago

The Role

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.

Responsibilities

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

warehouses.

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

activities.

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 :

  • Latest versions of Oracle RDBMS (12c and later), Oracle Enterprise Manager, Oracle Weblogic
  • Identity and Access Management Systems
  • Oracle Database high availability Architectures
  • Tomcat Administration
  • 4.Demonstrated knowledge of :

  • Operating Systems
  • Physical Database Design
  • Performance tuning at database and application level
  • Backup and recovery scenarios
  • Security management
  • Computer system administration including good knowledge of UNIX, Linux and MS Windows server operating systems.
  • Basic networking, including familiarity with TCP / IP, DNS, DHCP, VPN, SSL.
  • 5.Good knowledge and thorough understanding of web technologies.

    6.A demonstrated ability to :

  • Provide strategic database direction for the organization;
  • Work independently with minimal supervision;
  • Work with others in a team environment;
  • Establish priorities and achieve deadlines;
  • Build trust and maintain professional image in all situations;
  • Communicate effectively in person, on the phone and in writing with administrators, faculty, staff, development team and external vendors;
  • Establish and maintain system-specific documentation and operational procedures.
  • 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.

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form