Database Administrator Resume
PROFESSIONAL SUMMARY:
- Overall 6 years of IT experience in Administering, Installing, Configuring and Maintaining Linux and NoSQL clusters cassandra, mongodb, mssql
- Experience in planning Cloudera, designing, deploying, fine - tuning and administering hadoop using cloudera manager.
- Around 5 years of experience working on NoSQL Database cassandra.
- Strong experience in Ansible and Terraform, python, shell automations.
- Excellent experience in Datastax Enterprise versions 4.5 to 6.0 versions in a production environment, Installation, Configuration and Monitoring, Performance tuning, Backup and recovery, Deployment Experience, Capacity planning / Hardware sizing, Maintenance & Growth Architecture.
- Extensive knowledge of datacenter architecture, particularly multi-datacenter and global deployments for Disaster Recovery (DR).
- Exceptional troubleshooting and analytical experience in relation to enterprise level application server technologies. Experience in troubleshooting of Cassandra cluster problems like reads becoming slow, OOM errors, failure of JMX connections, ring differs, insufficient use of resource limit errors
- Experience in Datastax Enterprise and Opscenter to manage and monitor Cassandra Clusters, good experience of Cassandra Driver and performance tuning. Good understanding of Cassandra tools like Cassandra stress tool, SSTablescrub utility, SSTable upgrade tool.
- Good expertise in Cassandra Security concepts like client to node encryption, object permission management, ssl encryption, internal authentication and authorization.
- Good expertise understanding of Cassandra configurations of Cassandra.yaml file, gossip settings, heap dump directory, Virtual nodes, logging configurations.
- Good understanding of monitoring concepts for Cassandra cluster like node tool, Datastax opscenter, tuning bloom filters.
- Experience in Cassandra concepts like Data caching, Compression, adding or removing dead seed nodes or dead nodes and switching snitches, decommissioning datacenter or replacing running nodes.
- Expertise in Cassandra cluster data backup/recovery concepts like enabling restoring or taking snapshots, incremental backups.
- Experience in DRBD implementation.
- Managing the configuration of the cluster to meet the needs of data analysis whether I/O bound or CPU bound
- Experience in using full suite of infrastructure services like DHCP, PXE, DNS, KICKSTART and NFS Mount
- Strong troubleshooting and performance tuning skills.
- Basic knowledge in puppet, ansible automation.
TECHNICAL SKILLS:
Datastax Enterprise Package: 4.5,4.6,4.7,4.8,5.0,5.1,6.0
Datastax Enterprise Cassandra: 2.0, 2.1,3.0,3.11
Datastax opscenter: 4.0,5.0,5.1,5.2,6.0,6.4
Apache Cassandra: 2.1.15, 3.11
Cloudera manager: 5.15. 5.14. 4 , 5.13. 3, 5.12. 2, 5.11. 2, 5.10. 2, 5.9. 3, 5.8. 5, 5.7. 6.
Mongodb: 2.6,3.0,3.4
Big data: hadoop, oozie, pig, hive, map, reduce
Scrum software: Rally, jira
Languages and Technologies: Core Java, C, C++, Pyhon-2.7.6, python 3.6.6
Operating Systems: Windows, Linux & Unix
Scripting Languages: Shell scripting, python 2,3, Networking tcp/IP Protocol, Switches & Routers, OSI Architecture, HTTP, NTP & NFS
Databases: MySQL,NoSQL - Cassandra
IDE: Eclipse, visual studio, Datastax dev center
Automation: Terraform 0.9, ansible 2.9, puppet
PROFESSIONAL EXPERIENCE:
Database administrator
Confidential
Responsibilities:
- Automating maintenance and deployment tasks on cassandra clusters using ansible.
- Responsible for Cluster maintenance, Adding and removing cluster nodes, Cluster Monitoring and Troubleshooting, Manage and review data backups, Manage and review Hadoop log files.
- Installed Oozie workflow engine to run multiple Hive and Pig jobs which run independently with time and data availability.
- Continuous monitoring and managing the Hadoop cluster through Ganglia and Nagios.
- Upgraded the Cloudera hadoop ecosystems in the cluster using Cloudera distribution packages.
- Doing Installation, Configuration and Monitoring, Performance tuning, Backup and recovery scripts, and deployment of Datastax enterprise Cassandra clusters and mongodb with automation.
- Performing automation of tasks using python scripts.
- Monitoring all Cassandra clusters using Datadog gui based alerts and splunk logs and alerts.
- Suggesting and implementing minor and major upgrades of cassandra packages.
- Giving support for tickets opened by developers, resolving any Cassandra related issues if any during deployment of the applications and routine errors .
- Opening tickets for the production issues and deploying them.
- Attend daily scrum, and developer meetings.
- Daily Oncall, resolve any production alerts triggered.
Database Administrator
Confidential
Responsibilities:
- Done proof of concepts building end-end Cassandra, mongodb production and nonproduction clusters as per client requirements.
- Doing Installation, Configuration and Monitoring, Performance tuning, Backup and recovery, and deployment of Datastax enterprise Cassandra, mongodb clusters with automation.
- Performing automation of tasks as needed by the client.
- Building infrastructure as code by Terraform for aws and open stack.
- Monitoring all Cassandra clusters using Datastax opscenter and writing customized scripts which send emails to the team twice a day about all Cassandra clusters of all client projects.
- Suggesting and implementing minor and major upgrades of Datastax enterprise packages, when the client requests for it.
- Giving support for client production deployments, resolving any DSE Cassandra related issues if any during deployment of the applications.
- Opening tickets for the production issues.
- Enabling Datastax enterprise search and analytics on Cassandra clusters, when the client needed it.
Cassandra Subject Matter Expert and hadoop administrator
Confidential, NJ
Responsibilities:
- Designed and built Datastax enterprise Cassandra, spark clusters production and non-production clusters from scratch both in physical servers and cloud platforms.
- Responsible for building scalable distributed data solutions using Hadoop.
- Responsible for Cluster maintenance, Adding and removing cluster nodes, Cluster Monitoring and Troubleshooting, Manage and review data backups, Manage and review Hadoop log files.
- Continuous monitoring and managing the Hadoop cluster through Ganglia and Nagios.
- Installed Oozie workflow engine to run multiple Hive and Pig jobs which run independently with time and data availability.
- Performed major and minor upgrades for the cluster.
- Upgraded the Cloudera hadoop ecosystems in the cluster using Cloudera distribution packages.
- Performed Monitoring, performance tuning, backup and recovery of cluster data, and maintenance operations of the cluster.
- Writing automation scripts as required in installations and for customized checking.
- Deployed log stash, elastic search and DSE 5.0 non-production clusters in AWS using Terraform scripting.
- Installed software components with Ansible using Terraform output in AWS.
- Daily meetings with the team about issues, preparing status report and documentation.
- Resolved issues in the cluster that show up.
- Performing minor and major upgrades of DSE from 4.5 to 5.0
- Writing shell scripts for backups and monitoring script for the backup status.
- Researched alternative for Kafka-mirror maker and tested it for the architecture and provided results to the team.
- Automating aws cloud watch alerts by using Terraform for DSE clusters and other software components in the aws instances.
- Used Rally and Jira for reporting daily status and have daily scrum meetings.
- Automated installations using basic puppet scripting.
- Used puppet automation for different software components in the architecture along with DSE.
Cassandra Subject Matter Expert
Confidential, VA
Responsibilities:
- Done proof of concepts building end-end Cassandra production and nonproduction clusters as per client requirements.
- Doing Installation, Configuration and Monitoring, Performance tuning, Backup and recovery, and Deployment of Datastax enterprise Cassandra clusters.
- Monitoring all Cassandra clusters using Datastax opscenter and written customized scripts which send emails to the team twice a day about all Cassandra clusters of all client projects.
- Suggesting and implementing minor and major upgrades of Datastax enterprise packages, when the client requests for it.
- Contact puppet team, if Cassandra installation on new servers is requested.
- Giving support for client production deployments, resolving any DSE Cassandra related issues if any during deployment of the applications.
- Enabling Datastax enterprise search and analytics on Cassandra clusters, when a client requests it.
- Opening Tickets and work with the Datastax support team, when issues related to Datastax enterprise packages show up.
- Started implementing dse solr, configuring it, enabled it from dse enterprise package and configuring global filter cache and multi-threaded queries, securing dse search cluster.
- Report weekly status and prepare documentation.
- Done benchmark testing for selecting hardware configurations for servers for the client Cassandra clusters and done analysis of the results and prepared a report for submitting to the client management for the final decision.
- Giving support to the development team like user related issues and giving them a million records of sample data from clusters for the quality check tests, in non-production clusters.
- Attended daily scrum calls with team and client discussing issues and performance related issues.
- Troubleshooting DSE cluster issues.
- Implemented first Customized NetBackup and restore for client data based on client requirements.
- Performing specific record restore and full data restore to clusters based on development team requests when accidental deletes happen in cluster data.
Cassandra Subject Matter Expert
Confidential
Responsibilities:
- Installation and administration of RHEL 4.0/5.0/6.0.
- Configured kickstart server and updating/applying patches to the servers using Red hat Satellite server.
- Remote system administration using tools like SSH, Telnet, and Rlogin.
- Performed capacity analysis, monitored and controlled disk space usage on systems.
- Monitored system activities and fine-tuned system parameters and configurations to optimize performance and ensure security of systems.
- Responsible for maintenance of development tools and utilities and to maintain shell automation Scripts.
- Fine tuning of Servers and configuring networks for optimum performance.
- Setting up network environments using TCP/IP, NIS, NFS, DNS, SNMP agents, DHCP and Proxy.
