Location: Remote

Experience: 7+ Years

Roles & Responsibilities:

·       The candidate should have a Bachelor’s degree in Computer Science or a related field.

·       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.

·       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.