Senior Database Administrator

Scotiabank   •  

TORONTO, ON

Industry: Accounting, Finance & Insurance

  •  

5 - 7 years

Posted 35 days ago

This job is no longer available.

Job Purpose:

Under the supervision of the Manager Database Administration, manage and provide support for the banks Oracle databases. As a member of the database administration group, the incumbent will assist in the team effort to maximize the availability, security, and performance of the databases.

Key Accountabilities:

  • Provide on-site database and system support
  • Monitor, collect statistical information, and provide reporting on capacity and system performance
  • Based on statistics, make recommendations to maintain and improve capacity and system performance
  • Monitor the system, and act upon system and application automated alerts
  • Perform diagnostics, testing, and troubleshooting of software, o/s, and database issues (ex. correcting installation, configuration, or data problems)
  • Plan and perform software and database installation, configuration, upgrade and patching
  • Perform and manage system and database backups
  • Perform manual switch to redundant system / database components, in case of system failure
  • Willingness to work flexible hours, outside of regular business hours, nights, weekends.

Functional Competencies:

1. Oracle DBA 11g, 12c (5+ years experience with production database creation, upgrade and administration - NOT application )

2. Oracle 11g 12c on Windows (5+ years experience with setup, configuration, support)

3. Oracle RAC+ASM (5+ years experience with setup, configuration, support)

4. Oracle ODBC, JDBC, Heterogeneous Connectivity (5+ set-up environment, configure, and support)

5. Oracle Data Guard (5+years experience) 6. Performance tuning (5+ years experience) 7. Golden Gate 8. Oracle Exadata.

45331