ORACLE DATABASE ADMINISTRATOR

Canadian Bank Note Company, Limited (CBN) is a world leader in high-level security documents and related issuing and management software systems. Canadian Bank Note has a global workforce of approximately 1,000 employees with the majority of employees located in Ottawa, Canada. We have offices on every continent in the world and customers in over 40 countries.

EDUCATION
Bachelor degree or Master degree in Computer Science or Computer Engineering.
REQUIRED QUALIFICATION
- 3+ years experience of database administration with Oracle 10g/11g/12.
- 2+ years experience in database design including defining and analyzing ERDs
- Working experience with online transaction processing systems
- Good Database and SQL Performance Tuning skills and good understanding of Oracle Internal Structures
- 2+ Linux system administration experience
- Experience with system installation (both operating system and Oracle) and patching
- Backup/Recovery knowledge
- Experience writing PL/SQL (Packages, Stored Procedures, Functions and Triggers).
- BASH scripting language experience is an asset
- Experience supporting mission critical relational databases are considered an asset
- Certifications are considered a plus (Oracle Certified Professional / Oracle Master)
- Oracle streams experience and/or knowledge
- Experience and/or good understanding of RAC, physical and logical standby, and other high availability Oracle technologies is considered a plus.
- PostgreSQL knowledge and experience is considered an asset
SKILLS:
- Strong communication skills in English (French is an asset)
- Good problem solving and analytical skills
- Strong team player
- Make-it-work attitude under firm deadlines
- Ability to work under pressure
- Willing to travel abroad twice a year

- Participation in System Architecture planning and design
- Database design and participation in design reviews and system design
- Performance tuning and stress testing the systems
- Reports development
- Installation and configuration of system servers (hardware and software)
- Monitor database events and proactively optimize system performance
- Database support and optimization post system deployment
- Travel to customer sites globally to install the new systems and train system administrators following deployment.