DBA expert

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

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.

Hi! Can you send me your SQL statement ?

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.

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.

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

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.

Hello. More 20 years programming experience. I need more details to set real time and price. Regards. ---------------------------------------------------------------------------------------------------------------------------------------------------

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.

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!

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

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.

I am already working as a Database Administrator and being managing Voip Billing Database which contain almost million of records per mont

Hi Sir, I have 5 years of experience on sql and MySql. I will complete this task more efficiently. Thanks

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.

A proposal has not yet been provided

A proposal has not yet been provided

could you please give me database, application, servers information ?

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

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?