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