Title: Netezza Administrator
Location: Remote (India)
Time : 7.00 Am Or 1.00 Pm IST shift
Targeted Start Date:should Immediate (We are looking only for immediate candidates)
Exp - 5 - 10 Years
Job Description:
Database Administrator ( strong Netezza experience)
Environment
The DBAs will support a data warehouse ecosystem utilizing:
- Oracle
- SQL Server
- Netezza
Current workload distribution is approximately:
- Netezza: ~50%
- Oracle: ~25%
- The client is also moving heavily toward Oracle Exadata and would strongly prefer candidates with Exadata and RAC experience.
- SQL Server: ~25%
Responsibilities:
Application DBA Support
This role is primarily an Application DBA function focused on project delivery and operational support rather than infrastructure management.
Key responsibilities include:
- Database deployments
- Environment support
- User and security administration
- Performance monitoring and troubleshooting
- Backup and recovery support
- Database access and permissions management
- Ticket management and issue resolution
- Participation in project delivery activities
DBAs will act as a first point of contact for database-related issues, including:
Performance Monitoring
- Locking and blocking issues
- Long-running jobs
- Data processing failures
- Missing or ineffective indexes
- SQL performance troubleshooting
Operational Support
- Reviewing database logs
- Monitoring CPU and storage utilization
- Troubleshooting database job failures
- Diagnosing setting issues and escalating when necessary
The role functions largely as an L2/L3 support resource responsible for initial investigation and resolution.
Build and Deployment Support
The team supports data warehouse development projects through:
Build Activities
- Reviewing code changes
- Merging code into GitHub repositories
- Supporting development teams during implementation
Deployment Activities
- Executing database deployment scripts
- Following deployment instructions packaged through ServiceN