DB2 UDB Development DBA Job

Employer Name: A top investment bank worldwide	SpiderID: 2500046
Location: Montreal, Québec	Date Posted: 10/2/2008
Wage: Negotiable	Category: Computer Software/Programming
Job Code:
Number Of Openings: 1

Job Description:
The Derivatives Processing Confirmation team develops systems to confirm over the counter (OTC) derivative trades, for example Interest Rate Swaps. Our systems enable our users to automatically generate electronic confirms for straight through processing (STP) on Swapswire, DTCC, ICE, EFET and SWIFT. We also provide tools to allow users to manage the complex manual workflow for exotic trades that need to be confirmed by FAX or mail. OTC trades can last for periods in excess of fifty years and this poses particular challenges in terms of data retention and ensuring ongoing system performance as the portfolio of trades increases. Growth of OTC dertivative volumes has historically been greater than 100% per year. We are currently part way through a multi-year renovation of the systems to provide a consolidated confirmation platform spanning Interest Rates, Credit Derivatives, Commodity Derivatives, FX Derivatives and Equity Derivatives. The team is global, with members in London, Budapest, New York and ShangHai Job description This position offers opportunities in systems analysis, software development and project planning. It applies to our OTC derivative processing. Responsibilities: - Design, develop and maintain a set of large financial databases as well as advanced mechanisms to populate them on an automated basis, perform automated QC analysis. - Maintain audit trail of changes. - Create and maintain a data dictionary. - Identify and resolve database problems. - Resolution of Database related Incidents. - Taking ownership of the deployment of database related changes. - Contributing to the evolution of the overall continual service improvement plan. - Data matching, cleaning, conversion and migration. - Work closely with other groups within FID and IT. Write project design and requirement specifications, track your own projects and integrate them with those in other groups.

Job Requirements:
Required non technical skills:
==============================
· Strong analytical and organizational skills with a proven ability to understand business, service, spplication and technical based requirements.
· Individual should be dynamic, motivated and able to perform independent work as well as manage tasks on multiple projects in a fast paced environment.
· Good communication skills (verbal and written)
· Experience working with FID or Equity data
· Ability to operate under remote management

Required technical competencies:
===============================
· BSC or MSc in Computer Science or related discipline
· One to three years of aggregate comparable experience in a similar post
· Strong relational database design skills
· DB2 UDB
· Strong SQL
· Performance tuning
· Stored procedures
· Unix/Linux shell programming

Skills Desired
==============
· Sybase ASE
· Perl
· Perforce
· ERWin
· ETL tools
· XML

Job Criteria:
Start Date:
Position Type: Full-Time Permanent
Years of Experience Required: 3
Education Required:
Overnight Travel: None
Vacation Time: Negotiable / Other

Job Benefits:
Health/Dental Benefits, Paid Holidays, Vacations, and Sick Leave, Life and/or Disability Insurance, Company Cafeteria, Other Benefits

Company Profile:
ZAR is a technology staffing and project-based consulting firm specializing in full-time and contract I.T. placement as well as project based consulting.

ZAR was founded by industry experts with a combined knowledge base of over 25 years. Our background includes hands-on experience in corporate software development in addition to search and placement.

Our philosophy is simple: Service your clients with the utmost quality, consistency and integrity, and the rest will come!

Contact Information:

Contact Name: James Murphy	Company Type: Staffing Agency
Company: Zar Technolgoy Consulting	Phone: 201-633-4041
Street: 117 Butternut Lane	Fax:
City: Stamford
State: Connecticut
Zip: 06903

Web Site: http://www.zarit.com