Yogesh Sharma

Creative and result-oriented software architect and manager with experience in managing and developing cutting-edge software solutions for a variety of industries. Throughout my 30 years of career, I have taken concepts and converted them to software products. One of the software received an US Patent.

Work Experience

Jul-2022

Manager, Software Development @ Amazon.com (AWS RDS Open Source Databases)
Manage PostgreSQL projects and upstream contributions

Oct 2018

Director, Solutions Engineering @ Crunchy Data
Manage Solutions Engineering (SE) team. In this role I created various solutions to meet client and internal teams need. Activities included were requirements gathering, design and code reviews and steering team in right direction. Some of the projects are:
- Crunchy HA PostgreSQL
- Crunchy PostgreSQL
- Crunchy Monitoring
- Crunchy PostgreSQL STIG Automation
- PostgreSQL Prometheus Adapter

Oct 2017

Senior Data Architect @ Crunchy Data
I assisted clients with their requirements, design and developing required solutions. Some of the projects were:
- Designed PostgreSQL HA based on pacemaker/corosync
- Developed pgMonitor a PostgreSQL monitoring, based on Prometheus, Exporters, and Grafana.
- Created a remote monitoring system using Icinga2, Prometheus exporters, exporter2perfdata, and Grafana for client database monitoring

Oct 2015

Data Architect @ Crunchy Data
As a Data Architect, I created Crunchy Support Team to streamline and organize "Crunchy Support".

May 2015

Director Software Engineering @ OSS Expert LLC
Provided support for Open Source. PostgreSQL, Linux support and system design. Managed clients and ensured that issues are resolved as per their expectations.

Mar 2013

Manager Software Engineering @ OSS Expert LLC (formerly credativ US)
Provided support for Open Source. PostgreSQL, Linux support and system design. Managed clients and ensured that issues are resolved as per their expectations.

Feb 2010

Staff Software Developer @ Cymer Inc
Adapted MSC as the EUV Controller. Managed on site and off site teams and reviewed requirement, design and technical docs. Designed and discussed software architecture and helped with development.

Feb 2008

Manager New Products @ Cymer Inc
Managed on-site and off-site teams for MSC software development and new products design and development. Activities included Agile based development cycle and followed Product Development Process (PDP)

Feb 2006

Senior Software Developer @ Cymer Inc

Worked on requirements, design and development of Master System Controller. Activities included code development, Proof of Concept work, design discussion, testing and periodic travel to integration site.

Feb 2005

Software Developer @ Cymer Inc

Designed and developed Master System Controller (MSC) for TCZ flat panel system. MSC was designed for versatility due to unavailability of many hardware devices as they were still under development and communication protocol was not ready

Oct 2000

Systems Analyst / DBA @ MTSI Inc

Worked as a Oracle DBA to help with Oracle DB optimization for CymerOnLine (COL). Later COL was converted to use PostgreSQL.

Mar 1998

Systems Analyst / DBA @ Everest Solutions

First flight of my life, first overseas job, and first snow all happened when I came to USA and started working a consultant at Department of management & Budget in Lansing, MI and 6 months in Minneapolis, MN.

Jan 1995

Systems Analyst / DBA @ Rajasthan Financial Corporation (RFC)

Joined Rajasthan Financial Corporation and worked in their IT department. Good to see some high end computer systems, a line printer and finally a dial up modem.

Oct 1992

Software Developer @ Pharma Traders

After completing a Diploma in Computer Science, I started working first real Job working computers. Looked at their current clipper based software and suggested redesign in FoxPro (for MSDOS). Along with day to day activities software was development to manage their business. Later one other local business owners also started using this new software

Jul 1990

Internship @ Hotel Arya Niwas

While pursuing my bachelors degree in accounting, I started an internship as an accounts assistant. This is where my life has a critical turnaround event. First time in life I saw an IBM XT 8088 system with dual 5.25" floppy drives. This is when I started learning computer and changed my career.

Projects

Crunchy High Availability PostgreSQL

Platform: Ansible Automation, PostgreSQL, Patroni, pgBouncer, HAProxy, and pgMonitor
URL:https://www.crunchydata.com/products/crunchy-high-availability-postgresql
A production-ready PostgreSQL which is automated using Ansible and very scalable.
A all in one, fully automated solution for deploying High Available PostgreSQL based on open source software. Key design features are:
- High Availability
- Disaster recovery
- Load balancing
- Connection Pooling
- Critical Metric collection
- Alerting
- Automated Healing.
PostgreSQL 9.6-14 are supported on CentOS 7, RedHat 7/8, Ubuntu Focal, and SuSe Enterprise Linux (SLES15)

Prometheus Exporter to Icinga2 / Nagios perfdata converter

Platform: GoLang
URL:https://github.com/CrunchyData/exporter2perfdata
The exporter2perfdata is developed in golang, It captures Prometheus Exporters metric and generates Icinga2 / Nagios ingest able output. It supports metric comparison and validation. It also supports include and exclude filters.

PostgreSQL Prometheus Adapter

