Netezza DBA

OmegaHires · India

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 efficient 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.