Data Engineer (Oracle Apps)

Senior Data Engineer

Position Overview

We are seeking a highly skilled Senior Data Engineer with Application DBA expertise to design, build, optimize, and support enterprise data platforms. This role combines advanced data engineering with hands-on database administration, ensuring high availability, performance, and scalability of critical data systems.

The ideal candidate brings deep experience in data warehousing, ETL development, and database management, along with a strong foundation in modern cloud data platforms.

Key Responsibilities

Application DBA Responsibilities

• Administer, monitor, and tune Oracle databases supporting critical applications
• Manage database performance (query optimization, indexing, partitioning, and execution plans)
• Perform database maintenance activities (backups, recovery, patching, upgrades)
• Ensure high availability, disaster recovery, and data integrity
• Support application teams in database design and troubleshooting

Data Engineering & Architecture

• Develop and maintain data models (dimensional and normalized) to support analytics and reporting
• Build and optimize enterprise data warehouse solutions across Oracle and Snowflake platforms
• Ensure efficient ingestion, transformation, and integration of structured and unstructured data
• Design, develop, and maintain scalable data pipelines and ETL processes using tools such as Informatica and Python

Reporting & Analytics Support

• Support and enhance Oracle Analytics Server reporting environments
• Collaborate with BI and analytics teams to ensure data accuracy and usability
• Optimize data structures for reporting performance

Cloud & Modern Data Platforms

• Develop and maintain solutions in Snowflake cloud data warehouse
• Implement best practices for cloud data architecture, cost optimization, and performance
• Work with NoSQL technologies (MongoDB) for semi-structured and unstructured data use cases

Development & Automation

• Write efficient, reusable, and scalable code using Python and SQL
• Automate data workflows, monitoring, and alerting
• Implement CI/CD practices for data pipelines and database deployments

Data Governance & Quality

• Ensure data quality, consistency, and security across platforms
• Implement data validation, cleansing, and lineage tracking
• Adhere to corporate data governance and compliance standards

Required Qualifications

Bachelor’s degree in Computer Science, Information Systems, or related field (or equivalent experience) and 7+ years of experience in data engineering and database administration

Technical Skills

• Strong expertise in:
• Oracle Database (Application DBA experience required)
• Informatica (ETL development)
• Data Warehousing concepts and architecture
• Hands-on experience with:
• Snowflake
• Oracle Analytics Server (reporting and integration)
• Python
• SQL (advanced querying and performance tuning)
• NoSQL databases (MongoDB preferred)

Preferred Qualifications

• Experience with cloud platforms (Azure, AWS, or GCP)
• Familiarity with modern data stack tools (dbt, Airflow, etc.)
• Knowledge of DevOps and CI/CD pipelines
• Experience supporting high-volume transactional systems (OLTP)
• Exposure to data governance and security frameworks

Key Competencies

• Strong analytical and problem-solving skills
• Ability to balance development and operational DBA responsibilities
• Excellent communication and stakeholder collaboration
• Detail-oriented with a focus on performance and reliability
• Proactive in identifying and resolving system bottlenecks

Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories.

Company Overview

At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to complete the application or interview process.

Fidelity TalentSource, is the in-house temporary staffing provider for Fidelity Investments. Unlike traditional staffing agencies, we are an internal business unit within Fidelity’s Talent Acquisition team, dedicated to recruiting talent from various backgrounds for roles in Fidelity’s regional and investor center locations. Our mission is to help you experience Fidelity’s diverse and inclusive workplace while expanding your skill set and professional network, with the ultimate goal of conversion to full-time employment as part of Fidelity’s long-term strategy.

For information about working at Fidelity TalentSource, visit FTSJobs.com.

Fidelity TalentSource will reasonably accommodate applicants with disabilities who need adjustments in order to complete the application or interview process. Please email us at [email protected] if you would like to request an accommodation.