Oracle Database Administrator - Toronto, Canada - iPartner Staffing

iPartner Staffing

Verified Company

Toronto, Canada

4 weeks ago

Posted by:

Sophia Lee

beBee Recruiter

Description

Role:
Database Administrator - Senior

Location:
Toronto, ON

Contract

Description

Senior Database Administrator:

Perform day-to-day operations, maintenance, and support, including:1.1 Database Error/Alert Monitoring & Troubleshooting

1.2 Database Logs Review and Troubleshooting

1.3 Database Backup/Recovery jobs/tasks review

1.4 Performance monitoring and tuning

1.5 Storage and capacity planning and management

1.6 Database objects management

1.7 Database Change Management

1.8 Security/Auditing

1.9 Identify security gaps and vulnerabilities, identify and implement mitigations (e.g. patches)

1.10 Installing, Configuring, Patching work related to projects

1.11 User and Profile management

Create a SOP (Standard Operation Procedure) document to assist operational staff (non-DBAs) in their duties regarding Oracle database environments.

Perform regular assessment of the existing Oracle databases/environments, and make recommendations regarding:3.1 Maintenance and leading practices;
3.2 Changes required to address production issues (e.g. instability, poor performance) and risks;
3.3 Improvements to operational procedures (e.g. backup/restore) to align to standard methodology and industry best practices, taking into account the amount and criticality of the systems;
3.4 Recommendations for disaster recovery and non-production environments; and

3.5 Database upgrade options and approaches, informed by overall solution refresh plans and industry best practices;

Implement approved recommendations as described above;
Provide guidance and outline best practices for incorporating future database requirements into the environment.
Contribute to a team culture of collaboration, excellence and innovation;
Develop or inform the development of role descriptions for the development and sustainment of OPS/BPS Secure;
Develop plans for the knowledge and skills transfer to OPS employees, including activities or tests to

demonstrate the successful transfer of knowledge and attainment of required skills; and