The Farber Consulting Group has been providing 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 title of Microsoft SQL MVP - a prestigious award for someone in the SQL consulting field.
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 the performance of your database. Your application will run faster and the company’s employees will be much more productive thanks to the system's quick results.
Our company has tremendous amounts of experience with large scale databases. Please see our SQL blog for articles about related work we have done.
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 when you needed us.
Usually we monitor the performance of your database daily during normal business hours while scheduling any maintenance work for your company after the end of the business day.
Remote DBA services will reduce database administration costs by up to 70%. Thus the work we do delivers an 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. But just remember that your company does not have to be nearby to benefit from a remote database administrator, so while we provide database services for companies in the New York and New Jersey area in person, our services are not limited to these two states.
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 creating a new index file. Our SQL consulting experts can make recommendations that will save your company time and money.
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. Day-to-day operations can create duplicate records inherently however, we remove these duplicate records after careful planning.
Imagine this scenario. 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 loss while performing data cleansing. Our SQL consulting experts can handle these delicate procedures to ensure your database is working optimally. 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 mistakes. This ensures the database is best optimized and prevents redundancy of data. A good design concept means that once you enter data in the application you can use that data throughout the application without the need to re-enter it.
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.
We can use reverse database engineering on the following formats 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 the 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. So, whether you need a remote database administrator or are a local company in need of SQL consulting, the Farber Consulting Group is here for you.