Find Jobs
Hire Freelancers

Required DBA

₹600-1500 INR

Closed
Posted almost 5 years ago

₹600-1500 INR

Paid on delivery
I need a Sql Server DBA who can help me to figure out the problem I am facing. Problem: I have one DB with near about 300 tables. One application is inserting the rows in the table on a regular basis like each second. While my website is reading the same table when the user is accessing the site. Due to the insert application website is opening slow. If I will close the application then I am able to open the site within 3 seconds but if service/application is running then it takes near about 30-35 seconds. Please let me know the solution for this.
Project ID: 20297240

About the project

19 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average ₹2,443 INR for this job
User Avatar
With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. I am 24x7 available on chat, so i can serve you whenever you want. Please check the PMB. Let's Lets start! To achieve goal with 100% quality we have team of 27 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Regards Dsv Infosolutions Pvt. Ltd.
₹1,125 INR in 7 days
4.2 (79 reviews)
7.6
7.6
User Avatar
Hello I have a solution for you. I will guide you but you will have to implement it yourself because you are the one who know the whole infrastructure. Talk soon
₹3,500 INR in 1 day
5.0 (30 reviews)
4.6
4.6
User Avatar
Hi Sir, I am core SQL Server DBA. I have excellent experience in performance tuning. I understand your problem in your database. I will fix your database such that you website loads always faster and you no need to kill the other application for making it fast, Please give me chance to work on your project. For sure I ll fix . Pay me only if you like the work , All i need is give me chance to work . waiting for your chat.
₹950 INR in 1 day
5.0 (11 reviews)
3.9
3.9
User Avatar
Myself Anil have more then 10 years of experience in SQL Server databse development and Administration. I have worked with big Databases for clients like match. Com, nationstar mortgage and with TCS. I am also good for BI part like SSIS, SSRS and SSAS. I am looking for full time /part time or hourly remote job. I am immediate available. 
₹3,333 INR in 1 day
5.0 (6 reviews)
3.3
3.3
User Avatar
By analyzing the problem, I have understood that there are two applications which are being operated on a single database. One application is the write-intensive application while the other (website) is unknown. Can we have a short message conversation to further understand the problem more clearly?
₹2,000 INR in 2 days
5.0 (1 review)
1.2
1.2
User Avatar
hi we can solve this. it requires a performance tuning. we are quite familiar with it. to work on this and proceed further we know few more details. os , database version and also awr report , alert log , other system health report , recent CPU if any etc. if you can provide those details we can work on this. thanks sayantan
₹10,500 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi Sir, I've facing like your problem, I know the transaction was locking table by default. So, I'll use with no lock for speed up reading on your web app. Lets we discuss for details. Regards Lucky Relevant Skills and Experience I'm fullstack developer with expertise in .Net, SQL, WebApp, Desktop and ERP SAP. And as solution architect in various projects.
₹1,300 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
 Having 9.4 years of experience as SQL Server Database Administrator in production support environment.
₹10,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is my first project in freelancer, but I am SQL DBA by profession. I have worked in such scenarios. We can work together and fix it. Let's work together and solve it..Give me a chance Relevant Skills and Experience Validating query plans and waits and working on indexes.. We can try other possible ways to insert
₹900 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I can show you a way how to find bottleneck. Please contact with me for farther cooperation. Regards, Mike
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
There is a indexing issue Relevant Skills and Experience Surerb to work at optimizer wuery
₹1,250 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
You require bit of tweaking, doesn't seem much work Hi, I am core SQL Server DBA. I have excellent experience in performance tuning. I understand your problem in your database. I will fix your database such that you website loads always faster and you no need to kill the other application for making it fast.
₹600 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Database expert with 15 years of rich BAU experience. Speciality in performance tuning, upgrade and migrations.
₹600 INR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will complete your project asap
₹750 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
. I have 16+ Yrs of experience in IT and for last 7 Yrs, I have been working for Top E-commerce platforms. I have an exposure for working in vast variety of IT Technologies in the area of Database/Infrastructure/Security/System Architecture. I have implemented latest and cost cutting technologies to improve the scale/performance of the application/systems and helped in designing the new architecture on application and Infra Level. Area of Expertise 1) Designed and Build Complex Database systems for BI, Web and Backend Application and ERP. 2) Designed and Implemented Infra and Devops Solution, like CI/CD, Automation, Dockers & kubernetes and Risk & security Audits. 3) Scaling and Optimisation of Monolithic application. 4) Implemented and Designed micro services based architecture. 5) Expertise of implementing cloud based infra architecture.
₹3,500 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am an experienced SQL Server (MCSE) DBA and have faced similar locking issues in the past. I can provide feedback and several proposals as soon as I watch the issue and we will agree on the changes depending on the resources. I will need additional information which will be requested if I am chosen. Best regards, Marios Pavlidis
₹1,400 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Our team is experienced with databases in fortune 200 companies that come across issues like this all the time. We have solutions that have been put in place to account for these situations. We have over 20 years of experience on our team and we will be able to see the issue and come up with a solution for your company. We are excited to hear from you and being able to create a working relationship. -NTA Creative
₹1,050 INR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
SAS Nagar, India
5.0
39
Payment method verified
Member since May 2, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.