SQL DBA

Responsibilities:

• Responsible for providing day-to-day administration support and maintenance for existing and new NoSQL 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 NOSQL platform.

• Write shell scripts for automation of installation and support of NoSql databases

• Working with using DevOps tool 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

Experience:

• Requires related experience in the UNIX systems and shell scripting, design, maintenance, and administration of NOSQL databases (Redis, Memsql, CockroachDB, MongoDb, Cassandra, 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/bootstrapping/removing nodes, consistency tuning, replication, and multi-DC configuration.

• Strong knowledge of monitoring, management, capacity planning and compaction strategy

• Good knowledge of database backup and recovery, connectivity and security, and role management

• Ability to express complex technical concepts effectively, both verbally and in writing

• Ability to work well with people from many different disciplines with varying degrees of technical experience

• Must be versatile, flexible, and proactive when resolving technical issues

• Excellent Interpersonal Communication Skills