SUMMARY:

• 8 plus years of Professional work experience with 4 years of Cassandra and 4 years DB2 and Oracle database Administration.
• Setting up Cassandra and Apache Spark Cluster and Installing, setting up and configuring Cassandra Clusters.
• Developed Recovery Manager scripts for the database backup and disaster Recovery including HOT and COLD backup options for both RAC and standalone Instances.
• Good in Application Life Cycle Management (ALM).
• Good in Migrating the data from an existing Database.
• Good in AGILE SCRUM Methodology.
• Highly motivated, creative, fast learner and good communication skills.

TECHNICAL SKILLS:

Programming Languages: Java, C, C++, PL/SQL, Scala

Web Technologies: HTML, HTML5, CSS, XML, JavaScript, PHP, Joomla, Hadoop

Relational Databases: SQL Server, MySQL, JDBC, Oracle 9i,10g, DB2 LUW 9.7/10.5

NoSQL Databases: Apache Cassandra 1.1/1.2./2.1/3.0, DataStax 3.2/3.2/4.0/4.6/4.7/4.8/5.0/5.0

Scripting: Shell Scripting, Python, Ansible

Cloud Technologies: AWS, Google Cloud.

Tools: & IDEs: Visual Studio, Eclipse, Rational Rose, MySQL Workbench, Net Beans, Visual Basic, OpsCenter, DevCenter

Operating System: AIX, Sun Solaris, RedHat Linux, CentOS and Windows

Ticketing tools: JIRA, BMC Remedy

Agile tools: VersionOne

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Cassandra Consultant

Responsibilities:

• Worked with business users to define user requirements and business rules; ensured overall solutions met SLA (performance and up - time), DR, and scalability.
• Tuned Cassandra for efficient operation using multiple views into system metrics, including OS stats, GC logs, JMX, Opscenter, and cassandra-stress.
• Created and supported one Cassandra cluster with 48 nodes for the inventory purpose.
• Involved in the process of designing Cassandra Architecture.
• Designed and Automated the process of installation and configuration of secure DataStax Enterprise Cassandra cluster using puppet.
• Developed shell scripts along with setting up of CRON jobs in Jenkins for monitoring and automated data backup on Cassandra cluster.
• Responsible for availability and performance of online databases.
• Tuned the cluster to achieve maximum throughput and execution time based on the benchmarking results.
• Implemented DataStax Hadoop solution to integrate promotional data with enterprise Hadoop cluster.
• Implemented Spark solution to enable real time reports from Cassandra data.
• Performed Stress and Performance testing, benchmark on the cluster.
• Knowledge on bootstrapping, removing, replicating the nodes in Cassandra and Solr clusters.
• Migrated the data from one datacenter to another datacenter.
• Configured, Documented and Demonstrated inter node communication between Cassandra nodes and client using SSL encryption.
• Imported data from various resources to the Cassandra cluster using Java APIs.
• Working closely with DataStax to resolve issues on cluster using ticketing mechanism.
• Moved the Cassandra data from old cluster to new cluster on production and lower environments with minimal application downtime.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Involved in database deployments, capacity planning, monitoring multi datacenters, performance tuning, and troubleshooting.
• Knowledge on Google cloud compute engine and AWS instances.
• Excellent knowledge on Cassandra Architecture, Read/Write Paths, CQL Data Modelling, Replication Strategies and Consistency Levels.
• Experience in implementing security, control, integrity and accessibility of the data.

Big Data Consultant

Responsibilities:

• Design a solution to load existing data from MS Sql Server to Apache Cassandra.
• Designed Cassandra data model for single sign on application.
• Responsible for availability and performance of CXP (Covalent Xtreme Performance), SSO (SingleSignOn), Cassandra shared Prod and lower environments.
• Enabled spark on Separate datacenter on CXP cluster to run data analytics on Cassandra data.
• Performed backup and recovery on Cassandra nodes.
• Performed node tool repair to make data on nodes inconsistent.
• Performed Tuned Cassandra cluster.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Configured accordingly to achieve maximum throughput and execution time based on the bench marking results.
• Have knowledge on deploying DataStax enterprise on Google Cloud and Amazon cloud services.
• Involved in the process of data mover for disaster recovery platforms Backup and recovery.
• Performed cleanup operations on Cassandra nodes.
• Performed Cassandra Cluster Rolling upgrades.
• Knowledge on set up Cassandra wide monitoring scripts and alerting system.

Database Administrator

Responsibilities:

• Managing multiple Production and Development DB2 LUW Applications environments of different releases.
• Worked as a Production/Development DBA in Installation, configuration, maintenance and tuning on Oracle11g and 10g on IBM-AIX 6.1.
• Database server Installation, Database Creation, Maintenance, Backup, Recovery & Performance Tuning.
• Migration of UDB databases from 8.x to 10.1.
• Migration of Oracle databases from 9.2.0.7 to 10g (10.1.0.4).
• Involved in creating logical data models for various applications using Erwin.
• Converted logical models into physical models.
• SQL tuning and Database performance tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitored the database performance on daily basics.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Implementation of high availability and disaster recovery of databases through DB2 HADR in production environment.

Database Administrator (IBM DB2-LUW, Oracle on AIX) in Database Management Support Services group for member portal Applications.

Developer (Java, DB2 9.1, Oracle 10g)

Responsibilities:

• Requirement gathering, analysis and estimation.
• Implemented upload functionality using java.
• Developing, Testing and Implementing Sound backup and Recovery Strategy.
• Involved in Data Modelling (Creating data dictionary, Logical Data Model and Physical Data Model).
• Installed and configured Oracle RDBMS on UNIX and Windows environments.
• Wrote shell script to invoke Java implementation.
• Implemented password encryption /description using AES Algorithm.
• Implemented log4 for logging.
• Wrote unit test cases using Junit.
• Developing SQL scripts to monitor table space and extent growth.
• Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth rate.
• Partitioning tables by determining the suitable methodology to improve performance and manageability.

Oracle 9i/10g, java, Solaris 2.9 / 2.10, Red Hat Linux AS/EL 4.0, AIX 5.2, 5.3, Sun E10k, SQL, SQL * Loader, Exp/Imp, RMAN.