Indexing and optimizing Queries in the Applications

Hi, I have done many database and ETL projects successfully, Have extensive knowledge on SQL Server & ETL using SSIS Query optimization, Index maintenance and Performance tuning are my specialties. Relevant Skills and Experience Having 7+ years of experience in database development, designing, administration and troubleshooting. Holds SQL Server MCSA certification. Proposed Milestones $110 USD - After project completion Please let me know more details about about you requirements like size of the DWH, ETL requirements

Hello, I have been working with a MNC based company since last ~ 6 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 in SQL Server, Oracle ,MySql 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 • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas which I have gained during execution of project work. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction. Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble

I have 12 years of experience in Large data warehouse environments. Teradata Certified professional. Relevant Skills and Experience Expert in Teradata, performance tuning, DWH modeling etc. Proposed Milestones $160 USD - Indexing strategy, query optimization, table structure review etc. How many tables and queries we are talking about?

Hi , i will use MS SQL Server's profiler to analyze the work load and create all the necessary indices. I will also check the DB to suggest any improvements. Relevant Skills and Experience MSSQL , SSIS , Data warehouse. Proposed Milestones $100 USD - at the begin $200 USD - at 25% $200 USD - at 50% $200 USD - at 75% $300 USD - at the end What is your DB ? My expertise is with MSSQL. How big is the DB ?

Hello Sir, I am a database expert and interested in this project. Could you please open chat to discuss more about this project? Thanks Aanvik Relevant Skills and Experience Database, DBA, ETL Proposed Milestones $155 USD - Milestone

Hello Sir, Please give me chance to work on your project. i am the expert freelancer here and delivered almost 270 projects with 100% client satisfaction. Relevant Skills and Experience I have more than 5 years of experience in Business Intelligence, Data Science, Data Warehousing, Database Programming. Please ping me for more discussion Proposed Milestones $200 USD - Once project done

Hi, i have extensive experience in database design, sql queries, query tuning, query optimization, optimization techniques using index, partitioning etc. Please let me know the details. Relevant Skills and Experience SQL, Query Tuning, Optimization Techniques Proposed Milestones $150 USD - Help optimize tables and queris

Hello Will do my best to optimize your database Regards

Working in data engineering field since last 5 years. Have complete expertise over this field. Relevant Skills and Experience 5+ years experience. Have hands on knowledge of data-modelling, crunching, exploration and evaluation of data using DWH techniques and languages. Worked using python, shell, SQL, Unix/Linux systems. Proposed Milestones $35 USD - Index optimisation $80 USD - Query optimisation $51 USD - ETL process Additional Services Offered $20 USD - DB analysis and recommendations Would like to know about the data complexity like size and also the structure of data.

There is no limit to optimize DB for query response and storage strategy Relevant Skills and Experience ETL for processing CDR and optimizing postgres DB Proposed Milestones $155 USD - design some crunchig while processing data, partisioning data for search/read data and write quickly which DB to store data and which lib to parse plain info?

A proposal has not yet been provided

Hi Team, The total time-frame of Analysis of database table depends on the amount of data present. Average analysis of 100GB data takes 4 days. Relevant Skills and Experience Pentaho ETL , Tableau and Data Analysis Complete BI Project architecture Design (Logical Data Model, Physical data structure,DWH , ETL, Reports) , Development and Deployment. Proposed Milestones $82 USD - Analysis of end to end database tables architecture $67 USD - ETL process design and procedures $53 USD - Indexing Tables $40 USD - Query optimizations Additional Services Offered $50 USD - Data Model Diagram $100 USD - Reports based on data for different process areas

20+ years consulting industry experience in analyzing, design, development, research, testing and implementation and installation of several projects/applications related to Data Management Relevant Skills and Experience Proven record of architecting, developing, and delivering enterprise-level, mission-critical systems that yield exceptional return-on-investment Proposed Milestones $50 USD - Indexing Analysis and optimization $50 USD - Query Analysis and optimization $100 USD - Analysis for ETL Needs and development $50 USD - Analysis End-to-End Database How deep do you need for analysis requirements? Do you really know the requirements?