Role & responsibilities
Position:
Job Overview
Senior Database Administrator (Netezza DBA)
The candidate will be responsible for application database support, performance monitoring, troubleshooting, database deployments, security administration and supporting data warehouse development projects.
This is primarily an Application DBA role focused on project delivery and operational support rather than infrastructure management.
Key Responsibilities
1. Database Administration & Application Support
- Provide L2/L3 database support across Netezza, Oracle and SQL Server environments.
- Perform database deployments and environment support activities.
- Manage database users, access permissions and security administration.
- Support backup and recovery activities.
- Monitor database performance and troubleshoot issues.
- Manage database-related tickets and resolve operational issues.
2. Performance Monitoring & Troubleshooting
- Identify and resolve database locking and blocking issues.
- Troubleshoot long-running queries and database jobs.
- Identify missing or ineffective indexes.
- Perform SQL performance tuning and query troubleshooting.
- Review database logs and monitor CPU and storage utilization.
- Investigate data processing failures and environment-related issues.
3. Build & Deployment Support
- Review database code changes and support code merging into GitHub repositories.
- Execute database deployment scripts across QA and UAT environments.
- Follow deployment workflows through ServiceNow and Jira.
- Troubleshoot database deployment issues.
- Collaborate with development teams during implementation and release activities.
4. Project & Operational Support
- Support multiple applications and projects simultaneously.
- Work closely with Data Engineers, Developers, Project Managers, Scrum Teams and Product Owners.
- Provide database support throughout Development, QA, UAT and Release phases.
- Participate in Agile project delivery activities.
- Monitor ticket queues and ensure timely resolution of database-related issues.
Required Technical Skills
- Strong hands-on experience in
IBM Netezza Database Administration
. - Experience with Oracle Database Administration.
- Working knowledge of Microsoft SQL Server.
- Database performance monitoring and SQL tuning.
- Database backup and recovery.
- User provisioning, access management and security administration.
- Database deployment and production support.
- Data Warehouse / OLAP environment experience.
Preferred Skills
- Oracle Exadata experience.
- Oracle RAC experience.
- DB2 database experience.
- GitHub, ServiceNow and Jira.
- Experience supporting enterprise data warehouse environments.