Lead Infrastructure Engineer - Postgres Database Administrator

JPMorgan Chase • Jersey City, NJ

70d

About The Position

We are seeking a skilled Postgres Database Administrator to join our Jersey City team. The ideal candidate will be responsible for the configuration, maintenance, and performance tuning of Postgres databases. As a Lead Infrastructure Engineer at JPMorgan Chase in Corporate Sector in Relational Databases Team, you leverage your extensive expertise in infrastructure, focusing on compute, storage, and networking. You apply technical processes within the infrastructure engineering discipline and continuously expand your technical and cross-functional knowledge beyond your primary domain of expertise.

Requirements

• Formal training or certification in Infrastructure engineering concepts and 5+ years applied experience specifically around Postgres Databases.
• Experience working with PostgreSQL databases, specifically versions 16 & 17 with a keen interest in version 18.
• Experience in database design, implementation, and maintenance.
• Deep understanding of Postgres architecture and internals.
• Ability to explain technical concepts to non-technical stakeholders.
• Experience with EnterpriseDB and its software is beneficial.
• Proficiency in SQL and PL/pgSQL programming.
• Knowledge and experience with Python and understanding of modern engineering practices (SRE, DevOps, CI/CD pipelines, continuous integration) would be beneficial.
• Strong database security management with knowledge of cyber security and controls.

Responsibilities

• Monitor database health and performance using tools and scripts.
• Troubleshoot and resolve database issues and errors.
• Analyse and optimize database performance.
• Identify bottlenecks and implement solutions to improve efficiency.
• Help to plan and execute data migration projects.
• Integrate Postgres databases with other systems and applications.
• Maintain documentation of database configurations, processes, and procedures.
• Work closely with development teams to support application requirements.
• Provide technical support and guidance to other team members.
• Ensure databases comply with industry standards and best practices.
• Stay updated with the latest PostgreSQL features and technologies.

What This Job Offers

• Career Level: Mid Level