Your Name

• Working on DSE and Apache Cassandra cluster - Production support for Tier 1 applications,operations  & Development 
• Upgradation of DSE cluster from 4.8.x to 5.0.x and 5.1.x using manual and ansible scripts.
• Installation , upgradation of Apache cluster using ansible playbooks
• Automating DDL deployment using Ansible
• Log aggregation using python scripts 
• Building automation framework - Installation, Up gradation of DSE & Apache Cassandra clusters using Ansible
• Working on DSE Search - Solr and analytics-DSE  Spark
• Install new Database releases and related software tools evaluate in Dev , Test environments and eventually promote to production
• Apply software patches & upgrades server software for Cassandra database to stay in compliance with security standards and performance.
• Analyse 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 analysing the tables and recommending Indexes and best practices using Cassandra data modeling techniques.
  
  

• Working as Apache Cassandra 3.10 Admin - Architect , Managing multiple clusters with 100's of nodes -in production, QA & Development
• Building the cassandra nodes  using AWS & setting up the cassandra cluster using Ansible automation tools
• Configuring & Setting up the environment using multiple tools- Ansible,Zabbix,Splunk,Ruby, shell scripts
• Building & scheduling daily cassandra health reports using Splunk queries.
• Setting up monitoring tools using Zabbix, Splunk,Cloudwatch
• Automating multiple cassandra activities like repairs,daily backups etc using shell/Ruby scripts & cron jobs.
• Building alert setup-nodedown alerts  ,Weekly capacity reports- etc using shell
• Installing & configuring Janusgraph & Elastic search for Application developers to connect to Cassandra.
• Building Janusgraph and Elastic search cluster and connecting to Cassandra as a back end.
• Alert setup on Cassandra , Janusgraph and Elastic search using AWS cloud watch, Shell scripts
• 24*7 support to the prod environments.
• Cassandra data modeling best practices- Keyspace, Table, Index,Materialized views etc-  best practices(Nosql)
• Creating & maintaining users,roles,access.

      Datastax Cassandra Admin/Architect

• Working as Cassandra Admin/Architect (Datastax DSE--NoSQL DB) on 30 node prod and QA DR cluster.
• Cassandra Cluster planning which includes Data sizing estimation, and identify hardware requirements based on the estimated data size and transaction volume
• Designing ,creating ,Running and monitoring spark job on cassandra cluster for validation , loading from Teradata/Oracle RDBMS
  
• Working closely with Application team to resolve issues related to spark, cql and loading issues etc
• Working closely with Talena team for DR plan, on Prod QA cluster.
  
• Analyze Solr indexing requirements and evaluate the impact to overall system.
• Datastax Enterprise 4.8 Installations & multi data center DSE Cluster Set up on multiple environments with solr & spark enabled.
• cql queries to support integration with Cassandra cluster.
• Documentation of Design Documents, Data dictionaries, Implementations, Operational strategies, standards and policies.
• Administration ,Maintenance and Supporting of the cluster using Opscenter,Devcenter,Linux, Spark,Nodetool etc.
• Data migration from Teradata to Cassandra using Terdata Fexport & Cassandra loader.Installing, configuring Cassandra on AWS platform.
• Working on Opscenter(monitoring),Devcenter,Nodetool,Spark.Validating data using Spark.
• In memory data comparison between Teradata and Cassandra using Spark.Resolving spark validation issues, creating solr and secondary indexes for faster response and Tuning.
• Cassandra Data modelling,NoSql Architecture, DSE Cassandra Database administration- Keyspace creation,Table creation, Secondary and Solr index creation,User creation &access administration.
• Working closely with Datastax to resolve issues on cluster using ticketing mechanism.Nodetool repair, Compaction,Secondary index issues resolution.
• Query tuning & performance tuning on cluster& suggesting best practice for developers.
• Automation and configuration using Chef tool.
  
• Working closely with Cassandra loading activity on history load and incremental loads from Teradata and Oracle Databases and resolving loading issues and tuning the loader for optimal performance.
• Working closely with Datastax support Team to resolve user query , loader and spark query issues.
• Working on agile management to track the project using Rally. 

      BigData Consultant

• Working on bigdata Technologies as Admin- Hadoop, MR, Pig,Hive,Hawq, Greenplum
• Working on oozie,Sqoop,Flume, Spark streaming.
• Working on Migrating data from Teradata to BD technologies-Hortonworks,Hawq,Hive,Greenplum DBs & Cassandra.
• Working on Horton works Hadoop Distribution-Abbari,Zeppline,Spark.
• Query monitoring using PCC- Pivotal command center Working on Pivotal Technologies on Big data, HAWQ- Query tuning.
• Working on Greenplum Database-Query tuning,Monitoring using GCC.
• Working on Maintaining and configuring Haddop Cluster.

      Teradata DBA

