Dharmesh A.

ABOUT ME

• Carrying 13 years of IT experience with various database technologies. Working Knowledege of PostgreSQL,MS-Sql,Oracle Databases.
• In depth practical knowledge of Installation, Configuration and Cloning of database instances, Upgradation & Implementation on Windows, Linux platform.
• Working Knowledge of Postgis Developing with Geometrical Datatypes and Various postgis functions.
• Knowledge of Hadoop Framework Component Hive,HBase,Yarn,HDFS System.
• Knowledge of Oracle/PostgreSQL/MS-Sql 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.
• Exposure in Database Administration activities like Database optimization, Query Optimization.
• Extensive DBA experience in maintenance, development, logical(Datapump, pg_dump)/physical backups and various recovery techniques.
• Working in Microsoft Azure cloud environment.
• Partitioned tables in Production databases to improve performance.
• Expertise on Automation of processes using cron job schedulers.
• Highly complex business logic, Rules processing and report development with SQL & PL/SQL using stored procedure, function, triggers and some other advance features.
• Expertise in Postgres SQL developing skill , proficient in T-SQL writing stored procedures, triggers and functions.
• Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time.
• Migration experience from Oracle to Postgres, Postgres to MS-SQL. Performed migration till 5 TB of Databases.
• Ensuring database statistics are updated and healthy. Performing automated(via OS scheduler) statistics gathering(using vacuumdb/VACUUM) to avoid unexpected performane issues.
• Installing & managing various exteansions in PostgreSQL.
• Implemented pooling mechenisam using pgbouncer & Pgpool-II. And tested failover & load balancing using Pgpool-II.
• Periondically verifying frgmentation/bloat on tables/indexes and performing debloating using VACUUM FULL.
• Implemented High Availibity in Linux/Windows environment using streaming replication. Also performed switch over and failover in a postgreSQL enviroment.
• Expetise in managing file group space management in MS-SQL database.
• Performed job scheduling using sql server agent(MS-SQL) and dbms_scheduler(Oracle) with manaing,creating and debuging options.
• Team player with excellent interpersonal, analytical and communications skills.
• Trouble shooting the problems encountered in day-to-day activities.

SKILLS