Senior Data & Platform Support Engineer

Company

Federal Reserve Bank of Atlanta

Federal Reserve Financial Services (FRFS) delivers a suite of payments services to financial institutions via FedLine® Solutions, Fedwire® Funds and Securities, the National Settlement Service (NSS), FedCash®1, FedACH®, Check Services, and the FedNow® Service. FRFS operates as a fully integrated organization with groups dedicated to customer experience, operations, technology, product and customer/industry management, enterprise services, payments system improvement, and one focused on the ongoing growth and development of the FedNow instant payment service. Our strategy defines our future direction, seeking to offer a fully integrated product suite that provides speed, resilience, and choice in meeting the payments needs of FRFS customers across the United States. Through our Enterprise structure, we strive to meet the needs of the marketplace for new products and services with speed and agility, seek to provide a robust and unified customer experience, and work to create career growth opportunities for FRFS staff.

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.