En cours

Access/MS-SQL Advanced Database Project (Part 3)

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

• General

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

Compétences : Administration de Bases de données, Microsoft Access, SQL

Voir plus : sql queries freelancer, sql data conversion, sql database freelancer projects, projects freelancer using excel, postgresql freelancer, part time night job, part problem, mysql database free download, intermediate excel, import export freelancer project, work money freelancer, work freelancer project, freelancer sql database, freelancer search sql, freelancer raw process, freelancer qualified person, freelancer projects excel, freelancer night, freelancer good bad, freelancer going, freelancer access job, first freelancer, export project, data structure definitions, data conversion sql

Concernant l'employeur :
( 42 commentaires ) San Diego, United States

N° du projet : #8540192

Décerné à :

mpalgeo

Hi I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have de Plus

555 $ USD en 5 jours
(24 Commentaires)
5.1

34 freelance ont fait une offre moyenne de 505 $ pour ce travail

fabest

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can get your data and merge them. As you can see I have very good rate, you Plus

684 $ USD en 3 jours
(30 Commentaires)
5.8
gkalish

Having 8 + years experience in MS Access, SQL Server and full time freelancer. I am willing to join in your team and will do my best

833 $ USD en 10 jours
(139 Commentaires)
5.9
Neno585

Just to thank for the invitation, I have read the description and sadly, looks like I will not be able to work for you as I have full-time job and I can't work as much as you require. It is shame as I am qualified in a Plus

555 $ USD en 10 jours
(19 Commentaires)
4.8
frehmanpk

Respected Sir, Actually I have huge experience in data integration and I have developed a tool called Cross Platform Data Integrator in which I automate download of data files, process them, map data structure, out Plus

555 $ USD en 3 jours
(20 Commentaires)
4.6
rkumarvw

Hi, Greetings !!! Given that you are looking for an experienced MS-SQL Developer to work on your project requirements I can do an excellent job for you which will give you full value for your money. With my ex Plus

722 $ USD en 10 jours
(6 Commentaires)
4.4
farr4u

HI, Access and Excel VBA expert here, I offer you access application with very user friendly forms having functionalities like auto filling easy data selection through dropdowns, these forms will be for performing data Plus

250 $ USD en 10 jours
(20 Commentaires)
4.4
Altantsetseg

Hello, From your project declaration, its the kind of job I have been experienced very well. I had been working as a senior programmer responsible for financial system developed in MS Access for over 6 years. That Plus

444 $ USD en 2 jours
(8 Commentaires)
4.4
pnjadhav

A proposal has not yet been provided

750 $ USD en 10 jours
(4 Commentaires)
4.1
bspanovic

Hello I'm Microsoft Certified Database Developer. My Microsoft transcript you can check on this link: http://89.38.210.110/myfiles/MS_Learning_Transcript.pdf I have 20+ years experience with Access and 15+ with Plus

250 $ USD en 2 jours
(4 Commentaires)
3.7
lukaszoz

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Plus

250 $ USD en 3 jours
(4 Commentaires)
3.5
zu02

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Acc Plus

555 $ USD en 10 jours
(2 Commentaires)
3.5
swarm22

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

555 $ USD en 10 jours
(5 Commentaires)
2.9
axiomswb

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

277 $ USD en 3 jours
(5 Commentaires)
1.9
rafaelnadal

Hello I am Software Engineer and expert in database analysis and design so you can consider me for this Project Thanks

250 $ USD en 10 jours
(2 Commentaires)
2.9
mmuthamilselvan

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

277 $ USD en 5 jours
(2 Commentaires)
1.9
Mazharhameed91

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

666 $ USD en 10 jours
(1 Commentaire)
1.6
ggopi

Hi, I am Gopi here. Please send me further details. I ready to start your project immediately. Regards Gopi

555 $ USD en 10 jours
(1 Commentaire)
1.4
ufasoft

Hello! I can help in this project! I have the 16 years of experience in the field of automation of the financial sector and trading companies. I am an expert in the field of databases: MS Access; SQL Server 2000-20 Plus

388 $ USD en 15 jours
(2 Commentaires)
1.2
tommydevoss

A proposal has not yet been provided

750 $ USD en 2 jours
(0 Commentaires)
0.0
msoonasra

• Excellent Project Management skills including project planning, scheduling, estimating, monitoring, reporting, and tracking results for projects and/or small work requests. • Successful at partnering with the busine Plus

500 $ USD en 10 jours
(0 Commentaires)
0.0