Perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance on Netezza appliance platform.
Use the NZAdmin/NZMigrate tool for typical administrative tasks, including Genstats, Groom, and manage Development to Production environments.
Perform database backup and restore activities.
Work closely with Developers, Data Modelers, Architects, Business Analysts and other IT staff to implement Database Administration standards, policies, methods, and procedures building consensus with all parties.
Assist application development teams with planning and implementing database changes as well as query/job optimization.
Create, test, implement and monitor an automated set of procedures for database and server backups as well as necessary maintenance procedures.
Work closely with IBM support to manage hardware/software failures, appliance upgrades and install patches.
Troubleshoots difficult database problems, including slow running queries.
Manage workload via prioritization and configuration.
Excellent verbal/written communication & client interfacing skills.
Exposure to Google Cloud and have worked on Big query
Worked on migrating Netezza to other Database technology.