Job Description

This role requires a wide variety of strengths and capabilities, including:

• Bachelor's degree
• Minimum 5 years of experience in MSSQL DBA
• Proficient in MS SQL, SSIS, SSMS, SSRS, etc
• Proficient or willing to learn cloud database (eg. Azure, Aws)
• PowerShell scripting skills with DevOps, Infra Development experience
• Strong understanding of Agile, Scrum practices
• Experience with Linux and Windows Server environments
• Certification in Microsoft MSSQL is a plus
• Ability to manage escalated technical situations & develop action plans.
• MSSQL Database Engineering Specific requirements:
  • Installing, configuring, administrating, securing and maintaining SQL Server 2012~2019 instances and databases.
  • Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.
  • Experience in SQL Server database Migration from lower version to higher version.
  • Hands on Experience on Database High Availability solutions like Log-Shipping, Database Mirroring, Replication, Clustering and AlwaysON.
  • Involved in server and database level performance issues.
  • Using PerfMon/Profiler solved low-level SQL Server bottlenecks like Dead Locks/Long running queries.
  • Responsible for database backups and restoration, backup strategies and scheduling backups and performed Database Refresh tasks.
  • User and database security management, creating groups, users, roles, granting permissions.
  • Risk & Control Assessment reviews and compliance check for SQL Servers.
  • SSL Certificate deployment and maintenance on all SQL Servers.
  • Monitor databases for errors and perform problem determination when necessary.
  • Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans

J.P. Morgan is a global leader in financial services, providing strategic advice and products to the world's most prominent corporations, governments, wealthy individuals and institutional investors. Our first-class business in a first-class way approach to serving clients drives everything we do. We strive to build trusted, long-term partnerships to help our clients achieve their business objectives. 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. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.