Сучасна диджитал-освіта для дітей — безоплатне заняття в GoITeens ×
Capgemini Engineering Ukraine Official web site: www.capgemini-engineering.com.ua Capgemini Engineering Ukraine (ex-Lohika) is the leader in engineering and R&D services.
17 червня 2020

Senior/Lead SQL/DBA Engineer (relocation to Canada) #7371 (вакансія неактивна)

за кордоном

PURPOSE OF THE JOB
Our client is one of the world’s largest online marketplaces, dealing with one billion events per day. Currently, we are building a team to work in our office in Vancouver and in the client’s office in San Francisco.
We are looking for Senior DBA, who will contribute to the optimization of existing DB monitoring and maintenance and resolve the ongoing issues with the number of high loaded DBs in Amazon RDS and MySQL infrastructure.

MAIN TASKS AND RESPONSIBILITIES
• Resolve most complex DBA tasks
• Handling major and minor version upgrades for MySQL and Aurora DB
• Schema migration with minimal online production impact, including tooling support for such migrations
• Database migrations, including migrating out tables to a new database cluster
• Review and consultancy support for data model and query workload designs
• Technical Reports and Recommendations for Capacity Assessment
• Recommendations for improvements in database configuration, query pattern or data models to improve capacity headroom
• Contribute to DBA runbook
• Work closely with Engineering and Infrastructure teams
• Work in close contact with team members and project stakeholders on the client’s site

MUST HAVE:
• 5+ years in DBA of MySQL
• Python, or Ruby, or Bash, or other scripting experience to automate routine tasks
• Experience in managing large scale (1000+ qps, 50+ instances) MySQL based storage systems
• Extensive experience of DB administration based on AWS EC2 and RDS
• Experience in query optimization, replication, migration, monitoring, backup and restore

WOULD BE A PLUS
• Experience with Aurora
• Experience with Terraform

LOHIKA BENEFITS
— Friendly and highly professional teams
— Flexible working hours with no overtimes
— Regular performance reviews
— Comfortable office facilities (kitchens, shower, gym, sports activities, yoga, lounge zone, coffee points etc.)
— Fully paid English classes (twice per week) with own English teachers
— 20 working days of annual paid vacation
— Christmas holidays (1-7 January) and state holidays celebration
— Paid sick-leaves
— Premium Medical & Life insurance
— Incentives (marriage, childbirth)
— Training activities & bonuses for internal training delivery
— Corporate events

Гарячі вакансії

Всі вакансії