• Providing L3 Support to Mission critical Applications at GE Aviation.
• Query Tuning, Performance tuning Working closely with GCC Teradata for critical fixes on critical applications Helping the Developers to resolve issues on the query and helping them to tune the query for optimal performance.
• TASM Optimization for new and old workloads,based on user issues.
• Attending code review meeting to obtain Industry standard codes.
• Resolving Incidents on Teradata issues in different platforms and Applications.
• Helping the Application teams to resolve their critical issues related to Teratata Performance / code performance/ and end to end resolutions.
• Working closely with offshore DBA's , attending calls daily on the progress / status of work.
• Working on data mover , for disaster recovery platforms Backup recovery Capacity planning, CPPT report generation, Resolving Teradata production issues.
• Working closely with Application team to resolve production issues.Working on migrating data from Teradata to Bigdata environments-Greenplum,HAWQ,Hortonworks-Hadoop, Hive,NoSQL Databases-DSE Cassandra.
• Resolving issues and performance issues during Migration and Optimizing Exportingdata,Work loads(TASM) within Teradata.
  

• Monitoring database using Teradata Viewpoint, Performance Tuning, Administrating, supporting etc using Teradata 13 Tools and utilities and monitor and maintain TASM settings.
• Production implementation using ITSM,User request management using EURC, On call support ticketing using Peregrine tool Monitor incident ticket queue and troubleshoot and resolve database incidents within SLAs amp; 24*7 on call supporting the environment on rotation basis.
• Worked on DATAMOVER ­ Create job, copy data, troubleshoot.
• Worked on Unity Director Monitor backup results using Teragui and resolve/troubleshoot failed database backups Monitor storage capacity and consumption, trend long term usage.
• Granting & Revoking of Object Rights, System Rights on Databases / Users / Roles.
• Monitoring of Sessions, Nodes, Vproc Information and aborting the rouge queries in the system using Performance Monitor.
• Space management including PERM, TEMP and SPOOL space for the users and databases.
• Calculating the capacity and forecast the space proactively.
• Saved over 1 TB of space by revisiting compression.
• Work with ETL developers in load related issues like releasing utility Locks, granting missing privileges.
• Releasing HUT locks using show locks utility Executing change requests for DDL & DML statements from the ETL and BI users Improving the table access by collecting statistics, compress multi values, define PPI as per the access patterns.
  

• Working on a Teradata System over 25 Terabytes.
• Interact with Logical Modelers/Business Analysts/Data Analysts/Technical Leads to understand the requirements and thereby providing better project deliveries.
• Manage and monitor TD databases using Teradata Manager & Teradata Administrator.
• Creating and modifying Teradata objects like Databases, Users, Profiles, Roles, Tables, Views, Indexes, Macros, and sand Stored Procedures etc.
• Using the DBQL and Access Log to monitor the database log.
• Physical database modeling and implementation using Erwin Model.(LDM PDM conversion) Using Teradata Explain, PMON to analyze and improve query performance.
• Identified the stale database objects and decommission by communicating with the business.
• System monitoring using PMON, VIEW POINT & TD Manager Aborting long running sessions using View point.
• Worked on TASM ­ Analysis and implementation of TASM Worked on Teradata MVC tools.
• Ussr management using roles & profiles Monitoring the system 24 * 7 support basis.
• User/DB creation , managing security, privileges& Tuning the queries.
  

• Working as a Production Support and Development DBA in Large warehousing environment.
• Monitoring system using PMON, TD MANAGER & VIEW POINT (TD 12 & 13) Migrating TD 12 TD Manager & PMON alerts to VIEW POINT 13.
• Taking Net vault (Bar backup) backup and restore from Prod to Dev & vice versa.
• Creating Objects- tables/views from PDM (Physical Data Model).
• Query Tuning using Explain plan and Visual Explain Deploying the Development work from Dev Teradata Box to Production.
• Resolving different types of issues related to Teradata Loading Data from PROD to DEV using OLE LOAD utility for SIT/UAT Creating Different environments in DEV (SIT/UAT) for testing purpose.
• Extracting collects stats/Objects information from Dev using TSET(Teradata System Emulation Tool) Capacity planning document creation on database level for deployment in production.
• Helping Developers in Query tuning, Access issues etc.
• Creating the backup strategy for Database level and table levels Involved in Analysis and design phase of the project.
• Choosing identity columns/Compression columns/Stats columns based on the analysis on production and Business inputs.
• Worked on MVC (Multi Value Compression) to choose the right candidate for Compression using built in tool and executing with sample and production data and analyzing the o/p
• Choosing the collect stats column using statistics and index wizard tool.
• Editing LDM-PDM based on the changes made during the execution of the project.
• Using Rev/Fwd engineering (Erwin) to create the DDL to run it in Dev environment.
• Worked on TPT (Teradata Parallel transporter) for loading data.
• Managing BAR using Net vault Running pack disk/scan disk/check table utility to perform System support.
  

