What are the responsibilities and job description for the Lead Infrastructure Engineer - Postgres Database Administrator position at JPMorgan Chase?
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. Key responsibilities include ensuring data security, monitoring database health, and troubleshooting issues. The candidate will collaborate with development teams to support application requirements and ensure compliance with industry standards. Strong analytical skills and experience with database optimization are essential for this role.
Job 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.
Required qualifications, capabilities, and skills
- Formal training or certification in Infrastructure engineering concepts and 5 years applied experience specifically around Postgree Databases
- Experience working with PostgreSQL databases. Specifically, versions 16 & 17 with a keen interest being shown 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