Senior Netezza Developer
The Sherwin-Williams Company - Cleveland, Ohio
The Senior Netezza Data Warehouse developer will develop, test, analyze, document, and maintain the Netezza data warehouse domestic and global processes and related infrastructure. They will assist in the day to day operations of the Netezza data warehouse. The developer will also research, design, document, and modify software specifications throughout the software development life cycle. They will work closely with DBAs, development staff, Project Management, and the Data Integrity team to support both domestic and global initiatives.Essential Functions
Strategy and Planning
• Day-to-day monitoring of the overall system health of two Production and two Dev/QA Netezza appliances.
• Research, document, and implement Netezza Performance Portal to allow for proactive server monitoring.
• Monitor and maintain existing Netezza Database user and group configurations, and existing backup and restore procedures, to support ITGC effectiveness.
• Work closely with the MicroStrategy development team to document and enhance existing domestic and global data warehouse processes.
• Work closely with the development staff and DBAs to coordinate new & existing processes.
Acquisition and Deployment
• Perform scheduled software upgrades, maintenance, and applying software patches as necessary for the Netezza OS, and for Netezza In-Database Analytics.
• Develop comprehensive disaster recovery procedures and test DR plan during annual DR simulation.
• Perform data validations while working closely with the Data Integrity team.
• Create and maintain auditing and balancing processes and reports.
• Create and maintain accurate project timelines and tasks.
• Perform adhoc queries to facilitate data requests for both internal and external users.
Operational Management
• Document server configurations, hardware relationship diagrams, procedures, and general DB best practices.
• Develop, test, analyze, and document Linux bash scripts for ETL and reporting processes from multiple sources including Oracle systems, the mainframe, and other internal and external systems.
Incidental Functions
• Research new technologies, including tools, components, and frameworks.
• Make presentations to management, clients, and peer groups as requested.
• Analyze performance of programs and take action to correct deficiencies based on consultation with customers and approval of supervisor.
• Provide off-hours support as required.
• Assist with other projects as may be required to contribute to efficiency and effectiveness of the work.
• Participate in hiring activities and fulfilling affirmative action obligations and ensuring compliance with the equal employment opportunity policy.
• Minimal travel is required
• Work outside the standard office 7.5 hour workday may be required.
Position Requirements
Formal Education & Certification
• Bachelor Degree or foreign equivalent in related field or equivalent experience.
Knowledge & Experience
• 5 years of IT experience.
• 3 years in SQL development (such as PostgreSQL, SQL, PL-SQL)
• 3 years of server side scripting and programming in a Linux/Unix/Solaris environment.
Preferred Experience
• Experience working with customers to build and formulate business requirements.
• Excellent understanding of common database technologies including performance, tuning, and optimization (Netezza preferred).
• Strong data manipulation skills and experience with data warehouse ETL tools and processes.
• General understanding of Business Intelligence Tools (Business Objects, OBIEE, or MicroStrategy).
Personal Attributes
• Strong analytical, conceptual, and problem-solving abilities.
• Strong written and oral communication skills.
• Good presentation and interpersonal skills.
• Ability to conduct research into database issues, standards, and products.
• Ability to present ideas in user-friendly language.
• Able to prioritize and execute tasks in a high-pressure environment.
• Ability to work in a team-oriented, collaborative environment.
Unable to retrieve job information. This job may not be available anymore. Sorry for the inconvenience. • Work outside the standard office 7.5 hour workday may be required.
Position Requirements
Formal Education & Certification
• Bachelor Degree or foreign equivalent in related field or equivalent experience.
Knowledge & Experience
• 5 years of IT experience.
• 3 years in SQL development (such as PostgreSQL, SQL, PL-SQL)
• 3 years of server side scripting and programming in a Linux/Unix/Solaris environment.
Preferred Experience
• Experience working with customers to build and formulate business requirements.
• Excellent understanding of common database technologies including performance, tuning, and optimization (Netezza preferred).
• Strong data manipulation skills and experience with data warehouse ETL tools and processes.
• General understanding of Business Intelligence Tools (Business Objects, OBIEE, or MicroStrategy).
Personal Attributes
• Strong analytical, conceptual, and problem-solving abilities.
• Strong written and oral communication skills.
• Good presentation and interpersonal skills.
• Ability to conduct research into database issues, standards, and products.
• Ability to present ideas in user-friendly language.
• Able to prioritize and execute tasks in a high-pressure environment.
• Ability to work in a team-oriented, collaborative environment.
Must be legally authorized to work in country of employment without sponsorship for employment visa status now or in the future.
Equal Opportunity Employer. All qualified applicants will receive consideration for employment and will not be discriminated against based on race. color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information or any other consideration prohibited by law or contract.
VEVRAA Federal Contractor requesting appropriate employment service delivery systems, such as state workforce agencies and local employment delivery systems, to provide priority referrals of protected veterans.
Equal Opportunity Employer. All qualified applicants will receive consideration for employment and will not be discriminated against based on race. color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, pregnancy, genetic information or any other consideration prohibited by law or contract.
VEVRAA Federal Contractor requesting appropriate employment service delivery systems, such as state workforce agencies and local employment delivery systems, to provide priority referrals of protected veterans.
Posted: 30+ days ago
About The Sherwin-Williams Company
The year 2016 is a unique moment in the history of Sherwin-Williams — it’s our 150th anniversary. We are proud to honor our founders Henry Sherwin and Edward Williams, and the thousands of men and women who have shaped our company since 1866... more
