Find Jobs
Hire Freelancers

SQL DATABASE

$250-750 USD

Completed
Posted almost 7 years ago

$250-750 USD

Paid on delivery
You have MICROSOFT SQL server, Fast Computer, Must have extensive database knowledge. Need 214 million records that are in ASC II comma delimited format and put into SQL database. Current database is in 4 files 10 gig each. Must complete one file at a time.
Project ID: 14399910

About the project

26 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi I have been working with MSSQL for over 17 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 designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo
$555 USD in 10 days
4.9 (64 reviews)
6.0
6.0
26 freelancers are bidding on average $467 USD for this job
User Avatar
Hi, I am an experienced developer with vast experience in .NET, MVC, SQL, JavaScript, JQuery, Bootstrap available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid
$500 USD in 5 days
4.9 (32 reviews)
5.5
5.5
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$500 USD in 7 days
5.0 (3 reviews)
5.1
5.1
User Avatar
Hello, Do you want to process your csv file and save it in database i.e sql server. Right ? Can you please tell me do you want to process these 4 files one time or there will be incremental approach and files will be updated and needs to process agian. please do let me know bit more details and I'll do this job for you as I'm expert in sql server and ETL process using ssis. Thanks
$833 USD in 10 days
5.0 (6 reviews)
4.6
4.6
User Avatar
Please review my profile. Relevant Skills and Experience I have 7.5 years experience in SQL and 4.8 years experience in SSRS, SSIS. Proposed Milestones $250 USD - MICROSOFT SQL server, Fast Computer Please let me know more details and when we will start. Sky pe: jikenjd
$250 USD in 3 days
5.0 (13 reviews)
3.9
3.9
User Avatar
Hi Dear I have a lot of experience in DataBases ,Data Warehous,DB2 , Teradata etc . I am DataBases + Warehouse certified from Oracle,postgresSQL,SQL SERVER , Access. Relevant Skills and Experience I have done many work in Requirements analysis , Data Staging, Data Warehouse, DataBases. I am expert in developing ERD, Front-End, Backend, Security, Optimization, SSIS, SSRS. Proposed Milestones $250 USD - milestone
$250 USD in 10 days
5.0 (4 reviews)
3.3
3.3
User Avatar
I Have 3+ years experience in the .Net technologies, and a strong educational background featuring a master degree in Computer Science Relevant Skills and Experience -Strong database knowledge, Entity Framework. Proposed Milestones $555 USD - Default
$555 USD in 10 days
5.0 (2 reviews)
2.8
2.8
User Avatar
I am working in SQL server for last 13 years as database developer and optimization Relevant Skills and Experience I have more than 13 yrs exp as database developer Proposed Milestones $555 USD - 10% token, 60% on delivery, 30% on your testing completion Additional Services Offered $1 USD - 1 month free support Thanks
$555 USD in 10 days
5.0 (3 reviews)
1.9
1.9
User Avatar
Greetings, I am experienced database designer and MS SQL Server specialist so can help you. Please invite me to chat to discuss concrete details of the task. Regards, Konstantin
$360 USD in 7 days
5.0 (2 reviews)
0.3
0.3
User Avatar
Hola puedes contactarme al chat y explicarme bien lo que quieres hacer ya que en inglés no lo explicaste muy bien
$350 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in handling bulk data integration. I can deliver high quality and timely way. Relevant Skills and Experience I am expert in database programming (TSQL) and data integration (SSIS) with almost 19 years of IT industry experience. Proposed Milestones $111 USD - File 1 Processing $111 USD - File 2 Processing $111 USD - File 3 Processing $222 USD - File 4 Processing Additional Services Offered $1 USD - Documentation and Deployment Guide What is the Microsoft SQL Server version/edition and hardware architecture you have?
$555 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I understand the requirement. I have a good knowledge of queries. I have also done SQL Server Microsoft Certificate for Query programming. For further details you can contact me. Relevant Skills and Experience I have a good knowledge of queries and I have also done Microsoft Certificate for Query programming. For further details you can contact me. Proposed Milestones R$500 BRL - I will try to complete the queries ASAP and will provide the optimized queries on time. Please provide details of queries required.
$495 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am informatica developer with 4.5 years experience and I can complete you work in less than 5 days using informatica as i have experience loading such big files using informatica power centre tool. Relevant Skills and Experience Work as Informatica/ETL developer in MNC. I have done this task 100 time in my project Proposed Milestones $250 USD - Getting requirement and files and complete full task with minimal required time and best quality Additional Services Offered $200 USD - Any job related to current such as loading files to database.
$250 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Data Analyst with experience in database management and schema design. I can upload data from different file formats and data sources.
$388 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Your requirement is matching with my skill set, so I can take up your project and complete in minimum budget and short time as well. With the help of Simple SSIS package I can export file to SQL database.
$275 USD in 10 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PANAMA
Las Vegas, Panama
5.0
28
Payment method verified
Member since Jun 5, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.