DescriptionJoin us as we embark on a journey of collaboration and innovation where your unique skills and talents will be valued and celebrated. Together we will create a brighter future and make a meaningful difference.
As a Lead Data Engineer at JPMorgan Chase within the Healthcare Payments you are an integral part of an agile team that works to enhance build and deliver data collection storage access and analytics solutions in a secure stable and scalable way. As a core technical contributor you are responsible for maintaining critical data pipelines and architectures across multiple technical areas within various business functions in support of the firms business objectives.
Job Responsibilities:
- Implement database backup recovery and archiving strategies.
- Contribute to a team culture of diversity equity inclusion and respect.
- Monitor customerfacing databases to ensure 24/7/365 uptime adhering to our internal SLA of 99.99% with oncall responsibilities.
- Set up and configure Amazon RDS database instances.
- Solve and troubleshoot issues in Amazon RDS using DataDog and CloudWatch.
- Identify optimization opportunities within customerfacing databases.
- Perform change management of database systems following the companys defined change management policies.
- Utilize tools such as JET Jules and Spinnaker effectively.
Required Qualifications Capabilities and Skills:
- Formal training or certification in data engineering concepts with 5 years of applied experience.
- Experience with database backup recovery and archiving strategies.
- Working experience with both relational and NoSQL databases.
- Extensive knowledge of cloud infrastructure and multiple cloud technologies with the ability to operate in and migrate across public and private clouds.
- Advanced proficiency in SQL including expertise in joins and aggregations.
- Experience with AWS database services including RDS SQL Server and ability to run and troubleshoot AWS Lambda functions.
- Proficiency in using Datadog and CloudWatch for monitoring and troubleshooting.
- Experience in administering Microsoft SQL Server 2019.
- Experience with MultiAZ deployments.
- Background in the installation and configuration of SQL Server database technology in both development and DBA capacities including tasks such as data backup and restore debugging optimization software patch applications defragmentation and database replacement.
- Strong communication critical thinking and problemsolving skills.
Preferred Qualifications Capabilities and Skills:
- AWS Certification is preferred.
- Experience with Microsoft SQL Server preferably in a highly transactional/OLTP environment.
- Background in the installation and configuration of SQL Server database technology in both development and DBA capacities including tasks such as data backup and restore debugging optimization software patch applications defragmentation and database replacement.
- Minimum of 2 years of experience with AWS database services including RDS SQL DynamoDB etc.
- Proficiency in using the AWS Management Console.
- Basic knowledge of DEV Shell and Postman.
FEDERAL DEPOSIT INSURANCE ACT:
This position is subject to Section 19 of the Federal Deposit Insurance Act. As such an employment offer for this position is contingent on JPMorganChases review of criminal conviction history including pretrial diversions or program entries.
Required Experience:
Unclear Seniority