The FRFS Enterprise operates with a customer-first mindset, comprised of team members seeking to do the best work of their careers in pursuit of our important central bank mission.
The following Reserve Bank locations are preferred due to the concentration of FRFS team members in these locations: Chicago, Kansas City, Minneapolis, Atlanta
The selected candidate will reside within a reasonable commuting distance defined by the employing Reserve Bank and will work full-time onsite.
Job Description:
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.
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.
- Travel required up to 15% of the time.
- Participate in database support on-call rotation.
- Perform other responsibilities as assigned.
Qualifications:
Required:
- Experience: 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.
- Oracle Data Warehousing: Proven experience designing and implementing Oracle data warehouses including dimensional modeling, ETL/ELT processes, data integration, and performance optimization.
- Data Modeling: Familiarity with dimensional modeling techniques (star schema, snowflake schema), slowly changing dimensions, and data warehouse design patterns.
- Oracle RDBMS and PL/SQL: 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.
- Performance Tuning: Expertise in query optimization, partitioning strategies, indexing, and materialized views for data warehouse environments.
Strongly Preferred:
- 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.
*This position offers the opportunity to work with cutting-edge data warehousing technologies while supporting critical payment systems infrastructure.*
Onsite Work Expectation:
The Bank believes in flexibility to balance the demands of work and life while also recognizing the necessity of connecting and collaborating with our colleagues in person. Onsite work is an essential function of this position, and you are required to be onsite according to the schedule set by your management.
Full Time / Part TimeFull timeRegular / TemporaryRegularJob Exempt (Yes / No)YesJob CategoryInformation Technology Family GroupWork ShiftFirst (United States of America)The Federal Reserve Banks are committed to equal employment opportunity for employees and job applicants in compliance with applicable law and to an environment where employees are valued for their differences.
Always verify and apply to jobs on Federal Reserve System Careers (https://rb.wd5.myworkdayjobs.com/FRS) or through verified Federal Reserve Bank social media channels.
Privacy Notice
Top Skills
What We Do
This page is dedicated to Federal Reserve System career and employment related information only. Comments not pertaining to Fed recruiting will be removed. The Fed - Make a world of difference in the global economy OUR BANK has one of the most recognizable brands around the world. The Federal Reserve is the central bank of the United States—one of the world's most influential, trusted and prestigious financial organizations. The Federal Reserve is charged with the important mission of promoting a strong economy and a stable financial system and fulfills this responsibility by formulating national monetary policy, supervising and regulating banks and bank holding companies, and providing financial services for banks and the U.S. government. OUR PEOPLE are diverse in background and ideas, which allows for ongoing creativity and innovation. Ultimately, they are the ones who push our high-performance, exchange-driven culture forward. Why Our People Choose Us: Our reputation precedes us There will always be room for personal growth Our people are first You’ll find the right balance Your responsibilities will be meaningful We hope that you will be our future colleague. Find your preferred locations around the United States and explore the breadth of opportunity available at the Federal Reserve. Atlanta https://www.frbatlanta.org/ Boston http://www.bostonfed.org/ Chicago https://www.chicagofed.org/ Cleveland https://www.clevelandfed.org/ Dallas http://dallasfed.org/ Kansas City https://www.kansascityfed.org/ Minneapolis https://www.minneapolisfed.org/ New York http://www.newyorkfed.org/ Philadelphia https://www.philadelphiafed.org/ Richmond https://www.richmondfed.org/ San Francisco http://www.frbsf.org/ St. Louis https://www.stlouisfed.org/ Board http://www.federalreserve.gov/
