Mainframe Platform Engineer Database Analyst
Company: Ameriprise Financial, Inc.
Location: Minneapolis
Posted on: August 7, 2022
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).
- 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. Conduct data analysis involving
- the design and modification of complex reports, forms and
system queries. Apply data analysis and data modeling techniques to
establish, modify and maintain complex data structures and their
associated components to increase efficiency of structures and
components. Provide technical guidance and work direction to less
experienced staff.
- Work closely with customers, application development and other
DBA teams to ensure that stringent back-up, recovery and
replication strategies are developed, tested, implemented and
maintained for development and production database environments.
Ensure strategies allow for data recovery in accordance with agreed
upon service levels. Continually monitor and make improvements to
back-up and recovery mechanisms and processes.
- Champion consistency across databases by identifying data
inconsistencies and working with environment owner(s) to enable
data completeness. Monitor assigned data assets to ensure
consistent data definitions and standard data naming conventions.
Collaborate with other internal teams to champion and uphold
governance policies. Required Qualifications
- Bachelors degree or equivalent in Computer Science, Information
Systems or related technical field; or equivalent work
experience.
- 5-7 years of relevant experience required.
- 5-7+ years of technology experience of increasing scope and
responsibility (e.g. software development, database).
- 5+ years of experience with database design, administration and
maintenance in distributed and mainframe environments.
- 5+ years of experience troubleshooting and resolving database
issues, including performance tuning and capacity planning.
- Proven expertise in database design, to include solid
understanding of related programming languages, clustering,
back-up/restore technologies, replication and security.
- Proven understanding of SQL coding required to understand
performance implications and translate requirements to application
developers. 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.
- 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 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.
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.
Keywords: Ameriprise Financial, Inc., Minneapolis , Mainframe Platform Engineer Database Analyst, Professions , Minneapolis, Minnesota
Didn't find what you're looking for? Search again!
Loading more jobs...