Location: Remote
Experience: 7+ Years
Shift Timing: Complete night shift - 8:30pm - 5:30am IST
Roles & Responsibilities:
· Lead database performance 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.
· Robust 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.
📌 Netezza Performance Engineer (India)
🏢 Blutic
📍 India