Search by Job Title

Senior Data Architect/Database DeveloperSurrex

THIS JOB HAS EXPIRED

Job TypeContract Full-Time
Position Id21688
Job Description
Well established leading firm in the fixed income financial services industry has an immediate need for an accomplished Senior Data Architect/Database Developer for a long term consulting opportunity.

Description:
Senior Data Architect/Database Developer will be responsible for database design, data modeling, configuration and development as well as ETL related work to build a mission critical enterprise risk platform, which supports various portfolio and security risk management needs. He or she will implement tasks required for database design, development and optimization, ETL related implementation, and continuing operation of the enterprise risk management systems as well as support other databases in risk management team. He or she will also work closely with project lead, system architect, quant/SAS developers, QA engineer, and business analyst throughout project lifecycle under minimum supervision of project manager.

Responsibilities/Duties:
Work with quantitative/SAS developer, business analyst, DBA, system administrator, and QA engineer to architect data model, design and implement database as well as write ETL related programs.
Produce sound logical data model and build efficient physical database.
Propose proper database features for best design, customization, and user experience. Oracle 11g, MS SQL 2008 R2, and Sybase 15 experience preferred.
Design and develop efficient SQL queries, PL/SQL programs, Store Procedures, and UNIX scripts to support various data operations.
Optimize performance by analyzing query patterns and building appropriate indexing and partition mechanisms.
Manage database artifacts in source code management system and deploy to Dev, QA and Production environments.
Analyze issues and fix defects during SDLC, troubleshoot, production issues, and respond to business users data inquiries.
Produce database design documents, test plans, and system requirements.
Understand complex data requirements such as Terms and Conditions, market, position and price data of vast fixed income and derivative securities.

Technical Knowledge:
Minimum 8 years hands-on data modeling and database design experience for enterprise applications.
Minimum 7 years of intensive database programming experience such as SQL, PL/SQL and store procedures. Minimum 4 years experience with database performance optimization ? query, indexing, partitioning, etc.
Familiar with ETL development using various tools and Ab Initio is preferred.
Familiar with Oracle 11g and MS SQL 2008 new features, Sybase 15 is a plus.
Familiar with UNIX and Windows and various scripting languages such as UNIX Shell scripts, Perl, and Autosys.
Familiar with source code management and deployment tools such as SVN, CVS, Ant, and Ant Hill Pro.
Familiar with IT SDLC methodology and best practices.

Business:
Minimum 3 years data modeling experience in Fixed Income domain and understand data fields for various fixed income products including Structured Product, Options, and Swaps and other derivatives.
Minimum 2 years hands-on system experience with risk management domain and understand various risk terminologies and concepts.