American Express Looking for Senior Data Engineer -Cloud & Data Services at Scottsdale, Arizona Full Time

Scottsdale, Arizona, United States

ID: (phone number removed)

Job DescriptionWork Location Options:

Virtual

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

With the right backing, people and businesses have the power to progress in incredible ways. When you join Team Amex, you become part of a global and diverse community of colleagues with an unwavering commitment to back our customers, communities and each other. Here, you’ll learn and grow as we help you create a career journey that’s unique and meaningful to you with benefits, programs, and flexibility that support you personally and professionally.

At American Express, you’ll be recognized for your contributions, leadership, and impact—every colleague has the opportunity to share in the company’s success. Together, we’ll win as a team, striving to uphold our company values and powerful backing promise to provide the world’s best customer experience every day. And we’ll do it with the utmost integrity, and in an environment where everyone is seen, heard and feels like they belong.

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

As part of our diverse tech team, you can architect, code and ship software that makes us an essential part of our customers’ digital lives. Here, you can work alongside talented engineers in an open, supportive, inclusive environment where your voice is valued, and you make your own decisions on what tech to use to solve challenging problems. American Express offers a range of opportunities to work with the latest technologies and encourages you to back the broader engineering community through open source. And because we understand the importance of keeping your skills fresh and relevant, we give you dedicated time to invest in your professional development. Find your place in technology of #TeamAmex.

Responsibilities :

Performs DB design, optimization, break-fix, recovery, administer DB security, implement automation, new DB features implementation, support & assist with database software installations/upgrades, develop, and administer IMS z/OS and DB2 z/OS mission critical business operational application databases in development, test, pre-production & production data sharing complexes. Migration of applications to suitable database platforms to and from DB2, IMS database platforms. Migration of legacy IMS applications to modern DB platforms. Implementation of database encryption across all platforms.

• 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
• Generate and deploy new database scripts to implement ISPW back-end application SQL, REST program enablement, deploys
• Provide maintenance like backups, reorganization, recovery, and database analysis & diagnoses / database error resolution
• Support major financial applications in an onsite & telecommuter capacity, to conduct the Database Administrator functions – 24x7x366, as required
• Provide primary DBA design guidance and support services for ensuring those critical mission systems, which run primarily on the mainframe, function with high availability, limited, to ZERO, outages
• 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

• Recommend performance improvements which optimize and fine-tune AXPs database and operating system data sharing complexes / environments
• Recommend replat form various existing applications
• Support mainframe mission critical applications covering WCC SERVICES ACQUISITIONS, REMITTANCES, ACCOUNTS RECEIVABLE, MERCHANT, LOYALTY, CORP. etc. Totaling tens of thousands of database instances
• Frequent activities include database break-fix, recovery, troubleshooting and on call support in a SUPER-HIGH availability environment
• Provide database security management to ensure systems availability, integrity, and confidentiality
• Support major financial applications in an onsite & telecommuter capacity, to conduct the Database Administrator functions – 24x7x366, as required
• Continuous definition, update, and optimization of mainframe DBMS configuration parameters according to data sharing and database tuning requirements, across all tech-DEPTs, in collaboration with the mainframe tech-support departments and teams
• 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
• Identify long running IMS and/or Db2 threads which are not issuing frequent intermediate commits and then guide the application developers on deploying proper coding correction(s). Done proactively because no one is, explicitly, addressing this ongoing coding failure
• 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
• Assist and provide guidance and support for installation, upgrade, and configuration of zDb2 drivers for application developers, production operations, and business clients, based on URGENT, URGENT calls for – HELP ME NOW type requests from database engineering team
• Fine-tune and maintain IMS and Db2 for back end applications & configure new REST service interface access to distributed front end cloud based applications – seeking connection to the REAL cloud complex eco-system
• DRIVE application migration from LUW-db2 to zDb2 MAINFRAME solution. 
• Drive application migration from z/OS to Postgres
• Legacy platform modernization
• Research new IMS & Db2 system and application functionality and develop implementation strategies to deploy new zDBMS features and functionality

Salary Range: $(phone number removed) to $(phone number removed) annually + bonus + benefits

The above represents the expected salary range for this job requisition. Ultimately, in determining your pay, we’ll consider your location, experience, and other job-related factors.

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.

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.

US Job Seekers/Employees –  Click here  to view the “EEO is the Law” poster and supplement and the Pay Transparency Policy Statement.

Employment eligibility to work with American Express in the U.S. is required as the company will not pursue visa sponsorship for these positions.

Considerations for sponsorship:

Depending on factors such as business unit requirements, the nature of the position, cost and applicable laws, American Express may provide visa sponsorship for certain positions.

Other Jobs You May Be Interested In

Gurgaon, Haryana, India and 1 more

Phoenix, Arizona, United States

Slide 1 of 5

When you become part of our Talent Community, we’ll keep you posted about future job opportunities that you may be a match for, as well as career-related events.

Join Talent Network