|
|
Oracle DBA
| Location: | Toronto, Ontario, Canada |
|---|
| Job Type: | Permanent |
|---|
| Posted: | 7th May 2008 |
|---|
| Closing Date: | 7th Jun 2008 |
|---|
| Posted By: | VaR-Value Added Recruiting |
|---|
| Details: | |
|---|
Oracle DBA
Oracle Database Analyst
The purpose of this job is to provide database administration of all the Corporate Production, QA, Development and Test databases. The role involves the establishment and utilization of effective policies and procedures for the definition, management, protection, and efficient utilization of systems, data and databases. This includes running scripts, installation, migration, monitoring, backup and recovery, tuning, resolving complex client related problems, and resolving all database related work/change orders in a timely manner. This is a hands-on senior technical support role that involves 7 x 24 support of Production related databases and software
Key Accountabilities
1. Database Analysis and Design: Enforcement of database standards; works with Development Teams to design new databases and/or change existing databases
2. Database Monitoring/Tuning: Lead efforts to develop and improve procedures; for automated monitoring of database availability and performance; Review performance stats and recommend changes for tuning database, server, storage configurations, and application SQL. This includes load-balancing and managing resources in a clustered environment.
3. Database Backup/Recovery: Participate in periodic backup audits, ensuring all databases and associated logs are being backed-up; Periodically conduct test database restores to validate backup integrity through regularly scheduled Disaster Recovery exercises
4. Database Problem Resolution: Assume ownership of database related problems; pursuing short and long-term problem resolution and root cause analysis; Work across support teams to gather information, determine and implement resolutions; Coordinate interaction with vendors in critical database problem situations
5. Database Software Installation and Upgrades: Identify hardware, software and configurations necessary to build and run database systems optimally. Specific knowledge and experience in installing and configuring highly-available DBMS solutions is required. Define best practices for patch management, version maintenance, and initial deployment, including the creation and maintenance of a "gold image" for deployment.
6. Contributes to the technical and strategic direction for the Database Management environment
7. Liaises with Infrastructure vendors marketing and support groups to keep abreast of industry trends
8. Provides input to the technical and strategic direction of Database Management related hardware and software
9. Provides support in the evaluation and proof of concept for Database Management hardware and software
10. Establish best practices to support Production using appropriate tools such as Oracle Database/Grid Control
11. Provide level 2 escalation and hands-on support to project and operational activities as required; participates in the 7 x 24 pager rotation
12. Maintain documentation, including operational documentation, support knowledgebase, and configuration information.
13. To be available to work after business hours and during the weekends
Requirements:
1. Database Management experience in the deployment, administration and maintenance of software such as Oracle, MySQL, and MS SQL-Server.
Specifically including the following technologies:
Oracle 10g, 9i, & 8 on Unix & Linux
Oracle RAC, ClusterWare, OCFS2, Partitioning, Grid Control, & RMAN
MySQL 5.x on Linux
MS SQL-Server 2000 & 2005
2. Experience working with teams such as QA, Operations, Architecture, etc
3. Oracle and MySQL database Performance and Monitoring experience in the Distributed/Open Systems environment
4. Minimum 7 - 9 years Database Management hands-on experience
5. University degree in Computer Science or equivalent experience
6. Database backup, recovery and Disaster Recovery experience with high availability solutions
7. Technical understanding of Solaris, Linux, Windows and Enterprise class servers, including VMWare ESX 3.x
8. Experience in highly available systems and RAID configurations
9. Excellent oral and written communication skills
10. Ability to manage multiple tasks in a fast-paced and changing environment
|
| |
| Sorry! This job is no longer active as the closing date for applications has passed. You can view other
vacancies from this company (if they have any) by clicking on their name above, alternatively we may have some suggestions
for similar vacancies listed below that might be of interest. |
| |
Featured External Adverts
|
|
|
|
 |
|
