NoSQL DBA  

·       Experience range – 8 to 10 years  

Skills  

Must 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  

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 OnCall 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