Database Administrator 3 / Administrateur de base de données 3 (10748)

Location: Thornhill, ON
Date Posted: 08-08-2017
The DBA 3 provides 24x7 Tier III operational support for our MySQL DBs in all environments supported by client. Responsibilities and qualifications include: 
• 8+ years of related experience – High traffic, enterprise environment 
• Complex Problem-Solving Skills to include SQL and No-SQL technologies (Oracle, MSSQL, MySQL, MariaDB, memcached, redis, Oracle NOSQL, Microsoft Cosmos) 
• Knowledge of and experience integration with Infrastructure Automation frameworks, puppet, ansible, etc. 
• Knowledge of and experience integration and operation specific to auto heal/auto scale container frameworks: OpenShift, Kubernetes, CloudFroundy etc. 
• Strong experience in MySQL sharding and partitioning 
• Have knowledge in cloud infrastructure environments, data warehousing and enterprise IT concepts 
• Deep knowledge and experience with Clustering techniques and technologies 
• Deep knowledge and experience with Replication techniques and technologies 
• Deep knowledge and experience with UNIX and Windows Shell and related scripting languages 
• In-depth Logical/Physical Database Design 
• Plan, automate and implement Database backup and recovery 
• Capacity planning & system-level architecture 
• OS / Storage / DB configuration and optimization 
• Database security checks and audits, including compliance-related reporting & controls 
• Work with database vendor support to resolve challenges as needed 
• Define and maintain quantitative SLA's and helping enhance current service levels 
• Database creation, configuration, and upgrades, and automation of those functions 
• Apply patches as needed for security and bug fixes 
• Database tuning (proactive and reactive) 
• Maintaining specialized environments such as log shipping, replication, cluster-based instances, etc 
• SOP (Standard Operating Procedure) definition & automation 
• Disaster recovery / fail over services 
• Participation in On-call Rotation
this job portal is powered by CATS