Basic Information

Ref number

Req_00026977

Primary Location

Ortigas Center

Description and Requirements

Additional Job Description

As a member of the Database Services 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 national team responsible for the daily management and administration of a variety of database technologies mainly focused on Oracle but not limited to it. The DBAs prime role is supporting the operational availability of these systems on a daily basis. The position requires excellent written and interpersonal skills to build relationships with external and internal 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.

 

 

Responsibilities:

  • Complete full cycle 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; escalation to DB vendor; 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

  • Install/Setup and maintain Oracle database RAC software with updates/patches

  • Analyze and performance tune all aspects of databases systems including but not limited to database software, Operating System/VW elements, Storage sub-systems, etc

  • Utilize system side performance monitoring tools as well database-specific tools such as Oracle Enterprise Manager, AWR, SQLT to tune instance and or session performance problems

  • Capacity planning and storage concept on RAID, SAN, NAS, Storage snapshots features

  • Develop and maintain accurate documentation of all areas encompassing the database infrastructure

  • Database Security – access, authentication, auditing, vulnerability assessment

  • Database Replication (Dataguard, GoldenGate) and High Availability (Real Application Clusters)

  • Perform migration and upgrade tasks while minimizing downtime

  • Perform database backups, restore, and recovery tasks using native backup and restore (RMAN), as well as utilizing storage or VM level snapshots technologies

  • Understanding and planning and executing DR planning/testing

  • SQL, PL/SQL, DTS package programming

  • Application DBA (data modeling, SQL programming/optimization) support role is a definite asset

 


Required Skills & Abilities:

  • Strong UNIX/Windows/VMware environment skills

  • Provide 24x7 on-call support

  • Assist in help desk calls utilizing Remedy

  • Good analytical and problem-solving skills

  • Good proactive planning skills and multi-tasking skills

  • Good communication skills

  • Taking initiative and ownership, delivering quality and thorough services to customers

  • Excellent team worker and good performer under minimum supervision

  • Bi-lingual (English/French) is a definite asset

  • Strong Oracle database experience

 

Required Professional Designation/Certification:

  • Undergraduate degree or diploma in Information Technology, or equivalent experience

  • Oracle Certified Professional, OCP (preferred)

  • Microsoft Certified Database Administrator or related MS Technology Certification (asset)

 

Required Experience:

  • Over 4 years’ experience as a Database Administrator working with Oracle in enterprise capacity

  • Proven experience working with Oracle 9i, 10g, 11g, 12c over the last 3 years

  • Experience on MS SQL Server in a production environment is a definite asset

Explore the possibilities at TELUS International. We love to see you grow and develop both personally and professionally. Find jobs that match your skills to build a career that excites you. Join our Talent Community to receive Newsletters and jobs alerts based on your profile and interests. Come learn how!