New Jersey, United States
Database Developer II
• Design, maintenance, ETL and normalization of data imported into SQL databases from 200+ real estate MLS data feeds via API, RETS or flat file.
• Creation and optimization of stored procedures and functions in standard and dynamic SQL.
• Database performance enhancements - improvement of SQL performance and CPU usage by monitoring and optimizing queries, creation and defragmentation of indexes, monitoring and avoiding deadlocks, and timing of job scheduling.
• Creation of custom outbound feeds for vendors and divisions of the company - providing data dumps through XML, flat file or data migration.
• Creation of custom email reports and statistics.
• Designed, coded and implemented solutions improving efficiency, including:
• --- Hybrid publishing process for MLS listings in which inbound feeds would download and refresh data once an hour, incrementally based on modification dates providing weichert.com with new/updated data faster than our competition.
• --- Image true-up solution for real estate photos to stay current on ever-changing MLS listings based on modification dates.
• --- Automated mapping of real estate listing features, property types and styles to cross-reference tables using fuzzy logic.
• Provision of internal and external helpdesk support.
• Part of on-call rotation involving troubleshooting failing jobs after hours and on weekends.