Sr. Oracle DBA

Position: Sr. Oracle DBA
Location: Ottawa, Ontario, Canada
Position Type: Contract
Language: English

Clearance: Enhanced
 

JOB SUMMARY


The Senior Database Administrator (DBA) performs the role of Technical Lead and/or Project Lead for all assigned projects and is accountable for delivering the technical solution. The incumbent will be responsible for ensuring that any project is delivered following corporate policies, procedures while following industry and vendor best practices.  The incumbent will also be responsible for the successful transition of this project into production and for the availability and the integrity of these databases by managing regular maintenance, backups and recovery processes, securing and safeguarding its data.

RESPONSIBILITIES:

Project Delivery

  • Implement best practices and standards for databases, database server configurations, monitoring and operational procedures
  • Collaborate with project teams to understand requirements and specifications while ensuring all solutions align to the technology roadmap and direction
  • Ensure solutions follow change control systems to protect the integrity of all systems and the delivery of high quality solutions
  • Plan and manage complex changes to ensure that proper processes are followed and appropriate people are informed
  • Work with Project Managers to develop project plans, schedules and timelines
  • Database migration performance / tuning and troubleshooting

Operational Management

  • Provide administration and support for mission critical and pre-production database environments
  • Perform and manage daily database maintenance, monitoring and performance tuning
  • Responsible for database disaster recovery of all database environments which includes managing and supporting data recovery policies
  • Responsible for managing database availability technologies like Oracle OEM, Oracle RAC, Data Guard
  • Responsible for managing resource capacity by monitoring usage and trends for proactive management of resources
  • Ensure all environments comply with corporate security measures and best practices

QUALIFICATIONS:

SCREENING CRITERIA

  • University degree or diploma in computer science or
    an equivalent combination of education and relevant work experience
  • Minimum of 7 years of progressive proven experience in Oracle database administration
  • The DBA should have strong experience in implementing and supporting Oracle Database 12c
  • Experience with Oracle Linux / Oracle ODA
  • Experience with Oracle RAC and Oracle Data Guard
  • Experience working in a team-oriented, collaborative environment
  • Excellent written and verbal communication skills

SKILLS & KNOWLEDGE

  • Strong understanding of database structures, theories, principles, and practices
  • Experience with monitoring and identifying performance bottlenecks
  • Proven analytical and problem-solving abilities
  • Experience with backup and recovery methods
  • Experience using database availability technologies
  • Experience working within an ITIL environment
  • Experience with database coding in SQL, PL/SQL
  • Experience with Unix Shell Script
  • Experience with Source Code repositories

ASSETS

  • Database Administrator certification
  • Experience with Oracle Database Appliances (ODA)
  • Experience supporting RDBMS’s on Windows Servers and Linux Servers
  • Experience with IBM Cognos
  • Microsoft SQL Server 2012+
  • Bilingual in both official languages (French and English)