Talent.com
Lead Database Engineer

Lead Database Engineer

Federal Home Loan Bank Of New YorkHoboken, United States
job_description.job_card.variable_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.permanent
job_description.job_card.job_description

Lead Database Engineer 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 dataernance 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 oues

  • Review, rmend, 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 andpliance 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 bestbination 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 rmend 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 andplex 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 diagnosingplex 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 (, 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 inputer 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 ismitted to recruit, hire, develop, motivate, promote, retain, andpensate 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). Job ID R641

    serp_jobs.job_alerts.create_a_job

    Database Engineer • Hoboken, United States