Oracle DBA > Tata Consultancy Services > Joboolo CA :
Company : Tata Consultancy Services Location : Toronto Ontario From : Neuvoo CA
• 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 Oracles 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 • Knowledge of database upgrades from 10g to 11g and 11g to 12c.
Proactivity apply PCU and bug fixes to the database.
• Nice to have knowledge of SQL server instances and databases, configuring and scheduling the backups, handling daily tasks.
Also provided on-call support for SQL server.
Roles & Responsibilities:
• 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 data pump 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 Disk groups, Voting disk and OCR files Addition/backup • 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 • Configure database replication using oracle GoldenGate TataConsultancyServices Canada Inc.
is committed to meeting the accessibility needs of all individuals in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code (OHRC).
Should you require accommodations during the recruitment and selection process, please inform Human Resources.
Thank you for your interest in TCS.
Candidates that meet the qualification for this position will be contacted within a two-week period.
We invite you to continue to apply for other opportunities that match your profile. TataConsultancyServices TorontoOntario
