Title: Database Administrator

Reports To: DBA Team Leader. ID Systems, Customer Support Department

Location: Ottawa, Ontario, Canada

General Objective:

  • To provide database support for Identification Software Systems deployed around the world.


Responsibilities:

  • Install and maintain databases in development, test, training and production environments;
  • Develop and maintain sound backup and recovery policies, and procedures. Develop disaster recovery plans, and perform disaster recovery tests;
  • Monitor multiple databases and applications using internal and external tools;
  • Maintain maximum system availability;
  • Perform database and application tuning and performance monitoring;
  • Plan growth and changes ensuring appropriate storage for the database (capacity planning);
  • Write and maintain database stored procedures, packages, triggers and views;
  • Provide troubleshooting and root cause analysis for database related issues;
  • Provide telephone and email support to on-site support staff and end-users;
  • Provide on-site support to customers;
  • Work as part of a team and provide 7x24 support on rotational basis;
  • Provide data management support for multiple applications;
  • Perform installation and configuration of system components (hardware, software, database);
  • Setup and maintain documentation and standards;
  • Provide help and consultation to development teams and other internal staff;
  • Recommend software and hardware upgrades as they relate to database functionality and performance;
  • Train onsite technical support staff;
  • Keep up to date with latest technology;
  • Meet deadlines for deliverables.


Qualifications:

  • Post-secondary education Computer Science, Engineering or related field;
  • At least 4 years of experience in developing and administering database systems (specifically Oracle);
  • Experience with database systems in Linux or Unix environments is an asset;
  • Experience in supporting database systems in the field;
  • Hands on experience in establishing and maintaining sound backup and recovery procedures;
  • Knowledge of Oracle security management, data integrity, performance tuning;
  • Experience with Oracle streams, standby databases or RAC is an asset;
  • Strong troubleshooting skills;
  • Good analytical and high quality documentation skills;
  • Understanding of Help Desk tools and trouble ticket tracking processes;
  • Self-motivated and action oriented team player;
  • Ability to meet tight deadlines, handle multiple tasks, and adapt to changing priorities;
  • Detail oriented, with strong organizational skills;
  • Ability work off-hours on-call;
  • Strong communication skills in English (French is an asset), with the ability to communicate effectively with customers;
  • Must be willing to travel internationally;
  • Must qualify for or possess Canadian Government Secret level (assessed by CSIS).