Basking Ridge, New Jersey
Phone + Skype
Senior Netezza DBA with ETL (SAS) experience. Contract to Hire (Must be or ).
As part of this role the candidate is required to coordinate and implement the changes to the Netezza database. Required to review SQL queries and database design for performance.
Responsible for planning,
coordinating, and implementing security measures to safeguard the computer database.
Required to develop standards and best practices along with performance tuning for Netezza database.
Needs to design and develop ETL (SAS) jobs for large data feeds and support complex data warehouse transactions.
Also troubleshoot, data analysis, validation, and identify data quality issues. Key Requirements:
5+ years of additional experience working in data warehousing and business intelligence tools, techniques and technology is strongly desired
8+ years of experience in DBA role with 3+ year experience in Netezza environment
5 years of experience using SAS to perform ETL
Must have 5+ years of SQL programming and Performance Tuning experience
Experience using Python to perform ETL functions
5 years of experience developing and maintaining Linux shell scripting
Expert level experience in administering large databases in mission critical environment
The application is a report generation tool. Netezza is the primary database. Need someone with ETL experience (preferably SAS but open to a very Senior person without SAS specific)
Metadata is stored in Oracle so that is a BIG plus. Preferred Qualifications:
Knowledge of NAZ mounts on servers and also experience with Object storage.
Experience with Pearl Oracle DBA experience is plus.
Ability to participate in code reviews and understand the feature capabilities