Netezza

Posted 2 Days Ago
Be an Early Applicant
St. Louis, MO, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Provide Netezza database administration and support: create users/groups and permissions, configure users, troubleshoot query and system performance, analyze log and plan files, manage backup/restore concepts, run gen-stats/reclaim/groom/nz_migrate, handle DB errors, implement hardware events, deploy changes from dev to prod, liaise with IBM Netezza support and application teams, and provide 24/7 global support.
Summary Generated by Built In
Company 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.

Additional Information


Thank you
 
Bhanu
Inent Inc (Innovative Enabling Technologies Inc )
Tel: 909 610 3103 * 127
Fax No: 310 388 0405
email: bhavanir(AT)inentinc.com
www.inentinc.com

Skills Required

  • Creation of users/groups and granting permissions per roles
  • Configure new Netezza users from Netezza and client servers
  • Troubleshoot query performance, analyze query plans, and rewrite queries as needed
  • Troubleshoot system performance (hardware: SPU/SPA, switches, SAS, Gig Ethernet)
  • Analyze Netezza log files (pg.log, dbos.log, sysmgr.log)
  • Understanding of backup and restore methodologies
  • Diagnose and resolve database memory/swap/host memory errors
  • Knowledge of Gen-stats, Reclaim, Groom, nz_migrate
  • Basic Linux scripting / shell scripting skills
  • Knowledge of Query History configuration
  • Basic Nzsql and Nzplsql knowledge
  • Ability to add and manage hardware events (automated/manual), runaway query events
  • Willingness to work in a 24/7 on-support environment (shift work/on-call)
  • Deploy database changes from dev to prod environments
  • Work with IBM Netezza Support / Engineering for major fixes and vendor management
  • Strong understanding of Netezza architecture
  • Collaborate with application teams and assist global Netezza users
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
12 Employees
Year Founded: 1982

What We Do

Inent Inc is an award-winning IT services and staffing firm founded in 2010. The company specializes in delivering specialized talent and consulting services to Fortune 1000 customers, with core expertise in Salesforce, SAP, Pega, mobile application development, and data services including Hadoop and NoSQL. They focus on optimizing business productivity and growth through strategic IT implementations and talent acquisition solutions.

Similar Jobs

In-Office
2 Locations
93K-109K Annually

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

Microstrategy .Developer

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account