Mahesh is available for hire

Mahesh R. Pingili

Verified Expert in Engineering

Data Engineer and Software Developer

Location

Des Moines, IA, United States

Toptal Member Since

September 12, 2022

Manesh is a data engineer, database admin, developer, and analyst working in Oracle, MySQL, SQL Server, and PostgreSQL. He's proficient in Bash shell, SAS, SQL, PL/SQL, data pump, and physical standby database setup. He worked on data migrations, developed code for the ETL process, and moved databases to AWS RDS and applications to EC2 instances. His experience also spans generating high volumes of data for QA and load testing, tuning activities, and data modeling.

Data Engineering Data Analysis Data Warehousing Data Migration Oracle Data Guard Data Visualization Amazon RDS Oracle Databases PL/SQL Oracle SQL SQL ETL OLAP SQL Stored Procedures

Portfolio

State of Iowa

Amazon Web Services (AWS), Amazon RDS, Azure, Azure Data Lake, BigQuery, SQL...

Experience

Oracle - 20 years SQL - 19 years Data Migration - 8 years Microsoft SQL Server - 7 years MySQL - 6 years Amazon Web Services (AWS) - 5 years PostgreSQL - 4 years PostgreSQL 9.3 - 4 years

Availability

Part-time

Preferred Environment

Oracle, MySQL, Microsoft SQL Server, SQL, ETL, Data Engineering, Data Pipelines, MongoDB, SQL Stored Procedures, Amazon Web Services (AWS), Snowflake, Consulting, Python, Google BigQuery

The most amazing...

...thing I've migrated is a 10TB database to AWS RDS. I deployed an application in AWS EC2 with Elastic Load Balancing and managed its security.

Work Experience

Database Administrator and Data Engineer

2017 - 2023

State of Iowa

Acted as a database administrator, data engineer, and data scientist.
Performed AWS RDS, EC2, S3, data migration, and Linux administration.
Developed and administered in Oracle, MySQL, Microsoft SQL, PostgreSQL, and MongoDB.

Technologies: Amazon Web Services (AWS), Amazon RDS, Azure, Azure Data Lake, BigQuery, SQL, Microsoft Power BI, Oracle, PostgreSQL, MySQL, Microsoft SQL Server, Linux, Web Hosting, Data Engineering

Experience

Telehealth and E-healthcare Platform and Solution Integration

I developed a remote healthcare solution for monitoring patients.
Medical IOTs were used for monitoring remote patients, all data was collected and stored in AWS RDS (Oracle, MySQL), as I configured AWS application servers (scaling), designed and implemented custom database

Skills

Languages

SQL, Snowflake, HTML, Python, Stored Procedure

Paradigms

ETL, OLAP

Platforms

Oracle, Unix, Amazon Web Services (AWS), Google Cloud Platform (GCP), Azure, Webflow, Linux

Storage

MySQL, PostgreSQL, Databases, SQL Stored Procedures, Database Administration (DBA), PL/SQL, Oracle SQL, Microsoft SQL Server, AWS Data Pipeline Service, Data Pipelines, MongoDB

Other

Data Migration, Oracle Data Guard, Programming, Data Engineering, Data Warehousing, Amazon RDS, Google Data Studio, Data Processing, Data Processing Automation, Data Analysis, ETL Tools, Scripting, Data Visualization, Data Mining, Data Architecture, Azure Data Lake, Google BigQuery, Data Modeling, Internet of Things (IoT), PostgreSQL 9.3, Informatica, Data Analytics, Azure Data Factory, Consulting, CSV, Web Hosting

Tools

Microsoft Power BI, BigQuery, Google Analytics, Microsoft Excel, Crystal Reports

Certifications

FEBRUARY 2018 - PRESENT

Oracle Database 11g Administrator Certified Professional

Oracle

MAY 2017 - PRESENT

SAS Certified Base Programmer for SAS 9

SAS