Write some SQL Stored Procedures and optomise code

Greetings, I have read Project Description & can you please provide me more detailed requirements? I have a DB expert having 10 years of experience, so I can assign him this work. At the moment, my bid is just a placeholder, as I cannot submit the proposal without entering any amount but once you respond us, we can then finalize the estimate. Look forward to hearing from you. Regards, YK LEADconcept

Hi, I have 9 years experience in development and deployment that includes SQL Server, SSRS, SSIS and .NET. Involved in SQL Server activities like Installing, Migrations, Table Partitioning, Configuring maintenance jobs, Optimizing etc. I have expertise in writing complex queries with proper joins and index selection. Involved in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. Microsoft Certified Technology Specialist in SQL Server. Thanks

Hi I have been working with MSSQL for over 15 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits the reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hi there, Nice to meet you. I hope you are doing well with your business. My name is Manh, from Vietnam. I am highly interested in your project. I am very good at SQL. I have been working on this site for more than 4 years with many successful and interesting projects. I am willing to help you do your business with high quality and on time. Please contact me and we can discuss further on timeframe and cost.

Hello, I am a Microsoft Certified Solutions Master: SQL Server and a Consultant working as a Developer and DBA. I have had 15 years experience. I have my own website http://www.nicholsonsql.com. I have experience with many companies small and large. If you have any questions let me know.

Hello, I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan

Hi. I have a computer engineering degree from CMU and 20 years experience doing admin, programming, and performance tuning. I've written a lot of stored procedures though they only speed up the operation about 20%. Typically, the query is bad to begin with, I'd like to have a look at your code, look over the queries, and put in some timing information to narrow down the problem. I know PHP and MySQL extremely well, so I should have no problem fixing this quickly.

Hi I am a database expert with 12 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. With my domain expertise in the ERP, when ever I have a business requirement, I can easily look into a database, identify the required tables and write the required query for that. I have no experience with Access Dimensions, FocalPoint, or Weighbridges but I can get hold of it, if this is going to be a part of the job. Can you please more specific details on the job, so that I can place a more accurate bid. I can connect on team viewer or on a RDC and work on your server, that is how I normally work on remote SQL databases. Thanks Roni

I am a sql server dev with experience in optimising queries to boost the performance of the application and its usability.

Hello! I am a highly qualified business professional, currently doing my doctorate in economics and have tons of writing experience, I am very much excited and deeply interested in bringing laurels to your assignment, please assign me this task without any hassle and you will experience quality work on time. I am 100% Sure, you will award me all your writing tasks once you witness the quality of this task. Thanks!

Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assistant, Database Migration Assistant,SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN. Oracle Appex, forms, Reports. Let me know when can we discuss more.

Hello, I have been working with a MNC bases company since last ~ 4 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. Delivering best & Customer satisfaction is the key for any individual and I always work keeping these things in mind during project execution. Apart from above also successfully completed Database & Informatica Training for a US based Training Organization. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish Seth

SQL Server DBA with 7+ years of experience, I have expertise in creating ssis packages, ssrs reports and sql server performance tuning

Hello, I'm Tomislav from Croatia. I have 8 years experiance with MSSQL / T-sql - stored procedure - view - trigger - function - SSIS - DTS, DTSX (transform dts->dtsx) - data migration / data manipulation ....... I also have experience and in VB6, Crystal Reports ver 8.5 and 2010 R2. Please se my MS cert ! Kind regards, Tomislav

1) It needs to update the logic of the procedures. Please send examples of what needs to be done. I have a period of one month, as I do not know the whole volume of works. After discussion, the need may be less or more time. 2) I have extensive experience in the development and updating of existing stored procedures. I work for a telecommunications company and I had to perform similar tasks. 3) For the project I need will have access to your test environment or a copy of the database and services. 4) Please contact me to discuss the technical details of the project.

Hello, We have about 20 years experience with SQL Server - application development, code optimization, tuning. And have been working for clients at - Canada, US, Mexico, Brazil etc. We are confident to help you with your project. Thanks!

if you write what service is about and how many procedures need to be optimized, the cost and time can be less or more

A proposal has not yet been provided

Предложение еще не подано