JPMorgan Database Administrator- Lead Infrastructure Engineer 

United States, California 

890219591

Job Responsibilities:

• Apply technical expertise and problem-solving methodologies to projects of moderate scope.
• Collaborate with other platforms to architect and implement changes required to resolve issues and modernize the organization and its technology processes.
• Execute creative solutions for the design, development, and technical troubleshooting of problems of moderate complexity.
• 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.
• Utilize tools such as JET, Jules, and Spinnaker effectively.

Required qualifications, capabilities, and skills:

• Formal training or certification in infrastructure engineering concepts with 5+ years of applied experience.
• Deep knowledge of one or more areas of infrastructure engineering, such as hardware, networking terminology, databases, storage engineering, deployment practices, integration, automation, scaling, resilience, or performance assessments.
• 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.
• 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