Logo of Huzzle

Home

Matches

Explore

Manage

Database Administration & Design-Vice President

image

Sumitomo Mitsui Trust Bank Limited New York Branch

3mo ago

  • Job
    Full-time
    Expert Level
  • IT & Cybersecurity
    Banking & Finance
  • Jersey City

AI generated summary

  • You need 10+ years as a SQL Server DBA, expertise in SQL Server 2014-2022, high availability, disaster recovery, and experience in a financial environment. Strong communication and documentation skills are essential.
  • You will manage SQL Server platforms, administer and troubleshoot databases, support SSRS/SSIS/SSAS, ensure security compliance, automate tasks, and maintain documentation while collaborating with teams.

Requirements

  • We are looking for a SQL Server DBA Engineer with 10+ years of experience.
  • Experience with SQL Server 2014, 2016, 2017, 2019, 2022
  • Experience with installation, configuration, and maintenance of SQL Servers on Windows VMs
  • Experience with installation, configuration, and maintenances of Always-On, SSRS, SSIS, SSAS
  • Experience with Windows
  • Experience with high availability and disaster recovery, backups/restores
  • Understanding on change control, upgrade, and release deployment activities
  • Knowledge of database security, access control, monitoring, and auditing
  • Experience with DB authentication via AD or Azure AD
  • Experience with monitoring, tuning, and analyzing database performance
  • Experience that is a major plus:
  • Experience with Azure SQL DB’s and SQL VM’s, Always-On Availability Groups
  • Working experience in a financial environment
  • Required Skills / Abilities:
  • Excellent customer service skills
  • Good verbal and written communication skills
  • High sense of urgency as a Trading Floor environment needs to be supported
  • Able to follow directions, priorities, and guidance from management
  • Ability to multi-task and work on several projects at the same time
  • Strong ability to deliver on time
  • Ability to document processes, requirements, and create test plans
  • Strong ability to translate business requirements into technical solutions
  • Strong team player

Responsibilities

  • Support SQL Server 2016, 2017, 2019 and 2022 platforms
  • Support and usage of SSRS, SSIS and SSAS technologies
  • Support of SQL Server Always-On
  • Provide system administration, troubleshooting, monitoring, DB installation, DB backup and restore, database replication setup and maintenance, database development and tuning, user supports, security hardening such as CIS deployment and maintenance
  • Research and recommend innovative solutions and where possible automated approaches for system administration tasks
  • Implement monitoring tools and proactively implement improvement steps to prevent potential issues. Troubleshoot and solve incidents quickly to maintain the high availability environment
  • Carry out periodic Technology Recovery tests and On-Call Support rotation responsibilities.
  • Work with Cybersecurity and audit teams to satisfy security requirements
  • Late night and weekend work may be necessary at times for installations, patching, upgrades, and maintenance
  • Follow the change control processes and procedures
  • The candidate is required to update/maintain all documentation and will be tasked with improving such documentation as required
  • Maintain effective communication with all Infrastructure and Application teams and management

FAQs

What is the anticipated salary range for the Database Administration & Design-Vice President position?

The anticipated salary range for this role is between $142,000.00 and $196,000.00, depending on individual qualifications and experiences.

What role does this position play within the company?

This role is for a Senior SQL Server Database Administrator and Engineer within the Information Systems department, responsible for maintaining and supporting SQL Server database environments.

What specific SQL Server versions will the candidate be supporting?

The candidate will support SQL Server versions 2016, 2017, 2019, and 2022.

Is there a requirement for after-hours work?

Yes, late night and weekend work may be necessary for installations, patching, upgrades, and maintenance.

What experience is required for this position?

The candidate should have 10+ years of experience with SQL Server, including experience with installation, configuration, and maintenance of SQL Servers on Windows VMs, as well as high availability and disaster recovery strategies.

Are there additional skills that are considered a plus for this role?

Yes, experience with Azure SQL DBs, SQL VMs, Always-On Availability Groups, and working in a financial environment are considered major pluses.

What kind of working environment does SMBC provide?

SMBC offers a hybrid workforce model, allowing employees to work from home as well as from an SMBC office, while requiring that employees live within a reasonable commuting distance of their office location.

Does SMBC support diversity and inclusion in its workplace?

Yes, SMBC is committed to fostering a culture of diversity and inclusion and holds leaders accountable for creating an inclusive environment.

What benefits does SMBC offer aside from cash compensation?

In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.

How does the company support employees with disabilities during the application process?

SMBC provides reasonable accommodations for employees and applicants with disabilities consistent with applicable law.

Sumitomo Mitsui Trust Bank Limited New York Branch

Finance
Industry
201-500
Employees
1925
Founded Year

Mission & Purpose

Sumitomo Mitsui Trust Bank, Limited (SuMi TRUST) was established through the merger of The Sumitomo Trust and Banking Co., Ltd. with Chuo Mitsui Trust and Banking, Ltd. and Chuo Mitsui Asset Trust and Banking Company, Ltd. on April 1, 2012. SuMi TRUST is Japan’s largest trust bank, with AUM of more than $800 Billion USD. SuMi TRUST provides an assortment of financial solutions and manages a broad spectrum of financial products across its global branches. The SuMi TRUST NY Branch manages a $35 Billion USD portfolio of corporate debt investments in the United States, with an emphasis on stable income generation, with decades of proven business success. Our areas of expertise include leveraged loans, CLOs, middle-markets, corporate bonds and project financing. SuMi TRUST continues to strive towards excellence and future growth with dedication to our employees and customers.