Senior Data & Platform Support Engineer

Federal Reserve System•Minneapolis, MN

3d•Onsite

About The Position

You will help administer and support Oracle databases with other DBAs within the operations organization. Collaborating with initiative and project owners to provide expert advice and support to enhance business outcomes. You will be part of the FRFS Technical Operations team that is tasked with overseeing the day-to-day operability of our nation’s payment systems.

Requirements

Minimum 8 years supporting, designing, and engineering highly complex RAC-enabled Oracle data warehouse and data technology solutions across multiple diverse platforms requiring high performing, high volume transaction processing and analytical workloads.
Experience with RAC one-node.
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.

Nice To Haves

Oracle Analytics Server (OAS) and/or Oracle Business Intelligence Enterprise Edition (OBIEE) experience with data warehouse integration.
Experience with Operational Data Store (ODS) design and implementation.
Experience working with Oracle Exadata.
Java, Python, or other programming languages knowledge/experience for data processing and automation.
Experience using ServiceNow and Jira for project and incident management.
Experience working in Agile/DevOps teams for iterative data warehouse development.
Ability to independently provide summary and recommendations on operational and analytical data.
Knowledge and understanding of organizing or structuring complex data across varied data sources in a data warehouse context.
Knowledge and understanding of data requirements management, modeling, and analysis.
Strong understanding of data lifecycle management and archival strategies.
Experience with data warehouse testing strategies and frameworks.
Familiarity with big data technologies and how they integrate with traditional data warehouses.
Knowledge and understanding of organizing or structuring complex data across varied data sources in a data warehouse context.
Knowledge and understanding of data requirements management, modeling, and analysis.
Strong understanding of data lifecycle management and archival strategies.
Experience with data warehouse testing strategies and frameworks.
Familiarity with big data technologies and how they integrate with traditional data warehouses.

Responsibilities

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.
Support the organization with proposals for data warehouse architecture changes and enhancements.
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.
Ability to influence development organizations to comply with data warehousing best practices, naming conventions, and design standards.
Lead the support and enhancements of Oracle databases and data warehouse platforms in a highly available architecture.
Assist with database and data warehouse platform contingency events.
Participate in database support on-call rotation.
Perform other responsibilities as assigned.