Job Description

Position Title: NoSQL DBALocation: Gurgaon/BangaloreExperience : 2 -6 yrs.Shift Timing : 1:30PM -10:30PMCTC :20-35LPAJoining Availability : Immediate joiner onlyNote : get profiles with Couchbase and Cassandra experience including intermediate level automation skills for building playbooks and using them (Job Summary/Roles & Responsibilities)- 24/7 Support handling L1 & L2 tickets- Installed and configured multi-nodes fully distributed Cassandra cluster.- Involved in Cassandra Cluster environment administration that includes adding and removing cluster nodes, cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting.- Good Knowledge on Backing up and Restoring data (Taking Snapshots, Deleting Snapshots, Enabling Incremental backups, Restoring from Snapshots)- Responsible to manage 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- Supporting as an Couchbase/ PostgreSQL Database Administrator for Cloud and AWS servers- Performing DB administration tasks such as Node speci\xef\xac\x81c, Couchbase installation and con\xef\xac\x81guration, Backup and Restore, Views query writing in Couchbase- Performing DB administration tasks such as PostgreSQL logical database server administration, Database HBA con\xef\xac\x81guration (User & Schema Maintenance), Replication setup, Backup and restore and L1/L2 administration in PostgreSQL- Monitoring DB Performance and DB tuning- Providing OnCall support on weekends for all the database technologies which is mandatory- Excellent customer service skills and positive attitude as demonstrated by receiving employee of the month in two consecutive quartersMandatory SkillsMust have- DBA experience- Cassandra DB (DSE Cassandra )- Couchbase DB- Postgre SQL 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

Ciel HR