Senior SQL Developer

$30-250 USD

完了済み

投稿日:

9年以上前

$30-250 USD

完了時にお支払い

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

プロジェクト ID: 6406043

プロジェクトについて

33個の提案

リモートプロジェクト

アクティブ 10年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@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 2日以内

5.0

(88 レビュー)

7.1

この仕事に33人のフリーランサーが、平均$240 USDで入札しています

@r4rony

A proposal has not yet been provided

$263 USD 15日以内

4.8

(41 レビュー)

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 3日以内

4.7

(76 レビュー)

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 15日以内

4.9

(54 レビュー)

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 7日以内

4.9

(24 レビュー)

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 7日以内

4.2

(42 レビュー)

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 6日以内

4.9

(16 レビュー)

4.7

@nurakantech

A proposal has not yet been provided

$155 USD 3日以内

5.0

(9 レビュー)

4.3

@GhaziOualha

A proposal has not yet been provided

$366 USD 3日以内

5.0

(2 レビュー)

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 5日以内

4.9

(13 レビュー)

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 14日以内

4.5

(16 レビュー)

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 3日以内

4.9

(7 レビュー)

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 10日以内

4.8

(9 レビュー)

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 4日以内

5.0

(1 レビュー)

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 2日以内

5.0

(2 レビュー)

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 20日以内

1.4

(1 レビュー)

2.9

@bmsm3n54

A proposal has not yet been provided

$222 USD 3日以内

5.0

(1 レビュー)

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 3日以内