Database Administrator and Data Engineer
2017 - 2023State 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
Mahesh R. Pingili
Data Engineer and Software Developer in Des Moines, IA, United States
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.
Mahesh is now available for hire
Portfolio
- State of IowaAmazon 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.
Employment
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 ProcedureParadigms
ETL, OLAPPlatforms
Oracle, Unix, Amazon Web Services (AWS), Google Cloud Platform (GCP), Azure, Webflow, LinuxStorage
MySQL, PostgreSQL, Databases, SQL Stored Procedures, Database Administration (DBA), PL/SQL, Oracle SQL, Microsoft SQL Server, AWS Data Pipeline Service, Data Pipelines, MongoDBOther
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 HostingTools
Microsoft Power BI, BigQuery, Google Analytics, Microsoft Excel, Crystal Reports
Certifications
- Oracle Database 11g Administrator Certified ProfessionalFEBRUARY 2018 - PRESENTOracle
- SAS Certified Base Programmer for SAS 9MAY 2017 - PRESENTSAS
