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
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
IT Project Manager involved in managing diverse projects at Fidelity focusing on architecture and data solutions. Lead delivery teams in technology initiatives enhancing existing systems.
Data Platform Engineer transforming operational data into clean, analysis - ready datasets for Versana's platform. Collaborating within a team to implement data engineering practices and ensuring data quality standards.
Head of Platform Engineering overseeing SaaS platform development for mobility payments in Denmark. Leading a talented team in a hybrid work environment with a focus on infrastructure and support.
Platform Engineer focused on enhancing platform reliability and release automation at Aspire Software. Engaging with both development and operations teams for better integration.
Senior Platform Engineer at Bannerflow maintaining and securing cloud platform while collaborating with product teams. Designing and implementing DevOps processes and tooling for improved workflows.
Senior Software Engineer in Platform Engineering at Redfin, developing AI tooling for frontend code and infrastructure. Focused on enhancing developer experience and productivity across multiple teams.
Copilot Agent & SDLC Context Platform Engineer designing and building technical foundations for GitHub Copilot. The role involves extensive experience in data engineering and workflow automation in Kraków, Poland.
Fabric Platform Engineer responsible for the technical foundations of ISS's Data & Reporting Platform. Ensuring reliability, operational performance, and comprehensive reporting for a global maritime shipping company.
Senior Platform Engineer specializing in the IAM security solution for Disney's enterprise applications. Collaborating with cross - functional teams and maintaining compliance standards.