This position is responsible for: modernizing data platforms and implementing
frameworks to improve standards for on-premises and cloud-hosted relational
and non-relational databases; designing strategies for optimized, efficient,
reliable, and cost-effective cloud-native data platforms; and performing root
cause analyses of database infrastructure or platform-related issues, identifying appropriate resolutions, and partnering with stakeholders to implement solutions.
Essential Job Function:
Review, recommend, and implement solutions for optimizing database operations, including but not limited to: database replication, storage, and performance
Monitor and optimize the Bank's RDS instances for cost-effectiveness and compliance with Bank standards
Proactively monitor and perform frequent analysis of the Bank's cloud data platforms for capacity planning, anticipate future problem areas, and plan for appropriate sizing
Provide expert insights while troubleshooting application data platform issues and advise on solution options and their trade-offs
Proactively review and analyze data access patterns and advise on best combination of indexes, constraints, foreign keys, and queries
Resolve existing technical debt and eliminate or minimize the growth of new technical debt related to data platforms
Work closely with Database Administrators to ensure the availability, stability, and security of the Bank's database infrastructure
Collaborate with application development teams and Database Administrators to ensure alignment to Enterprise Architecture (EA) and Data Architecture (DA) standards for database design, configuration, replication, and use
Stay up to date with industry trends and emerging technologies in cloud data platforms and recommend relevant changes to the Bank's data platforms
Take proactive ownership of operational issues related to data platforms, perform root cause analysis to get a resolution, and provide updates to management
Provide thought leadership in identifying reusable, flexible, and scalable database solutions with zero downtime reliability
Other Duties:
Provide training on supported capabilities.
Collaborate with other Data Management Office staff as needed to advance the maturity of the Company's overall data management.
Identify existing and avoid building new roadblocks to delivering business value in a timely manner.