Netezza Admin

Company: ShoreWise Consulting
Location: Bellevue
Posted on: February 17, 2020

Job Description:

Company Description

ShoreWise Consulting is a world class IT solution provider offering technology solutions and managed services in verticals such as Customer Contact, Healthcare and Finance (banking & trading).

Job Description

Netezza Support Tasks

--- Updating Backup/Restore scripts on addition/deletion of new database or other objects

--- Lead database administration (DBA) efforts to perform various admin tasks, such as identifying bad queries and performance tuning associated with Netezza appliances

--- Change in Update Statistics script(s) if any, on changes in Database objects

--- Reclaiming activities on deletion of database objects

--- Taking Backup and performing selective restore of database as validation.

--- Making space available by performing Reclaim (Groom) on databases tables and vacuum for system tables

--- Updating Statistics and zone-maps to improve query performance

--- Management of File sizes : Log file maintenance and archiving of older log files, maintaining space for new data files by performing cleanup activities

--- Corruption detection and SCSI error check on disks.

--- Health Check to maintain healthy hardware environment and resolve any possible issues before hand

1 SYSTEM ADMINISTRATION

--- Maintain the Netezza tool by monitoring for new software upgrade releases and implementing all relevant upgrades in the Customer's system in coordination with IBM.

--- Maintain the Netezza analytic database.

--- Document existing feature requests, in order to accommodate any and all new queries for new events and features.

--- Communicate system failures to TMP and provide guidance to successfully resolve incident.

--- Communicate the introduction of new features and updates in Netezza and provide necessary training to users in coordination with IBM.

2 PLATFORM SUPPORT

--- Coordinate as needed Netezza upgrades and validation on all processing node servers.

--- Coordinate user training on Netezza, including, but not limited to:

o Functionalities,

o Features,

o Updates

--- Manage and coordinate trouble tickets related to Netezza platforms.

--- Coordinate new features requests received from various Customer's engineering teams and work with TMP on prioritizing the implementation of the requested features.

--- Update queries and key performance indicators ("KPIs"), as necessary, for new requirements and performance improvements, including, but not limited to:

o Parser performance,

o System load,

o Mean time to process data

--- Perform Netezza system health check and management:

o Monitor hardware outages.

o Netezza account provisioning.

o Provide specific data (i.e. usage report, users) to the Customer's management team.

3 OPTIMIZATION SUPPORT

--- Assist and support Customer's with the architectural feasibility and use of systems, including both Netezza and Hadoop, based on specific data use cases.

--- Troubleshoot specific issues related to the optimization in Netezza, including, but not limited to, data integrity and additional queries.

4 MULTI DATA SOURCE MANAGEMENT

--- As necessary, determine outside data source requirements for data analysis and optimization.

--- Create necessary queries, scripts, Extract Transport Loads ("ETL") and schedule tasks for automatic data extraction and manipulation from different data sources (parsers).

--- Modify and troubleshoot queries, script and ETLs to adapt with any changes coming from data source.

--- Coordinate with Customer's engineering teams on generating and updating data (i.e. TPIM, planning team, etc.).

--- Troubleshoot issues related to the files uploaded to Netezza.

Additional Information

12 months with possibility of extension.

Keywords: ShoreWise Consulting, Seattle , Netezza Admin, Administration, Clerical , Bellevue, Washington