Post Job Free

Resume

Sign in

cassandra dba

Location:
Mumbai, Maharashtra, India
Posted:
January 22, 2021

Contact this candidate

Resume:

Suraj Shelke,

Contact No: 970-***-****

E-mail: adjmlw@r.postjobfree.com

Present Address: Navi Mumbai, Maharashtra

CAREER SUMMARY

Certified Apache Cassandra™ 3.x Administrator Associate from Datastax

Certified Apache Cassandra™ 3.x Developer Associate from Datastax

Certified Apache Cassandra™ 3.x Architect from Datastax

Oracle Certified Professional having experience in Project management and Banking Domain.

Overall, 10 years of experience in Cassandra database administration, Oracle Database Administration, and SQL Server database administration

More than 5 years in Cassandra database related activities

Expertise in tuning, development, analysis, design, all phases of SDLC, installation, patches, upgrades, migrations, configuration, database security, capacity planning, space management, data modeling, backup and recovery, cloning, auditing, SQL, PL/SQL, NoSQL, Azure Cloud services, troubleshooting, and documentation.

Possesses extensive experience in Oracle 9i, Oracle 10g, Oracle 11g, Oracle 12c, and Microsoft SQL Server 2012/2014 database systems; Operating Systems including HP-UNIX, LINUX, Windows; multidimensional tools; relational databases and data warehousing.

Excellent knowledge in database administration for Production, Testing and Development Environments, implementation and product support, performance monitoring, data, and user security, and development tools.

Possess outstanding communication skills, resulting in excellent rapport with employees and executive management.

SKILLS

Apache Cassandra 3.11 Admin/Architect

Elasticsearch Stack, Kibana, Beats, Prometheus, Grafana

Datastax Cassandra, Nodetool, Devcenter, Jmeter, Python, Cassandra Loader

Container-orchestration – Kubernetes, Docker

Middleware – Tomcat, Jboss, Weblogic

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

COURSES AND CONTRIBUTIONS

GitHub: Contributions in open source Cassandra projects on Azure using Kubernetes.

https://github.com/suraj1287

SingleNode_Cassandra_Docker_Inbulit_Keyspacemulti-node-cassandra

cassandra_backup_restore_scripts

cassandra_data_persistence_Azure

ELK_Cassandra_Monitoring_Kibana

ELK_azure_kubernetes

Intro to Python for Machine Learning: Completed the online course from IIT Kanpur.

StackOverflow: Regular contributor in the community.

https://stackoverflow.com/story/suraj1287

PROFESSIONAL EXPERIENCE

Company Name: Wipro Limited, Mumbai – Aug 2019 to Present (1.2 years)

Designation: Senior Engineer

Roles and Responsibilities:

Senior Cassandra Database Administrator

HDFC net banking team uses Cassandra for the backend to support The RSA Identity Protection and Verification Suite offers one of the most complete and innovative portfolios of strong authentication and anti-fraud technologies and is engineered to protect organizations and their online users against the latest external threats. It is a complete Software-as-a-Service (SaaS) portfolio that is designed to increase activity in online and remote transactions, inspire user confidence, and reduce fraud losses and related costs. The RSA Identity Protection and Verification Suite leverage RSA’s expertise in fraud analysis, fraud forensics, and fraud modeling.

Working as Apache Cassandra 3.10 Admin – Architect, Managing multiple clusters with 50 plus nodes- in production, QA & Development

Install new Databases releases and related software tools evaluate in Dev, Test environments and eventually promote to production

Apply software patches & upgrades server software for the Cassandra database to stay in compliance with security standards and performance

Analyze and resolve complex technical problems including performance tuning and debugging

Monitor database backups and maintain automated disaster recovery procedure

Plan database and server level capacity according to statistics and user requests

Coaches and mentors’ junior resources in Cassandra best practices

Creating user, keyspace, tables and analyzing the tables and recommending indexes and best practices using Cassandra data modeling techniques

Automating multiple Cassandra activities like repairs, daily backups, etc using scripts & cron jobs

24*7 support to the production environments

Cassandra data modeling best practices- Keyspaces, Table, Index, etc best practices (NoSql)

Environment: Apache Cassandra 3.11, DevCenter, Cqlsh, OpsCenter, Node tool, UNIX, Cassandra-stress, Shell Scripting, Apache Tomcat

Company Name: Digite Infotech Pvt Ltd, Mumbai – July 2012 to Aug 2019 (7.2 Years)

Designation: Team Lead-Database

Roles and Responsibilities:

Data Lake Admin (Cassandra DBA), Oracle and SQL Server DBA

Worked in an agile team to design and develop data lake from scratch, this is Machine Learning based product to provide predictions in the Project Management domain.

Configuring CI/CD pipeline for deploying and testing Cassandra in a cluster on Azure cloud using Azure CLI as well as on-perm

Involved in capacity planning and requirements gathering for multi-datacenter Cassandra cluster.

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 Grafana tools for monitoring Cassandra Clusters.

Knowledge of 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 the latest releases.

Implementation of High Availability solutions with Oracle 12c, 11g RAC, 10g RAC, Standby Database (Active Data Guard)

Implemented and maintaining Database Audit and Security Policy & Procedures.

Managing and planning for patch installation and upgrade process.

Defining Backup and Recovery Strategies. The backup and recovery strategy included both physical and logical backup.

SQL Server Installation Backup/Restore, Database Mail, SQL Agent, SQL Up-gradation/Patching, Import/Export, Space Issues (Shrinking), Security.

High Availability options like Clustering, Log Shipping, Mirroring, Replication, and implement them as per the Customer requirements

Troubleshooting SQL Server Performance Issues, Optimizing the query performance, and SQL Server Replication Issues.

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

Company Name: Electracard Services Pvt ltd now Mastercard on behalf of Beltronic HR Consultancy Pvt Ltd, Mumbai – Feb 2011 to Apr 2012 (1.2 Years)

Designation: Application and Database Support

Roles and Responsibilities:

Oracle DBA & Application Support

Worked as a database & application support engineer.

Carrying out-migration activity on SBI and Associate ATM and Switching them from the BASE24 switch to the Electra switch.

Monitoring Acquiring and Issuing transactions of NFS.

Handled daily operational database activities based on requests.

Checking alert log files daily.

Database size Monitoring.

Installation of 10g database software

Database creation.

User management (creating and managing users, roles & privileges).

Space management (tablespace and datafile management).

Backup activities (physical and logical).

Providing support to the application team for Database related issues.

Basic Network troubleshooting.

Transferring data using Expdp/Impdp utilities.

Environment: Oracle 11g, Oracle 12c, Oracle SQL Developer, SQL Server 2012/2014/2016, Linux

EDUCATIONAL QUALIFICATIONS

Currently pursuing an MBA in Information Technology and Systems from D.Y. Patil University.

Bachelor’s in Computer Science from S.K. Somaiya College (Mumbai University) in 2008-09.

CERTIFICATIONS

Apache Cassandra™ 3.x Administrator Associate

Apache Cassandra™ 3.x Developer Associate

OCA (Oracle 10g Certified Associate)

OCP (Oracle 10g Certified Professional)

ITIL Foundation Certificate in IT Service Management from Axelos



Contact this candidate