Key Responsibilities
Database Administration
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 productive 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.