Netezza Admin @ REMOTE

Technical Requirements:
- Evaluate the Database Server Hardware
- Define/Recommend/Maintain Database Standards and Architecture
- Recommend Server H/W, Netezza Server Editions for a new Build
- Research and Recommend Patch management for database/instance and Impact Analysis.
- Initiate need and Impact Analysis for Database Migration/Upgrade
- Monitor and optimize Netezza database performance and capacity planning
- Troubleshoot database issues, maintain database systems availability and scalability
- Create and maintain Netezza databases required for development, testing, Integration, QA and production usage
- Performs the capacity planning required to create and maintain the databases
- The DMA should work closely with Server, Backup and storage administrator to meet Backup, Hardware, Storage and Operating system requirements
- Perform ongoing analysis and tuning of the Netezza database
- Install new versions of the Netezza database and its features and any other tools that access the Netezza database
- Application code promotion and migrations of programs, database changes, reference data changes and menu changes through the development life cycle if applicable
- Hands on experience with Netezza Cluster on Linux
- Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle
- Experience of cluster configuration and OS level and database level
- Troubleshoots with problems regarding the databases, replication and database related Tools
- Good knowledge of physical database design and responsible for the physical database design
- Ability to perform database and operating system performance monitoring and the necessary adjustments
- Excellent skill in High availability, replication technologies and fail over
- Netezza server configuration experience required
- Recommend and Review Backup and Recovery Strategies.
- Provides technical support to application development teams
- Having experience of DR Solution/Implementation/Execution through various sync methods.
- Designing strategy towards Capacity Management for DB tracks
- Designing Netezza Server Security (Server hardening,Auditing,compliance)
- Good knowledge of the windows and unix operating system(s)
- Netezza server HW experince C48

Responsibilities :-
- Adhering to SLAs
- Mentoring / Training Team Members
- Handling tickets / requests
- Perform root cause analysis
- Troubleshooting technical issues
- Oversees and is responsible for successful completion of Installation, configuration and migration
- Ensure maximum uptime according to the SLA
- Understanding of Multi-geo support environment
- Responsible for building / maintaining a test environment
- Planning Backup/Restoration Strategy for 24x7 operation support
- Suggesting patches/upgrades to maintain security level
- Testing / Auditing/processes as required from time to time
- Assist in effort estimating, forecasting, and work planning for resources
- To participate or contribute on EN business in creation of proposals to drive Service improvement plans
- To provide support for on call escalations and doing incident & problem management
- Work on value adding activities such Knowledge base update & management, Training fresher, coaching
analysts & conducting interviews/participation in hiring drives
- Familiarity and capability of learning new database technology across tower is an add-on.
- DMA point of contact for database requirements
- DMA should possess a sound understanding of the business.

Soft Skills :
- Excellent communication and conversation skills (Verbal and Written)
- Good documentation skills
- Good working knowledge of MS OFFICE (Including MS Project and Visio)
- Should have a great customer handling skills
- Able to handle unforeseen situations
- High level of acceptance

Certification requirements:
- Netezza administration certification

Other Skills / Experience:
- Worked on Production systems
- Experience with Database Migration, Installation, Upgrades and Patching
- Datacentre understanding
- Knowledge of Data warehousing and
- Knowledge of Gateways for Other DBs
- Storage Management Techniques
- Experience on Cluster Technologies
- Experience on Third Party backup tools
- knowledge of Public and Private cloud Provider and their services