Database Administrator 1(11133)

Location: Cambridge, Ontario, Canada
Date Posted: 24-11-2017
Position Overview 
As a member of the Client's Health team, the Oracle DBA (Database Administrator) will be responsible for supporting the operational elements of our customer’s database infrastructure as well as involved project delivery. 

The DBA is a member of a team responsible for the daily management and administration of a variety of database clients at various levels. While your role is very technical in nature you will be called upon to discuss these matters to business minded individuals inside the customer’s organization. Technologies mainly focused on Oracle but not limited to it. The DBA's prime role is supporting the operational availability of these systems on a daily basis. 

• Familiar with the full cycle of Oracle instance/database management: software installation/patching; upgrade; configuration and deployment of instance/database; capacity planning; monitoring of capacity, availability, performance of the instance/database; performance analysis and tuning; backup, restore and recovery; setup replication and high availability; architect customized backup solutions; scripting jobs for automation; problem fix; Security management and auditing; documentation etc 
• Interact with customers, application teams and peer support team (DBA, SA, Storage, project management etc.) for project implementation and ongoing support 
• Take initiative to improve the performance, efficiency of the database assurance operation; being cohesive to standard best practice and collaborate / coordinate with the DBA peers on change management, problem management and work management etc 
• Take 24x7 on-call rotation and troubleshooting problem tickets and response to customer requests and change controls 
• Support other DBA/project activities; contribution to knowledge and experience sharing 

Required Knowledge 
• Install/Setup and maintain Oracle database software with updates/patches 
• Develop and maintain accurate documentation of all areas encompassing the database infrastructure 
• Database Security – access, authentication, auditing, vulnerability assessment 
• Perform migration and upgrade tasks while minimizing downtime 
• Perform database backups, restore, and recovery tasks 
• Understanding and planning and executing DR planning/testing 
• SQL, PL/SQL programming 
• Application DBA (data modeling, SQL 

Required Skills & Abilities 
• Windows/VMware environment skills 
• Provide 24x7 on-call support 
• Assist in help desk calls 
• Good analytical and problem solving skills 
• Good proactive planning skills and multi-tasking skills 
• Good communication skills 
• Excellent team worker and good performer under minimum supervision 

Required Professional Designation/Certification 
• Undergraduate degree or diploma in Information Technology, or equivalent experience 

Required Experience 
• Over 2 years’ experience as a Database Administrator working with Oracle in enterprise capacity 
• Experience on Postgres and MySQL in a production environment is a definite asset
this job portal is powered by CATS