Lead Database Engineer

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 Bank's overall data management.
• Identify existing and avoid building new roadblocks to delivering business value in a timely manner.

Salary Range: $140,000 to $160,000

Skills: