Access/MS-SQL Advanced Database Project (Part Two)
Looking for a database freelancer to work on large projects on an on going basis. This could be stable good money for the right person. We need a freelancer with enough time free to work on complex things when we need to, not someone that can only work a few hours a week at night.
This job project here is a small sample of the work to proof yourself qualified and able to work well with our team.
The job requires you to go to about 8 different websites (which we will provide) and download certain databases in multiple different formats, CSV, DBF, TAB etc and with different columns. This data is similar but with different heading and structure. Your job is to follow our instructions (which will be provided) to normalize the data into a single SQL database, which you will send to us.
We will provide detailed instructions on how to download, process and load data from 4 different websites. The remaining 4 other websites and data you will need to figure out how to do, however, if you work on the first 4, you will have experience already in what we need the data to look like, so this should not be a problem to any database person.
This process takes us approximately 2 days to complete in-house, obviously we are looking for someone that will be able to do this in a similar amount of time.
Working advance knowledge in the following:
• MS Access data processing:
o Must know how to work with raw tables (field/table definitions, relationships, etc)
o Import/Export from/to different formats (SQL, CSV, DBF, ETC)
o Build and run queries (append, update and select queries a must!)
o Integration with MS Excel
• MS SQL <--- MUST HAVE INSTALLED AND USING
o Required knowledge of MS-SQL queries or
o At least working-intermediate knowledge of conversion to and from MS SQL
o PostgreSQL and MySQL knowledge desired but not a must
o Must know how to troubleshoot (normalize and standardize) “bad” data
o Must be able to figure out gaps in instructions to make sure there is little to zero down-processing-time
o Must know how to navigate, search and update through Internet links and broken links
34 freelance ont fait une offre moyenne de 505 $ pour ce travail
Dear Sir/madam I have +5.5 year experiences in ms access programming ,mysql and oracle programing. To Provide Quality,modular and object oriented coding. Thanks & Regards
I have expertise in SQL. I can assure you will be fully satisfied. give me some sample data so that I can tell you my approach for the solution.. please feel free to communicate.. thank you
I have over 10 years of experience in handling databases. I have worked with access, SQL server, oracle and mysql databases. Looking forward to work with you. Regards, Selvan
hello brother i am professional DB developer in my firm and doing this job since 2010 i have vast industry experience and i can do this job very efficiently