Data Engineer I

Job Description

Batch-2022 & before

You Lead the Way. We’ve Got Your Back.

At American Express, we know that with the right backing, people and businesses have the power to progress in incredible ways. Whether we’re supporting our customers’ financial confidence to move ahead, taking commerce to new heights, or encouraging people to explore the world, our colleagues are constantly redefining what’s possible — and we’re proud to back each other every step of the way. When you join #TeamAmex, you become part of a diverse community of over 60,000 colleagues, all with a common goal to deliver an exceptional customer experience every day. We back our colleagues with the support they need to thrive, professionally and personally. That’s why we have Amex Flex, our enterprise working model that provides greater flexibility to colleagues while ensuring we preserve the important aspects of our unique in-person culture. Depending on role and business needs, colleagues will either work onsite, in a hybrid model (combination of in-office and virtual days) or fully virtually.

Join Team Amex and let’s lead the way together.

• Performs DB design, optimization, break-fix, administer DB security, implement automation, new DB features implementation, support & assist with database software installations/upgrades, develop, and administer IMS v15 and DB2 z/OS v12 mission critical business operational application databases in development, test, pre-production & production data sharing complexes
• Prefer Bachelor’s degree or higher in Information Management, Computer Science Engineering, or related subject
• Design review meetings, involved in logical design and in converting logical model(s) into a physical database model(s)
• Re-engineer and optimize mainframe access paths and assist in redesign of very large databases, via new function deployments, for performance reasons and for the inclusion / deployment of new tech-business features
• Maintain and administer application database security in accordance with zDBMS and organizational approved standards and procedures
• Provide maintenance like backups, reorganization, and database analysis & diagnoses / database error resolution
• Utilize BMC Admin toolset Change Manager, IBM data studio, IBM visual studio to exploit automation functionality to complete LIFT & SHIFT tasks, across disparate platforms, not just mainframe DBMSs
• Experience in using IBM, BMC utilities for IMS, DB2 z/OS DBs
• Experience in IMS FF, FP DBs
• IMS, DB2 z/OS
• IMS FF, FP DBs
• Drive application migration from z/OS to Postgres
• Recommend performance improvements which optimize and fine-tune AXPs database and operating system data sharing complexes / environments
• Support mainframe mission critical applications covering WCC SERVICES ACQUISITIONS, REMITTANCES, ACCOUNTS RECEIVABLE, MERCHANT, LOYALTY, CORP. etc.  Totaling tens of thousands of database instances
• Maintain standard procedural documentation related to all aspects of operating the mainframe IMS/zDb2 database business computing ecosystem
• Participate in enablement of high availability / automated database reorganization procedures that minimize business client impacts, improve overall availability and allow for huge data volume scaling
• Create, synch-up and refresh required mainframe IMS & Db2 data Warehouse databases for development, test and production (as directed) environments
• Spearhead team efforts to upgrade to NEW and IMPROVED structure capabilities – e.g., converting OLD zDb2 VSAM tablespaces to massively improved Universal Table Space type structures – to enable PETABYTE data volume growth capabilities and in preparation for zDb2 VERSION 13
• Create, synch-up and refresh required mainframe IMS & Db2 data Warehouse databases for development, test and production (as directed) environments
• Spearhead team efforts to upgrade to NEW and IMPROVED structure capabilities – e.g., converting OLD zDb2 VSAM tablespaces to massively improved Universal Table Space type structures – to enable PETABYTE data volume growth capabilities and in preparation for zDb2 VERSION 13
• Drive application migration from z/OS to Postgres
• Legacy platform modernization
• Support IMS FF, FP, DB2 z/OS maintenance, development, and migration activities
• Mentor new junior team members to effectively develop and monitor database systems – pass on and nurture junior DBAs in the ways of properly administering critical mission operational DBMS systems, on the mainframe

American Express is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law.  

Offer of employment with American Express is conditioned upon the successful completion of a background verification check, subject to applicable laws and regulations.