- Install, configure, upgrade, and maintain IBM Netezza appliances and software.
- Manage database objects including databases, schemas, tables, views, users, and privileges.
- Perform routine health checks and system monitoring.
- Handle capacity planning and storage management.
Performance Tuning & Optimization
- Analyze and optimize complex SQL queries.
- Monitor system performance and resource utilization.
- Tune data distribution keys and zone maps for effective query execution.
- Identify and resolve database bottlenecks.
Backup, Recovery & Disaster Recovery
- Implement and manage backup and restore strategies.
- Support disaster recovery planning and testing.
- Ensure high availability and business continuity requirements are met.
Security & Compliance
- Manage user access controls and database security.
- Implement auditing and compliance requirements.
- Monitor security vulnerabilities and apply fixes.
Data Migration & Integration
- Support ETL processes and data warehouse operations.
- Perform database migrations, upgrades, and patching activities.
- Work closely with data engineering and application teams.
Troubleshooting & Support
- Diagnose and resolve database incidents and performance issues.
- Perform root cause analysis (RCA) for production issues.
- Support 24x7 production environments and participate in on-call rotations.