Nosql Architect

GIRIBABU VENUGOPAL Email: *****************@*****.*** Phone: 949-***-****

PROFESSIONAL SYNOPSIS:

Accomplished Database Architect/Engineer with over 15 years of extensive experience in managing and optimizing No SQL Server relational databases across diverse environments. Skilled in leveraging NoSQL Database services for cloud-based solutions, including migration, scaling, and maintenance of No SQL Managed Instances such as MongoDB, Cassandra, Neo4J and Elasticsearch.

PROFESSIONAL SUMMARY:

Sr No SQL/Mongo Architect, having over all 10+ years of experience on level 1, level2 and level3 support, Installation, Migration, Administration and Deployment.

Hands on different NoSQL data base tools such as Elastic Search, Mongo, Cassandra, Redshift, Couchbase, Big SQL, Postgres, MySQL and SQL Server.

Excellent understanding of software development methodologies and software development life cycle like Waterfall model, AGILE and SCRUM.

Performed AWS Datacenter migrations from on-premises to cloud and Talend, AWS Migration tools.

4+ years of experience in automation CI/CD (continuous integration/continuous deployment) using Jenkins, dockers and Kubernetes.

Developed robust backup and recovery strategies to safeguard data integrity and ensure quick restoration during system failures or data corruption incidents.

Designed and implemented high availability and disaster recovery (HA/DR) solutions such as Always On Availability Groups, Replication, Failover Cluster Instances, Log Shipping, windows clustering and Database Mirroring.

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.

Skilled in SQL query optimization, index tuning, and performance monitoring using tools like SQL Server Profiler, Extended Events, and Dynamic Management Views (DMVs).

Comprehensive experience in AWS (EC2, RDS, VPC, Security Groups, Subnets, IAM, Lambda, BOTO3, S3, CloudFront, CloudWatch, Route53, ELB, AWS CLI)

Experienced in Database Installation, Provisioning, Creation, Configuration, Administration, Upgrades and managing of On-Premises and Cloud - AWS RDS, EC2 and other AWS resource. Oracle, PostgreSQL, MySQL, SQL Server, RedShift, Snowflake

Monitoring databases for database performance analysis and SQL Optimization using native tools such as AWS, ADDM and OEM other metrics: including PL/SQL and complex Queries.

Amazon OpenSearch Service is a fully managed service that simplifies the deployment, operation, and scaling of OpenSearch and Elasticsearch clusters.

Experience in creating Terraform, CloudFormation (CFT) templates and deployed using CI/CD pipeline using AWS technologies to automate provisioning RDS, EC2 and other.

Experience in Datadog (monitoring tool) setup/configuration for application servers and database servers (EC2, RDS) - Datadog templates, development, testing and production.

Experience in Rehydrate the EC2 (automate) - automate the tasks using Jenkin Pipelines, Python, HTML and Shell Scripts.

BAU work as needed to manage database changes, infrastructures.

Ability to adapt to New Technologies quickly.

ITIL V3 Foundation course certified.

CB020 Fundamentals of NoSQL Data Management.

CB030 Essentials of Couch base NoSQL Technology.

Mongo DBA Certified 4.4 Associate Level.

Neo4J Certified Professional 2017.

AWS Associate Architect Certification 2019.

Administrator Certification for Apache Cassandra.

PROFESSIONAL EXPERIENCE:

Ebay - No SQL/Mongo DBA SEPT 2016 to till Date.

Role: Mongo DBA(SME)

Location: San Jose

Environment: Red Hat Linux 6.4, Mysql, Mongo, Sqlite3, Python 2.7, JIRA, Confluence, Teams, Github java tools.

MONGO Administration:

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.

By leveraging the Apache Kafka, the Confluent Oracle CDC Connector and the MongoDB Connector for Apache Kafka, I have stream database changes from Oracle to MongoDB and migrated.

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.

Extensive experience on Database Migration from MongoDB 3.6 to 4.x, 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, Migrations(5 to 6) 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.

Hands-on experience with container orchestration tools like Docker, Kubernetes and CI/CD pipelines(Jenkins).

Hands on experience deploying Terraform, Ansible and Chef.

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.

Client: Macys -BigData/NoSQL DBA Jan 2013 to DEC 2016

Role: Big Data/NoSQL Admin

Location: Atlanta, GA.

Project: IFS Macys Infrastructure

Environment: Red Hat Linux 6.4, Kafka, Cassandra, Elastic Search [ELK], Redshift, ZooKeeper, Couchbase, Groovy, Power Shell, Chef, Ansible, Shell scripting, Jenkins, SVN, Team City, Flume, Tibco streambase, Git java tools.

Elastic Search/Cassandra:

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].

Mongo Administrator:

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.

Client: Citigroup Jun 2010 to Dec 2013

Role: SQL DBA

Location: Tampa, FL.

Environment: SQL Server Management Studio, SSIS, SSAS, SSRS, SQL profiler, Perfmon, Sentry One, Power shell, DTA, Commvault, Evault.

General Responsibilities:

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.

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.

Experienced SQL Database Administrator with a proven track record in database management.

Skilled in database installation, configuration, and optimization for performance.

Expertise in database monitoring, troubleshooting, and resolution of issues.

Syntel Inc Sep 2009 to Jun 2010

Role: Project Lead

Location: Northbrook, IL.

Environment: Oracle 11g, Red Hat Linux 5.x, Tibco BW 5.7,5.8, TRA 5.6, Admin 5.6, Hawk 4.X, Bea WebLogic 10.x, Wesbpshere, Hermes 8.1, Webpshere MQ 7, Tibco BE 5.x, Tibco IProcess 11.x, Tibco IProcess Web Clients, Tibco iProcess ToolKits. AMX BPM 1.2.0.

General Responsibilities:

Administered and maintained SQL Server databases across development, testing, and production environments, ensuring data availability, integrity, and security.

Extensively created webservices using SOAP/HTTP and SOAP/JMS.

Developed XSDs, XPATH transformations and XSLT mapping using TIBCO Designer.

Configured the ADB adapter and set up the environment for TIBCO and TIBCO ESB.

Implemented Business rules in TIBCO Business Works and used ADB Adapter for data update in Oracle Database.

Created Queues, Topics, Database scripts and migration/deployment scripts.

Wrote Unit, Integration and System Test plans and cases for the newly developed system and Involved in code release for Clear case.

Involved in implementing the best practices in load balancing and fault tolerant part of EMS server.

Created XML Schema Definitions to validate XML’s against their models.

Designed & implemented the Exception handling solution for the business process and conducted Unit testing and component testing.

Used TIBCO Administrator GUI to upload, configure and deploy applications.

Used Quality center Tool to upload the Test Cases while performing the Unit Testing.

Accumulated and reviewed Use Cases of Business Requirements to integrate legacy systems through TIBCO BW.

Performed Development, Testing and Deployment of the application in different environments.

Used Common Logging and Error Handling (CLE) framework library and extensively implemented it in Business Works processes.

Involved in Code review and migration procedures along with documentation.

Involved in complete SDLC of this project with hands on involvement in Requirement gathering, Design, Development, Testing and migration to Production along with Application Production Support.

EDUCATION:

Master of Computer Application - Chennai University, India

Bachelor of Computer Science - Chennai University, India

VISA: Green Card Holder.

Contact this candidate