Oracle Data Architect-----Need locals
Core
Design, model, and tune large-scale Oracle and SQL Server databases for real-time and batch applications in a financial domain.
Role type
Senior Oracle Data Architect
Builds
Enterprise data warehouses, physical database designs, and DataStage ETL processes
Domain
Financial services, Data Warehousing, Relational Database Management
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Oracle Exadata, SQL Server, ERwin data modeling, DataStage ETL, database performance tuning, DDL scripting, capacity planning, Star Schema design
Preferred skills
IBM Infosphere DataStage, SSIS ETL Tools, ModelMart Software
Technologies
Oracle Exadata, SQL Server 2012, ERwin, ModelMart Software, DataStage, SSIS
Responsibilities
Produce and document physical database designs using ERwin; maintain the Enterprise data model repository; perform database tuning and instance performance monitoring; coordinate testing with development groups; architect and develop multi-threaded DataStage ETL jobs
Seniority
Senior, hands-on IC