SQL Server DBA at Brightgrove (offline)

About The Customer
The Client has been servicing technology solutions to the New York City real estate industry for over a quarter of a century. As there is no widely accepted MLS in the Manhattan real estate industry, the Client’s application environment is the system that transmits up to the minute inventory from one firm to another. This system has grown from 10 firms and 300 listings exchanged daily to close to 500 firms and approximately 10,000 listings exchanged daily in accordance with REBNY's RLS guidelines.

About The Project
The Project is a full service listings system application which is in use by approximately 300 firms. It includes but are not limited to the full service listing application supporting both the agent end user and data entry, a mobile listings application, a variety of listing feeds, off the shelf and customized VOW options, and marketing services which consist of custom brochures, an interface with the New York Times' Ad times 2000 and a proprietary advertising tool known as Premium Marketing Opportunity (PMO).
It has a long standing history of successful data conversions, integrations, and development of customized business solutions.

Responsibilities
- Daily work with stored procedures, indexes;
- Business logic development;
- Optimization and improvement of existing database;
- Day-to-day maintenance and monitoring of database servers, troubleshooting;
- Develop and improve the database servers to improve security, performance, reliability and cost.

Requirements
* Strong knowledge of SQL as well as MSSQL specifics;
* Big experience with different types of MSSQL replication;
* Comprehensive knowledge of security in MSSQL;
* Experience optimizing MSSQL Server’s performance;
* Ability to work in small collaborative teams and have a great passion working in an Agile development process environment;
* Good communication and interpersonal skills when working with developers;
* Strong knowledge about structure of OLAP and OLTP DB's;
* Experience in using and building OLAP-cubes;
* Experience in ETL using;
* Experience in DB tuning, performance improvement. Working with explain plans etc;
* Intermediate English.

About Brightgrove

Brightgrove is focused on software development, consulting and outsourcing. We deliver a broad array of managed services to our customers, including development of top-quality software applications, quality assurance, testing, web systems design, and offshore staff augmentation. Established in May 2000 as a subsidiary of German Ecotel in response to the exciting new opportunities on the German telecom market, Brightgrove has always been focused on innovative and cutting-edge technologies since the very inception. The Phoenix-V Billing System created by our engineers became the backbone of 15 telecommunication companies.

In 2010, Brightgrove achieved full self-governance and became a privately owned company. In 2011, Brightgrove expanded its market presence and launched the custom development and outsourcing businesses. By now, these rapidly-growing businesses attracted over 280 new employees.

Company website:
https://www.brightgrove.com