Skip to Main Content

SQL Database Administrator (Mandarin)

PGM TEK
New York, NY
  • Expired: over a month ago. Applications are no longer accepted.
Job Description

One of the largest global banking institutes in New York City is looking for a DBA.

This is a long-term consulting role for an international bank in NYC. It is responsible for managing and administering the Branch’s databases including but not limited to SQL Server and Oracle, to make sure that data is available to users, and to ensure the databases are secure from unauthorized access or accidental loss or corruption. The position is also responsible for designing, testing, planning, implementing, protecting, operating, managing, and maintaining database applications of the Branch.

Responsibilities:

  • Perform database installation, upgrade, migration, configuration, administration, and security patches.
  • Design and implement database structures on relational schemas and tables. Perform other database housekeeping activities such as security administration, user access management, backup/recovery, and performance monitoring.
  • Execute routine database backup and disaster recovery activities.
  • Perform service packs and security patch updates at the OS and MS SQL Server levels, as well as other database-related vulnerabilities remediation to comply with the Branch policies and standards.
  • Monitor, troubleshoot database issues, and conduct performance tuning, including but not limited to slow queries, statistics, indexing, partition, etc.
  • Deploy new code releases in lower and production environments.
  • Conduct database maintenance, performance tuning, capacity planning, database optimization, and other database administration tasks.
  • Implement SQL Logins, Roles, and Authentication Modes as a part of Security Policies for various categories of users.
  • Diagnose and troubleshoot ETL process and database errors.
  • Develop processes and build standards for Data Replication, Database Security, Encryption, Compression and Data Masking/Redaction.
  • Manage and administer database access and database user access management, set and maintain database standards.
  • Maintain version control on system servers and other application servers.
  • Report on KRI & KPI metrics regarding usage and performance.
  • Create and manage database reports, visualizations, and dashboards.
  • Create automation for repeating database tasks.
  • Respond in a timely manner to user-reported errors.
  • Suggest changes and improvements for database maintenance or protection.
  • Design databases with both front-end and back-end users in mind.
  • Strong organizational skills with attention to detail and the ability to manage multiple and concurrent tasks.
  • Excellent communication and documentation skills.
  • Any other work assigned by IT Department Management.

Education and Experience Requirements:

  • A bachelor's degree in computer science or a related field.
  • A minimum of 3 years experience as a database administrator.
  • Oracle and MS-certified Database Administrator is preferred.
  • Proficiency in data manipulation languages, including MS SQL Server, Oracle database, Hadoop, or PostgreSQL.
  • Excellent experience with RDBMS, especially in Database tuning, upgrades, installation, configuration, security patches, and etc.
  • Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
  • Strong experience with performance tuning, capacity planning, and optimization of database environments.
  • Performance of load balancing/High Availability (HA) and Disaster Recovery (DR) options for SQL Server.Advanced knowledge of Microsoft Business Intelligence Technology including T-SQL, SSIS, and SSRS.
  • Understanding of relational and dimensional data modeling.
  • Good understanding of the VMWare environment, storage hardware and software.
  • Experience working with Windows server operating system, including Active Directory.Good to have experience writing PowerShell, and/or Python.
  • Analytical mindset and good problem-solving skills.
  • Capable of working under pressure.
  • Ability to read, write and speak Mandarin a plus.

PGM TEK

Address

New York, NY
USA

Industry

Technology