Find Jobs
Hire Freelancers

DBA expert

$10-30 USD

Скасований
Опублікований about 9 years ago

$10-30 USD

Оплачується при отриманні
I have an SQL statement does a simple "count" on 30 millions records. It takes 1 minute more or less and I want to make it faster
ID проекту: 6939665

Про проект

45 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

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

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
45 фрілансерів(-и) готові виконати цю роботу у середньому за $22 USD
Аватарка користувача
Hi I have been working with MSSQL for over 14 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
$15 USD за 1 день
5,0 (45 відгуки(-ів))
6,0
6,0
Аватарка користувача
Hi, I have gone through your requirements. I am 12+ years experienced Database Programmer at CMMI-5 level company. I am working on : RDBMS: Oracle ,Sybase (12.5) ,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards, MySQL. Data Base Tools : Database Configuration Assistant, Database Migration Assistant, OEM, SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN, DataPump, AWR, ADDM, Asmcmd, Asmca, Tkprof Big data : Hadoop Ecosystem No SQL :Mongo DB, Neo4J I think I Can do your work easily. Let me know when we can discuss.
$30 USD за 1 день
3,7 (36 відгуки(-ів))
5,6
5,6
Аватарка користувача
Hi! Can you send me your SQL statement ?
$25 USD за 1 день
5,0 (5 відгуки(-ів))
4,3
4,3
Аватарка користувача
There is a very easy way to do it in seconds. Write me and I'll do it now for you. I've been working with all sorts of DBs for 15 years.
$15 USD за 1 день
5,0 (6 відгуки(-ів))
3,4
3,4
Аватарка користувача
I have more than 20 years of experience main on Sybase, SQL Server, Oracle and PostgreSQL. Worked 13 years in USA for federal bodies in Washingon DC. This is my first job on freelance hence will not leave any stone unturned.
$25 USD за 1 день
4,8 (7 відгуки(-ів))
3,3
3,3
Аватарка користувача
Hi, I'm an expert DataBase Administrator and web developper. Please specify the database you are using and information of the application, because te optimal solution for your problem depend on those details. Sincerely yours, Eric
$30 USD за 1 день
5,0 (1 відгук)
2,6
2,6
Аватарка користувача
Get your problem solved quickly! May be you need to rearrange your query to get more performance (especially joins and groups ...), or you need to avoid null values counting. i will use my expertise which exceeds 4 years in databases programming. In fact, i am a SQL developer originally, where I have great experience in creating, manipulating and administrating various types of databases, i used to perform complex queries on Oracle, MySQL and SQL server. Also i can deal with data on an Excel file or CSV file or even a text file (with specified format), then i can work out queries on those files as you need. /*******************/ Note : May be i am a new freelancer on freelancer.com, but be sure that i am not a new database programmer :) /********************/ Also you will get a coordinated results and hints, and may be you need me in other issue, because always i think out of the box. So i wish i can work with you from NOW. Kindly , contact me to discuss further details.
$18 USD за 1 день
5,0 (3 відгуки(-ів))
2,5
2,5
Аватарка користувача
Hello. More 20 years programming experience. I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------
$25 USD за 1 день
5,0 (4 відгуки(-ів))
2,2
2,2
Аватарка користувача
I have strong experience in T-SQL Developping, more then 5 years writing, tunning, solving issues in T-SQL code. Reconstruction to maximize the performance of the database. I am happy to help you with your problem.
$15 USD за 1 день
5,0 (1 відгук)
1,6
1,6
Аватарка користувача
Having more than 4 years experience with Oracle, MySQL and especially SQL Server (versions >= 2008) makes me confident that I can help with this task. So far, I have obtained 3 certifications: - Administering a Microsoft SQL Server 2012 Database (070-462) - May 2014 - Querying Microsoft SQL Server 2012 (070-461) - September 2013 - Oracle Database 11g SQL Fundamentals (1Z0-051) - September 2011 Hope to collaborate!
$20 USD за 1 день
5,0 (3 відгуки(-ів))
1,2
1,2
Аватарка користувача
I am an oracle certified database administrator with 3 years of experience in MNC. I have also worked on query tuning. As the description you mentioned, proper indexing can make the query faster. Also we have to check the level of fragmentation, if necessary have to defragment it . Else we can implement cache technology to make the query faster. You can ping me on freelancer, if you need more information
$15 USD за 1 день
4,8 (1 відгук)
1,1
1,1
Аватарка користувача
I can do this for you and i am a Oracle DBA in 12c.i have been working for a company related ERP database n Booking portal Database. Ping me if you would like to take my proposal.
$20 USD за 1 день
5,0 (1 відгук)
0,8
0,8
Аватарка користувача
I am already working as a Database Administrator and being managing Voip Billing Database which contain almost million of records per mont
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi Sir, I have 5 years of experience on sql and MySql. I will complete this task more efficiently. Thanks
$10 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I can finish your job well in time and in your budget. I have previous experience of performance improvement on a data migration tool project which was done for a US based company. Request you to please give me a chance to work with you.
$20 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$25 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
A proposal has not yet been provided
$15 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
could you please give me database, application, servers information ?
$20 USD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hello, It should be a quick problem to solve, if it is selecting only one table. Hope to hear from you. Best Regards, Charl Erasmus
$15 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Ill give you some ideas what you could do to resolve this issue, i have some experience on big databases. Also what database are you using?
$35 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор AUSTRIA
Vienna, Austria
5,0
33
Спосіб оплати верифіковано
На сайті з лют. 4, 2012

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.