Database Administrator- Data Engineer II

You thrive on diversity and creativity, and we welcome individuals who share our vision of making a lasting impact. Your unique combination of design thinking and experience will help us achieve new heights.

As a Data Engineer II at JPMorgan Chase within the HealthCare Payments, you are part of an agile team that works to enhance, design, and deliver the data collection, storage, access, and analytics solutions in a secure, stable, and scalable way. As an emerging member of a data engineering team, you execute data solutions through the design, development, and technical troubleshooting of multiple components within a technical product, application, or system, while gaining the skills and experience needed to grow within your role.

Job responsibilities

• Organize, update, and maintain data to ensure it is actionable and useful for decision-making.
• Demonstrate basic knowledge of data system components to determine necessary controls for secure data access.
• Be responsible for making custom configuration changes in one to two tools to generate products based on business or customer requests.
• Update logical or physical data models based on new use cases with minimal supervision.
• Contribute to a team culture of diversity, equity, inclusion, and respect.
• Monitor customer-facing databases to ensure 24/7/365 uptime, adhering to our internal SLA of 99.99%, with on-call responsibilities.
• Set up and configure Amazon RDS database instances.
• Solve and troubleshoot issues in Amazon RDS using DataDog and CloudWatch.
• Identify optimization opportunities within customer-facing databases.
• Perform change management of database systems following the company's defined change management policies.
• Understand and utilize tools such as JET, Jules, and Spinnaker

Required qualifications, capabilities, and skills

• Formal training or certification in software engineering concepts, with 2+ years of applied experience.
• Advanced proficiency in SQL, including expertise in joins and aggregations.
• Significant experience in statistical data analysis and the ability to select appropriate tools for analysis.
• Experience with AWS database services, including RDS SQL Server.
• 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 Multi-AZ 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 problem-solving skills.

Preferred qualifications, capabilities, and skills

• AWS Certification is preferred.
• Bachelor's degree in Computer Science or a related field 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 JPMorganChase's review of criminal conviction history, including pretrial diversions or program entries.

ABOUT US

JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.

We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.

We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.

JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans

ABOUT THE TEAM

J.P. Morgan's Commercial & Investment Bank is a global leader across banking, markets, securities services and payments. Corporations, governments and institutions throughout the world entrust us with their business in more than 100 countries. The Commercial & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.