Database optimization

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

Hi I have been working with MSSQL for over 17 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 dashboards via Power BI and 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

I can help you.

Hello, I am interested in your project. I am a software engineer and I have professional experience with SQL. Thank you, Best regards, David

A proposal has not yet been provided

Hello, I have all the skills and experience that makes me a competitive candidate for this post. I have had an ideal prospect and am ready to accept any new challenges that may be put in front of me. If given an opportunity to work for your company I will fulfill the given work with utmost dedication and loyalty. My Freelancer Profile: https://www.freelancer.in/u/punitpuneet2008.html I always give my 100% effort to do my job and client’s satisfaction is my first Skill When working on a new project, I like to speak with my clients so that I can have a clear understanding of their needs and vision of the project. I would like to request you to write back to me along with your preferred time and medium to get in touch and take this opportunity forward. I am looking forward to you & I hope to hear from you soon. Thanks and regards,

MM. Hi, I am a SQL developer. I will optimize your procedures. Please give me some more details of your project. So that we can take things forward. Thanks.

A proposal has not yet been provided

Hi. I believe that this project should be done as fixed-price. You only pay if you're satisfied with the result. Please, contact me to discuss details.

Dear Employer , we are experts in Microsoft BI stack , SQL Server ,C# , ASP.Net . we work for Microsoft as consultants and this is first time we are entering into the freelancing world. we are good at data entry projects and filling forms or websites. we have expertise in Excel Macros , Excel Dashboards , spread sheets , tables ,excel analysis etc... we are certified from Microsoft in SQL Server , Oracle ,MSBI. we want to make our foot prints so strong in freelancing world and we need a opportunity to prove our self. we have completed 2 projects successfully and looking forward to work with you. Looking forward to hear from you. Please feel free to ping us.

I'm a software engineer with 15 years of experience. I have a BS degree in Comp. Eng. and MSc in Computer Science. I have worked extensively with SQL Server and MySQL. I can easily help you optimize and normalize your tables and improve the performance of your queries within the stored procedures.

From project description, I have understood that you DB is MS SQL Server. I will have to review all SQL statement within stored procedure based on your business requirement and optimized the performance. I think I am perfect for this assignment as I have 4+ years of experiences in .NET technologies with MS SQL Server 2008 R2 as backend.

I am system analyst() and currently working as system administrator (Angola Telecom), I am not expert in the subject of database system management, I like to work with data modeling, I study continuously the sql language to understand the Best practices for database disign. I believe in being able to apply my knowledge to build the solution best suited to your need.

Hello, I would like to take this assignment. I am having 12 years of experience on web development and deployment. Below are my core technical skills 1 ASP.Net /HTML/CSS/Javascript 2 C# SOLID Design Priciples 3 MS SQL and non relational databses like Azure Table storage, Azure Document Db and MongoDb 4 Entity Framework (Database first, Code first and OData) 5 Azure Service Bus, N Service Bus and Azure Service Fabric 6 Restful Api Development(using c#) and deployment on cloud 7 Team City and Octopus Server for Continous Integration and deployment 8 VSS/TFS/GitHub/SVN/Bitbucket/VSO 9 Agile/Scrum/Kanban 10 JIRA/Confluence 11 Unit tests using nUnit and XUnit framework 12 Integration testing 13 Acceptance/ Behavioural testing using SpecFlow 14 API Authentication using Json web token 15 JSON format for information exchange 16 Domain Driven Design (DDD) 17 Command Query Responsibilities Segrigation (CQRS) 18 Owin Web hosting 19 QuartzNet for Cron job Working on tools like: Autofac, AutoMapper, SeriLog, Elastic-Search,Kibana, RoboMongo, RabbitMQ, TopShelf Looking forward to hear from you for further discussion and startup. Best Regards

Hi, Greetings from Vijendra Baloda!! I have reviewed your basic project requisites and would like to work with you on the same. I have been 10 years of expertise in MS SQL - Query Performance Optimization, Database Performance Tuning, Database Design Data Warehouse, Microsoft Business Intelligence (SSAS, SSRS,SSIS), Database Design. I have expertise in Analysis the requirement and Implementation, Database Design.I have grate expertise in data base migration. Approach to the Job: => I am grate expertise in MS SQL Optimization, Performance Tuning, Data migration, extraction etc. I can assure that I am best in SQL Optimization and I can show the result set in minimal time. I am Lead SQL Developer , I have done optimization with large scale of data with millions of record tables. => Our core expertise lies among the technologies required for this project. => Kindly initiate our communication by messaging us on Upwork, we would like to discuss this opportunity with you further. => We are also available on Skype and G-Talk for discussion and regular meetings. Thanks for reviewing my proposal

Hi, I m very much eager to take up this work. I will complete this as you expect and with good manner.

A proposal has not yet been provided

Worked in the USA for 11+ years predominantly in Oracle PLSQL technology. Total experience in Oracle database is 14 years. I have solid troubleshooting and performance tuning experience. I have excellent client referrals and good track record on delivery. On-Time On-Budget.

Dear Sir/Madam, I have been working with an organisation for past two years where my work was to deal with the database, create procedures to manipulate and retrive data with efficient procedures using queries that could run within shorter time frame and use lesser storage space. I have always preferred to optimise my queries to get best results within shorter time frame. I could get along with your request and get the work done within given time,it would be nice if I could get a glimpse of your work that you want to be done ,so I can give you an trial query which you could try. Thank you

Good Day Sir, I appreciate your time very importantly, so I'm please to put my efforts and my time in your service. ------------------------------------------------- Important Notes ------------------------------------------------------ - i will not risk with your time and my job quality ( so i will not accept your project before i made one sample to ensure your project will done in time with high quality ). - i'm offering you this low price because i want to grow up faster and get more employer easier so it's important to me to do this job with higher accuracy in lower time. - I'm creative and flexible and will be beneficial to your jobs. ------------------------------------------------------ SKILLS ------------------------------------------------------ i have 7 years of experience in: - Database administration ( Oracle, MySQL and MS Access ) - Excel worksheets - Word documents - PDF - working on images ( JPG - BMP - TIFF - PNG - ICO ) - Data entry - copy typing (typing speed >50 word/min.) - JavaScript - Power Point presentations - Photoshop CS6 - Illustrator CS6 - HTML5 - CSS3