
Mahesh R. Pingili
Verified Expert in Engineering
Data Engineer and Software Developer
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.
Portfolio
Experience
Availability
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
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.
Experience
Telehealth and E-healthcare Platform and Solution Integration
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
Oracle Database 11g Administrator Certified Professional
Oracle
SAS Certified Base Programmer for SAS 9
SAS