Find Jobs
Hire Freelancers

DBA for SQL Server 2012 - Increase Speed / Secure Server / Etc..

$30-250 USD

Closed
Posted over 9 years ago

$30-250 USD

Paid on delivery
1. Refine stored procedures --- CPU is at 100% on a 6 core multi processor - Something is wrong with that with under 10 users -- trace the usage, and get the CPU down 2. Reduce redundancy 3. Increase speed 4. Secure server
Project ID: 6362800

About the project

29 proposals
Remote project
Active 10 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
29 freelancers are bidding on average $197 USD for this job
User Avatar
Hello Sir, Greeting for the day, Hope you are doing well I am Working with Data Center Organization as a Linux and windows Expert, I have more than 8 years’ experience in Web hosting and migration, working on more than 1000 of Linux and Windows servers. I will do all mentioned task successfully and fast. Please let me know your time availability for this task. Please add me on Skype (karunakartiwari) for further discussion, will let you know our final price. Thanks karun
$100 USD in 3 days
4.9 (248 reviews)
7.6
7.6
User Avatar
Hello, I'd like to help you on this. My bid is for 10 hours' time during which I will analyse what's going on, fix and/or make recommendations on addressing all performance issues found, look at security and improve/make recommendations as well as set up maintenance plans as necessary for automated backups of your database(es). Should any additional work be required I will be there to take it forward after having agreed any extra actions required. I can't bid to address *anything* since I don't know your environment and can't fully estimate the workload involved - but I will make sure we either manage to completely address all issues you have or have an agreed list of actions required to complete everything. I look forward to working with you! thanks & regards, Janos
$421 USD in 3 days
5.0 (20 reviews)
7.4
7.4
User Avatar
Hi, I have 8.5 years experience in SQL Server 2005|2008|2008R2|2012 and involve in designing databases, Indexing Strategies, table partitioning, writing Stored Procedures, Triggers, functions and views. I have expertise in writing complex queries with proper joins and index selection. In past, i involved in balancing between concurrency and locking and lock escalation. Microsoft Certified Technology Specialist in SQL Server. Thanks
$244 USD in 15 days
4.9 (50 reviews)
6.8
6.8
User Avatar
Sr. Software Developer with 4.8+ yrs experience. Sr. Software Developer with 4.8+ yrs experience. Sr. Software Developer with 4.8+ yrs experience.
$277 USD in 3 days
5.0 (17 reviews)
6.0
6.0
User Avatar
Hello , my proposal is this : We will run the sql profiler and we will receive the results to a file. You will navigate to your application and execute the most heaviest jobs. You will send me the .trc file , I will check the file to see the most heaviest queries to start with and after 2 days you will receive a report with my recommendations. We will check the SPs ,as you have proposed, but we will also check the usage of the indices of the tables. We might need to create new indices or new statistics. Also it is good to know the size of your DB in GB , the number of tables , sp, views , the purpose that DB Serves (OLTP,OLAP). Ii need to know the purpose because we can use different techniques on. index creation (SQL Server 2012 columnstore index). Also we will secure the DB we can make a lot of things (change default ports,hide the sql instance , review the users and their privileges ,etc). Final about the backup it depends on the use of the DB. If it is an OLAP DB we can schedule a daily backup after the updates but if it is an OLTP DB we can set up a daily back and log backups every 1hr , 30’ whatever we will decide. With this solution we can restore up to the point of last log backup. At this time i’m working on another project on the freelancer for a sql server 2008 R2 optimization. I will be more than pleased to send you an example of my recommendations report.
$200 USD in 5 days
5.0 (48 reviews)
6.1
6.1
User Avatar
Dear Sir, Please assign this task for me I'll do the job with lowest rate with 100% completion of the Job I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during last five years I involved many project in ETL, data warehousing, BI reporting and six years of application development experience. I would highly appreciate if you assign this job to me and also I'm Microsoft Certified Technology Specialist (MCTS) for Microsoft SQL Server 2008 for Business Intelligence Development and Maintenance & Microsoft Office SharePoint Server Application Development. Please reply me for further details Best Regards, Jinesh
$111 USD in 3 days
4.9 (69 reviews)
5.7
5.7
User Avatar
how many stored procedures are creating the issues ?.............................................................
$210 USD in 3 days
4.9 (20 reviews)
5.8
5.8
User Avatar
A proposal has not yet been provided
$222 USD in 7 days
5.0 (4 reviews)
4.9
4.9
User Avatar
I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast I can fix it fast
$277 USD in 3 days
4.8 (25 reviews)
4.7
4.7
User Avatar
Aucune proposition n'a encore été fournie.
$222 USD in 3 days
4.8 (14 reviews)
4.5
4.5
User Avatar
Hi, I have gone through your requirements.I am a DBA at CMMI-5 Level company since August 2008.I am working on MySql,MSSQL Server,Oracle database, I can do your job confidently. I am very much Interested to do your work,Please revert me if you have any concern .I am ready to start now.
$200 USD in 4 days
3.7 (37 reviews)
5.6
5.6
User Avatar
Hi. I am certified MSSQL Server expert - MSCE: Data Platform. And I spent great deal of my life administering MSSQL since v2000 was released. Would be glad to help you with this task. Regards, Yury.
$200 USD in 5 days
5.0 (19 reviews)
3.8
3.8
User Avatar
Hi!, I'm a SQL Server DBA with 10+ years of experience. I can help you to detect what is happening in your server and fix it. Thanks in advance!
$244 USD in 3 days
5.0 (6 reviews)
3.8
3.8
User Avatar
Good morning! Solving CPU performance issues is my specialty. I've worked with large and small servers, every flavor of SQL Server from 6.5 to 2012 (and am starting to look at SQL 2014!). I can find bottlenecks, be they in your queries, missing indexes (or perhaps have fragmented indexes), or hardware-based. Your request didn't indicate the size of the database, or the number of queries that have issues, so I want to clarify: the bid here is for the following services: * Detailed analysis of your server, including performance reports of your most troublesome queries. * Up to 5 stored procedures, views, or ad-hoc queries fixed with a 50% or better performance gain. * Maintanence script to help keep statistics and indexes tuned. * Review of server security, best practices analysis, and implementation. I hope to be able to help you with this problem at your soonest convenience. Thank you for your time and consideration.
$166 USD in 3 days
4.9 (7 reviews)
4.0
4.0
User Avatar
hi i have a sound knowledge of the SQL and have 7 years of experience working on the same tell me when we can discuss this and find out the best possible solution . I will wait for your response
$222 USD in 3 days
4.8 (7 reviews)
4.2
4.2
User Avatar
Hi, I'm high rated developer who working everyday with MS SQL (7, 9, 11). I'm quite sure, I'll help you since it's my work. Thanks, Andriy
$150 USD in 3 days
5.0 (15 reviews)
3.5
3.5
User Avatar
La propuesta todavía no ha sido proveída
$200 USD in 5 days
5.0 (1 review)
3.0
3.0
User Avatar
A proposal has not yet been provided
$266 USD in 8 days
5.0 (1 review)
2.5
2.5
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have Experience In SQL, .net,oracle Technology. I can Handle Every project very Efficiently and technically.
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Houston, United States
4.8
131
Payment method verified
Member since Mar 5, 2010

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.