Onsite Senior Data, Platform Support Engineer

Posted 4 hours ago

Apply now

About the role

  • Senior Data & Platform Support Engineer supporting Oracle databases at the Federal Reserve Bank. Collaborating with teams to ensure operability of payment systems and enhance business outcomes.

Responsibilities

  • Help administer and support Oracle databases with other DBAs within the operations organization
  • Collaborate with initiative and project owners to provide expert advice and support to enhance business outcomes
  • Oversee the day-to-day operability of our nation’s payment systems
  • Perform research activities with a focus on complex data warehousing systems, automated ETL/ELT processes, data architecture, enterprise information systems, and project enhancements with Bank and System-wide impact
  • Optimize data warehouse performance through partitioning strategies, indexing, materialized views, and query tuning
  • Identify and analyze operational impacts of new projects, services, data warehouse infrastructure, enterprise information systems, and automated systems
  • Address moderately complex data-related customer issues
  • Provide input to the development and implementation of data standards, procedures, and safeguards
  • Work with management and staff across customer and service provider areas to define business and technical requirements for enterprise data warehousing and analytics systems
  • Communicate complex technical topics to non-technical audiences
  • Collaborate and communicate with team members to perform work, resolve issues, update statuses, and analyze and report on alternative data warehouse design solutions
  • Provide technical expertise in database and data warehouse solutions including DBMS tools and utilities usage, database administration, backup and recovery, database performance tuning and monitoring
  • Lead the support and enhancements of Oracle databases and data warehouse platforms in a highly available architecture
  • Participate in database support on-call rotation

Requirements

  • Minimum 8 years supporting, designing, and engineering highly complex RAC-enabled Oracle data warehouse and data technology solutions across multiple diverse platforms
  • Proven experience designing and implementing Oracle data warehouses including dimensional modeling, ETL/ELT processes, data integration, and performance optimization
  • Familiarity with dimensional modeling techniques (star schema, snowflake schema), slowly changing dimensions, and data warehouse design patterns
  • Strong understanding of PL/SQL; ability to read/review code and offer suggestions to improve developer Packages, Functions, and Procedures
  • Unix, Linux, and/or AIX experience required
  • Expertise in query optimization, partitioning strategies, indexing, and materialized views for data warehouse environments

Benefits

  • Onsite work expectation
  • Opportunity to work with cutting-edge data warehousing technologies

Job title

Senior Data, Platform Support Engineer

Job type

Experience level

Senior

Salary

Not specified

Degree requirement

Bachelor's Degree

Location requirements

Report this job

See something inaccurate? Let us know and we'll update the listing.

Report job