DescriptionYou belong to the top echelon of talent in your field. At one of the worlds most iconic financial institutions where infrastructure is of paramount importance you can play a pivotal role.
As an Infrastructure Engineer III at JPMorgan Chase within the Infrastructure Branch Technology team youutilize strong knowledge of software applications and technical processes within the infrastructure engineering discipline. Apply your technical knowledge and problem-solving methodologies across multiple applications of moderate scope.
Job responsibilities
- Provides recommendationsandinsight on data management governance proceduresandintricacies applicable to the acquisition maintenance validation andutilization of data
- Adds to team culture of diversity equity inclusion and respect
- Works with other team members to resolve any high priority issues
- Helps to manage internal cloud (GAIA) application pools
- Designs and maintains robust software solutions for monitoring and alerting as needed
- Works with the team on any infrastructure and code database performance issue utilizing SQL Sentry
- Helps in monitoring and troubleshooting SQL Server Availability Groups including replication issues and database failovers
- Works with the team on certificate tracking and renewals
- Provide after-hours (on-call coverage) on weekly scheduled basis
Required qualifications capabilities and skills
- Formal training or certification on infrastructure engineering concepts and 3 years applied experience
- Strong experience with relational database systems
- Experience and/or solid understanding of transact SQL
- Strong proficiency in SQL infrastructure including Availability Groups.
- Knowledge of PowerShell and ETL processes
- Ability to work collaboratively with cross-functional teams including non-technical business stakeholders
- Experience with operating internal cloud applications
- Excellent communication skills with the ability to convey complex technical concepts to non-technical audiences
- Experience with version control systems such as Git and bitbucket for data
- Experience working with development teams from operational and controls perspective
- Experience with overall SQL troubleshooting
Preferred qualifications capabilities and skills
- Proficient with PowerShell
- Experience tuning and troubleshooting T-SQL queries and indexes
- Experience with internal cloud application infrastructure