Senior CockroachDB Architect/Engineer

Apex Systems is a global IT services provider, and our staffing practice has an opening for Senior CockraochDB Engineer and with extensive enterprise architecture and design experience as well as the ability to build optimize and configure a platform to place at our client, an industry leading technology company.

Client: A Fortune 100 Technology Company

Terms: 12 month rolling contract

Location: Hybrid Toronto

Project Description:

• The CockroachDB Specialist will be responsible for the design, implementation, and ongoing management of a distributed CockroachDB cluster running on OpenShift.
• This role will involve working closely with development teams to ensure optimal database performance and scalability, as well as managing the underlying infrastructure.

Role Responsibilities:

• Design and implement a CockroachDB cluster architecture that meets the organization's performance, availability, and scalability requirements.
• Configure CockroachDB pods and StatefulSets on OpenShift to ensure optimal performance and resource utilization.
• Implement submariner to interconnect multiple OpenShift clusters and enable seamless communication between CockroachDB instances.
• Operationalization of CockroachDB to support observability patterns and logging.
• Tune queries and indexes to improve database performance and efficiency.
• Automate deployment and upgrade processes using tools like Helm or Ansible.
• Automate configuration changes to ensure consistency and reduce errors.
• Monitor database health, performance, and utilization.
• Troubleshoot and resolve database-related issues.
• Collaborate with development teams to optimize database usage and performance.
• Stay up to date on the latest CockroachDB features and best practices.
• Technical team lead/mentorship role for others on the team, however this is not a role that has direct reports.

Required Project & Technical Experience:

• Minimum 2 years of experience operating CockroachDB in a multi-region cluster environment.
• Implementation of CockroachDB in a HA environment structure for RTO=0 and minimal RTO (near 0) mins for high volume transaction system deployed across 4 OpenShift clusters spanning 4 different regions
• Strong understanding of CockroachDB architecture, distributed systems, and SQL.
• Proficiency in Kubernetes and OpenShift, including pod configuration, StatefulSet workloads, networking, and storage.
• Experience with submariner for interconnecting multiple OpenShift clusters.
• Experience with technical setup (greenfield) of CockroachDB on RedHat OpenShift Container Platform environment in on premise environment (not cloud based)
• Knowledge of SQL tuning techniques, including query optimization and index design.
• Experience with automation tools for deployment, upgrades, and configuration management (e.g., Ansible, Helm, Terraform).
• Certifications or referenceable experience equivalence in
• CockroachDB
• PostgreSQL / Enterprise DB
• RedHat OpenShift Container Platform
• Strong problem-solving and troubleshooting skills.
• Experience with cloud platforms (e.g., IBM Cloud, AWS, GCP, Azure).
• Knowledge of other distributed databases (e.g., Cassandra, Aerospike, MongoDB).
• Experience with DevOps practices and tools (e.g., Git, Jenkins, Podman, Docker).
• Experience or previous working knowledge of Payment Systems.
• Excellent communication, technical writing, and collaboration skills.

Interview Process: Interviews will take place in two rounds during the same week this month.

This is a great opportunity to join a major leading enterprise organization and continue your career in the technology domain. Be a part of a great work environment with a very well-organized team and colleagues who will help you succeed.