Title: Senior Database Administrator
Division: Oil and Gas North America, IT Services
Reporting to: Database Team Lead
Location: Calgary – Downtown Office
Position Type: Temporary/Contractor, to December 2010, Full Time Hours - maybe extended to end of April 2011
Position Summary & Major Responsibilities:
This position performs database administrative tasks under the direction of the Database Team Lead. Detailed responsibilities include:
· Analyze, design, develop, deploy and implement new database systems
· Support applications development in areas requiring database skills
· Provide support in database modifications and design structures
· Install and maintain database software with upgrades or patches
· Develop and maintain data backup and recovery systems
· Develop and maintain database design documentation and meta data
· Provide after-hours on-call support of production environment
· Analyze and performance tune databases
· Assist in helpdesk calls using Remedy
Candidates must have technical experience in the following areas:
· Excellent design and requirements analysis skills
· Certified (OCP) in Oracle 9i or 10g
· Strong written and verbal communications
· Service- and deadline- oriented person
· Demonstrated experience managing databases on Unix Solaris platforms
· Product experience with Oracle Enterprise Manager, DBArtisian, TOAD and RMAN
Education and Experience Preferred:
· A Bachelor’s Degree in Computer Science or related discipline with 5+ years related post-secondary experience, or
· A Technology Diploma with 7+ years related post-secondary experience
· 5-7 years experience working with Oracle 9i, 10g and 11g in a UNIX Sun Solaris environment
· Two years experience working with SQL Server 2005 and 2008
· Experience working in a SOX (Sarbanes-Oxley) environment
· Experience in performance tuning, structured design, development methods and tools as well as implementation of database software