Summary
Overview
Work History
Education
Skills
Visa
Timeline
Generic

GIRIBABU VENUGOPAL

San Jose

Summary

With a proven track record at Ebay, I excel in NoSQL database administration, enhancing system efficiency and security through innovative solutions. My expertise in MongoDB migrations and stakeholder management has driven significant improvements. Skilled in analytical problem-solving and mentoring, I deliver results that exceed expectations, ensuring customer satisfaction and operational excellence.

Overview

15
15
years of professional experience

Work History

NoSQL DBA(SME)

Ebay
San Jose
09.2016 - Current
  • Involved firmware upgrade, TechRefresh, C3 Rack Migration (OPENSTAC VMs from BARE METAL)
  • Involved security, backup and restore discussions
  • Designed & deployed robust, scalable, resilient database based on application usage
  • Closely worked with Mongo, Cassandra and Couchbase vendors
  • Involved in Mongo, couchbase, Cassandra upgrades on Q4 and Q1
  • Involved migrating bare metal to openstack vms
  • 1600 couchbase nodes with 133 cluster, 1028 mongo nodes with 208 replicasets
  • All nodes, cluster information, script details were maintained by source of truth sqlite3
  • Responsible for administration, maintenance, Performance analysis, and Capacity planning for Mongodb clusters
  • Coordinate and plan with Application teams on Mongodb capacity planning for new applications
  • Collaborated with development teams to define and apply best practices for using MongoDB
  • Designed and deployed Dependent MongoDB Sharded Cluster Platform, followed by Replica Cluster and GRIDFS replica set
  • Extensive experience in Installation and configuration of multi node MongoDB sharded cluster and replica sets on Linux
  • Deployed high availability replica set, sharded cluster and GRIDFS across multiple data center
  • Deployed MongoDB on NUMA Hardware by setting ulimit’s, disable NUMA settings and THP for better MongoDB operations
  • Configured to read Preference data from secondary server to reduce load on primary in replica set environment and also worked on modifying priorities of nodes
  • Manual Monitoring of the Database at system level by scheduling cron scripts for mongo service restart, replication lag, slow queries and disk space
  • Responsible for monitoring the Database cluster through 3rd party tools like Prometheus, Datadog and Grafana Stack
  • Enabled Journaling across all mongo instances for auto recovery of data after unexpected shutdown
  • Created multiple databases with sharded collections and chose shard key based on the requirements
  • Worked on Sync logic on different pattern and situation to resolve replication issues
  • Experience working on enabling Profiling Levels to debug query level performance
  • Experience on Debugging instance level performance with iostat, mongostat and mongotop
  • Performed Data Migration between multiple environments using mongodump and mongorestore commands
  • Extensive experience on Database Migration from MongoDB 3.6 to 4.0 , 5.x, 6.x and 7.x version without any downtime
  • Worked on enabling zone aware sharding for better data consistency
  • Manual Backups and Restore are done using Mongodump, mongoexport and mongoimport depending on the needs
  • Implemented POC for OPS manager and Percona MMS monitoring system
  • Responsible for OPS Manager monitoring, performance tuning and troubleshooting tasks
  • Configured delayed secondaries to avoid human failures in coding and development
  • Experience in analyzing chunk migrations, splitting and balancing across the cluster
  • Worked on data partitioning on chunks splitting
  • Knowledge on enabling locking mechanism to ensure data consistency on MongoDB
  • Developed Scripts for transferring data from production server to testing/development servers
  • Performed on-call technical support to minimize the impact of system disruptions
  • Hands on experience Mongo Atlas deployed in AWS cloud platform
  • Hands on experience troubleshooting application-side data issues and effectively solving customer problems
  • Engaged with application and engineering teams to design No-SQL/MongoDB solutions that integrate with the application design
  • Migrated all mongo clusters from BareMetal to Kubernetes (TESS framework)
  • Engage with stakeholders, vendors to validate solutions
  • Engage with enterprise security and architecture teams to validate solutions

Big Data/NoSQL Admin

Macys
Atlanta, GA
12.2013 - 09.2016
  • Company Overview: BigData/NoSQL DBA
  • Architect & Designed, Installed and Configured POC for Macys Search and Browse and provided 400ms average for faster search of UPC Inventory around 150 million
  • Created two instances and 2 Sharding for elastic search and stored 150 million data into index
  • Used sense client for Queries
  • Created POC and perform benchmark for different NoSQL DB such as ElasticSearch, Cassandra, MongaDB, Redis, Couchbase and Redshift
  • Configured shards and running two node instances for Elastic Search with 40 million data of indexes
  • Used groovy scripts for upgrade and configured Sense Client for writing Elastic Search queries
  • Configured Cassandra for replication factor 1 to make faster write consistency and running 4 node ring architecture
  • Installed Datastax Devcenter and Opscenter and configured for application query and monitoring for developers
  • Enable log trace to identify slow running queries from the application
  • One-click deployment through proof of concept for elastic search using AWS Management Console, CLI, or SDK
  • Configured Flume to get the real time data from Oracle Golden Gate
  • Aggregating logs using Logstash and showing into Kibana, Elastic search used as Backend store
  • [ELK]
  • BigData/NoSQL DBA
  • Configured high availability replica set across multiple data centers and worked on configuring different replica members (Hidden, Delayed)
  • Configured to read data from secondary server to reduce load on primary in replica set environment and also worked on modifying priorities of nodes
  • Implemented write concern to avoid rollback
  • Enabled Journaling across all mongo instances for auto recovery of data after unexpected shutdown
  • Created multiple databases with sharded collections and chose shard key based on the requirements
  • Experience in User management and role-based access control
  • Worked on Sync logic on different pattern and situation to resolve replication issues
  • Experience working on enabling Profiling Levels to debug query level performance
  • Performed Data Migration between multiple environments using mongodump and mongorestore commands
  • Extensive experience on Database Migration from MongoDB 3.4 to 3.6 and 4.0 version without any downtime
  • Responsible for OPS Manager monitoring, performance tuning and troubleshooting tasks
  • Configured delayed secondaries to avoid human failures in coding and development
  • Experience in analyzing chunk migrations, splitting and balancing across the cluster
  • Worked on data partitioning on chunks splitting
  • Knowledge on enabling locking mechanism to ensure data consistency on MongoDB
  • Troubleshot day-to-day server related issues and problems using the Jira Ticketing System

