SQL Server Database Developer

SQL Server Database Developer

Mansion House Consulting - Jersey City, NJ

Mansion House Consulting is a highly successful and rapidly expanding Technology and Business Transformation Consultancy specializing in the Investment Banking, Corporate Banking, Asset/Fund Management and Wealth Management sectors. We currently have offices in London, Frankfurt, Singapore, New York and Florida.

KEYWORDS:  Database Developer, Sybase, SQL Server (2008R2), database schema, star schema, data models, ETL, process models, Data warehouse 

SUCCESSFUL CANDIDATE MUST BE:

Comfortable working under pressure and exhibit strong multi-tasking skills, prioritizing tasks when required.
Looking for a challenging and truly global role in a fast paced and constantly changing Tier One Investment Banking Enterprise Technology environment.

PROJECT DESCRIPTION AND SCOPE:

Participation in all phases of project life cycle: analysis, design, develop, test, debug, deploy, maintain and update
Design, implement and maintain database schema across multiple versions
Develop data warehouse process models, including sourcing, loading, transformation, and extraction.
Develop and implement data extraction procedures from other applications (commercial & in-house developed)
Create star schema data models, performing ETLs and validate results
Verify the structure, accuracy, or quality of warehouse data.
Provide or coordinate troubleshooting support for data warehouse
Develop data migration scripts
Performance database tuning, monitoring and backups
Be an expert of business and data flows of Systems
Be up-to-date with database security, new technologies and architectures, for potential implementation within platforms
Design maintenance plan
Prepare technical and operational documentation for data warehouses.

Thank you for taking the time to respond to this job posting. If you do not receive any response within four working days, we will hold on to your profile for a position that is a better fit.