Senior Data, Platform Support Engineer

Role Overview

• 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
• Address moderately complex data-related customer issues
• 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

Tech Stack

• ETL
• Linux
• Oracle
• SQL
• Unix

Benefits

• Onsite work expectation
• Opportunity to work with cutting-edge data warehousing technologies