Netezza Database Administrator

Netezza Database Administrator Summary: Responsibilities include management and monitoring of Netezza and DB2 databases in support of the Enterprise Data Warehouse environment. Test and implement changes to the database. Apply knowledge of database management systems to improve performance, stability and recoverability. Responsible for planning, coordinating and implementing security measures to safeguard the computer database. ESSENTIAL JOB FUNCTIONS • Perform database performance analysis, ongoing maintenance/tuning to ensure maximum performance on Netezza and DB2 UDB systems. • Very strong Analytical and problem solving skills, in depth technical knowledge and effectively applies business solutions; improve productivity through re-usable centric design • Extensive experience in Netezza 4.5.2/7.x, NZ utilities, NZLOAD, nzbackup, nzstats, Oracle, PL/SQL, Oracle utilities like SQL Loader, Shell Scripting, awk scripting & Unix Utilities • Extensive experience in Dimensional Data Modeling & Application Modeling (OLTP Applications). • Working experience for building Enterprise Data Warehouse Solutions • Assist development teams with planning and implementing database changes and query optimization. • Recommend and implement a detailed security design based on minimum necessary privileges required. • Review SQL queries and database design for performance. • Work as part of a project team to coordinate database development and determine project scope and limitations. • Support QA and DEV environments with refresh tasks. • Develop and implement data patches to address incidents and enhancements. • Facilitate implementation of data, script and/or code changes into the production environment. EDUCATION / EXPERIENCE REQUIREMENTS • Bachelor’s degree with a minimum of 6 years of combined experience in Netezza and DB2 UDB administration. • Exposure to mainframe, desktop, and UNIX system support is required. • Support experience will include installation, setup and configuration, and troubleshooting of hardware, software, and network issues. • Expert understanding and application of data warehouse architecture principles; including data warehouse data storage strategy/technique (ODS, EDW, DM, ROLAP, MOLAP, etc.). • Strong shell scripting (ksh) and SQL experience, specifically on DB2 and Netezza. • Expert level experience in administering large databases in mission critical environment. • Must have good understanding of Netezza architecture (grooming, distribution, etc.). • Develop and define administrative and operational standard practices to leverage Netezza performance. • Solid experience in Netezza system configuration and setup with its utilities and tool sets. • Strong knowledge and experience with computer hardware including Servers, Network, SAN technologies, I/O subsystems. • Experience in SDLC and change management process. • Basic project planning and management, strong communication and interpersonal skills, leadership abilities, strong technical abilities, quick study of new technology via on the job training, the intellect to resolve complex problems logically and methodically, and good judgment to involve and communicate with vendors, senior level technicians and management. • Positive attitude, problem solving skills and initiative are important key behaviors. Banking or financial services industry experience preferred Job Type: Contract Pay: Up to $80.00 per hour Expected hours: 40 per week Work Location: Remote Apply tot his job