• 
• 
  • 
    • 
  • 
  • 
  • 
• 
  • 
    • 
    • 
    • 
    • 
    • 
    • 
    • 
  • 
    • 
    • 
    • 
    • 
    • 
    • 
  • 
    • 
    • 
    • 
    • 
    • 
  • 
    • 
    • 
    • 
    • 
    • 
  • 
  • 
  • 
• 
• 
  • 
• 

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).

Site Map | Copyright | Disclaimer | Trademarks