Dharmesh Amin Email & Phone Number

Ahmedabad, Gj, In

Gandhinagar

Working Knowledege of PostgreSQL,MS-Sql,Oracle Database TechnologyIn depth practical knowledge of Installation, Configuration and Cloning of database instances, Upgradation & Implementation on Windows, Linux platform.Working Knowledge of Postgis Technology.Knowledge of Hadoop Framework Component Hive,HBase,Yarn,HDFS System.Knowledge of Oracle/PostgreSQL Database Administration including Planning/Implementing, Memory Management, Tablespace Management, File Management, User Management, Resource Management.Database upgradation from one major version to another major version.Knowledge of Data Science with python.(Pandas, numpys, scilearn,Linear regration,Decision tree)Knowledge of Apache spark, kafka, hadoop hdfs system,yarnExposure in Database Administration activities like Database optimization, Query Optimization and corruption detection.

Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.Involved in Unit Testing Stored Procedures and Functions.Created Materialized Views and partitioning tables for performance reasons.Troubles hooted performance issues and bugs within packages, for reports using dbms_output, Forms debugger, explain plan.Coordinate with the front end design team to provide them with the necessary stored package and procedures and necessary insight into the data.Created SQL*Loader scripts to load data into the temporary staging tables.Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development teamUsed TOAD, PL/SQL developer tools for faster application design and developmentsDeveloped procedures using Dynamic SQL..Developed database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problemsTuned complex Stored Procedures for faster execution and Developed database structures, according to the requirementsInvolved in handling the changes in compiling scripts according to the database change.

Ahmedabad Area, India

Ahmedabad Area, India

Worked on Oracle ERP with oracle forms & report