PostgreSQL User Needed - CRM Database Cleanup
Budget: $1,500 – $2,500 USD
We are seeking an experienced PostgreSQL User. We use NationBuilder as a donor management and donation tracking database. After our transition to NationBuilder involved a few different data imports, we see that there are redundant/duplicate donations in the system. We'd like to work with someone that can help us clean up this duplicate data in the system by exporting the database, cleaning it up, and reuploading to our system.
The downloaded file is in a "PostgreSQL.pg_dump" format. To work with the data, it has to be uploaded into a local PostgreSQL database, using the instructions in the attached file. We need someone to write the queries involved in finding and removing duplicates, then create a new .pg_dump file that could be uploaded into NationBuilder. All this has to be done quickly during a period in which nobody else adds or changes data in the Invertigo Dance database on NationBuilder.
Invertigo Dance Theatre is leading Los Angeles dance company sharing the benefits of dance and storytelling with people of all ages and abilities.
The downloaded file is in a "PostgreSQL.pg_dump" format. To work with the data, it has to be uploaded into a local PostgreSQL database, using the instructions in the attached file. We need someone to write the queries involved in finding and removing duplicates, then create a new .pg_dump file that could be uploaded into NationBuilder. All this has to be done quickly during a period in which nobody else adds or changes data in the Invertigo Dance database on NationBuilder.
Invertigo Dance Theatre is leading Los Angeles dance company sharing the benefits of dance and storytelling with people of all ages and abilities.
Related categories:
MySQL
Database Administration
PostgreSQL
Database Programming
Database Development