SUMMARY

• Over 8+ years of experience in IT industry as an Cassandra DBA and Oracle DBA working for various organizations.
• Having over 4+ years of DBA experience in MongoDB, Apache Cassandra & DataStax Enterprise edition installation, configuration, backup configuration, upgrade, node tool commands, bootstrapping, performance tuning, decommissioning, migration etc.
• Over 3 years of experience on Oracle 10g/11g database planning, installation, upgrade and migrations, performance tuning, backup, recovery, security provisioning, data guard, golden gate etc. on production, staging, development environments, understanding ITIL guidelines.
• Good knowledge on tools like Kafka, Apache Spark.
• Good experience in Designing, Planning, Administering, Installation, Configuring, Troubleshooting, Performance monitoring of Cassandra Cluster.
• Involved in designing various stages of migrating data from RDBMS to Cassandra.
• Used DataStax OpsCenter and Node tool utilities to monitor the cluster.
• Have Knowledge on Apache Spark with Cassandra.
• Experience of doing Casandra upgrades to Major & latest versions.
• Expertise in AWS, experience in implementing new AWS EC2 instances and working with EBS and S3 storage.
• Managed Amazon Web Services like EC2, S3 bucket, RDS, EBS, ELB, Auto - Scaling, AMI, IAM through AWS Console and API Integration with Puppet Code.
• Back-end programming, database Triggers, stored procedures and functions using PL/SQL.
• Good knowledge on integrating Cassandra with Hadoop.
• Good knowledge on Spark SQL, Spark Streaming and Scala.

TECHNICAL SKILLS

Programming Languages: Java, C, PL/SQL, Python, XML, HTML5, PHP, Java Script, Shell Scripting.

Databases: Apache Cassandra, DSE, MySQL, MongoDB, DynamoDB, Oracle, SQL Server.

BigData Technologies: HDFS, MapReduce, YARN, Spark, Hive, Sqoop, Flume, Oozie, Zookeeper, Kafka, Impala, Apache Solr, Ambari.

Tools: and Utilities: OpsCenter, DevCenter, Maven, Log4j, EclipseJenkins, Tableau, Jira, Putty, Winscp, Toad, SQL Developer, VMware, Vnc-Viewer, DBCAADDM, RMAN, AWR, FileZilla, OEM

Cloud Infrastructure: AWS (S3, EC2, EMR), Google Cloud Platform.

Version Control Systems: GitHub, SVN.

Protocols: HTTP, HTTPS, FTP, TCP/IP, SOAP, REST.

Operating Systems: Linux, Windows 2000/NT/XP/7/8/10, Unix.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Cassandra Consultant

Responsibilities:

• Responsible for online availability and performance of Cassandra database ( Confidential .com, Confidential .com)
• Created 64 node Cassandra cluster for pricing application in DSE 5.1.4 for both Confidential .com and Confidential .com.
• Implemented Spark solution to enable real time reports from Cassandra data.
• Upgraded all Cassandra nodes across all platforms from DSE 4.8.12 to DSE 5.0.11
• Created scripts which could automate repairs,SStableloader, snapshots.
• Understanding of data architecture, ETL and processing of structured and unstructured data and build CQLs as per the requirements.
• Implemented DataStax Hadoop solution to integrate data with enterprise Hadoop cluster.
• Designed and implemented Spark cluster to analyze data in Cassandra.
• Perform capacity planning related activities on database storage and performance.
• Used Ansible scripts for Cassandra automation
• Used OpsCenter as a monitoring tool for Cassandra.
• Imported data from various resources to the Cassandra cluster using Java APIs.
• Configured Performance Tuning and Monitoring for Cassandra Read and Write processes for fast I/O operations and low latency time.
• Configured, Documented and Demonstrated inter node communication between Cassandra nodes and client using SSL encryption.
• Worked on applying updates and maintenance patches for the existing clusters.
• Design, implementation and maintenance of Hadoop/Big Data infrastructure and clusters.
• Implemented Hadoop eco-system that includes Hive, Sqoop, HBase, Zookeeper, Oozie, Flume, Yarn, MapReduce.
• Worked on implementing large-scale Spark cluster for distributed dataprocessing and analysis.
• Involved in Implementation of DataStax Spark data processing project to handle data from various RDBMS, Cassandra and other streaming sources.