SQL DBA

Citigroup
Tampa, FL
06.2010 - 12.2013
  • Administered and maintained SQL Server databases across development, testing, and production environments, ensuring data availability, integrity, and security
  • Installed, configured, and upgraded SQL Server instances and database services, applying patches and service packs to maintain system stability and security
  • Cost optimization project: server consolidation, Elastic search review of hardware configurations and SQL Server licenses
  • Implemented database replication and log shipping solutions to replicate data between distributed servers and support disaster recovery requirements
  • Designed and implemented database backup and recovery strategies, including full, differential, and transaction log backups, to minimize data loss and downtime in the event of system failures
  • Monitored database performance using SQL Server Performance Monitor and other diagnostic tools, analyzing system metrics and query execution plans to identify performance bottlenecks and optimize database performance
  • Documented database configurations, procedures, and troubleshooting steps to facilitate knowledge transfer and ensure operational consistency
  • Experience of managing containerized database MongoDB Python services with Kubernetes, CI CD pipelines
  • Set up high availability and disaster recovery solutions such as Always On Availability Groups and SQL Server Failover Cluster Instances
  • Analysed and optimized database performance using tools such as SQL Profiler, Database Engine Tuning Advisor, and execution plans
  • Implemented indexing strategies, query optimization, and data partitioning to enhance database performance
  • Developed and maintained backup and recovery plans, ensuring data integrity and availability
  • Performed regular backups, tested restore processes, and implemented point-in-time recovery strategies
  • Configured and managed database security, including user authentication, role-based access control, and encryption
  • Conducted security audits and implemented measures to protect sensitive data and comply with regulatory requirements
  • Experienced SQL Database Administrator with a proven track record in database management
  • Participated in capacity planning and scalability initiatives, assessing current infrastructure resources and forecasting future database growth to ensure adequate performance and resource availability
  • Skilled in database installation, configuration, and optimization for performance
  • Expertise in database monitoring, troubleshooting, and resolution of issues
  • Strong understanding of database security measures and implementation
  • Capable of designing and implementing backup and disaster recovery strategies
  • Experienced in SQL query optimization and database tuning to enhance efficiency
  • Knowledgeable in data migration processes and database version upgrades
  • Continuous learner keeping up with the latest advancements and best practices in database administration
  • Monitor and manage database replication and failover/recovery as needed
  • Proficient in debugging techniques and technical problem analysis
  • Investigate the Github logs and validate all the Github jobs are running as expected
  • Check logs in failed folder and investigate the failed deposits
  • Verify the Registrar deposit Processing and make sure the RyDE, RrDE and RDEA registrar deposits get executed on SQL server
  • Check success notifications for ICANN have been generated for all the executed deposits in database
  • Ensuring the goals of the Incident Management Process are achieved, restoring normal service as soon as possible based on customer perspective and within defined SLA
  • Install, manage, maintain, and troubleshoot databases and data models that support applications
  • Manage multiple MsSql databases, ensuring that all servers are operational 24x7x365 and all scheduled jobs and backups are consistently completed

Education

Master of Computer Application -

Chennai University
Chennai, India

Bachelor of Computer Science -

Chennai University
Chennai, India

Skills

  • Stakeholder management
  • Strong analytical skills
  • Innovative thinking
  • Expertise in subject matter
  • Customer focus
  • Training and mentoring

Visa

Green Card Holder

Timeline

NoSQL DBA(SME)

Ebay
09.2016 - Current

Big Data/NoSQL Admin

Macys
12.2013 - 09.2016

SQL DBA

Citigroup
06.2010 - 12.2013

Master of Computer Application -

Chennai University

Bachelor of Computer Science -

Chennai University

Similar Profiles

  • Madeline Oyler

    Madeline OylerMadeline Oyler

    Reseller at EbayReseller at Ebay

    View Profile
  • Matthew McLendon

    Matthew McLendonMatthew McLendon

    EBay Seller at EbayEBay Seller at Ebay

    View Profile
  • Elijah Reasons

    Elijah ReasonsElijah Reasons

    Online Seller at eBayOnline Seller at eBay

    View Profile
GIRIBABU VENUGOPAL