This job board retrieves part of its jobs from: Emploi Étudiant | Toronto Jobs | Work From Home

Tech jobs every day in Canada!

To post a job, login or create an account |  Post a Job

   Canadian Tech jobs   

Website updated every day with fresh jobs in the IT industry

Slide 1
Slide 2
Slide 3
previous arrow
next arrow

Oracle Database Administrator

HaiLa

This is a Full-time position in Toronto, ON posted September 16, 2022.

Skills:
• DBA with work experience in Oracle 11g ,12c and 18c , 19C
• Proficient in managing databases in various platforms.

Support activities ranging from initial database architecture design through implementation, administration, monitoring, tuning, backup and migration.

Develop and oversee database policies and procedures
• Working knowledge of Oracle, covering Enterprise and Standard Edition.

Oracle Real Application Clusters (RAC) and Data Guard (DG).

Familiar with Oracle’s Product line, Database Editions and Options
• Expert level knowledge in ORACLE RAC, Goldengate and OEM
• Strong experience of performing SQL DBA activities such as installation, configuration and maintenance of SQL Server databases
• Experience in handling Incidents , change and problem tickets and have knowledge of ITIL processes
• Upgraded Oracle RAC cluster and Oracle DB to 18c and 19C
• Participate in planning, installation, implementation, configuration of Oracle GRID and RAC Database troubleshooting issues
• Collaborated in Design, Development, Testing and Support phases of new applications and databases.

Suggested optimal structure for database objects and physical design
• Database cloning and refreshes using ACTIVE, Manual and RMAN .

Also should have knowledge of Backup/recovery tasks such as complete, incomplete recovery, block recovery, export import using datapump etc.

• Installation, Monitoring and implementation of OEM 12C and performed task such as targets addition , creating monitoring templates, creating blackouts and configuring incident alerts
• Configure and create physical standby databases using Dataguard for disaster recovery and participated in BCP testing drills
• ASM administration including Disk addition and managing ASM Disk and Diskgroups, Voting disk and OCR files Addition/backup
• Knowledge of database upgrades from 10g to 11g and 11g to 12c .

Proactivity apply PCU and bug fixes to the database
• Proactively Tune queries, procedures and database IO to improve performance
• Handling day to day ORA related errors reported by the users and application owners
• Perform Database tuning, setting Initialization parameter and memory tuning using TKPROF, AWR, ASH, ADDM reports
• Configured database replication using oracle goldengate
• Nice to have knowledge of sql server instances and databases, configuring and scheduling the backups , handling daily tasks.

Also provided oncall support for sql server.

Good to have skills:
• Networking knowledge include TCP/IP and DNS
• Contact and work with vendor on all database related issues
• Implement security and auditing on databases.

Database/Table access and permission
• Database server(s) health check, monitoring, database performance capture, trending, tuning and improvement.

Project growth and expansion requirements, and plan to ensure that long term requirements are met
• Design database maintenance plan and backup/recovery strategies
• Prepare and compose technical documentation and support document