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.
The job ad is no longer active
Look at the current jobs SQL / DBA Kharkiv→