Sr Oracle Application design DBA,Modeler 9/2/2016

TCS Boston, MA

Company
TCS
Job Classification
Full Time
Company Ref #
29461713
AJE Ref #
576078063
Location
Boston, MA
Job Type
Regular

JOB DESCRIPTION

APPLY
TITLE: Sr Oracle Application design DBA,modeler

LOCATION: Boston, MA

JOB TYPE: Permanent

* 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 Oracle11g, 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 ,