We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.As a SQL Database Administrator Software Engineer II at JPMorgan Chase within the JPMorgan Health Payments team, you serve as a seasoned member of an agile team to design and deliver trusted market-leading technology products in a secure, stable, and scalable way.
You are responsible for carrying out critical technology solutions across multiple technical areas within various business functions in support of the firm's business objectives.
Job Responsibilities : Executes software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems Creates secure and high-quality production code and maintains algorithms that run synchronously with appropriate systems Produces architecture and design artifacts for complex applications while being accountable for ensuring design constraints are met by software code development Gathers, analyzes, synthesizes, and develops visualizations and reporting from large, diverse data sets in service of continuous improvement of software applications and systems Proactively identifies hidden problems and patterns in data and uses these insights to drive improvements to coding hygiene and system architecture Contributes to software engineering communities of practice and events that explore new and emerging technologies Adds to team culture of diversity, equity, inclusion, and respect Responsible for monitoring customer facing databases and ensuring 24x7x365 uptime within our internal SLA of 99.
99% with on call responsibility. Setting up an configuring Amazon RDS database instances. Responsible for identifying optimization opportunities within customer facing databases.
Responsible for capacity management and capacity planning of database resources. Required Qualifications, Capabilities and Skills : Formal training or certification on software engineering concepts and 3+ years applied experience Hands-on practical experience in system design, application development, testing, and operational stability Proficient in coding in one or more languages Experience in developing, debugging, and maintaining code in a large corporate environment with one or more modern programming languages and database querying languages Overall knowledge of the Software Development Life Cycle Solid understanding of agile methodologies such as CI / CD, Applicant Resiliency, and Security Demonstrated knowledge of software applications and technical processes within a technical discipline (e.
g., cloud, artificial intelligence, machine learning, mobile, etc.) Minimum of 3 years of experience with Microsoft SQL Server, preferably in a highly transactional / OLTP environment.
Minimum of 2 years of experience with AWS databases services including RDS SQL Server preferred. Preferred Qualifications, Capabilities, and Skills : Proficiency in few modern technologies such as : Java version 8+, Spring Boot, Restful Microservices, AWS or Cloud Foundry, Kubernetes Performance Testing experience with Blazemeter / JMeter and automation experience with Cucumber / Automated Functional Testing Experience with Datadog and Cloud watch.
Experience with administration of Microsoft SQL Server 2019. Experience with Microsoft SQL Server tools. Experience with Always-On Availability groups preferred.
Background in installation and configuration of SQL Server database technology in a development and DBA capacity, including but not limited to data back-up and restore, debugging, optimizing, software patch applications, defragmenting and replacing of databases.