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天之内