Filters

Location

me

Job Type

Full-time

Part-time

Contractual

Hourly

Intership

Consultant Toronto

HCL Technologies

HCL Technologies Toronto Canada

2 weeks ago

Ontario

4.5-8 Years

Canada

Job Description (Posting).

1.1 Big Data Support (Exadata, Netezza, ODA, ZFS, GG, DBA)

(a) As part of the Big Data Support Services , Service Provider will provide 24x7 support of the following State Street database environments: Exadata, Netezza, Oracle databases (DBA), Oracle database appliance (ODA), ZFS, Golden Gate ( Big Data ).

(b) As part of the Big Data Support Services , Service Provider will operate a tiered support model where the first level support for the infrastructure will be provided through the SysOps team (i.e., monitoring, basic troubleshooting) and the second level support will be provided by the Big Data Support system administrators as well as Big Data database administrators.

(c) Service Provider will also have separation of duties between engineering and operations (including between the system administrator and database administrator).

(d) Service Provider understands and operates the primary responsibilities of Big Data... systems administration (SA) functions. And work closely with State Street to make sure that State Street business needs are being met and that any changes are fully tested and compatible with the State Street business applications, schedules, and capacity needs. Following are the activities performed as SA function on Big Data systems:

(i) Monitoring all Exadata, ODA, ZFS, Netezza, DBA and Golden Gate systems;

(ii) Conduct agent install, configuration and maintenance (e.g., Autosys, Tanium, Illumio, Dynatrace, Splunk);

(iii) Apply security patch for all vulnerabilities;

(iv) Support during application and database issues and Major Incidents;

(v) Conduct OS tuning for appliances, including working with vendor for maximum performance;

(vi) Conduct ad hoc system health check to identify any new issues;

(vii) Provide data replication support;

(viii) Provide HA support and RAC support;

(ix) Coordinate with all applicable vendors for hardware related break fix;

(x) Conduct lifecycle hardware migration;

(xi) Manage and implement new hardware installation with request for power, space, network, vendor and access;

(xii) Provide NFS Support for ZFS;

(xiii) Provide ZFS support for database migrations;

(xiv) Provide support to State Street Global Advisors (SSGA) Exadata infrastructure;

(xv) Implement CMDB updates for new hardware, decommissioned hardware, entry mismatch, entry duplication with upper case and lowercase;

(xvi) Conduct OEM setup and maintenance;

(xvii) Conduct ASR validation and updates working with all applicable vendors;

(xviii) Provide automatic storage management (ASM) and cluster ready services (CRS) support during installation and upgrades;

(xix) Perform decertification of old Exadata frames after migration of databases to newer frames and/or hardware;

(xx) Perform database encryption using wallets or other State Street engineering-approved solutions;

(xxi) Deploy and maintain digital transport layer security (TLS) certificates on demilitarized zone (DMZ) environments for direct client connection databases;

(xxii) Conduct fast recovery area (FRA) monitoring and housekeeping; and

(xxiii) Respond to ASR alerts on compute nodes and storage servers, switches, etc., by owning investigation and fixes, by collaborating with Oracle vendors and data center facilities teams, including raising necessary tickets.

(e) Specifically, as part of the Big Data Support Services, Service Provider will provide database configuration and support, which includes Service Provider performing database monitoring and the following tasks, among others:

(i) Control, monitor and audit user access to the database;

(ii) Control, monitor and audit all user activity within the database;

(iii) Escalate database incidents immediately to the State Street s SOC;

(iv) Monitor and optimize the performance of the physical database;

(v) Mai

Qualification

B-Tech

No. of Positions

1

Skill (Primary)

Technical Skills-Systems Internal & Storage-Netezza

Employee Group

Business Line FT

City

Central Toronto (Davisville)

Entity

INFRA

Auto req ID

1241250BR

Expected Date of Closure

08-Jun-2023
Toronto ON

Salary Criteria

Suggestions

people

Robert.D

people

Robert.D

people

Robert.D

people

Robert.D

people

Robert.D

Copyright © 2023 Fonolive. All rights reserved.