| Job Description |
A bank in Downtown Toronto is looking for a full-time Oracle DBA.Under the supervision of the Senior 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.
Configuration planning and installation of Oracle servers. Performance and general health / capacity monitoring. Tuning and load balancing of servers. Routine maintenance including database rebuilds/re-indexing/expansion and archiving. Trouble shoot Oracle server problems, and assist in the resolution of application problems. DB upgrades and conversions. Assist in promotions, data conversions. Backup and recovery of local and remote replicated databases. Provide pager support to production systems as assigned; involves week end and after hours support on a rotating basis. Provide DBA support to development/implementation projects as assigned including installations, database loading, conversions, testing etc. Prepare change control documentation. Maintain database monitoring systems.
|
| Job Requirements |
Sound practical knowledge of the following - Sun Solaris operating system and utilities. Bourne or Korn shell script writing. Oracle 9i, 10g, 11g and Oracle 12c (device configuration, installation, stored procedures & packages PL/SQL and sql script writing, Sql*Loader, RMAN, Replication & Standby databases, database re-build / de-fragment techniques, logical & physical backup / recovery techniques. Application side tuning vs. server side tuning vs database tuning). Perl scripting, shared memory tuning etc. Minimum 5 years of practical DBA experience. Good analytical, problem solving and trouble shooting skills. Quick learner, with good interpersonal and communication skills. Experience with Oracle RAC, OLAP, OWB, OEM and ASM is an asset. Knowledge of Sybase and/or MS-SQL technologies would be an asset
A degree in Compurter Science, math, or related discipline. Oracle DBA OCP certification in is desirable
|