Senior Oracle Database Engineer

new york, New York

A leading financial services firm is seeking a Senior Oracle Database Engineer to join their team in New York, NY.

Responsibilities

  • Provide technical expertise in the areas of data architecture, data modeling and data management to the Data warehouse project team as well as transitioning the logical design and architectures to the engineering team
  • Oversee the development of normalized and dimensional models for ODSs, Data Marts, and the Enterprise Data Warehouse
  • Provide senior level experience in modeling Enterprise grade data warehouses to the modeling work group
  • Act as Technology Lead for the metadata initiative and ensure the implementation of the metadata solution
  • Provide technical expertise to Data Warehouse implementation teams and interface with the industry vendors for technical support as needed
  • Develop strategies and solutions for reference data and master data management within the context of the Data Warehousing project
  • Perform data model design reviews and evaluations to ensure that the group standards and best practices are being adhered to and the resulting physical databases meet project needs
  • Develop, maintain and enhance data modeling and database design documents, policies, procedures
  • Work with the application developers, architects and project team on logical and physical database design and implementations
  • Provide guidance on dimensional modeling, on maintaining data histories, and conformed dimensions
  • Prepare high quality documentation of design/architecture/database infrastructure documents
  • Develop semantic data models for Business Intelligence
  • Write comprehensive SQL for exploring and profiling data
  • Maintain and extend data standards

Qualifications

Required

  • A Bachelor’s Degree in Computer Science or related field
  • 8+ years relevant work experience in Data/Database architecture that includes senior level experience in data modeling
  • Extensive experience in ER Studio including creation and use of macros to automate tasks
  • Understanding of relation database technologies as well as data warehouse architectures
  • Experience in data modeling in a financial services provider organization
  • Understanding of credit related financial instruments
  • Experience with performance optimization and management for relational and dimensional models
  • Expertise as an application DBA
  • Experience in Oracle database administration tasks such as schema/user and object creation
  • Experience in large scale data warehouse architectures
  • Understanding of ETL processing and Data Lineages
  • Experience in managing metadata and supporting data governance initiatives
  • Strong communication skills

Preferred

  • Experience with multi-terabyte environments and familiar with best practices of data archiving and purging
  • Understanding of the emerging Big Data Paradigm

Job keywords:

Address
Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs