22 days ago
Westlake, TX, USAStaff+
Responsibilities
- Administer and maintain mission-critical DB2 databases across z/OS and Linux, including reorganizations, image copies, sizing, installation, configuration, patching, and upgrades.
- Review, develop, test, tune, and optimize SQL queries, stored procedures, triggers, and DB2 subsystem behavior.
- Coordinate data replication and modernization between mainframe DB2 and distributed, on-premises, and cloud platforms.
- Design logical and physical data models, data architectures, database standards, data dictionaries, and enterprise data architecture strategies.
- Implement database security controls, access privileges, backup and recovery processes, disaster recovery planning, and data integrity practices.
- Monitor performance, conduct capacity planning, troubleshoot production issues, and develop immediate solutions or workarounds.
- Develop automation and observability for repeatable DB2 operational tasks, monitoring, alerting, and troubleshooting.
- Participate in a 24x7 production on-call rotation.
- Develop advanced data engineering frameworks and scalable, secure, high-performance data environments.
- Advise senior leadership, mentor junior engineers, and perform complex technical and functional analysis for divisional initiatives.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field and five years of relevant experience, or a master’s degree in one of those fields and three years of relevant experience.
- Experience modernizing DB2 environments supporting mission-critical trading platforms in the financial services industry using cloud and hybrid replication architectures.
- Expertise administering DB2 across z/OS and Linux environments and supporting large DB2 z/OS sysplex environments.
- Expertise with DB2 COBOL/NSP, Broadcom CA Insight, IBM RC/Tools, Subsystem Analyzer, and native DB2 utilities.
- Expertise implementing IBM InfoSphere Data Replication Q Replication on z/OS and IIDR CDC for heterogeneous cloud and on-premises targets, including AWS.
- Expertise tuning high-volume, low-latency transactional trading applications using IBM Omegamon, Broadcom CA Detector/Insight, SMF data analysis, Explain access path evaluation, and IBM QMF.
- Experience automating DB2 operational tasks using Linux shell scripting, REXX, SQL, and Python, with observability for proactive monitoring and troubleshooting.
- Ability to develop enterprise data architecture strategies, advise senior leadership, mentor junior engineers, and support complex multi-divisional initiatives.
Benefits
- Fidelity is transitioning toward a full-time onsite working model through a phased regional and role-based rollout; current onsite requirements vary and may evolve.
- The role includes participation in a 24x7 on-call rotation.
About Fidelity
Fidelity Investments provides brokerage, retirement plan recordkeeping, wealth management, and asset management services to individuals, employers, advisors, and institutions, plus online trading platforms and mutual funds and ETFs. It earns fees from managing and administering assets, advisory services, and brokerage transactions. Founded in 1946 and headquartered in Boston, it is privately held and administers trillions of dollars for U.S. and global customers.