Principal, Data Engineer

Fidelity Investments•Westlake, TX

About The Position

Performs application database administration and supports application development and engineering efforts. Responsibilities include reviewing SQL code, analyzing and tuning query performance, designing database applications, developing physical data models, and coordinating replication projects to move data between Mainframe DB2 databases and distributed platforms across on-premises and cloud environments. Maintains critical DB2 databases through reorganizations, image copying, and sizing. Participates in a 24x7 on-call rotation supporting production, database maintenance, housekeeping, and installations. The role performs complex technical and functional analysis for multiple divisional initiatives and defines enterprise-level data architecture strategies. It develops advanced data engineering frameworks and innovative solutions for scalable, secure, high-performance data environments; advises senior leadership on data infrastructure and technology solutions; and mentors junior engineers. The position requires a relevant bachelor's degree and five years of specified experience, or a relevant master's degree and three years of specified experience. The required experience involves modernizing DB2 environments for mission-critical financial-services trading platforms using cloud and hybrid replication architectures, along with the specialized DB2, replication, performance-tuning, and automation expertise described in the posting. Fidelity states that it will not provide immigration sponsorship for this position. The company describes a phased transition toward full-time onsite work, with current onsite expectations varying by role and location.

Requirements

Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent), and five years of experience as a Principal, Data Engineer or closely related occupation performing modernization of DB2 environments supporting mission-critical trading platforms in the financial services industry using cloud and hybrid replication architectures; alternatively, a relevant master’s degree (or foreign education equivalent) and three years of that experience.
Demonstrated expertise in DB2 database administration across z/OS and Linux environments and applying DB2 operational standards using DB2 COBOL/NSP, Broadcom CA Insight, IBM RC/Tools, Subsystem Analyzer, and native DB2 utilities to support large DB2 z/OS sysplex environments.
Demonstrated expertise engineering and implementing enterprise replication solutions for stringent high-availability and disaster recovery requirements using IBM InfoSphere Data Replication Q Replication on z/OS in Active–Active and Active–Passive architectures, and IIDR CDC for heterogeneous cloud and on-premises targets, including AWS.
Demonstrated expertise in performance tuning and root-cause analysis for high-volume, low-latency transactional trading applications by optimizing SQL and DB2 subsystem behavior using IBM Omegamon, Broadcom CA Detector/Insight, SMF data analysis, Explain access path evaluation, and IBM QMF.
Demonstrated expertise designing and implementing automation for repeatable DB2 operational tasks aligned with standard operating procedures, incorporating observability for proactive monitoring, alerting, and troubleshooting using Linux shell scripting, REXX, SQL, and Python.

Responsibilities

Review SQL code, analyze and tune query performance, design database applications, develop physical data models, and support application development and engineering efforts.
Coordinate replication projects moving data between Mainframe DB2 databases and distributed platforms across on-premises and cloud environments.
Maintain critical DB2 databases through reorganizations, image copying, and sizing.
Participate in a 24x7 on-call rotation for production support, database maintenance, housekeeping, and installations.
Collaborate with enterprise teams for systems administration, cybersecurity, and capacity planning.
Troubleshoot production issues and develop immediate solutions or workarounds.
Build database standards and best practices for operations, upgrades, migrations, and onboarding applications and clients.
Install and configure database management systems and related tools.
Plan and implement database security controls and access privileges.
Monitor performance and conduct capacity planning.
Design logical and physical database models and data architectures.
Develop, test, and optimize SQL queries, stored procedures, and triggers.
Perform backup and recovery and disaster recovery planning.
Migrate and integrate data across platforms and environments.
Document database standards, procedures, and data dictionaries.
Evaluate and apply patches and upgrades, ensuring data integrity, availability, and compliance.
Define and lead enterprise-level data architecture strategies.
Develop and implement advanced data engineering frameworks.
Advise senior leadership on data infrastructure and technology solutions.
Mentor junior engineers.
Perform independent and complex technical and functional analysis for multiple divisional initiatives.
Develop innovative solutions for scalable, secure, and high-performance data environments.