Cassandra DBA
Resume:
VENKATA RAVI GUDURU
https://www.linkedin.com/in/venkata-ravi-guduru-940bb344/
(****.******@*****.***)
CAREER SUMMARY
Experienced IT Professional with 15+ years of Application Software Development, lead developer and
Oracle Database Administration experience comprising of Oracle 12c &11g Installation and configuration on Linux & Solaris Platform. Experienced in Performance & Tuning, Advanced replication Setup & Oracle Streams, Shareplex, Oracle Upgrade & Migration, Patch Installations, Exadata and 24 x 7 Production support – on-site & remotely and 2+ Years of experience working on Cassandra and AWS.
TECHNICAL SUMMARY
Databases: Cassandra-2.1, Oracle Versions -12c/11g/10g.
Oracle Products: Oracle RAC, RMAN, OEM, Grid Control, Replication, Oracle Streams, Data Guard, Exa-Data/Super-Cluster, SQL* Loader, Export/Import, data pump, CDC, AQ, 10046 Trace Event, oradebug, RDA, AWR and ADDM.
Languages: SQL, PL/SQL. Shell Scripting, Python.
Replication: Shareplex, Streams, CDC.
Operating System: SUSE Linux, Redhat Linux, Sun Solaris, AIX.
Tools: TOAD, OEM, OPSCENTER.
SKILL SUMMARY
Implemented and managed hands-on Oracle based technical solutions in the following areas:
Cassandra Database: Installation & Configuration: Cassandra 2.1 with Installation, configuring and monitoring DataStax Enterprise cluster, 90 nodes 3 DC’s.
Oracle Database: Installation & Configuration: Oracle 12c/11g Installation for RAC and single node Installation. Patches installation & DB upgrade, Migration 11g to 12c on EXADATA/SC.
Backup & Restore: Implemented robust hot backup strategies using Oracle’s RMAN technology, Planned and coordinated DR drills to ZFS (EXADATA/SC). Logical backup using ‘export’ and recovered using ‘import’ features for object level recovery. Flashback of databases using (guaranteed) restore point. Backup & restore using datapump.
Disaster Recovery & High Availability: Implemented DR Solution using Oracle ‘Data Guard’ did planned switch-over while setting up DR solution for Production boxes and Maintenance.
Performance Tuning: Detecting and diagnosing production system performance problem by Analyzing Oracle trace file, analyzing SQL statements, querying Oracle dynamic data dictionary views; pin plans, SQL statement tuning for OLTP & data warehouse using TKPROF, SQL Trace and EXPLAIN PLAN tools. Generating & Analyzing AWR & ADDM reports. Enhance performance by Table partitioning for large tables.
Replication: Shareplex, Streams, CDC.
Production Support: Providing 24x7 on-site and remote DBA support.
Brain Bench Certified in C language.
Certification Date: Aug 1999 – Aug 2000
Verizon Wireless, Piscataway, NJ May 2015 - Till Date
MTS-IV- Sys-Eng/MTS-III- Sys-Eng Cassandra DBA
Involved in Cassandra Architecture, Cassandra data modelling & experience in installation, configuration and monitoring Multiple DataStax Enterprise Cassandra cluster (B2B & B2C). Worked with Datastax Support team in implementing patches/Upgrades.
Involved in supporting Multiple production Cassandra Clusters with 300 Nodes, 400TB of data across two Clusters: B2C 180 Nodes & B2B 120 Nodes.
Involved in end to end data modeling from RDBMS (IBM-DB2) to Cassandra and actively worked on designing data migration process from DB2 to Cassandra for Read and Write activities.
Actively involved in working with Development and Operations team’s in migrate API’s from IBM-DB2 to Cassandra which resulted in significant cost saving to organization.
Involved in evaluating and setting up Cassandra Databases on AWS and baremetal systems for non-production environment.
Lead automation effort in maintaining 300 Nodes Production Cassandra clusters for (Start/Stop/ Upgrade/Repair/Compaction/Monitoring) and worked on User defined compaction to release tombstones in Cassandra.
Lead end to end production monitoring, notification setup for Cassandra Clusters using OpsCenter, Node tool utilities, Shell Scripting and Python. Actively worked on troubleshooting hardware ware failures; analyzing disk failures, Memory Leak. etc
Involved in troubleshooting Cassandra performance related issues by analyzing various metrics available from OpsCenter & Custom Shell Scripts (Read Request Latency, Write Request Latency, Cfstats, TPstats, netstats, Dstats)
Actively Involved in expanding clusters like adding New Datacenter’s to existing clusters, Node addition and removing Dead Nodes.
Involved in 180 Node cluster upgrades from 4.8.9 to 4.8.14 to resolve significant SStable corruption issues and automating corruption clean up using (Offline Scrub and Online Scrub).
Actively Work with Development team and Operation team during crisis time to minimize customer impact and verifying the data consistency across all datacenter using CQL (Cassandra Query Language). Create new Colum Family’s as per application migration requirements
Support Iconic Launch (IPhone/Samsung Launch) schedules. 24*7 Production support & On-call Support
Experience in benchmarking Cassandra Cluster using Cassandra stress tool.
Verizon Wireless, Warren, NJ Aug 2011 – May 2015
MTS-III- Sys-Eng; Oracle DBA
Involved in end-to-end migration & Consolidation of Mobile Content Solutions databases from M8000 standalone database (~60TB) to Oracle Engineered solutions (2 Racks 8- Node RAC, 12 Storage cells) with minimal downtime.
Involved in setting up Exadata Half Rack setup using One Command configuration, maintaining and troubleshooting Exadata Cell disk/Grid Disks.
Executed and review Exacheck results and implement necessary fixes. Work with Oracle Platinum Support team to seamlessly install Quarterly patches.
Troubleshooting shoot SQL queries to optimally use Exadata smart scan/offloading features.
Installed and configured Shareplex replication between multiple datacenters, setup and implement Oracle Change Data Capture (CDC), Oracle AQ/DQ to provide high availability.
Involved in overall Application performance optimization by reviewing SQL Execution plans, PL-SQL procedures/packages.
Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain table spaces, creation and maintenance of tables, partition tables and indexes Stats Collection. Scheduled Jobs for auto drop partitions.
Performance monitoring and tuning up of the Database using ASH, AWR, ADDM and Setup Database monitoring by setting up Shell Scripts/ OEM
Involved in maintaining IBM Change Data Capture like creating Subscriptions, add/drop tables from subscriptions
Created Users, Roles, Privileges, Profiles, managing security, analyzing and monitoring the system performance and tune accordingly.
Involved in database Export/Import and performing backups using RMAN.
Support Organizational enterprise release.
Verizon Wireless, Warren, NJ Aug 2006 – Aug 2011
MTS-III; Production Support(Operations)
Analyzing and proactively managing problems and making decisions.
Validations script to enhance MCS / VISION Grid data compares and Recon and optimized various Oracle Database Objects such as, user defined functions and PL-SQL procedures, Data Import/Export, triggers and packages using Explain plan and hints and various sqlloader control files were written.
Incident Reporting into JIRA ticketing system and providing necessary analysis for bug fixes and adhering to published procedures and maintain support knowledge base and documentation and contribute to team's increased ability to serve business.
Worked with Analyst/business users, Dev team, Infrastructure team (Hardware and capacity planning) within MCS for resolving production bugs, optimizing and tuning reporting Queries.
Participated in UAT/training sessions to educate business users about new release functionalities.
Used Oracle CDC Replication feature to set up replication from database to grid.
Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
Planning, sizing, scheduling including implementation activities for the Operations/Production Support team and closely with Development, Infrastructure, DBA, Middleware and Analyst teams.
Providing on-fly solutions to make database healthy and keep running during Change Control and Enterprise release.
24x7 production environment and provided on-call and day-to-day support.
Environment: Oracle 10g/11g, Solaris 11, SuperCluster/ExaData, Red Hat Enterprise Linux 4, Cassandra 2.1, AWS EC2, Maria DB 10.1, DevCenter, Cqlsh, OpsCenter, Nodetool, ASM, HP-UX11, Shareplex, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, PL/SQL, Data Pump, Putty, SQLT, Sun Solaris 5.10.
Paragon Solutions Inc / AT & T, Bedminster,NJ Aug 2005–Aug 2006
Ad Hoc Analyst Developer/Sr. Analyst
Responsibilities:
Involved in designed and implemented a Metadata Marketing Database (MDB) Repository providing a centralized information source for data models, data maps, processes, documents, contact lists and issues affecting the AT & T/ SBC merger.
Migrated database from Non-ASM to ASM, non-RAC to RAC etc.
Cloning Database for prod parallel env with minimal downtime using DR Solutions and in sync with GG. Database refresh/Clone using RMAN.
Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, sql profiles, sql plan baselines, SQL Advisors, Performance Manager, and Stats pack.
To provide standard reports and AD HOC query capability to Web based front-end and developed end-to-end system, including other databases data extraction and loading, standard report development using PL/SQL Stored Procedures, triggers, packages and data security.
Unix Shell scripting for automating backup and recovery, Import and export procedure of databases, getting system alerts.
SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
24x7 production environment and provided on-call and day-to-day support.
Environment: Oracle 10g/11g, RAC, Shareplex, OEM (Grid Control), Data Pump, Putty, Sun Solaris 5.10,
Edge Technologies, Inc / PJM Interconnection Inc, Norristown, PA Dec2002 – May 2005
Lead Developer/Sr. Analyst
Responsibilities:
Generated SQL and PL/SQL scripts to install, create and drop Market Settlements & Operations database objects including: tables, views, primary keys, indexes, constraints, packages, sequences, replication (materialized views) grants and synonyms.
Respond to user requests for ad hoc queries and ad hoc reports, generated SQL and PL/SQL stored packages with Oracle's Web Toolkit for creation of menus, security and data load pieces.
Assisting test teams for designing and executing test cases and test plans.
Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer (CBO), SQL analyzer, sql profiles, sql plan baselines, SQL Advisors, Performance Manager, and Stats pack. Implemented interval partition.
Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
Unix Shell scripting for automating backup and recovery, Import and export procedure of databases, getting system alerts.
SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
Leading the build and implementation of high volume fast track data bridges using PL/SQL, C, Pro*C, UNIX Shells, Perl, XML.
Environment: Oracle 10g/11g, RAC, Shareplex, OEM (Grid Control), Data Pump, Putty, Sun Solaris 5.10,
Edge Technologies, Inc / Honeywell (Allied Signal Inc.), NJ Jul 2001 – Nov 2002
Sr. Programmer Analyst
Responsibilities:
Over a million end users have utilized the custom client/server HSER metrics Application design and development using PL/SQL Stored Procedures, packages, triggers, Pro*C, JavaScript, HTML, Netscape Live Wire and Netscape Enterprise Server.
Manage and implement requirements for custom extension and integration with external warehouse data maintenance, time-entry and other systems. Wrote ETL process using Orchestrate scripts.
Designed and developed ETL process using Orchestrate scripts.
Development, documentation and training of technical quality assurance standards and code review procedures. Evaluating PL/SQL procedures, sqls before golive.
Write scripts for creation of users, creation and assignment of roles, analyze space requirements and maintain table spaces, creation and maintenance of tables, partition tables and indexes Stats Collection. Implemented scheduled Jobs for auto drop partitions.
Hands on experience working with Oracle Database Administration.
Environment: Oracle 8i/9i, SQL, PL/SQL, Pro*C, UNIX Shell Script, Perl, SQL Loader, Export/Import, Excel, Access, Oracle Analyzer, Orchestrate scripts.
Edge Technologies, Inc / Telecordia Technologies, Piscataway NJ Jul 2000 – Jun 2001
Sr. Programmer Analyst
Responsibilities:
Designed & Developed Stored Procedure and Triggers for allocation and reservation of equipment for connections, effectively handling both high rates and high complexity of service orders.
Developed tool like Shell Script, PERL, AWK, PL/SQL Procedure for activating, changing, removing connections, test the connections and repairing faults. Supported rapid evolution of services and/or their technical implementation, by providing a unified, scalable connection model
Extracted high volume of data by using Pro*C, SQL*Loader, UNIX Shell Scripts & Perl and integrated with Application Software
Helped identify customers affected by network events and digging through existing code and re-creating problems in the on lines when the users are experiencing problems. Monitoring the production support queue and solving the severity issues as they come in.
Environment: Oracle 8i, SQL, PL/SQL, Pro*C, UNIX Shell Script, Perl, SQL Loader, Export/Import, Excel, Access, Oracle Analyzer, Orchestrate scripts
Edge Technologies, Inc / MCI WorlCom, Vienna, VA Nov 1999 – Jun 2000 Sr. Programmer Analyst
Responsibilities:
Development Integrated Mission System front-end using JavaScript, HTML, Netscape Live Wire and Netscape Enterprise Server.
Data migration and system conversion to Oracle – wrote SQL scripts and PL/SQL programs to move and hygiene the data, indexing tables and tuning the scripts as needed to expedite the process.
Troubleshooting performance issues and bugs within packages, forms, and reports using Oracle packages, debugger, explain plan and Oracle Analyzer. Cost-based optimization tuning for Application, SQL, PL/SQL procedures.
Developed C for user interface; a data load using PL/SQL and SQL*Loader; and cron jobs calling Unix scripts to download and manipulate files. Extracted high volume of data by using Pro*C, SQL*Loader, UNIX Shell Scripts & Perl. Designed Data warehouse, Database and integrated with Application Software.
24x7 production environment and provided on-call and day-to-day support.
Environment: Oracle 7x/8i, SQL, PL/SQL, Pro*C, UNIX Shell Script, Perl, C, SQL Loader, Export/Import, Excel, Access, Oracle Analyzer, Orchestrate scripts, PVCS.
Edge Technologies, Inc / Equal Employment Opportunity Commission (EEOC), Washington, DC May 1999 – Nov 1999
Sr. Programmer Analyst
Responsibilities:
Developer and Administrator of semantic Charge Data System database to relational database (especially for Oracle) conversion tools including schema translation and form generator using C, and awk. Perl and C program of various system tools to assist project management, including bug control system.
Test plan design, version control and database schema investigation using C and Perl. Developed various applications to test the Load balancing, high availability and maximum throughput of the server.
Written UNIX shell scripts for testing the application and writing the SQL queries & PL/SQL procedures, packages for Oracle database. Cron tabs used to automate the routine process.
Provide consultation to browser and reporting front-end developers regarding the development of supporting Oracle tables, indexes, views, triggers, packages, procedures, in-line functions, SQL queries, etc.
Environment: Oracle 9.2.0.8, 10.2.0.4 & 11.1.0.6, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, TOAD.
Edge Technologies, Inc / Citicorp, Queens, NY Oct 1998 – Apr 1999
Programmer Analyst
Responsibilities:
Developed a Perl and C program of various system tools to assist project management, including bug control system.
Developed various applications to test the Load balancing, high availability and maximum throughput of the server.
Developed a C program to support the transactions process, batches process, and also for client authorization system. Written UNIX shell scripts for testing the application and writing the SQL queries & PL/SQL procedures, packages for Oracle database. Cron tabs used to automate the routine process.
Environment: Oracle 7x, SQL, PL/SQL, Pro*C, UNIX Shell Script, Perl, C, SQL Loader, Export/Import, Excel, Access, Oracle Analyzer, Orchestrate scripts, PVCS.
Bharat Heavy Plates & Vessel Ltd. Oct 95 – Mar. 98
Programmer Analyst
Responsibilities:
Design and developed system to handles the day to day transactions of the organization like (Importing Goods, Generation of Monthly and Yearly report of various items, Generation of Invoices, Enquiry the information of items, suppliers, and customers, Cancellation of orders, Generation of Monthly and Yearly report of various items and model number of various items.
Developed C, COBAL, SQL, PL/SQL programs and UNIX shell and PERL scripts for pre-processing of data files and job flow control.
Developed database procedures using Pro*C and PL/SQL for backend. Developed database functions using PL/SQL for enforcing business rules. Developed database triggers using PL/SQL for maintaining database integrity.
Environment: Oracle 5/6/7x, SQL, PL/SQL, Pro*C, UNIX Shell Script, Perl, C, SQL Loader, Export/Import, Excel, Access, Mainframe, COBAL, DB2.
EDUCATION:
Executive MBA in Business Administration, Fairleigh Dickinson University, Teaneck, NJ, USA.
Master of Science in Computer Science, Fairleigh Dickinson University, Teaneck, NJ, USA.
Contact this candidate