Previous Job
Previous
Database engineer with Netezza
Ref No.: 20-00891
Location: Chicago, Illinois
Position Type:Contract
Role and Responsibilities:
Looking for a senior database administrator/engineer with experience in Netezza (MPP on-premises database appliances) and ideally also with at least one cloud based database such Azure Synapse/SQL Data Warehouse or Snowflake. The ideal candidate would have additional experience in ETL, ELT, and Big Data ecosystems and platforms such as Databricks.
Required Experience & Qualifications:
  • Expert in Netezza or similar MPP on-premises database appliance
  • Thorough understanding of Netezza architecture and how applications should interact with Netezza
  • Strong knowledge of Netezza administration tasks, consisting of:
    • SQL Tuning
    • Distribution & Zone Maps
    • Loads, nz_migrate
  • Advise Data Architects and Developers on best practices in relation to data models, DDL/DML, and suggest areas of improvement for performance and efficiencies.
  • Experience with Backups/Restores, Grooming, Vacuuming, statistics, nz command line utilities, health checks, explain plans, object design, security management, PMR management, upgrades and patching
Preferred Experience & Qualifications:
  • Prior experience with cloud and cloud based databases (Azure Synapse/SQL Data Warehouse, Snowflake)
  • Knowledgeable in ETL/ELT design and tools both on-premises and cloud (Ab Initio, Databricks, Azure Data Factory, etc.)
  • Experience with Azure ecosystem and related tools (Databricks, Power BI)
  • Shell Scripting a Plus