Summary
Overview
Work History
Education
Skills
Accomplishments
Websites
Projects
Interests
Timeline
Generic

Vivek Balyan

Noida

Summary

As a Senior Database Reliability Engineer at Adobe, I bring more than 14 years of experience in multi-cloud architecture, databases, data architecture, migrations, Automation and Site Reliability Engineering. I specialize in guiding customers through the design, implementation, and optimization of scalable, reliable, and cost-efficient cloud architectures. My technical proficiency spans various NoSQL and SQL technologies, such as MongoDB, Document DB, Cassandra, DynamoDB, MySQL, SQL Server, and RDS. I also have a strong foundation in observability, monitoring, database infrastructure design and modelling, and data as a service. Throughout my career, I have managed numerous migration projects for our clients.


As a leader, I possess a strong enthusiasm for guiding teams, addressing intricate challenges, providing outstanding customer value, and keeping abreast of emerging technologies. My goal is to utilize my knowledge and abilities to assist organizations in reaching their business goals and enhancing their data environments. Additionally, I have a solid understanding of cloud economics, FinOps, and cloud cost optimization. I take pleasure in working with diverse cross-functional teams, partners, and stakeholders, and I am always keen to share my expertise and perspectives.

Overview

13
13
years of professional experience

Work History

Sr. Database Reliability Engineer II

Adobe
08.2018 - Current
  • As Sr
  • DBRE my responsibility is evaluating an organization’s business needs and determining how I can support those needs leveraging new databases Technology, hardware, or infrastructure
  • I closely work with the application developers to create comprehensive databases that may be used by many dependent applications and also be used by millions of people outside
  • Along with my active participation in day-to-day activity and need to optimize the databases for any performance issues, taking care of DB maintenance, updates, and upgrades
  • Design and develop detailed migration plans, including timelines, dependencies, resource requirements, and risk mitigation strategies
  • Work with cross-functional teams spread across multiple products and locations within the organization and external partners, across different cultures and time zones and Provides technical solutions to a wide range of difficult database problems
  • Develops solutions that are imaginative, thorough, practicable, and consistent with organizational objectives

Senior Database Engineer

Expedia Group
03.2018 - 08.2018

Database Architect

Broctagon Fintech Group
03.2017 - 03.2018

Database Team Lead

Broctagon Fintech Group
01.2017 - 03.2017
  • Experience in AWS cloud services and Database designing,Benchmarking Databases ,Sql programming and Administering, Performance Tuning, Query Optimization, Backup Strategy ,Index Tuning, Clustering, Caching and Analysis, AWS Administering and Optimization -Design and Development of client/server, stored Procedure, Cursors, Triggers, Handle common database procedures, such as Upgrade, Backup, Recovery, Migration, etc
  • And Web based and n-tier Application, MongoDB.

Database Administrator

Kayako
02.2015 - 12.2016
  • Experience in Database designing, Benchmarking Databases, SQL programming and Administering, Performance Tuning, Query Optimization, Backup Strategy, Index Tuning, Clustering, Caching and Analysis, AWS RDS Administering and Optimization- Design and Development of client/server, stored Procedure, Cursors, Triggers, Handle common database procedures, such as Upgrade, Backup, Recovery, Migration, etc
  • And Web based and n-tier Application.

Mysql Database Engineer

IPsoft
08.2014 - 02.2015
  • Roles, Responsibilities and Area of work: 1) Design of Database architecture
  • 2) Porting of new data into database from different sources
  • 3) Maintaining the quality of database
  • 4) Design scripts to run on database for various process automation
  • 4) Create Stored Procedures and Triggers that are needed to maintain integrity of data
  • 5) Help front end developers with the database queries in their code
  • 6) Troubleshooting various issues that may occur in different modules
  • 7) Keep regular check on the cleanliness and accuracy of data
  • 8) Monitoring database servers during downtime

DBA

Just Dial Limited
05.2011 - 07.2014
  • Roles, Responsibilities and Area of work: 1) Design of Database architecture
  • 2) Porting of new data into database from different sources
  • 3) Maintaining the quality of database
  • 4) Design scripts to run on database for various process automation
  • 4) Create Stored Procedures and Triggers that are needed to maintain integrity of data
  • 5) Help front end developers with the database queries in their code
  • 6) Troubleshooting various issues that may occur in different modules
  • 7) Keep regular check on the cleanliness and accuracy of data
  • 8) Monitoring database servers during downtime

Education

Bachelor of Technology (B.Tech.), Computer Science -

Shobhit Institute of Engg and Technology
Meerut, Uttar Pradesh
01.2010

Skills

  • MySQL
  • MongoDB
  • Linux
  • Databases
  • Unix
  • Amazon RDS
  • PL/SQL
  • SQL
  • PHP
  • Cassandra
  • Snowflake
  • Shell
  • GitHub
  • Apache
  • HTML
  • Datadog
  • Amazon CloudWatch
  • AWS CloudFormation
  • PostgreSQL
  • Prometheus
  • Grafana
  • PagerDuty
  • New-Relic
  • Tungsten Cluster
  • Maintenance Planning
  • Debugging
  • Automation tools
  • Documentation And Reporting
  • Problem-Solving
  • Agile Methodologies
  • Documentation Management
  • Team Collaboration
  • Root Cause Analysis
  • Gathering requirements
  • Cross-Functional Teamwork
  • Troubleshooting and resolution
  • Technical communication skills
  • JIRA
  • Atlassian Tool Suite
  • Jenkins Build
  • Project Management
  • Performance Testing

Accomplishments

  • Supervised team of 6 staff members.
  • Documented and automate Toil work which led to save many hours.
  • Reduced response time by introducing Query fiddler tool for database read-only tasks.

Projects

Migration Projects: 

  • Azure Single server to Flexi Server.
  • Database Migration from AWS Non managed Db to Managed database on AWS.
  • On premises Database to AWS managed Database on AWS & Azure.


Automations: 

  • Query Fiddler: Created a tool for developer to fetch records from Database without impacting the cluster in a secure way.
  • Alert Setup on RDS: Created a script which automatically setup necessary alerts on Existing RDS.
  • AWS Aurora Infa provisioning: Created a terraform code which can deploy the AWS Aurora cluster with N number of nodes with events.


Upgrades: 

  • Lead teams for many upgrades of different flavors of databases like CentOS, MySQL, AWS RDS , AWS Aurora, MongoDB, Postgres Etc.
  • OS upgrades from centos 7 to Rocky 8.


Consultation: 

  • Database operation consultation to many cross teams for their projects.
  • Sprint planning and align tasks.

Interests

Volleyball, Travelling, Driving , Adventure activities, Cycling, listening to music

Timeline

Sr. Database Reliability Engineer II

Adobe
08.2018 - Current

Senior Database Engineer

Expedia Group
03.2018 - 08.2018

Database Architect

Broctagon Fintech Group
03.2017 - 03.2018

Database Team Lead

Broctagon Fintech Group
01.2017 - 03.2017

Database Administrator

Kayako
02.2015 - 12.2016

Mysql Database Engineer

IPsoft
08.2014 - 02.2015

DBA

Just Dial Limited
05.2011 - 07.2014

Bachelor of Technology (B.Tech.), Computer Science -

Shobhit Institute of Engg and Technology
Vivek Balyan