Senior Netezza Performance Tuning Engineer

Location: Remote

Experience: 7+ Years

Shift Timing: Complete night shift - 8:30pm - 5:30am IST

Roles & Responsibilities:

· Lead database performance tuning engineering initiatives for Netezza environments supporting enterprise-scale data warehouse platforms.

· Analyze and optimize complex SQL queries, ETL jobs, and stored procedures, providing recommendations displaying performance improvements.

· Identify system bottlenecks related to CPU, memory, disk I/O, SPU distribution, skew, and concurrency issues.

· Optimize database performance through effective table design, distribution keys, zone maps, data organization, and partitioning strategies.

· Collaborate with application development, ETL, BI, and infrastructure teams to improve application SQL performance.

· Monitor platform health, workload behavior, and long-running queries using Netezza performance monitoring tools and custom scripts.

· Hands-on experience with Groom, Generate Statistics, query execution plans, and database performance diagnostics.

· Strong understanding of Netezza architecture, Postgres internals, query execution engine, and parallel processing concepts.

· Recommend database performance best practices, coding standards, and optimization frameworks.

· Support high-availability enterprise environments with focus on performance stability, scalability, and reliability.

· Ability to document performance findings, optimization recommendations, and engineering solutions for technical and management stakeholders.

· Strong verbal and written communication skills.

Nice to Have

· Experience with cloud platforms such as Azure or AWS.

· Exposure to Snowflake or modern cloud data warehouse technologies.

· Experience with enterprise monitoring and observability tools.

· Knowledge of data warehousing concepts and large-scale ETL ecosystems.