Team Lead - Database Resume
SUMMARY:
- Over 8.4 years of experience in managing SQL/NoSQL Database mainly Cassandra database administration.
- Expertise in tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modelling, backup and recovery, cloning, auditing, SQL, PL/SQL, NoSQL, Azure Cloud services, troubleshooting and documentation.
- Excellent Knowledge of Cassandra Architecture, Cassandra data modelling & Monitoring Cassandra using ELK.
- Involved in designing various stages of migrating data from RDBMS to Cassandra.
- Can handle commissioning and decommissioning nodes along with monitoring of Cassandra Cluster.
- Have Knowledge on Apache Spark with Cassandra.
- Commendable knowledge on read and write processes, including SSTables, MemTables and Commitlog.
- Oracle Certified Professional having experience in Project management and Banking Domain.
TECHNICAL SKILLS:
NoSQL Database: - Cassandra, Azure Cosmos DB, Hbase
RDBMS: - Oracle, SQL Server
OS: - Windows, Unix, Linux, Hadoop HDFS
Cloud: - Azure Cloud Services, Azure VM, AKS (Azure Kubernetes service), ACR (Azure Container Registry), Azure Storage files, Azure Cosmos DB, Azure pipelines, Azure CLI
Bigdata: - Pig, Hive, Spark, Scala
Agile Management: - SwiftALm Enterprise
PROFESSIONAL EXPERIENCE:
Confidential
Team Lead - Database
Responsibilities:
- Worked in an agile team to design and develop data lake from scratch, this is Machine Learning based product to provide predictions in Project Management domain.
- Configuring CI/CD pipeline for deploying and testing Cassandra in cluster on Azure cloud using Azure cli as well as on-perm
- Designed, Automated the process of installation and configuration of secure DataStax Enterprise Cassandra cluster using Kubernetes on Azure Cloud.
- Configured Azure file storage and Kubernetes for data persistence on Azure Cloud.
- Installed, Configured, Tested Apache Cassandra multi-node cluster.
- Involved in the process of designing Cassandra Architecture.
- Creating required key spaces for applications in prod, dev, test clusters.
- Set Cassandra backups using snapshot backups.
- Involved in the process of data mover for disaster recovery platforms Backup and recovery.
- Knowledge on set up Cassandra wide monitoring scripts and alerting system.
- Installed and Configured ELK stack for monitoring using (Logstash, File beat, Metric beat, Cassandra beat) and multiple dashboards using Kibana scripted files as per requests.
- Explored and Configured Prometheus and Graffana tools for monitoring Cassandra Clusters.
- Knowledge on bootstrapping, removing, replicating the nodes in Cassandra clusters.
- Performance tuning a Cassandra cluster to optimize writes and reads.
- Implemented Spark solution to enable real time reports from Cassandra data
- Experienced in upgrading the existing Cassandra cluster to latest releases.
- Involved in installing and configuring of Cassandra on different nodes of a fully distributed cassandra cluster.
- Worked extensively on GUI monitoring tools (OpsCenter, Grafana, Nagios and kibana) for Cassandra cluster monitoring.
- Involved in data migrations, Incremental backups and data restores using ‘Snapshots’ and 'SStableloader' in Cassandra.
- Involved in Cassandra data modelling changes (i.e. like creating and modifying keyspace, Replication factor changes etc inside Cassandra cluster)
- Worked extensively in Casandra query language (CQL.sh)
- Managing NoSql distributed database Cluster that includes adding and removing cluster nodes, cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting.
- Attending client meetings for requirement gathering and providing daily status.
- Solving outstanding JIRA bugs and reporting daily status of Bugs in client meetings.
- Involved in writing python, shell scripts to extract and migrate the existing cluster data into new cluster.
Environment: Apache Cassandra 3.11, DevCenter, Cqlsh, OpsCenter, Node tool, UNIX, Cassandra-stress, Shell Scripting, GitHub, Maven, MongoDB, Solr, Shell Scripts, Sqoop, Spark and Scala, Azure Cloud, Python, Docker, GITLAB, ELK, Kubernetes, Oracle 11g, Oracle 12c, Oracle Sql Developer, SQL Server 2012/2014/2016, Linux