Database Architect 8/27/2016

Financial Services Company Boston, MA

Company
Financial Services Company
Job Classification
Full Time
Company Ref #
29347483
AJE Ref #
576000391
Location
Boston, MA
Job Type
Regular

JOB DESCRIPTION

APPLY
Key Area : Database Architect(Data Modelling , hands on Stored Proc , Setting up of Oracle DB)

Detailed JD:
project requires someone who could write stored procs, can do logical and physical data modelling and who also has more of an understanding on how to set up and maintain Oracle databases.

At least 5+ year of experience in Database design / Architecture / Data Modeling for OLTP, ODS and Data Mart or Data Warehouse for Financial Application (such as Trading, Operational, Transaction Processing, Reporting)
Working knowledge of Erwin
In depth Working knowledge and experience of Oracle 11g, Exadata, PL/ SQL
Working knowledge and experience of Oracle Golden Gate
Working knowledge and experience of Unix Shell Scripting
Must know how to optimize and improve the performance of the various long running queries
Recommend best practices / changes for the data base design (conceptual, logical, physical)
Understand the data requirements, ETL layer and tools familiarity (data transformation / extraction)
Experience working in a technology driven environment.
Business Intelligence platforms such as IBM Cognos
Practical experience using Scrum, Agile modelling and adaptive software development.

Candidate should have exp on the below
- Solid knowledge on SQL Query writing
- Data Designing
- Data Modelling
- Exp on Exadata , Golden gate
- Exp on Erwin