Senior SQL Developer

$30-250 USD

Завершено

Опублікований

over 9 years ago

$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 yrs ago

Хочете заробити?

Переваги подання заявок на 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 дні(-в)