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.

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.

• 4+ years Oracle, Exadata, AWS, etc. (specific technology skill requirements will vary by role and domain).

• 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.