Senior Database Operations Specialist

CompanyFederal Reserve Bank of AtlantaFederal 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), FedCash1, 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, AtlantaThe 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.*Our total rewards program offers benefits that are the best fit for you at every stage of your career:Comprehensive healthcare options (Medical, Dental, and Vision)401K match, and a fully funded pension planPaid vacation and holidays, flexible work environmentGenerously subsidized public transportationAnnual tuition reimbursementProfessional development programs, training, and conferencesAnd more…This is not necessarily an exhaustive list of all responsibilities, duties, performance standards or requirements, efforts, skills or working conditions associated with the job. While this is intended to be an accurate reflection of the current job, management reserves the right to revise the job or to require that other or different tasks be performed when circumstances change (e.g. emergencies, rush jobs, change in workload or technological developments).The Federal Reserve Bank of Atlanta is an equal opportunity employer.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 ( or through verified Federal Reserve Bank social media channels.Privacy Notice #J-18808-Ljbffr Federal Reserve Bank of New York