**We welcome all people based in Toronto, ON to apply. This job is a hybrid role from this location. **
Under the supervision of the Director of Technology, Datacenter Operations, the Cloud Database Engineer will lead the design, deployment, and support of scalable, secure, and highly performant cloud-based data platforms. This role focuses on optimizing and modernizing the organization's data infrastructure across relational and NoSQL systems, enabling robust analytics and reporting through AWS-native services, Snowflake, and Databricks. The engineer will ensure optimal data flow, high availability, and operational excellence in support of Perceptyx's enterprise-grade SaaS platform. This individual will provide thought leadership on database architecture and collaborate closely with application developers, DevOps, and data analysts.
Things You'll Do:

• Design, deploy, and manage cloud-native database architectures using MySQL, PostgreSQL, DynamoDB, MongoDB, and other open-source systems.
• Support the strategic adoption of AI-driven tools and techniques to optimize database design, accelerate implementation workflows, and improve operational insight and efficiency.
• Lead the development of ETL and ELT pipelines using AWS Glue, Apache Spark, Databricks, and Snowflake to support scalable data ingestion and transformation.
• Drive automation of database monitoring, proactive alerting, and self-healing routines to reduce unplanned downtime and improve observability.
• Perform performance tuning and optimization of large-scale SQL and NoSQL environments, identifying and resolving slow queries and blocking transactions.
• Evaluate and implement cloud database services such as Amazon RDS, Aurora, DynamoDB, Redshift, and S3-based data lakes.
• Create and maintain data models, schemas, storage structures, and migration scripts that support production-grade analytical and transactional workloads.
• Collaborate with security teams to implement and enforce role-based access control, encryption standards, and compliance protocols across all data environments.
• Support CI/CD workflows by integrating database changes into deployment pipelines and promoting DevOps culture across data infrastructure.
• Provide expertise in database backup/recovery strategies, high availability (HA), and disaster recovery (DR) using cloud-native and third-party tools.
• Own and maintain accurate architecture documentation, performance reports, and maintenance records across staging, testing, and production environments.
• Perform capacity planning and storage forecasting based on anticipated growth, workload analysis, and business usage patterns.
• Support production incidents and deliver root cause analysis for any database-related issues.
• Participate in a rotational on-call schedule to provide after-hours support as needed.

Marginal Duties

• Participate in broader infrastructure and DevOps initiatives.
• Assist other engineering teams with database-related development and troubleshooting tasks.
• Serve as a mentor to junior engineers and provide thought leadership in data best practices.

Things You'll Bring:

• Bachelor's degree in Computer Science, Information Systems, or a related technical field preferred.
• 5+ years of experience managing Linux-based database environments, preferably with MySQL, PostgreSQL, and NoSQL platforms such as MongoDB or DynamoDB.
• Proven experience working with Snowflake and/or Databricks in a cloud-native enterprise setting.
• Strong expertise in SQL query optimization, indexing strategies, and database performance tuning.
• Hands-on experience with AWS data services (e.g., RDS, Glue, Redshift, S3, Lambda, IAM, CloudFormation).
• High level of accountability for the performance, availability, and integrity of data systems.
• Advanced knowledge of stored procedures, triggers, indexing, and schema design for transactional and analytical workloads.
• Self-motivated with the ability to independently prioritize and manage large-scale, concurrent projects.
• Excellent communication and collaboration skills across technical and non-technical stakeholders.
• Strong analytical thinking and problem-solving skills; able to perform complex systems analysis and recommend scalable solutions.
• Experience with Infrastructure as Code (e.g., Terraform, CloudFormation) is a plus.
  Cloud certifications such as AWS Certified Database – Specialty or Snowflake SnowPro Core are desirable.

Compensation:
Perceptyx is focused on equitable pay for all our staff and aims for transparency with our pay practices. The annual salary range for the role is 125,000-145,000 CAD. The above salary range represents the expected base salary range for this position. The actual salary may vary based upon several factors, including, but not limited to, relevant skills/experience, time in the role, business line, and geographic/office location.
Benefits:
We Care About The Whole Person