nTitle : Netezza Administrator

nLocation: Remote (India)

nTime : 7.00 Am Or 1.00 Pm IST shift

nTargeted Start Date:should Immediate (We are looking only for immediate candidates)

nExp - 5 - 10 Years

n

n:

nDatabase Administrator ( strong Netezza experience)

nEnvironment

nThe DBAs will support a data warehouse ecosystem utilizing:

n

n
- Oracle
n
- SQL Server
n
- Netezza
n

nCurrent workload distribution is approximately:

n

n
- Netezza: ~50%
n
- Oracle: ~25%
n
- The client is also moving heavily toward Oracle Exadata and would strongly prefer candidates with Exadata and RAC experience.
n
- SQL Server: ~25%
n

n

nResponsibilities:

nApplication DBA Support

nThis role is primarily an Application DBA function focused on project delivery and operational support rather than infrastructure management.

nKey responsibilities include:

n

n
- Database deployments
n
- Environment support
n
- User and security administration
n
- Performance monitoring and troubleshooting
n
- Backup and recovery support
n
- Database access and permissions management
n
- Ticket management and issue resolution
n
- Participation in project delivery activities
n

nDBAs will act as a first point of contact for database-related issues, including:

nPerformance Monitoring

n

n
- Locking and blocking issues
n
- Long-running jobs
n
- Data processing failures
n
- Missing or ineffective indexes
n
- SQL performance troubleshooting
n

nOperational Support

n

n
- Reviewing database logs
n
- Monitoring CPU and storage utilization
n
- Troubleshooting database job failures
n
- Diagnosing environment issues and escalating when necessary
n

nThe role functions largely as an L2/L3 support resource responsible for initial investigation and resolution.

n

nBuild and Deployment Support

nThe team supports data warehouse development projects through:

nBuild Activities

n

n
- Reviewing code changes
n
- Merging code into GitHub repositories
n
- Supporting development teams during implementation
n





nDeployment Activities

n

n
- Executing database deployment scripts
n
- Following deployment instructions packaged through ServiceNow/Jira workflows
n
- Supporting deployments into QA and UAT environments
n
- Troubleshooting deployment issues
n

nDeployment work typically represents 1–2 hours per day, while the majority of effort is spent supporting project teams.

n

nDBAs become actively involved as solutions progress through:

n

n
- Development
n
- QA
n
- UAT
n
- Release/Deployment
n

nTypical responsibilities include:

n

n
- Supporting QA environments
n
- Assisting with database changes between environments
n
- Troubleshooting integration and testing issues
n
- Supporting project teams throughout the delivery lifecycle
n

nDevelopers primarily manage Development environments, while DBAs provide support as projects move into QA and UAT.

n

nAdministrative Responsibilities

nExpected activities include:

n

n
- User provisioning and access management
n
- Security administration
n
- Account unlocks and permission requests
n
- Monitoring ticket queues
n
- Backup and recovery support
n

nDatabase creation and infrastructure provisioning are generally handled by separate teams.

n

nProject Engagement Expectations

nThis is a highly project-oriented setting.

nKey expectations:

n

n
- Supporting approximately 10 active applications undergoing enhancements and modifications
n
- Working across multiple projects simultaneously
n
- Participating in Agile delivery teams
n
- Collaborating with:
n
- Project Managers
n
- Data Engineers
n
- Scrum Teams
n
- Product Owners
n
- Other DBAs
n

nStrong communication skills and previous project-based DBA experience are highly desirable.

n

nTools & Technologies

nDatabase Platforms

n

n
- Oracle
n
- SQL Server
n
- DB2
n
- Netezza
n
- Oracle Exadata
n
- Oracle RAC
n

nDelivery & Ticketing Tools

n

n
- GitHub
n
- ServiceNow (current)
n
- Jira (future-state initiative)
n

nArchitecture

n

n
- Data Warehouse / OLAP environments
n

n

📌 Netezza Administrator (Kannur)
🏢 MSRcosmos
📍 Kannur