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 environment 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