Confidential, Chicago, IL

Cassandra Consultant

Responsibilities:

• Responsible for availability and performance of online databases (Sears.com, Kmart.com and Mygofer.com).
• Involved in designing Cassandra data model for cart and checkout flow.
• Moved cart data from DB2 to Cassandra.
• Created 48 node Cassandra cluster for Single Point Inventory application in Apache 1.2.5.
• Upgraded Single Point Inventory (SPI) 48 node cluster from Apache 1.2.5 to DSE-3.2.7.
• Upgraded mobile checkout(UC) cluster from Apache Cassandra1.1 to DSE 3.2.7
• Implemented dual data center set up for all Cassandra cluster.
• Implemented Snapshot backups for all Cassandra clusters.
• Implemented DSE SOLR solution to push incremental orders data into centralized Hadoop cluster.
• Implemented DataStax Hadoop solution to integrate promotional data with enterprise Hadoop cluster.
• Implemented Spark solution to enable real time reports from Cassandra data.
• Created Mongo cluster with 4 shares and 3 replica sets for GameOn and GreenDB projects
• Involved in data modeling for IAS and UC Cassandra Clusters.
• Perform capacity planning related activities on database storage and performance.
• Provided support for Cassandra/MongoDB and DB2 LUW databases in OBU.
• Verifiable record for achievement of Exceeding Expectations, as a Database Administrator.

Database Administrator

Responsibilities:

• Managing multiple Production and Development DB2 LUW Applications environments of different releases.
• Database server Installation, Database Creation, Maintenance, Backup, Recovery & Performance Tuning
• Migration of UDB database from 9.5 to 9.7.
• 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.
• Implementation of high availability and disaster recovery of databases through DB2 HADR in production environment
• Developing shell scripts for database monitoring and maintenance.
• Research and resolve database issues.
• Design and implement required processes to ensure ongoing Audit/SOX compliance for databases.
• Performing certifications for new RDBMS features and new versions
• Verifiable record for achievement of Exceeding Expectations, as a Database Administrator.

Confidential

Oracle DBA

Responsibilities:

• Involved in performing health checks on Oracle database and monitoring database, listener services and other jobs.
• Extensively gained knowledge and understanding of UNIX Operating systems & ability to drill down databaseperformance issues using OS commands/tools for identifying CPU/Memory/IO usage and bottlenecks.
• Coordinating with Oracle support for logging tar and knowledge-based search to find solution to the problems that are occurring in the live server and while applying patches (tar, Bug search, and User forum participation).
• Working on Oracle 11g and 10g databases which are on windows, HP- UX, Linux platforms.
• Implementation of automation scripts for monitoring databases.
• Created RAC and non-RAC databases using DBCA and manual scripts.
• Managing the Oracle cluster ware using: CRSCTL, OCRCONFIG utilities and managing RAC instances using SRVCTL.
• Refreshing database schema by using exp/imp and expdp/impdp parameters and configuring parfile for regular schema refresh.
• Configured RMAN backups in catalog and nocatalog mode for the database and scheduling backup jobs for the database using crontab and tested backup and recovery using RMAN.
• Implemented Certificate in Oracle Database using Oracle OWM and orapki utility.
• Managing Tablespace sizes by altering datafiles and managing control files and Redo log files.
• Performed database cloning in various methods using RMAN, hot backup, cold backup and expdp/imp dp utilities
• Regular checking of trace, alert log file, all ORA errors and trace users using OEM.
• Checking Tablespaces and allocate space to Tablespaces time to time when needed- addition & resizing of datafiles.
• Regular maintenance viz., archives monitoring, deleting backed up archives, deleting old core files, cleaning up old trace and log files.
• Deployment of scripts on the Development and Production databases.
• Worked on performance tuning at the database level and SQL and PL/SQL tuning.
• Generating AWR and ADDM reports for the check of database health and performing activities to increase the performance of the database.
• Excellent troubleshooting skills (researching issues in oracle metalink, logging SR and working with oracle support, escalation of issues if need).
• Worked on documentation part for various processes of projects, also prepared Clones, Patching.
• Worked in production environment and provided on-call and day-to-day support
• Worked on Incident Management tool named as Advanced Help Desk
• 24*7 support of database.