Senior SQL Developer

$30-250 USD

Completed

Posted

over 9 years ago

$30-250 USD

Paid on delivery

The goal of modification is to normalize database and create extra tblMemberDetails table which will consists of all details of Member. The Requirements which must be done: 1. The table tblMember should consist of minimal number of fields. 2. Instead of filed “Position” in DB which determine the binary tree position of Member should be added two fields: “leftside” and “rightside” fields 3. Stored Procedures should be rewritten according to the new database scheme So you will need to get tblMember Table as: MemberID, LeftSide, RightSide, MemberDetailID All other fields you will have to shift to new table tblMemberDetail. We have approx. 180 stored procedures in DB. Stored procedures based on common T-SQL. We are not using CTE or some other Advanced SQL technique. Most of them you will need to rewrite. It should be done ASAP. Skill set: SQL, SQL Server, Database Development, Engineering, and Software Development check the file and only bid if you know what i am looking for.

Database Administration

Microsoft SQL Server

MySQL

SQL

Project ID: 6406043

About the project

33 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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:

@bigdognec

I have gone through the doc. 180 stored procedures is a pretty large number to go through for the mentioned budget. Also I have a suggestion for a much better performing structure for a binary tree stored in SQL. I have implemented it in some custom MLM websites that I have created.

$175 USD in 2 days

5.0

(88 reviews)

7.1

33 freelancers are bidding on average $240 USD for this job

@r4rony

A proposal has not yet been provided

$263 USD in 15 days

4.8

(41 reviews)

7.4

@riskypathak

Hello. I have good expertise in database optimization. I have gone through requirements and the work is my cup of tea. So in short I have to modify tblMember and store procedures accordingly Thanks

$189 USD in 3 days

4.7

(76 reviews)

7.3

@feninsoftech

Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expertise in writing complex queries with proper joins and index selection. In past, i involved in balancing between concurrency and locking and lock escalation. Microsoft Certified Technology Specialist in SQL Server. Thanks

$277 USD in 15 days

4.9

(54 reviews)

6.8

@smshafiqulislam

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 7 years of experience. I am expert in database design. ERD, DFD, Physical schema, normalization etc. I did lots of similar projects in freelancer. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://www.freelancer.com/u/smshafiqulislam.html I am confident on delivering quality. If you wish, I can show you my existing projects. Rgds, Shafiq

$222 USD in 7 days

4.9

(24 reviews)

5.2

@acronymsolutions

Hi, I have gone through your requirements.I am a DBA at CMMI-5 Level company since August 2002.I am working on MS Access,MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.

$235 USD in 7 days

4.2

(42 reviews)

5.8

@abdellatif81

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases, i have more than 8 years of experience working around databases and SQL development around (SQL Server ,Mysql ,Oracle ) . My last job was database consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database development and SQL to develop all types of requirements related ,and given my experience, I am persuaded to give you High quality of work delivery withing budget and time Best regards,

$244 USD in 6 days

4.9

(16 reviews)

4.7

@nurakantech

A proposal has not yet been provided

$155 USD in 3 days

5.0

(9 reviews)

4.3

@GhaziOualha

A proposal has not yet been provided

$366 USD in 3 days

5.0

(2 reviews)

4.3

@AImran

An Expert web application developer having 12+ years of experience with ASP, ASP.NET, ASP.NET MVC, VB.NET, C#.NET, VB, VBA, MS SQL Server, MYSQL, MS ACCESS, Oracle, WCF, LINQ, AJAX, JQuery, Crystal Reports, web & window based services etc.

$150 USD in 5 days

4.9

(13 reviews)

4.5

@DeoTech

Hello, I have more than 12 years experience in MS SQL. I am using MS SQL 2008 and 2012 editions. I can help you in your project. Regards.

$277 USD in 14 days

4.5

(16 reviews)

4.6

@daveclary

This can be done fairly easily. You mentioned 180 stored procedures? This might take time depending on complexity. It can be done though. Let me know when you want to get started.

$222 USD in 3 days

4.9

(7 reviews)

4.0

@pramodv

I have 10+ years experience of software development using Foxpro2.6(dos), Visual Foxpro 6 & 9, SQL Server 2000,2005,2008, C#, ASP.Net, MVC, Crystal Reports,MySql, HTML, CSS, JavaScript, jQuery and jQuery UI. I have developed lot of client/server database softwares like Accounting, Inventory, Taxation, Payroll, Production, ERP Implementation and more. I am proficient in MS Sql writing complex queries, stored procedures, functions, triggers, query optimization and performance tuning. Thanks! Pramod

$300 USD in 10 days

4.8

(9 reviews)

3.3

@grundahl

Hi, I'm a professionnal Database administrator. I can do your work efficiently. First "normalisation", then script to adapt stored procedure to the new schema. If i read correctly your needs, technically speaking, you need a de-normalisation for performance. The field MemberDetailID is not needed because the table tblMemberDetail can use the same primary key as tblMember : MemberID. Waiting to work for you. Eric

$250 USD in 4 days

5.0

(1 review)

2.7

@vizgro

We are a group of designers and developers who work as full-time employees in different companies and in part-time work as freelancers; and that way we can keep our cost low. So you get best in class quality at very affordable rate. Don't you worry about the quality, because that is the main area that we thrive to maintain all the time. Thanks, Vizgro Consultancy Services

$30 USD in 2 days

5.0

(2 reviews)

1.3

@n1mediasolutions

Hello there, I read your project description and we are ready to build a unique website for you based on your requirements. We are highly experienced in this field and are specialised in most of the features in web development. Kindly consider us for this project and let us know more details about this project whether you are having your own domain name or else whether we have to suggest a domain name for you? Awaiting for your acceptance! Thanks. Marketing Team

$200 USD in 20 days

1.4

(1 review)

2.9

@bmsm3n54

A proposal has not yet been provided

$222 USD in 3 days

5.0

(1 review)

1.0

@CelusB

Dear Hiring Manager, I have an experience of 1 year and half working full-time as a software engineer in an Indian IT company. During that period I worked with in a team and managed more than 10 modules of different projects. I was also in charge of client communication and assigning works for my juniors within the team. Last year I got an opportunity to come to Japan to study Japanese .Currently I’m studying Japanese from Musashi Urawa Japanese language school for the last 10 months. During my last job I learned much about different programming languages, how to work efficiently within a team and how to manage the clients. And I feel that I could be a valuable asset for this project with my past experience . Thank you so much for your time. Best Regards, Celus Berchmans Olayam

$155 USD in 3 days