Find Jobs
Hire Freelancers

Need a MSSQL expert to help me receive and restore an MSSQL data dump in .Bak format, extract and convert the database, and advise me re user-friendly applications for using the data for clinical research

$250-750 USD

Completed
Posted 10 months ago

$250-750 USD

Paid on delivery
SECOND UPDATE 11 JULY 2022 2.1 See updated project description from EMR company providing data dump 2.2 See updated timeline PLEASE NOTE UPDATES, 9 July 23 UPDATED BUDGET, reduced: 250-$600. Reduced because I no longer seek help to learn MSSQL. Instead, simply advice re selecting an appropriate user-friendly application for querying the data. UPDATED PROJECT DESCRIPTION: l am a retired physician, fairly tech savvy for my age (learned assembler language back in the late 60's, and then no computer use at all until the mid 80s, only as user), with access to my old electronic medical records and files, and want to use the data for some clinical research. The EMR company can provide the MSSQL/MYSQL data dump to my server in .BAK or SQL format, using Azure. I still have my office server, with MSSQL installed and running, and 532 GB of free space. which I've been assured is more than sufficient. I'll need help with receipt, recovery, extraction and conversion of the database, an appropriate schema, as well as advice regarding user-friendly higher level applications for using this data for clinical research. UPDATED DESCRIPTION OF WHAT The EMR company is providing: "A one time unencrypted database dump, all EHR data (including structured and free-text notes associated with a patient’s chart) will be part of the unencrypted copy of the database backup. This option is provided in a relational database machine-readable format (.BAK file format for MSSQL and .SQL file format for MYSQL). eCW would not be providing any table-level information nor any schema neither would be assisting in data extraction . It will solely be the responsibility of the practice to extract the data. If the data is less than 50 GB, data will be delivered via sFTP. If the data is 50 GB or more, data will be shared via Azure. I thus seek an IT expert #1. for whom the technical aspects of this job are simple, straightforward and easy: Specifically, (1.a) to assure that my MSSQL server is properly set up to receive the data, and then (1.b) restore, extract and convert the database to a logical schema for my research, and, just as importantly #2. who can help me select a user-friendly higher level application for using the MISSQL relational database for my retrospective clinical research. #3. who can explain, teach and clarify in plain language with minimal jargon. I no longer expect to learn MSSQL as originally stated for this project 7 July. Once I have installed an appropriate user-friendly application for querying the database, I expect I will not need a DBA for ongoing support with my research. If I do, that would be a separate job, not part of this project. UPDATED TIMELINE I will select a freelancer on or before 14 July.* I will put you in touch with the EMR company's project manager for this job. Your early work will be to assure my server is prepared to receive the data, but then there will be no work until late August. The EMR company will provide the dump sometime in late August. At that point you'll be responsible for recovery, extraction and conversion of the database. Once the data is delivered, the EMR compan practice must validate the data and provide feedback within 2 weeks. After you see what the database they've provided looks like, and how you might convert it, we'll engage in the selection of an appropriate user-friendly application I can use to query the database for my clinical research. I will be available until 20 Sept for this discussion, decision and initial look at the third party application. *I I'm unable to make a selection by 14 July, I will close this project and reopen it 28 July for a decision 4 August 2023. The data dump will still not happen for another 3 weeks or so. Thank you for your proposals. I will reply to all of those who can address #1, #2 and #3 above, in their own words, not parroting mine. CMS, MD
Project ID: 36849531

About the project

35 proposals
Remote project
Active 10 mos 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
$0 USD in 13 days
4.9 (4 reviews)
3.2
3.2
35 freelancers are bidding on average $575 USD for this job
User Avatar
Good day, I have understood requirements of your project & our team will deliver it successfully with 5 months FREE support but would you be flexible in your budget as our team estimate is higher? I am not sure how you selected this budget for your project on Freelancer website, because cost of any project is based on the overall features/functionality. However, If you are not flexible in your budget, then no problem and I respect it. Just so you know, I have 50+ Web/Mobile App Developers in office, UI/UX Designers team, QA developers and some other staff, so you will be working with an experienced & professionals having strong communication & prompt response. You may ignore the bid amount for now, as we still need to discuss & ask questions. Look forward to hearing from you. Regards, Yasir LEADconcept
$500 USD in 7 days
5.0 (51 reviews)
8.6
8.6
User Avatar
Very interesting to read about your tech interest, I also feel that knowledge is not bound with age. I am an expert in ms sql and sql server and have lots of experience in emr databases too, I can help you restore the database and guide you to the tools which you can use to view the data and perform analysis on them. Let’s get in touch to discuss further
$500 USD in 7 days
4.9 (61 reviews)
8.1
8.1
User Avatar
Hi there, I have read your project description and i'm confident i can do this project for you perfectly.I still have a few questions. please leave a message on my chat so we can discuss the budget and deadline of the project. Thanks. ..
$750 USD in 2 days
4.8 (80 reviews)
7.8
7.8
User Avatar
Hey there! I'm an experienced .net software developer (+12 years). I've been dealing with Msql databases since I've started to work, so I believe that I have the required skills to help and teach you how to handle and visualize the data that you need. Best Regards
$500 USD in 7 days
5.0 (68 reviews)
7.3
7.3
User Avatar
Hi, I can help you to restore the MSSQL .bak file to the MSSQL database. Regarding me, I've over 8 years of experience in development and work on lots of related projects. Let's have talked about it before we start work. Please contact me for quality work and quick services. Thanks Note: this is not an automatic and copy-pasted proposal, I first go through the requirement of the project and if I feel that I can work on that project, then I bid on it.
$500 USD in 7 days
4.9 (55 reviews)
6.9
6.9
User Avatar
Hello there, How are you doing? Just saw your project posted. I have good experience with Microsoft SQL Server, Microsoft Azure, Data Visualization, Data Extraction and Software Architecture. I read the brief details and I felt I could help you with it. Lets start the chat and discuss it in detail. Please check my porfolio: My Portfolio: https://www.freelancer.com/u/AITSoft Availability timings: 8am-8pm EST Regards, Shamshad
$750 USD in 22 days
5.0 (42 reviews)
6.5
6.5
User Avatar
Hello cmsmillie, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill set with sophisticated experience in Software Architecture, Data Extraction, and Data Visualization. As a next step I would like to discuss some further questions with you. Either over the chat or a call, whatever you prefer. For my references and qualifications: I graduated in Computer Science with highest grades from one of the most reputable universities in Germany. Currently, I am enrolled in the Master's program. During my studies, I already published a paper on the subject of Artificial Intelligence. Further, I managed to get a lot of hands-on experience by working in several companies that operate in the field of Computer Science. As a native German speaker who was living in Canada for a year, my level in English is proficient/fluent. Further, I am in the preferred Freelancer program, making me part of the top 3% on the platform. Many successful past projects can be seen on my profile page. I am looking forward to working with you and if you have any further questions I would be happy to answer them. Best regards, Simon
$550 USD in 5 days
5.0 (14 reviews)
5.8
5.8
User Avatar
Hi there! As I have read, I see you need help with MSSQL data extraction and conversion for your research project and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Appreciatively, Giovanni.
$250 USD in 1 day
4.8 (13 reviews)
5.5
5.5
User Avatar
Hi there, I’d like to work with you on this one if possible! I have 15 years of solid experience in Network and System Administration,Desktop and Technical Support. I can help you to with your current requirements .Thank you for considering my application. I look forward to hearing from you. Thanks, Muhammed Rafi
$500 USD in 3 days
5.0 (30 reviews)
5.3
5.3
User Avatar
Hi there cmsmillie, I went through your project description and it seems like my skills is a great fit for this job. I am an expert which have many years of experience on Software Architecture, Microsoft SQL Server, Data Extraction, Data Visualization, Microsoft Azure Please come over chat and discuss your requirement in a detailed way. Thank You Christopher
$500 USD in 6 days
5.0 (6 reviews)
4.0
4.0
User Avatar
Hi, how are you? I go through the description and read it carefully, I know exactly what you are looking for. I have 5+ years’ experience in these skills Software Architecture, Data Extraction, Data Visualization, Microsoft SQL Server and Microsoft Azure. I have some question about this job, Please start chat, so we have detail discussion about your task. Thanks! Umair
$750 USD in 7 days
4.9 (9 reviews)
3.8
3.8
User Avatar
Hello there! As an experienced professional in software architecture and database management, I can assist you with setting up your MSSQL server, restoring the backup, extracting the data, and providing guidance on using MSSQL for your clinical research. I will ensure that your server is properly configured to receive the data and help you throughout the process of data extraction and conversion. In addition, I can offer recommendations and resources for learning and utilizing MSSQL efficiently. Let's discuss your requirements and timeline in detail to ensure accurate delivery of your research project. I am here to provide the technical expertise and support you need. Kind Regards, Arbaz A
$350 USD in 12 days
5.0 (8 reviews)
3.9
3.9
User Avatar
Hello, my name is Bryan De Vera and I am a database administrator. I believe I am the perfect person for this job because of my strong technical background and commitment to delivering high quality work on time and within budget. If you choose me for this project it would be my pleasure to assist you with the data extraction and conversion as well as point you to online methods for teaching yourself how to use MSSQL. I would be delighted to discuss this project further if given the opportunity. Please feel free to contact me directly if you have any questions or queries regarding my profile or if you would like me to provide any additional information or clarification on any points raised in this letter. Thank you for your consideration!
$500 USD in 7 days
5.0 (3 reviews)
3.4
3.4
User Avatar
Hi, I am 39 yrs old Microsoft certified professional (MCP, MCAD) and BrainBench Certified. I have got more than 18 years experience working on .Net and various databases like MySql, Oracle, Sybase, SQL Server, SQL Azure etc. I can help you with restoration or .bak file on to your server and also help querying things and teach basics of sql. We can connect if you like my profile. Best wishes, Kamal Chand
$650 USD in 7 days
4.2 (4 reviews)
4.4
4.4
User Avatar
Hello cmsmillie, I'm really interested in your project Need a MSSQL expert to help me receive an MSSQL data dump in .Bak format, and with restoration, extraction and conversion of the data . I would like to grab this opportunity and will work till you get 100% satisfied with our work. I'm an expert who has 7 years of experience on Software Architecture, Microsoft SQL Server, Data Extraction, Data Visualization, Microsoft Azure Lets connect in chat so that We discuss further. Best Regards
$500 USD in 7 days
5.0 (2 reviews)
2.6
2.6
User Avatar
Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Software Architecture, Microsoft SQL Server, Data Extraction, Data Visualization, Microsoft Azure Please come over chat and discuss your requirement in a detailed way. Thank You
$730 USD in 7 days
5.0 (4 reviews)
1.4
1.4
User Avatar
Hello. I am a professional web developer with more than 9 years of experience in web development. I mainly specialize in website and web app development now. Given my experience and skills, your project is a great fit for me. I guarantee that I can complete your project and give you perfect results. I can start to work right away and you can call me anytime here. Let's discuss the details of the project via chatting. Best regards.
$700 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I am DataScinceFizer I would like to be your Visual Studio your project. I have extensive experience in Python, Visual Studio,Data Processing Data Mining. I have a degree in Electrical Engineering and specialize in Machine Learning data science. My major work is electrical engineering and I have worked as an EEE engineer for 13+ years with unstoppable excellent delivery. Additionally, I provide services 24 hours without any limitations and deliveries are assumed to be on time. Furthermore, rapid action on services is my motto which shows my commitment towards customer satisfaction.@DataScinceFizer
$250 USD in 2 days
0.0 (0 reviews)
2.0
2.0
User Avatar
Hello, As an experienced IT professional, I understand your need to extract and convert data from your old electronic medical records (EMR) for clinical research purposes. I will assist you in setting up your MSSQL server to receive the data and guide you through the restoration process. Additionally, I can help you navigate MSSQL and explore user-friendly applications for easier data management and analysis, considering your familiarity with technology from the late 60s to the mid-80s. My expertise in data extraction, conversion, and relational databases will ensure a smooth transition of your EMR data. Once the initial setup is complete, I will provide you with resources and guidance to empower you in utilizing MSSQL for your research. Ongoing support as a database administrator can be discussed as a separate, hourly job, should the need arise. Let's collaborate to unlock the valuable insights within your EMR data. Best regards, Zafar
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Hamden, United States
0.0
0
Payment method verified
Member since Jul 7, 2023

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.