Lead Database Engineer Jersey City Hybrid

The Team

The Data Management Office: Identifies the Bank's data needs and aligns data investments with business strategy. Partners with stakeholders to apply data governance best practices to activities with tangible business value Rapidly & securely provisions the right data to the right audience at the right time Delivers a high-touch customer service experience which meets the needs and exceeds the expectations of our customers. The Lead Database Engineer 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. Performing root cause analyses of database infrastructure or platform-related issues, identifying appropriate resolutions, and partnering with stakeholders to implement solutions. Key outcomes 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. 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. Required Experience 5+ years of experience working as a database engineer with various cloud-hosted and on-premises relational & non-relational database technologies & architectures. 3+ years of hands-on experience in designing and maintaining cloud database solutions; optimization and configuration of Amazon Web Services (AWS) Relational Database Services (RDS) is preferred. 3+ years of experience with optimizing storage, retrieval, tuning, and replication of large and complex data sets. Demonstrable experience in design and development of: Information management/data architectures Multi-tier data layers and frameworks Data Integration methods for transactional systems Cloud storage solutions. Strong interpersonal skills including collaboration, critical thinking, analytical mindset, stakeholder and relationship management. Technical Skills : Proficiency in setup, configuration, and scaling of relational & non-relational databases in the Cloud Expertise in relational database management systems (RDBMS) such as Microsoft SQL Server, PostgreSQL, and Oracle Expert troubleshooting and problem-solving skills for diagnosing complex issues with cloud-hosted databases Expertise in database server specification, performance monitoring, tuning, analysis, and optimization Expertise in database disaster recovery, including advanced use of AWS Database Migration Service (DMS) Strong SQL query optimization skills for improving query performance. Strong understanding of database design structures, theories, principles, and practices. Expertise in data privacy, encryption, and relevant data protection capabilities. Sound knowledge of best practices in database engineering including: Data storage techniques - hot/cold; column-oriented vs row-oriented Database security mechanisms - data masking, encryption, role-based access controls Data retrieval methods for optimized query performance Trade-offs between horizontal vs vertical scaling of databases Functional Skills: Ability to think at and switch between multiple levels (e.g., conceptual vs. logical vs. physical data models, strategic vs. tactical planning) Good understanding of data management functions as per the Data Management Body of Knowledge (DMBOK) and its application to design, development, and implementation of operational data solutions Working knowledge of project management techniques and/or System Development Life Cycle (SDLC) methodologies Education/Certifications Bachelor's degree in computer science, engineering, or related discipline. Master's degree preferred. Professional experience will be considered in lieu of education. Certifications in AWS RDS/DMS, data engineering, or database technologies are not required but are a plus. AWS Database Specialty certification preferred.

Salary Range - $150,000 - $165,000

The Federal Home Loan Bank of New York is committed to recruit, hire, develop, motivate, promote, retain, and compensate all applicants and employees in a nondiscriminatory manner without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, status as a parent, disability, genetic information, military or veteran status, or any other characteristic protected by applicable law (including title VII of the Civil Rights Act of 1964).