Amsath Ali

I have totally 13+ years of experience in Database administration. 8 years in Oracle and 5 years in Cassandra.

Strong administrator for Apache Cassandra and DataStax Cassandra, Cassandra Cluster Setup: Setting up a Cassandra Cluster involves configuring multiple nodes, Horizontal Scaling up: Adding datacenter, adding nodes in Cassandra, Horizontal Scaling Down: Removing Nodes/Datacenter from Cluster, Create/Alter DB/ keyspace, DDL and DML Operations: Creating, altering and dropping tables. Inserting, updating, deleting and querying data. analysing the tables and recommending Indexes and best practices using Cassandra data modelling techniques, Authentication and Authorization: Ensuring Secure access to the Cassandra Cluster.

User Management: Managing user accounts involves creating new users with specific permissions and privileges and deleting existing users when necessary.

Grant/Revoke Permission: Granting and revoking permissions for users or groups.

Repair Tasks: Full repair, Primary range repairs, Keyspace repairs and table repairs and working repear for repair. medusa Backup and restore.

Compactions: Full Compactions, Keyspace Compaction, Tablelevel compaction to ensure optimal database performance.

Backup Strategies: using COPY command, Snapshots, tools like ds bulk. Restoration.

Data Migration: Using copy command. Extensively used node tool for the cluster administration of Cassandra. Installation, Up gradation of Apache Cassandra clusters & DSE. Query tuning & performance tuning on cluster& suggesting best practice for developers.

Monitoring: Performance metrics, system health, Alerting and Log Analysis. Working on OpsCenter (monitoring) and Grafana , Splunk for log monitoring and new relic for monitoring.

I have completed Master of studies in information Technology