The Farber Consulting Group provides Remote Database Administrator Services since its founding in 1992 and we have developers with over 30 years of experience, having worked on projects with Johnson and Johnson, Avis Car Rental and Dassault Aircraft Industries.
Our developers have been featured in magazines and awarded the prestigious title of Microsoft SQL MVP.
As a remote database administrator (DBA) we can handle the design, implementation, and maintenance of your firm’s database on a daily basis and as a result, we improve performance of your database. Your application will run faster and the company’s employees will be much more productive in getting quick results.
Our company has tremendous amounts of experience with large scale databases. Please see our SQL blog for articles about related work we did.
You may also read about all the related services for MS SQL server that we provide. Click the link to learn more.
We provide database services for your company as MS SQL Remote DBA only as need basis, thus reducing the unnecessary expenses. When we work for your company as a remote DBA consultant there are no costs associated with hiring a database administrator, since we only work on an as needed basis.
Usually we monitor the performance of your database daily during the business hours while scheduling any maintenance work for your company by the end of the business day.
Remote DBA services will reduce database administration costs by up to 70%. The work we do delivers immediate return on investment (ROI).
Our main office is located in central New Jersey, USA which is just under an hour away from New York, New York. You may contact us by email as well by clicking “contact us link.”
We specialize in database optimization, and it is crucial to track down the duration of each executed stored procedure or ad hoc query.
We analyze your query first, then we decide on the best course of action to be taken in order to reduce the execution time. It could be as simple as just of creating a new index file.
We have a tremendous amount of experience with large scale databases in the magnitude of Tera Bytes. Our firm will perform data cleansing only when it is needed. The day to day can create duplicate records inherently however, we remove these duplicate records after careful planning.
Say, in one record you have an empty DOB field (Data of Birth), but in another record the DOB is actually filled with data.
The second record may contain a valid phone number while the first one is empty. We definitely need to remove duplicate records in a method that will increase productivity while not erasing any data.
The solution is to merge the missing phone number and/or DOB into a single record, while deleting the empty one. In any business which depends on its data, it is crucial to keep valuable data and prevent any data lose while performing data cleansing. Please check our article: How to remove duplicate records in sql to get a better understanding of this concept.
We specialize in data migration from one type of database to another. In this process, we improve the database design and optimize its performance while implementing the data migration.
The following are the database types when that we are involved:
We can implement the MS SQL migration from legacy Windows server to the new one from 2003 to 2016 including installation and configuration of MS SQL Server. Additionally, we can Migrate or upgrade the following:
Database design is extremely important for any database performance. We use data modeling tools such as: xCase to improve the efficiency of the database design process. It helps to automate the relations between tables, creation of tables, views and indexes. Using such a database design tool allows us to get a global view of the entire database.
Using data modeling tools prevents us from making any design flaw. This way we make sure the database is best optimized and prevents redundancy of data. A good design concept means that once you entered data in the application you can use that data throughout the application without the need to re-enter.
In addition, it helps to develop a long term database design while you preserve the initial design and add modules later on without re-designing the database.
Very important feature of the data modelling tool is the capability of Reverse Database Engineering. You can take an old database design and import all of it directly into the data modeling tool where you get a very quick head start with the design of the database.
The following databases we can reverse database engineering and save it as a different database engine:
and many more…
Big Data helps to drive the quality of your products and improve efficiency of your services. We can help you analyze your big data and transform it into action and decision making.
When you choose our firm to maintain your SQL Server databases, you can rest assured that your database will be handled by top MS SQL DBA's of our team. Our Senior developer has 30 years of experience in database development and our experts have at least 15 years of experience in servicing MS SQL databases.
In addition, we have database experts with the distinction of MS SQL MVP (Most Valuable Professional). We support MS SQL Server Databases as Remote DBA for the following versions:
MS SQL Server: 6.5, 2000, 2005, 2008, 2012,2014 and 2016.
We are an MS SQL Consulting firm located in central New Jersey, serving worldwide needs. Feel free to contact us at any time. Bear in mind that we can assist you onsite or remotely.