Database Administrator

Company: Sumitomo Mitsui Trust Bank (U.S.A) Limited
Location: Hoboken
Posted on: March 16, 2023

Job Description:

SUMMARY

Database Administrator is responsible for maintaining, configuring, and performance tuning database systems. The current platforms that need to be supported are MS SQL Server 2016 and 2019, as well as Oracle 19c. The primary duties include correcting issues in real time, ensuring performance, availability, security, monitoring the health of all internally hosted database server supported by the IT Production Support area.

JOB FUNCTIONS/DUTIES AND RESPONSIBILITIES

• Monitors daily processing, research exceptions and request items
• Monitors database performance and performs database tuning
• Establishes and monitors database backup, recovery, and replication processes
• Participate in disaster recovery testing for databases in conjunction with the Business Continuity Team
• Establishes database access controls under the supervision of the Security Administrator
• Designs and creates databases for applications developed by the bank implementing bank standards
• Perform data masking tasks
• Designs and writes stored procedures in SQL
• Reviews code (stored procedures) for release ensuring bank defined database best practices are adhered to
• Adheres to bank policy regarding change management
• Be part of the L2 production support team supporting internal and vendor applications.
• Be able to analyze a situation, communicate the issue to clients and management in a clear and concise manner.
• Installs, upgrades, and patches both MS SQL Server and Oracle databases with ASM running on Linux
• Working knowledge in database systems architecture, including networking, security, scaling, and fault-tolerance.
• Working knowledge of database internals such as locking, wait events, consistency, logging, recovery.
• Enhances knowledge and understanding of job responsibilities through continuous communication and on the job training.Training should focus on establishing high quality/accuracy of work.
• Participate in the on-call rotation of the Production Support group
• Provides high quality work by ensuring accuracy and seeking to continuously improve our processes and platforms by embracing new and better ways of doing things. REQUIREMENTS
  
• Bachelor's degree in Computer Science or equivalent
• 5years of DBA experience on Windows for Microsoft SQL and Linux with Oracle experience.
• Ability to work with Windows, UNIX, and Linux operating systems
• Knowledge of SQL, Transact SQL, PL-SQL
• Knowledge of PowerShell or other scripting languages
• Experience with version control system
• Experience with AWS, Doubletake, CloudEndure, or AWS DRS is a plus
• Experience with database monitoring tools - Solarwinds DPA, or Idera Diagnostic Manager a plus
• Experience with DataMasker tool for masking databases is a plus
• Excellent problem analysis and resolution skills.
• Excellent interpersonal skills.
• Excellent oral and written communication skills in English.
• Ability to work independently in a decentralized environment, without the reliance of direct authority.
• Proven maturity, reliability, composure, and stability under pressure.
• Strong organizational, analytical, and planning skills; Attention to detail and the ability to prioritize multiple, competing responsibilities
• Experience working directly with internal and/or external customers in database software development, release deployment, and support.
  
  PHYSICAL DEMANDS
  
  None

Keywords: Sumitomo Mitsui Trust Bank (U.S.A) Limited, Hoboken , Database Administrator, Other , Hoboken, New Jersey