We have a school database for a charity organization event. Schools are entered into the an administration panel of our system and then teachers are sent a code to login the portion of our site where they are able to register students, pick a lunch for each student and add the amount of wristbands they would like to have shipped to their school for fundraising purposes. At this present time having multiple schools registered under the same email causes an administrator with multiple schools to only be able to login to one school account.
The database structure has a flaw: non-unique IDs are used in places where unique IDs are required. This seems to have effects in various places of the application. We need someone with database expertise to look at the database, give an estimate and do the work.
We are effectively looking for a second opinion for what it would take to solve this problem from someone with many years experience with sql
Looking to make some money?
- Set your budget and the time frame
- Outline your proposal
- Get paid for your work
Bids on this Project
• Results-oriented professional with 4.6 years of experience in Database Development, Reporting Service and Integration Service. Hands on experience in writing T-SQL queries, Stored Procedure, UDF, Cursor, View, Triggers, Synonyms and Indexes. Analyzing, designing and implementing n-tiered, enterprise distributed applications. • Experience in writing complex query and optimization with different approaches like code optimization, indexing and normalization of database. I have also provided some solutions which are used to reduce maintance work and reusability of module in other applications. • As part of team, created various reports and integration service according to the business requirements. • Demonstrated ability to learn quickly to ever changing and new technologies. • Achievement oriented with excellent team playing skills and proven strength in problem solving, analysis and R&D. • Passionate to deliver my best for every task.
Over 13 year of IT experience with SQL databases starting from SQL 6.5, SQL7, SQL2000, SQL2005, SQL2008, SQL2008 R2, SQL2012. Various Code deploment , Testing, Security best practices
Portland, United States
MS-SQL Database Administrator since the mid-90s. Have designed and administered servers with SQL 7.0, 2000, 2005, 2008 and 2012. Expert design, performance, high availability, SSRS, SSIS and SSAS skills.
I am expert in Talend ETL Tool & SQL . I have certification in Talend, Oracle SQL & PL/SQL. I have workend with different types of Databases Oracle, SQL Server, MYSQL, DB2
Stamford, United States
I am a PMP with 12 years of IT experience. I have worked as a project manager/business analyst. I have technical expertise in Microsoft technologies (Classic ASP, VB6.0, SQL Server)
Mxicoders helps medium and small entrepreneurs to increase uses of software and value their drive. We, a custom web and native smartphone development firm, build advanced solutions to fulfill your needs. Each software solution is rigorously designed with simplicity, ease of use and flexibility. Rapid implementation means you get value from our solutions faster, with less cost and risk. Perfection is the standard, and we pursue it with enthusiasm. Today, Mxicoders serves thousands of customers across the globe. We usually get 9 out of ten in our service ratings and 65% repeat customer rate. Our goal is to provide your business with all the solutions needed to effectively monitor, manage and secure your IT environment. We will keep pace as your business grows. And we’re always making our business solutions even better. We believe in the "keep it simple" approach and implement it using the latest technology and design ideas.
I haved work for six years in IT industry as a Developer, I can provide you a very good work, with the best quality and service before the deadline. I'm expert on : SQL (6 years) Visual C# (1 years) MS Excel (macro, vba), Word, Access (6 years) Oracle, SQL Server (5 years) Business Analysis, Modelling, Creating, Manipulating and Administration Databases (3 years). I can also design logo, love creating arts and imagination
Hamilton, Sri Lanka
As a Designer, Programmer and writer, I have come a long way in my life. I'm a person with a well educated background and pure knowledge and expertise in the fields which are I'm currently doing. By joining this well organized website I'm able to use my knowledge and expertise to help the clients to complete their projects in pure quality and with best time manner. Area of Expertise o Expert in Article Writing o Expert in Data Entry o Expert in Web Programming/Developing/Designing o Expert in Transcribing o Expert in Administrative support o Expert in Web Research o Expert in Forum/Blog posting o Expert in GIS/Geo Data projects o Expert in PL/SQL Oracle o Expert in Data mining/Data Warehousing o Expert in Html/css php/java/servlets o Expert in Adobe products (Photoshop,dreamviwer..) Many more........