Platform: GoLang
URL:https://github.com/CrunchyData/postgresql-prometheus-adapter
Prometheus storage adapter to store Prometheus metric in PostgreSQL database. Many optimizations ex: partitioning schemes, copy instead of instead of insert, multi threaded reads and writes, were key elements to improve performance.

pgMonitor

Platform: Prometheus, Exporters, and Grafana
URL:https://github.com/CrunchyData/pgMonitor
pgMonitor is an all-in-one tool to easily create a monitoring environment to visualize the health and performance of a PostgreSQL cluster.
pgMonitor combines a suite of tools to facilitate the collection and visualization of important metrics from the PostgreSQL instance(s) as well host environment
Main design feature is to keep it highly configurable, so that advanced users can design their own metrics and visualizations.
Running pgMonitor gives confidence in understanding how well PostgreSQL cluster is performing and will provide the necessary information to make calculated adjustments to the environment.

EUV Master Controller System (EUV MSC)

Platform: C++, PostgreSQL, Python, and Linux
URL:Closed Source
EUV MSC, a retrofit version of MSC to control a EUV Laser instead of flat panel manufacturing system. Modular design of MSC was very helpful in re-using it for EUV. Team had to create C++ drivers, add proper command mapping and system was able to control new devices.

Master System Controller (MSC)

Platform: C++, PostgreSQL, Python, and Linux
URL:https://patents.google.com/patent/US7848835
MSC, a state of art high level controller for Cymer/TCZ flat panel displays manufacturing. This was a very complex database driver controller with recipes written in Python. System was highly modifiable with loadable C++ drivers, decoupling of hardware commands from software and heavy use of PostgreSQL. Diagnostic data loading was tweaked to use COPY with targeted inherited tables. Table inheritance was used to speed up old data purging and it also resulted in faster data queries.

Crunchy PostgreSQL

Platform: Ansible Automation, PostgreSQL, pgBouncer, and pgMonitor
URL:https://www.crunchydata.com/products/crunchy-high-availability-postgresql
A production-ready automation to setup PostgreSQL as Primary or a Replica with pgBackrest and with / without pgBouncer.
- PostgreSQL 9.6-14 are supported
- CentOS 7, RedHat 7/8, Ubuntu Focal, and SuSe Enterprise Linux (SLES15)



Crunchy PostgreSQL STIG Automation

Platform: Ansible Automation
URL:Private Repository
Ansible-based playbook to make a PostgreSQL instance compliant to the STIG standard. This playbook supports three mode of operations.
Assesses - remote database against STIG controls.
dryrun - Runs "check" but additionally provides remediation steps as output.
Remediate - Performs the STIG assessment and takes the necessary corrective actions to bring the database into compliance.




Field Data Server (COL)

Platform: PostgreSQL
URL:Closed Source
Central PostgreSQL server to store COL collected data in efficient manner. Optimize inbound and data load process and periodic PostgreSQL optimization


Cymer OnLine (COL)

Platform: Oracle / PostgreSQL, JSP, C++, Python, Java
URL:Closed Source
Innovative system to collect, process and store DUV Laser diagnostics, configuration and health data at periodic interval for predictive analysis and preventative maintenance. Software was design to utilize Oracle but later it was converted to use PostgreSQL.


Loan Aging Reporting

Platform: MSDOS, FoxPro, SQL
URL:Closed Source
Loan aging analysis software to eliminate lengthy manual printed reporting and convert to an easy to use user friendly interface


Hotel Management System

Platform: MSDOS, FoxPro, SQL
URL:Closed Source
Hotel front desk management software to handle Room Reservation, Allocation, and Invoicing.


Pharmaceutical Distribution Software for (wholesale)

Platform: MSDOS, FoxPro, SQL
URL:Closed Source
Pharmaceutical distribution system for managing wholesale distributors day to day working. Managing Purchase, Sales, Return, Inventory, and Accounting


Skills

  • C Level 7
  • C+ Level 8
  • golang Level 4
  • rust Level 2
  • java Level 6
  • python Level 8
  • bash Level 9
  • PostgreSQL Level 9
  • patroni Level 8
  • Oracle Level 3
  • MySQL/MariaDB Level 2
  • MS SQL Server Level 1
  • django Level 4
  • hugo Level 7
  • Networking Level 7
  • Linux Level 8
  • Docker Level 4
  • Podman Level 4
  • Ansible Level 9
  • RPM Packaging Level 7
  • Prometheus/Grafana Level 6

Contributions

  • Patroni
  • pgBackrest

Hobbies

  • Linux, Networks, and Security
  • Home automation
  • Hike / Nature walk
  • Bike / Motorbike
  • Horse back riding
  • Flying Single Engine
  • 4x4 offroading

Patent / Award

Patent ID:
US7848835
Description:
High power laser flat panel workpiece treatment system controller
Issued:
Dec 7, 2010
See patent

Certification

  • Oracle Certified DBA
  • Diploma in Computer Science
  • Proficiency in C langauge

Education

  • Bachelor of Accounting 1991
    (University of Rajasthan, India)