Provide on-going day to day Netezza Database Administration Staff Augmentation including support, maintenance and troubleshooting.
Configure and Modify Netezza events/monitoring and add new events if necessary
Set up Backup and Groom scripts
Monitor and Test Backup and Restore performance
Setup/maintain Netezza database, tables/views, users and security
Performance tuning and optimization for slow-running queries
Conduct data profiling/analysis and optimize physical design (data types, distributions)
Systems and service upgrades, including application of patches and upgrades
Conduct query/access path analysis and optimize physical design (distributions, CBT)
Test and optimize Netezza load performance
Daily troubleshooting of Netezza environment to ensure system is operational and performing as expected.
Utilize client Service Desk ticketing system to field moves, adds, changes and troubleshooting requests to Netezza environment.
Documentation of support procedures, troubleshooting and maintenance
Provide capacity/growth/trending reports
Job Maintenance and Support
Document and update Disaster Recovery plan