Senior Database Administrator - Cassandra / Couchbase

Job Description

Title – NoSQL DBA

· Experience range – 8 to 10 years

Skills

Must have

· DBA experience

· Cassandra DB (DSE Cassandra )/Couchbase DB

· PostgreSQL DB

· Devops tools (Ansible,Prometheus,Grafana)

· Capacity Planning, Power Shell, Shell scripting

· Involving in Patching activities

· Involving in upgrading of Databases

· Automating DBA tasks using any one of the scripting languages

Nice to have

· MongoDB

Responsibilities

· 24/7 Support handling L1 & L2 tickets

· Installation and configuration of multi-nodes fully distributed Cassandra cluster.

· Participation in Cassandra Cluster environment administration that includes adding and removing cluster nodes, cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting.

· Supporting as an Couchbase/ PostgreSQL Database Administrator for Cloud and AWS servers

· Performing DB administration tasks such as Node specific, Couchbase installation and configuration, Backup and Restore, Views query writing in Couchbase

· Performing DB administration tasks such as PostgreSQL logical database server administration, Database HBA configuration (User & Schema Maintenance), Replication setup, Backup and restore and L1/L2 administration in PostgreSQL

· Monitoring DB Performance and DB tuning

· Providing On Call support on weekends for all the database technologies which is mandatory

· Excellent customer service skills and positive attitude

· Good Knowledge on Backing up and Restoring data (Taking Snapshots, Deleting Snapshots, Enabling Incremental backups, Restoring from Snapshots)

· Responsible for managing data coming from different sources.

· Involved in Backing up and Restoring data.

· Analyse Client Systems and Gather requirements.

· Design technical solutions based out of the Client needs and systems architecture

· Configured Fair Scheduler to provide service-level agreements for multiple users of a cluster.

· Managing nodes on Cassandra cluster connectivity and security.

· Involved in writing Java API's for interacting with the Cassandra

· Used Cassandra as the data storage