Find Jobs
Hire Freelancers

MS SQL Server Database Project

$750-1500 USD

Completed
Posted over 2 years ago

$750-1500 USD

Paid on delivery
I am looking for a SQL Server database administrator with deep MS SQL Server experience. The project is to: a) write T-SQL scripts to find and clean up old data and orphan data b) set up horizontal partitioning (sharding) on selected tables There are approximately 30 database tables with between 100,000 and 25,000,000 rows each.
Project ID: 31481034

About the project

39 proposals
Remote project
Active 3 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
$0 USD in 180 days
5.0 (89 reviews)
6.5
6.5
39 freelancers are bidding on average $1,108 USD for this job
User Avatar
Hi, I can work with SQL Server and clean up database as per your requirements. I have over 14 years of expertise in SQL Server Full Stack. Regards, Muhammad Ali Safder
$1,125 USD in 7 days
5.0 (46 reviews)
5.2
5.2
User Avatar
Hello, kind regards, currently I have more than 10 years of experience working with different data management systems such as SQL SERVER, POSTGRESQL, MYSQL, MARIADB, I am the ideal person for your project, visit my profile without obligation.
$750 USD in 7 days
4.9 (25 reviews)
4.8
4.8
User Avatar
Greetings. I am MSSQL DBA. Total 19 years of IT experience. Since 8+ years working as dedicated MSSQL DBA. I can help you in horizontally partitioning tables using "Partition" feature available in MSSQL. Regarding cleaning and delete orphan data, I can commit after discussing in detail. Looking forward to work with you to complete the task. Thanks & Regards, Milind
$750 USD in 7 days
5.0 (24 reviews)
4.3
4.3
User Avatar
Senior Data Analyst with over 30 years' experience interpreting and analyzing data in order to create successful business solutions. Provide insight, analytics, and business intelligence needed to guide decisions. Over 15 years of experience as a SQL Server/Business Intelligence developer in database designing, modeling and reporting using SQL Server, SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services. Business Intelligence and Analytics experience in using data visualization tools such as Tableau and Power BI with DAX to make large and/or complex data more accessible, understandable and usable. Transforming, improving and integrating data, depending on the business requirements to deliver the data in a useful and appealing way to users. Experience in creating Tabular and Multidimensional models to provide insight into large data sets using a variety of front end tools. Strong background in statistics with knowledge of research.
$1,125 USD in 7 days
5.0 (1 review)
4.3
4.3
User Avatar
Hi, I've read the description of your posted job with the title "DB Developer”. I’m doing this job for the last 7 years. Which carries out different complexity level SQL/MySQL/PostgreSQL/MS Access task few of them are mentioned below, 1. Database Creation from Scenario 2. Create ERD from the documentation. 3. Extraction of Data from database through quires. 4. Writing Store procedure and views. 5. Indexing, look after query performance. 6. DB backup and restoration. 7. Data analysis and attractive visualization dashboards with (Tableau and Power BI) 8. Custom Visualization (I can show my works screenshot in chat). 9. Customize dashboards using different apps as a data source(Acumatica/Healthcare apps) I can give you my best rates for this role because I know I can do it in a better way. Thanks, Sufyan Jamil
$1,200 USD in 7 days
4.8 (7 reviews)
3.3
3.3
User Avatar
I have more than 15 years of experience in SQL Server database modelling, design, development, and Administration. I have worked for database designing and modelling of complex business an efficient way. I have very good experience in TSql, writing complex scripts, complex stored procedures, functions, triggers etc. I am good with performance tuning which includes Index and its usages, JOINS, dynamic queries, CTE, Temp tables, Table variable, and all its usages. I am also good and working with big clients for BI part like SSIS, SSRS and SSAS. Created different workflow PACKAGES and reports for clients. I also involved in Data warehouse design form OLTP systems. I have worked with medium to large mission critical databases. Worked as DBA for 24*7 support environment. Involved in activities like Performance monitoring, Log file maintenance, deadlocks and blocking handling, disk space management, Job monitoring and failure handling, Backup and recovery process for disaster management. I assure you that you will get complete satisfaction regarding my work and output. Looking forward to work with you. Thanks Anil
$1,667 USD in 40 days
5.0 (6 reviews)
3.3
3.3
User Avatar
Hello. I'm very happy to bid on your project. I've just read your description and I'm interested in your job. I am a senior PHP developer with 8 years of experience in Web development. I have the strong experiences in Wordpress, Shopify, Laravel, CakePHP and web design. Building user-friendly websites and applications is truly a passion of mine and I am confident I would be an excellent addition to you. My Skills: - Laravel, Yii, CakePHP, Wordpress, Shopify - HTML5, CSS, Javascript, JQuery - MySQL, Sqlite, MSSQL, MongoDB - SEO and API Integration I'll do my best for you and provide you satisfied results in a short time. I hope we will discuss more details about your project. Looking forward to your reply. Best Regards...
$1,000 USD in 5 days
4.6 (1 review)
3.2
3.2
User Avatar
Hello. I have read your description very carefully and I can complete it perfectly in short time. I am a new freelancer, But I am confident in my skills and always value for client's trust. So I have rich experience in these fields. I can use the SSMS, SQL Server to complete your project. I have done this kind of work several times so I know how to do this. I'd like to help your business by doing my best. If you hire me, I will do my best for you. Let's meet and discuss more. Best Regards.
$1,125 USD in 7 days
4.7 (3 reviews)
3.1
3.1
User Avatar
We have a expert team in SQL server to do this task . Let me know if you need any support on SQL server database.
$1,125 USD in 7 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hi, -Im an expert dba in oracle (ocp certification) , postgres, sqlserver, and mysql, and database developer on plsql tsql(15+ years exp) Complementaries: im a java (springboot, struts, selenium ) and python developer with 15+ years of experience in sandalone, web , and service oriented (REST) applications in business like retail, insurance, education. -ci/cd, pipelines, git, docker, aws, experience I am confident I can provide you efficient solution. Here I put a bid amount and days that be fixed after understanding the project details (dicts, tech, size) I'm looking forward to your response, to help you in the Dba tasks
$1,125 USD in 7 days
4.9 (4 reviews)
2.8
2.8
User Avatar
Hi, I have over 10 years experience in SQL Queries, Stored Procedures and Functions in MS SQL and MySQL. As a administrator of big size databases (>1TB), I'm really interested to do your job. I'm new to this platform, Trust me, I try my best to do your job ASAP. Let's Chat and talk about it.
$750 USD in 7 days
5.0 (3 reviews)
2.9
2.9
User Avatar
I understand that you want to remove hanging orphan records and historical data as the first step Do you have any criteria to identify the historical data that needs to be removed ? i.e like a timeline before which we can remove ? Also what's the criteria for sharding you want to use ? is it based on a time period or is it fixed number of maximum records per table ?
$1,125 USD in 7 days
5.0 (2 reviews)
2.8
2.8
User Avatar
Hi I have 15 years work experience in MS SQL Server, I am expert in writing T-SQL and have sound knowledge in Database Administration. Message me for further details. Thanks
$1,200 USD in 7 days
5.0 (1 review)
2.4
2.4
User Avatar
Hi There when viewing your job details, it really jumped out at me. You are looking for a SQL Server database administrator with deep MS SQL Server experience I have a question What's your time Duration In this Project ? I can show you my work on your request over chat. looking forward to your reply. Thank you Mohammad M
$1,250 USD in 9 days
5.0 (1 review)
2.1
2.1
User Avatar
Hi Sir, I have lot of experience in MS SQL. More than 25 projects working fine. I will show you demo of my work if you want. Hope you look forward to work with me. Thank You.
$750 USD in 7 days
4.1 (5 reviews)
2.1
2.1
User Avatar
Dear Sir, Greeting of the day!!! My name is Dharmesh Gajera and I am an expert in SQL. I have more than 7 years and 9 months of experience in SQL. I would love to have the opportunity to discuss your project with you. To complete your project I would review your existing data. This will help me to complete this project effectively. I have worked on the below projects: 1) More than 300 lines of Store procedure code which is calculating consumption. 2) Prepared a store procedure to find domain names from email addresses. In response to your task: 1) I have expertise in SQL. 2) I can start work right now. 3) Just let me know if we can finish this project together. Thanks & Regards Dharmesh Gajera
$1,125 USD in 7 days
5.0 (2 reviews)
1.2
1.2
User Avatar
****Database and database converting program developer**** Hi, there. I wish you are safe from Covid-19. I am a creative and professional Database and database convert application developer having more than 5+ years of professional experience as a senior developer in this field. my main areas of expertise are MySQL, Access, Oracle, MongoDB, hadoop and other bigdata king. So i ensure to finish your project within your deadline. If my project have some problems, you don't need to pay me. Thanks.
$1,125 USD in 10 days
5.0 (1 review)
1.0
1.0
User Avatar
Greetings, I have read the Job Description and understand that you are in need of MS SQL Server Database. We have huge experience in Software Developement including Database Management. We can handle and complete your project perfectly under your guidance. Please send me a message so we can discuss more. Thank you Ravi
$1,200 USD in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have 7+ years experience in asp.net c# with MSSQL database. I have a good command in MSSQL Database and its script. I have already manage a financial software where lot of the table and data are stored in millions of rows. where I worked and manage this MSSQL database. I have good knowledge of database so I can manage this database. Payment is not issue for me . My work satisfied you then you pay me
$1,125 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an Experienced ETL Developer. I can provide services related to data migration, data cleansing etc. I have experience in writing large queries I have used tools i.e Pentaho for ETL It will be a great opportunity for me work on your project. Please inbox for more details and discussion, thank you. Best regards Amir
$1,125 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
Cape Town, South Africa
5.0
8
Payment method verified
Member since Jun 10, 2006

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.