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.