Mainframe Platform Engineer Database Analyst Mainframe Platform Engineer Database Analyst …

Ameriprise Financial, Inc.
in Minneapolis, MN, United States
Permanent, Full time
Be the first to apply
Competitive
Ameriprise Financial, Inc.
in Minneapolis, MN, United States
Permanent, Full time
Be the first to apply
Competitive
Mainframe Platform Engineer Database Analyst
Job Description

Support the information needs of the organization through the development and operation of database technology and administration services that ensure data integrity and database availability, reliability and performance across a broad range of databases and applications. Develop, test, implement and maintain database technology components. Provide database support for production and non-production environments, to include back-up and recovery services. Monitor database environments, identify existing or potential performance issues and effectively tune when needed.

Support the data at rest needs of Ameriprise to ensure data integrity, availability, reliability, and performance across supported databases and mainframe software platforms.
Provide ongoing software lifecycle support, governance, compliance of Mainframe IMS and DB2 Databases and Data in Motion software such as MQ, Connect Direct, PowerExchange,
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.

Responsibilities

  • Gain thorough understanding of data requirements and business/client needs. Design, test, implement and maintain complex databases with the required organization, access methods, access time, validation checks and security to meet or exceed requirements. Ensure design and implementation meet architectural standards, company guidelines and client requirements. Develop, edit and maintain required documentation.
  • 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).
  • 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.
  • 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. Use database subject matter expertise to investigate and troubleshoot database related issues/incidents. Escalate and manage escalated issues as appropriate.


Required Qualifications

  • 5-7+ 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.
  • 5+ years of experience troubleshooting and resolving database issues, including performance tuning and capacity planning.
  • 5+ years of relevant experience required with expertise in system level maintenance of 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, ChanageMan, 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.
  • 2+ years of experience maintaining enterprise-scale database environments.
  • Demonstrated, successful experience working in a matrixed, multi-vendor technology environment.
  • Demonstrated ability to work effectively in urgent situations with high pressure and visibility.
  • Strong written and verbal communication skills.


About Our Company

With the right company, life can Be Brilliant®. The Ameriprise Financial Technology team mission is to create innovative technology solutions and engaging digital experiences for our clients, advisors, and employees. We embrace an inclusive and collaborative culture that allows us to partner across the business and lend our expertise in the areas of corporate computing, network infrastructure and security. We celebrate the unique qualities and reward the contributions of our talented, passionate employees. If you're motivated and want to work for a strong, ethical company that cares about you and your community, take the next step with Ameriprise Technology and we can Be Brilliant® together.

Ameriprise Financial is an equal opportunity employer. We consider all qualified applicants without regard to race, color, religion, sex, national origin, genetic information, age, sexual orientation, citizenship, gender identity, disability, veteran status, marital status, family status or any other basis prohibited by law.
Ameriprise Financial, Inc. logo
More Jobs Like This
See more jobs
Close
Loading...