OmegaHires
Website:
omegahires.com
Job details:
Position: Netezza DBA
Experience: 6-10 Years
Location: Hyderabad
Role Summary
We are seeking an experienced Netezza Database Administrator (DBA) responsible for the administration, maintenance, performance tuning, monitoring, backup/recovery, and support of IBM Netezza data warehouse environments. The ideal candidate should have strong expertise in Netezza architecture, database performance optimization, data migration, and troubleshooting in large-scale enterprise environments.
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.
Click on Apply to know more.
