Royal Bank of Scotland has flagged the Mainframe Tech Lead job as unavailable. Let’s keep looking.

Resource will be responsible to provide support the data at rest needs of Ameriprise to ensure data integrity, availability, reliability, and performance across supported databases and mainframe software platforms. He/She will also be responsible for providing ongoing software life cycle support, governance, compliance of Mainframe IMS and DB2 Databases and Data in Motion software such as MQ, Connect Direct, Power Exchange, InfoGix ACR and Optim MF Data Masking. Provide thought leadership on implementation of standard best practices, automation capabilities, process improvements, risk mitigation, and mentorship to junior team members. Performance tuning and working with our customers to optimize all interactions between our systems and their applications.

Key Responsibilities

  • Responsible for design and implementation of database processes to support all functions associated with deployment, recovery, patching, optimization of IMS and DB2 platforms. 
  • Design and implement automated solutions for deployment monitoring and alerting. 
  • Manage all technical aspects of the databases and processes for maintaining the health and compliance of the software. 
  • Troubleshoot IMS and DB2 database issues, including mainframe subsystem troubleshooting of issues outages as they occur. 
  • Assist other Ameriprise Mainframe Operations and Development resources on process improvements at a database and DBMS platform improvements 
  • Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements. Develop, edit, and maintain required documentation. 
  • Proficient in JCL. 
  • Proactively evaluate, recommend, and perform database upgrades and changes. Perform system optimization and improvement planning including, but not limited to, database performance analysis, capacity planning and system sizing. Stay abreast of and recommend improvements in technology and methodology to meet changing business needs and market demands, as well as provide for overall optimization of database administration function. 
  • Pro-actively monitor the performance of development and production databases to detect existing or potential incidents and/or performance issues. 
  • Perform tuning and maintenance to correct and prevent unplanned downtime or performance degradation. Ensure operation of database environments meet or exceed agreed upon service levels (e.g. availability and performance). 
  • Plan, schedule and manage the implementation of new databases and modifications to existing databases in a manner that avoids disruption to production and development systems. Set-up and manage database security, manage data purging/archiving activity and other day-to-day database administration activities. 
  • Provide ongoing support to operations and support teams as needed. Escalate and manage escalated issues as appropriate.

Required Qualifications

  • 10-14 years of experience with a degree in Computer Science or Some other advanced degree with increasing scope and responsibility (e.g. software development, database), or equivalent work experience. 
  • 10-14 years of experience troubleshooting and resolving database issues, including performance tuning and capacity planning. 
  • 1 years of relevant experience required with expertise in IMS and/or DB2 databases. 
  • Strong written and verbal communication skills. 
  • Extensive experience in troubleshooting and resolving database issues, including performance tuning and capacity planning. 
  • Proven understanding of Mainframe technologies and understanding of performance monitoring tools Omegamon and CQM. 
  • Working Knowledge of Mainframe High Availability environments (Sysplex and DataSharing). 
  • Experience with database design, administration, and maintenance in mainframe environments. 
  • Experience with IBM Database Utility Suites, SPUFI, TSO, REXX

Preferred Qualifications

  • Strong working knowledge of industry-standards database management tools. 
  • Demonstrated, successful experience working in a matrixed, multi-vendor technology environment. 
  • Demonstrated ability to work effectively in urgent situations with high pressure and visibility. 
  • Working knowledge of business continuity and disaster recovery exercises. 
  • Familiar with DevSecOps processes and tools. (Jira, GIT, Continuous Integration, Continuous Deployment, Ansible) 
  • Familiar with Service Now, ChangeMan, Power Exchange, InfoGix ACR, Connect Direct, MQ, Optim MF Data Masking 
  • Demonstrated experience contributing and collaborating effectively as an informal leader in a high-functioning team. 
  • Effective organizational, analytical and independent problem-solving skills. 
  • Experience with IMS 15.1 and DB2 12 databases. 
  • Successful experience coordinating and completing multiple tasks within established and changing deadlines. 
  • Strong presentation skills with experience addressing and interfacing with executives and technical staff. 
  • Experience working in the financial services industry or other highly regulated/compliance-oriented environments.

About Our Company

Ameriprise India LLP has been providing client based financial solutions to help clients plan and achieve their financial objectives for 125 years. We are a U.S. based financial planning company headquartered in Minneapolis with a global presence. The firm’s focus areas include Asset Management and Advice, Retirement Planning and Insurance Protection. Be part of an inclusive, collaborative culture that rewards you for your contributions and work with other talented individuals who share your passion for doing great work. You’ll also have plenty of opportunities to make your mark at the office and a difference in your community. So if you're talented, driven and want to work for a strong ethical company that cares, take the next step and create a career at Ameriprise India LLP.

Ameriprise India LLP is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, genetic information, age, sexual orientation, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.

Full-Time/Part-Time

Full time

Timings

(2:00p-10:30p)

India Business Unit

AWMPO AWMP&S President's Office

Job Family Group

Technology

Read Full Description
Confirmed 51 minutes ago. Posted 17 days ago.

Discover Similar Jobs

Suggested Articles