Netezza

INENT INC

St. Louis (MO)

On-site

USD 90,000 - 130,000

Full time

14 days+

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

INENT Inc is seeking a Netezza Database Administrator to join our team in St. Louis. You will create users, configure Netezza, troubleshoot performance, analyze log files, and collaborate with IBM Netezza Support for fixes.

This role requires strong database concepts and willingness to work in a 24/7 on-support environment. You will be responsible for deployment of changes from development to production, handle backup/restore concepts, and work with application teams globally.

Qualifications

Creation of users/Groups and granting the necessary permissions as per roles.
Configuration of new Netezza users from both Netezza/client servers.
Troubleshooting the query performance issues and rewriting queries as needed.
Toubleshooting system performance issues (H/W SPU/SPA/Switches/SAS Gig Ethernet interfaces).
Proficient in analyzing Netezza log-files (pg.log/dbos.log/sysmgr.log).
Backup/restore methodologies knowledge.
Handle database errors (Memory/Swap/Host memory).
Understand Gen-stats/Reclaim/Groom/nz_migrate concepts.
Basics of Linux scripting/Shell scripts.
Query History configuration concepts.
Nzsql/Nzplsql concepts.
Add new hardware events and Runaway query events.
Willing to work 24/7 on-support environment.
Deploy database changes dev to prod servers.
Collaborate with IBM Netezza Support/Engineering for fixes.
Strong Netezza architecture concepts.

Responsibilities

Create users/groups and assign permissions per roles.
Configure new Netezza users from Netezza/client servers.
Troubleshoot query performance and rewrite queries when needed.
Troubleshoot system performance issues (H/W SPU/SPA/Switches).
Analyze Netezza log-files (pg.log/dbos.log/sysmgr.log).
Understand backup/restore methodologies.
Address database errors (Memory/Swap/Host memory).
Work with Gen-stats/Reclaim/Groom/nz_migrate concepts.
Utilize basic Linux scripting for automation.
Configure Query History and Nzsql/Nzplsql concepts.
Handle hardware events and Runaway query events.
Support 24/7 on-call environment.
Deploy changes from dev to prod and coordinate with teams.

Skills

Netezza

Linux scripting

Nzsql/Nzplsql

Query performance

Backup/restore

Vendor management

24/7 on-support

Architecture concepts

Team collaboration

Netezza architecture

Job description

Company Description

INENT Inc. focuses on understanding, addressing and resolving Talent Acquisition, Engagement and Management needs. The core team has over many years of experience in a variety of industries and management disciplines. We serve our clients with the highest level of service standards, never compromising our integrity and commitment to excellence. The products and services are targeted at niche markets in information technology, health care, Financial Services, government, education and other industries.

INENT Services Includes:

Software Development The services offered cover Custom Software Development, Application Development, Web Application Development, Software Outsourcing, Website Design and Software Maintenance. Our goal is to deliver premium quality software development services and products while giving unmatched value to enterprises worldwide at an affordable cost.
Staffing Solutions: INENT, Inc. provides full implementation, upgrade, support and staff augmentation services

Job Description

Here is the requested information:

1) Creation of users/Groups and granting the necessary permissions as per roles.
2) Configuration of new Netezza users from both Netezza/client servers.
3) Troubleshooting the query performance issues. Analyzing the query plan-files and should have ability to rewrite the query if needed.
4) Troubleshooting system performance issues. (H/w SPU/SPA/Switches/SAS Gig Ethernet interfaces).
5) Proficient in analyzing all the Netezza related log-files like (pg.log/dbos.log/sysmgr.log etc).
6) Should possess over-all idea of concepts of backup/restore methodologies.
7) Should be proficient in tackling various database related errors (Memory/Swap/Host memory errors).
8) Should have clear concepts of Gen-stats/Reclaim/Groom/nz_migrate.
9) Should possess basics of Linux scripting/Shell scripts.
10) Should possess concepts of Query History configuration.
11) Should possess basics of Nzsql/Nzplsql concepts.
12) Should be proficient in adding new h/w events both (automated/manual events) , Runaway query events etc.
13) Willing to work in 24/7 on-support environment.
14) Associate would be taking responsibility of deploying the database changes in dev to prod servers accordingly.
15) Associate has to work with IBM Netezza Support / Engineering for major fixes and s/w or h/w defects (Vendor Management).
16) Should have good Netezza overall Architecture concepts.
17) Associate has to work closely with different application teams/users to help and deploy the new projects as scheduled.
18) Associate has to assist various Netezza users across the globe for any Netezza related issue.

Qualifications

Here is the requested information:

1) Creation of users/Groups and granting the necessary permissions as per roles.
2) Configuration of new Netezza users from both Netezza/client servers.
3) Troubleshooting the query performance issues. Analyzing the query plan-files and should have ability to rewrite the query if needed.
4) Troubleshooting system performance issues. (H/w SPU/SPA/Switches/SAS Gig Ethernet interfaces).
5) Proficient in analyzing all the Netezza related log-files like (pg.log/dbos.log/sysmgr.log etc).
6) Should possess over-all idea of concepts of backup/restore methodologies.
7) Should be proficient in tackling various database related errors (Memory/Swap/Host memory errors).
8) Should have clear concepts of Gen-stats/Reclaim/Groom/nz_migrate.
9) Should possess basics of Linux scripting/Shell scripts.
10) Should possess concepts of Query History configuration.
11) Should possess basics of Nzsql/Nzplsql concepts.
12) Should be proficient in adding new h/w events both (automated/manual events) , Runaway query events etc.
13) Willing to work in 24/7 on-support environment.
14) Associate would be taking responsibility of deploying the database changes in dev to prod servers accordingly.
15) Associate has to work with IBM Netezza Support / Engineering for major fixes and s/w or h/w defects (Vendor Management).
16) Should have good Netezza overall Architecture concepts.
17) Associate has to work closely with different application teams/users to help and deploy the new projects as scheduled.
18) Associate has to assist various Netezza users across the globe for any Netezza related issue.