Data Developer

Rajeshwar Yeerbothu

Fremont, CA 925-***-**** ************@*****.*** linkedin.com/in/rajeshwar-yeerbothu-2080095/

Sr DBA/Database Architect/Database Developer

Results-focused and highly experienced Database Management professional specializing in project execution through all phases of SDLC, including analysis, design, development, and the implementation of operational database systems (OLTP) and Strong team-builder, Proven track record of successfully streamlining and optimizing site functionality, performance, and recoverability in global, mission-critical environments. Possess outstanding individual contributor strengths, as well team leader skills. High ability to develop, train, mentor, and supervise teams to peak performance

Areas of Expertise

Oracle/SQL Server Data Modeling Infrastructure Architecture Database Security MAA (HA/DR) Infrastructure Oracle Streams Siebel CRM eCommerce Golden Gate Replication Data Centers Oracle RAC TAF Server Load Balancing MYSQL MSSQL Data Masking Logical Data Guard Compliance Delphix SOX Data Sales Analyst ERP SQL Servers Always ON PL/SQL Programming Unix Shell Scripts Oracle Database Audit Tables Staff Development, Training, Mentoring & Supervision Export & Import Backup & Recovery FGA

Performance Tuning Python ER win Toad Solar Winds DPA AWS Cloud Terraform OEM ERStudio Total Recall

Accomplishments

Top rated by StubHub management for technical leadership, project execution, and near flawless execution of database upgrade from 10g to 11g with minimal downtime and successful data center migration.

Created SQL scripts that boosted the performance of StubHub Site RAC clusters from regular outages to operation at 99.99% uptime.

Reduced Siebel upgrade downtime from 18 hours to 1 hour and executed 0racle provided steps; identified scripts and split into parallel and process split into PRE/ POST deployment; improved customer service, and saved millions.

Initial downtime was estimated 4 hours and management asked to work on reducing downtime

Reviewed Oracle database upgrade 11g to 12c plan and reduced downtime from 4 hours to 15 min using Oracle golden gate and GTM names and reduced app steps to 1-hour meeting StubHub uptime metrics and improve service levels.

Created history tables for all PII tables and implemented a new process and within two months generated savings of $1M in licensing fees and other costs and reduced dev database build from days to a couple of hours.

Professional Experience

StubHub CA 2016-Present

Sr. Database architect/Administrator

Designed and installed Defined the strategy to design, implement and install the MS SQL server with Always (HA solution with four-node windows cluster).

Automated the data fix process and migrated a SQL server database from AWS to the StubHub Data Center.

Executed the upgrade from the standard edition to the Enterprise edition of SQL server.

Spearheaded the install and configured the MS SQL server; improved the monitoring process and pager duty escalation process.

Operationalized the Oracle Golden Gate integration with Kafka and built the Oracle Logical Data Guard to data mask PII data using database triggers.

Established In-house data masking technologies in Logical Data Guard using database triggers and DevOps automation and built environments using Delphix and automated database created with data masking.

Data classification, data modeling and GDPR and PII Data classification

Exhibited strong working knowledge as a data analyst in sales and distribution applications.

MS SQL SERVER database migration to Oracle Database (MS SQL server 2012 to Oracle 12cR2 ?)

Installed and configured Oracle Golden Gate VERIDATA for data comparisons.

Rajeshwar Yeerbothu

Fremont, CA 925-***-**** ************@*****.*** linkedin.com/in/rajeshwar-yeerbothu-2080095/

StubHub CA 2012-2016

Sr. Manager DBA/Database developer team

Led a Siebel upgrade from 10g to 11g with minimal downtime.

Delivered benchmarking and MAA (HA/DR) infrastructure and supported ecommerce and mission critical websites across multiple data centers.

Developed business and database metrics collection and site monitoring metrics collections.

Streamlined processes, simplified execution, managed objectives and key results (OKRs), release on time, brought tooling and efficiencies to help teams execute daily tasks

Lead the prioritization and trade-off in order to balance developer/customer experience and time to market

Defined Archive Strategy designed and developed archive scripts to purge history data using PL/SQL programs and dynamic SQL and Unix shell scripts.

Involved tablespace management, Index management, (Export & Import) Backup and Recovery, Performance Tuning, and Tuning init.ora file for oracle

Sr. Database Architect/Administrator 2010-2012

Supervised the Oracle Golden Gate installation and configuration for a read-only Oracle database.

Replaced Oracle streams with Golden Gate replication to reduce latency and improve the operational efficiency for a CRM application.

Optimized the functionality of a Siebel EIM job.

Fine-tuned SQL queries and monitored plan changes and applied SQL profiles if performance was poor.

Reduced ITL wait for Oracle events by increasing the initrans parameters on tables/indexes based on the number of rows in each data block.

Implemented database architecture best practices on various Stubhub database servers

Revamped and spilt the primary database into smaller databases to reduce redo generation activity to save recovery time during database crashes.

Moved batch processing to a separate database with no archive log mode.

Completed Oracle Data Guard builds into a new data center

Sr. Database Developer/Architect 2007-2010

Launched best practices on database development/data modeling.

Applied pre-deployment of SQL scripts to reduce the dependency on the release process.

Designed and implemented the databases based on application requirements.

Led the MLB integration for StubHub and facilitated Oracle Streams setup to eCommerce data into Siebel DB.

Orchestrated Oracle AQ setup for message queuing and migrated data from legacy database to a Siebel DB.

Led SQL query performance tuning efforts and rewrote stored procedures using global temporary tables.

Analyzed SQL queries and suggested index strategies for Java Developers.

Collaborated with developers and upgraded from Oracle 9i (Linux) to the 10g Solaris RAC database.

Converted existing tables into partition tables with zero downtime using homegrown scripts.

Oversaw the change data capture implementation using database triggers for search index and reduced dependency on database queries.

Designed and implemented database retention policies at StubHub based on business logic.

Sr. Database Developer/Architect Wells Fargo CA 2005-2007

Contributed efforts for the Commercial Mortgage Securities Associations Investor Reporting Package (CMSA IRP) System enhancements to meet the needs of all types of investors who are monitoring CMBS transactions.

Collected requirements from functional users and designed database structures using Erwin.

Developed database scripts to create a tablespace, indexes, roles, and stored procedures to incorporate business logic.

Provided database support and performance tuning of SQL queries.

Automated the data loading process and assisted in the database migration from 8.1.7 to Oracle 10g.

Involved in user testing project release deployment documentation and preparing deployment scripts.

Designed database structure using Erwin as per user Kimball’s methodology.

Sr. Database Developer LifeScan Inc. CA 2004-2005

Developed a project plan and technical specifications and conducted the evaluation of the Cognos analytics.

Sr. Database Developer Johnson & Johnson CA 2000-2005

Education & Certifications

MS in Computer Science Engineering Bachelor’s in Civil Engineering Osmania University Hyderabad, India

Project Management Course Completed PMI

Contact this candidate