AWS Database Engineer - Software Engineer II

About the position

You're ready to gain the skills and experience needed to grow within your role and advance your career - and we have the perfect software engineering opportunity for you. As an AWS Database Engineer - Software Engineer II at JPMorgan Chase within the Consumer and Community Banking - Deposit Technology team, you are part of an agile team that works to enhance, design, and deliver the software components of the firm's state-of-the-art technology products in a secure, stable, and scalable way. As an emerging member of a software engineering team, you execute software 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.

Responsibilities

• Executes standard software solutions, design, development, and technical troubleshooting
• Administer, design, implement, and support highly available and scalable AWS database solutions
• Collaborate with Information Architects and Database Designers to implement data models, database designs, data access, and table maintenance codes
• Maintain Distributed Databases with High Availability features using Data Partitioning and Database replications
• Resolve database performance, capacity, replication issues including support for database upgrades or migrations exhibiting experience with incident management and root cause analysis
• Develop database performance monitoring processes and analyze data for optimization opportunities
• Exhibit strong written and oral communication skills, with the ability to influence and interface successfully with others
• Designs, develops, codes, and troubleshoots with consideration of upstream and downstream systems and technical implications
• Applies knowledge of tools within the Software Development Life Cycle toolchain to improve the value realized by automation
• Gathers, analyzes, and draws conclusions from large, diverse data sets to identify problems and contribute to decision-making in service of secure, stable application development
• Adds to team culture of diversity, opportunity, inclusion, and respect

Requirements

• Formal training or certification on software engineering concepts and 2+ years of applied experience
• Extensive experience with Amazon Web Services (AWS) and Aurora PostgreSQL, RDS, DynamoDB databases
• Experience in database design/development, modeling, integration, optimization, systems re-engineering, and operations support for both cloud and on-prem environments
• Ability to implement and manage database security, backup, and recovery strategies for continuous improvement, resiliency, and scalability
• Familiarity with AWS management and monitoring tools like CloudFormation, AWS CLI, AWS SDKs, AWS CloudWatch, Datadog, Performance Insights, DB Insights or Prometheus
• Experience with infrastructure as code (IaC) using tools like Terraform or AWS CloudFormation
• Over 2 years of experience leading transformational cross-functional IT initiatives
• Hands-on practical experience in system design, application development, testing, and operational stability
• Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages
• Experience across the whole Software Development Life Cycle and exposure to agile methodologies such as CI/CD, Application Resiliency, and Security
• Emerging knowledge of software applications and technical processes within a technical discipline (e.g., cloud, artificial intelligence, machine learning, mobile, etc.)

Nice-to-haves

• Experience in migrating databases from on-prem to cloud environments
• Experience in SQL and NoSQL database technologies, including MySQL and Cassandra
• Knowledge of traditional on-premises database systems such as Oracle, and AIX DB2 is plus
• Experience with Atlassian tools like Jira and Confluence