Yogesh Jadhav

Epsilon is a global marketing company. I have joined this organisation recently and I'm supporting Greenplum and PostgreSQL database.

Greenplum and PostgreSQL:

Broadridge is multinational financial solution provider company.

Greenplum:

• Maintaining database to perform well.
• Taking backup(pg_dump,parallel,ddboost) and restoring the same.
• Working with developers for tuning the queries and advising session level parameter by understanding query resource requirements.
• Working with work load manager.
• Loading and unloading data using gpfdist.
• Managing Security of database.
• Creating python,shell scripts to automate administrative tasks.
• Troubleshooting on various issues in case of failure and performance issues.

PostgreSQL:

• Having good knowledge in PostgreSQL architecture.
• Database Backup and Recovery SQL queryTuning,Usermaintenance,TablespaceManagement,HotStandby and Replication,PITR.
• Experienced in Performance Tuning Query Optimization,Client/Server Connectivity and Database consistency checks using diferent utilities.
• Experience in monitoring and maintaining testing and production environments.
• Implement and configured PostgreSQL Replication for hotStandby,Synchronous and Asynchronous types of replication and handled.
• Experience in Backup & Recovery using PG_DUMP,pg_backrest.
• Creation of Clone Database for Development/Testing Environments.
• Proficient in PostgreSQL DBAactivities including configuration settings. database index creation, maintained and Queryoptimization.
• Implementing and maintaining database security by creating roles and its privileges.
• Monitoring the production PostgreSQL alert logs for database errors,controling the database connections clearing the blockings to take necessary actions to rectify them.
• Worked on Vacuum-Reindexing-Analyzing the databases in PostgreSQL
• Formulated Auto-vacuum for various Databases.
• Scheduling the jobs in Crontab.

MarkLogic:

• Installing and upgrading Marklogic Server.
• Configuring database setting as per the requirement and resources available.
• Performing database maintenance like reindexing, merging, rebalancing and etc.
• Working on database backups and database refresh within the environments.
• Automating administrative tasks using python and REST API as well as Shell scripting.
• Managing Security of database.
• Working with Application team on deployments.
• Building corb2 jobs to perform jobs in batch like deletion, permission updates and etc.
• Working with mlcp utility for importing and exporting data.

During 1.7+ years of experience as greenplum database support engineer, I have supported multiple greenplum database environment of Pivotal's customers.

While working here, I have supported all kind of issues like:

• Installing/upgrading/configuring Greenplum Database environment.
• Troubleshooting and recovering failed segment instances.
• Managing master failover issues.
• Confuguring Greenplum Command Center.
• Working on greenplum expansion.
• upgrading customer database both out of family databases as well minor upgrades.
• Fixed catalogs for customer with inconsistencies in pg_class , pg_attribute,pg_type or persistent rebuilding regularly on customer system.
• Recommending Database Configuration as per customer's use case.
• Providing root cause analysis on issues to the customer and much more.

Here I worked as EMC DCA Support Engineer for EMC(Our Client). While working here, I supported global customers of EMC Data Computing Appliances with all types of hardware issues and failures.

Fundamentals of MarkLogic like database, forest and application services

Three days training of Advanced administrative tasks of MarkLogic Database Server