Lead Database Engineer - Jersey City, United States - Comrise

    Default job background
    Description

    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 Banks RDS instances for cost-effectiveness and compliance with Bank standards
    • Proactively monitor and perform frequent analysis of the Banks 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 Banks 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 Banks 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.