Submit your application

• Which location are you applying for?
  Select...Remote - Canada - PSTRemote - Canada - ESTRemote - Canada - CSTRemote - Canada - MSTRemote - Canada - AST
• LinkedIn profile
  Loading...

  Apply with LinkedIn

  Profile added

  Your full LinkedIn profile will be
  shared. Learn more
• Resume/CV ✱
  ATTACH RESUME/CV

  Couldn't auto-read resume.

  Analyzing resume...

  Success!

  File exceeds the maximum upload size of 100MB. Please try a smaller size.

• Full name✱
• Email✱
• Phone ✱
• Current location ✱
  No location found. Try entering a different location

  Loading
• Current company

Links

• LinkedIn URL

Salary

• What are your salary expectations for your next role?

MySQL Questions (long)

• How many total years of hands-on experience do you have working with MySQL databases in a production environment?✱

  • <2
  • 2-4
  • 5-7
  • 8+
• Which MySQL deployment topologies have you directly administered or designed in a production setting? (Select all that apply)✱

  • Single-node (Standalone)
  • Master–Slave Replication
  • Multi-source Replication
  • MySQL Group Replication
  • MySQL InnoDB Cluster (with MySQL Shell and Router)
  • MySQL NDB Cluster
  • Percona XtraDB Cluster / Galera
  • RDS/Aurora (Managed MySQL services)
  • Other
• Have you performed any of the following in a production environment? (Select all that apply)✱

  • Minor version upgrades (e.g., 8.0.28 → 8.0.34)
  • Major version upgrades (e.g., 5.7 → 8.0)
  • Migration between cloud providers or data centers
  • Migration from MySQL to another DB engine (or vice versa)
  • Built rollback plans for upgrades/migrations
• Please describe one MySQL upgrade or migration project you've worked on — include version numbers, tools used (e.g., mysql_upgrade, mysqldump, InnoDB ClusterSet, etc.), and any key challenges faced. (Optional)
• How would you rate your ability to write and optimize complex SQL queries?✱

  • Beginner – Familiar with basic SELECT, INSERT, UPDATE, and DELETE
  • Intermediate – Comfortable with joins, subqueries, and indexing
  • Advanced – Proficient with query tuning, CTEs, window functions, and execution plans
  • Expert – Frequently analyze and tune high-impact queries in large-scale environments
• Provide an example of a query you optimized. What was the problem, and how did you fix it? (Optional)
• Which of the following tasks have you handled regularly? (Select all that apply)✱

  • Designing normalized schemas
  • Designing denormalized schemas for performance
  • Creating and maintaining indexes
  • Analyzing index usage (using EXPLAIN, SHOW INDEX, etc.)
  • Partitioning tables for performance or scale
  • Refactoring legacy schemas
• Which of the following MySQL performance tuning activities have you performed in a production setting? (Select all that apply)✱

  • Analyzing slow query logs
  • Using EXPLAIN and ANALYZE to debug queries
  • Adjusting InnoDB buffer pool and other memory settings
  • Connection pool tuning (e.g., max connections, thread cache)
  • Disk I/O and storage tuning
  • Query rewrite or refactoring
  • Schema redesign for performance
  • Monitoring and alerting via Prometheus/Grafana/Percona Monitoring
  • None of the above
• Which backup and recovery methods have you implemented or used in production? (Select all that apply)✱

  • mysqldump
  • Percona XtraBackup
  • MySQL Enterprise Backup
  • LVM snapshots
  • PITR (Point-in-time recovery)
  • Binary log-based recovery
  • Restore testing and validation routines
• Please describe a real-life recovery scenario you've handled. (Optional)
• Which high availability (HA) techniques have you configured or managed for MySQL? (Select all that apply)✱

  • Semi-synchronous or asynchronous replication
  • Orchestrator-based automated failover
  • MySQL Router with InnoDB Cluster
  • Load balancing with HAProxy or ProxySQL
  • Cloud-native HA (RDS, Aurora, GCP SQL)
  • Custom scripts for failover
  • None of the above
• What MySQL security practices have you implemented? (Select all that apply)✱

  • Managing users with least privilege
  • Using SSL/TLS for MySQL connections
  • Encrypting data at rest
  • Auditing and logging access
  • Password policy enforcement
  • Role-based access control
  • GDPR/HIPAA compliance measures
• Which MySQL-related tools or platforms have you used? (Select all that apply)✱

  • MySQL Shell
  • Percona Toolkit
  • pt-online-schema-change
  • Orchestrator
  • Ansible/Chef/Puppet for MySQL automation
  • Terraform for DB provisioning
  • MySQL Workbench
  • Monitoring (PMM, Nagios, Zabbix, etc.)
• Do you have experience managing MongoDB databases? (Optional but preferred)

  • No experience
  • Limited exposure
  • Moderate experience (e.g., maintaining small deployments)
  • Extensive experience (e.g., sharding, replica sets, migrations)
• Have you worked with MongoDB in a sharded cluster environment? (Optional but preferred)

  • Yes
  • No
• Are you comfortable participating in on-call rotations for database-related issues?✱

  • Yes
  • No
• Have you worked in environments requiring 99.99%+ availability and strict SLAs?✱

  • Yes
  • No
• Please describe a challenging database issue you've resolved in the past. What tools or strategies did you use? (Optional)

• • Yes, Pythian can contact me about future job opportunities for up to 3 years
    Privacy policy