• Handling the Teradata Production system(4 TB) Manthan Product Support on Teradata(ARC-Retail Product) Extracting data from production to development using Fast export-Mload utilities Closely working with product development team and resolving Teradata related Issues.
• Writing, Tuning TD Macros for daily, Weekly, Monthly Loads.
• Scheduling macros for incremental load.
• Tuning SQL's (Macros) for Optimum performance.
• Writing Fast load/Mload scripts for daily loads.
• Solving Access rights issues, checking the database Health, Space Issues and Spool errors.
• Creating User/DB based on the requirement.
• Capacity planning for Haggen TD Database.
• Working on Scheduling tool Microsoft's SSIS Package.
• Restarting Teradata for maintenance purposes.
• Creating SSIS Packages for ETL and scheduling the same.
• Extracting data from Sql Server,MS Access AS-400 DB's and loading into Teradata using SSIS packages and TD load utilities(Fast load and Multi load) and scheduling the same using SQL Server scheduling utility.
• Debugging and solving all Teradata related issues.
• Working onaccess logging and DBQL, Alert policies etc.
• Working ARC Utility for Backup and restore and scheduling the same.

• Working as a Teradata DBA in Teradata V2R6 on MP RAS UNIX- 12 Node system (12*2=24 TB) 5450 series m/c.
• Designing the database structure and allocating spaces to a fresh Teradata v2R6 Box.
• Creating users and giving them necessary privileges based on customer requirement.
• Implementing database structure and users.
• Designing the new structure after migration and meeting customers requirement.
• Checking the data distribution and perm, spool space etc for each table and database.
• Checking CPU and Disk I/o utilization.
• Using Teradata Manager and Teradata Administrator for different DBA activities.
• Export-Import objects from one Database to another using system emulation tool.
• Working on Visual explain, statistics wizard, Index Wizard for Tuning.
• Performance Monitoring(CPU,Disk Utilization using TD Manager) Taking backup using Net vault.
• Experience using Teradata Manager to monitor and manage Teradata database.
• Killing the long running queries and tuning the queries using explain plan and Visual explain.
• Tuning the queries using collect statistics and statistics vizard.
• Creating secondary indexes based on statistics collection using index vizard.
• Manage user access and implements/ensures security requirements are met.
• Design, creating and tuning physical database objects (tables, views, indexes) with Users developers' support.
• Moving space using administrator.
  

• Administration skills on DB2 UDB -Database backup and recovery and tuning the database for optimum performance.
• Worked on Migration, Data movement (Load/Import/Export), Backup/Restore/Roll forward/Crash recovery.
• Stress SVT- Understanding the functionality of new features of DB2 UDB.
• Testing the new features while putting lot of stress on the database (Executing DML/JDBC/XML Applications) Opening defects through Clear quest and delivering the codes through Clear case(Rational) Having good problem solving skills to hit the defect and analyzing the problem.
• Crashing the database by giving stress on the system and analyzing the problem.
• Interacting with developers in SVL (Silicon Valley, US) labs, Portland and Toronto labs.
• Handled XML core bucket (xmlstore) of DB2 UDB v9.

• Handling Production, Development and Training Oracle 8I, 9I databases.
• Monitoring RMAN Backup scripts, Crontab files, editing the scripts Checking the automated mails sent by contraband resolving Priority 1 and 2 issues regarding different Databases and Ketera products.
• Recovery in case of DB crash.
• Tuning the DB using Utlbstat-Utlestat, Stats pack, using shell Scripts/Perl.
• Formatting data's and Bulk inserts using Transfer protocol or using Sql Loader.
• Helping D2k developers in complex coding and monitoring the Database performance.
• Taking Backups (Cold and Hot-User managed).