CockroachDB DBA

Primary Skills: Distributed Databases: Preferably Cockroach DB/ Cassandra/ Postgres | UNIX OS, Devops Tools

Role Summary:

• The DBA will be responsible for designing, deploying and maintaining database clusters in Linux operating systems that are used by different groups of applications.
• The DBA must have advanced knowledge of Unix systems and shell scripting/ Python. Experience and knowledge of some of NoSQL or distributed databases such as (Cassandra, CockroachDB, Postgres) is needed including creation and implementation of fully functional database clusters, ability to maintain multiple development, QA and production environments with strong experience in operations and production support.

Responsibilities:

• Responsible for providing day-to-day administration support and maintenance for existing and new distributed databases in production and non-production environments.
• Perform debugging, tuning and performance enhancement as well as automation of operational and continuous integration aspect of the database platform.
• Write shell scripts for automation of installation and support of distributed databases.
• Working with using DevOps tools like Ansible, BladeLogic to create, maintain and execute jobs.
• Identify inefficiencies in current databases and implement improved solutions
• Assist in planning and implementing capacity and resource expansion to ensure scalability of company databases.
• Assist developers in making changes to the schema, providing database access levels, etc
• Assist in planning and performing database upgrades and migrations

Required Experience:

• Requires related experience in the UNIX systems and shell scripting, design, maintenance, and administration of distributed databases     ( CockroachDB, Cassandra, Postgres etc.).
• Conversant with using DevOps tools like BladeLogic, Ansible etc.
• Previous experience in high volume environments is highly desired.
• Deep understanding of cluster management areas, such as adding/ removing nodes, consistency tuning, replication, and multi-DC configuration etc.
• Strong experience in UNIX/Linux with advanced knowledge of Shell scripting
• Strong experience in NoSQL or SQL Database Technologies