We provide IT Staff Augmentation Services!

Team Lead - Database Resume

0/5 (Submit Your Rating)

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

We'd love your feedback!