Hi Partner,
Greeting From EApps Tech LLC…!!!
I am Looking For Netezza Admin. for The Location Schaumburg, IL Please Find The Job Description Below, Send Me Your Updated Resume to bhargav@eappstech.Com and You Can Reach Me On 919-521-4343 For More About This Position. Please click on this link http://pukadjobs.com/viewAjob.php?jobId=PJ733
Job Title: Netezza Admin
Location: Schaumburg, IL
Duration: 6 Months.
Job Description:
· 6+ years of experience in IT, 4+ years in Data warehouse and BI Environment At least 3+ years DBA experience
· 1+ Year(s) experience as Netezza DBA
· Prior experience on DB2 UDB, Oracle and or SQL server 2008 would be a plus.
· Excellent knowledge of Netezza Architecture and system internals, including updates and features on new versions
· Excellent data modeling and data architecture knowledge with logical and physical data model knowledge
· Good infrastructure and network knowledge to troubleshoot potential infrastructure issues
· Consulting on use/relevance of Netezza for projects, future initiatives, providing thought leadership on the Netezza appliance platform
· Very Strong SQL knowledge and troubleshooting skills on SQL
· Experience with ETL tools like Informatica power center, SSIS and Reporting/Analytics tools like SAS or Business Objects would be an advantage.
· SQL optimization and query plan / execution optimization for adhoc queries, ETL procedures, BO queries, SAS packages/queries etc.
· Expertise in using bulk load with NZLoad and any other data utilities, doing import and export of data and databases from and to Netezza environment
· Good knowledge of Netezza compliant SQL development tools like Aginity
· Participate in the production software deployments, upgrades, capacity planning, backup strategies.
· Will provide production support for the Netezza database appliance
· Manage all Netezza database appliances – DEV, QA/TEST, PRODUCTION
· Monitoring of servers, Archiving and back-up planning & Disaster recovery planning
· (Setup and Manage backups, recovery and DR)
· User management, roles management and security control on the database and surrounding applications like ETL-INFORMATICA service accounts, SAP-BUSINESS OBJECTS service accounts, SAS service accounts and other applications interfacing with Netezza
· Create and maintain user profiles and groups consistent with security restrictions and performance considerations. Coordinate with IT Security as required.
· Software/hardware integration planning and will coordinate troubleshooting and make recommendations for the configuration
· Excellent knowledge on Work load management within Netezza and query load/concurrency management
· Research best practices and provide pre- and post-implementation documentation.
· Maintain awareness of new Netezza releases, patches and upgrades.
· Work closely with user areas to assure that their needs are being met.
· Installation, Administration, and Support of the software in conjunction with data center/infrastructure team and IBM tech support.
· Monitor storage growth and work with user areas to develop purge criteria.
· Coordinate with other IT groups on performance, storage issues, etc.
· Coordinate with 'power users' / Projects to schedule/prioritize production loads/jobs.
· Document operational processes and recovery procedures.
· Maintain environment configuration information.
· Work independently to resolve issues and escalate to management and other teams as needed.
· Performance tuning of database level queries and application (ETL or reporting /analytical jobs or queries)
· Open and manage tickets with IBM to own and resolve issues
· Excellent communication skills (written and verbal).
Thanks and Regards,
Bhargav Reddy | Resource Lead | EApps Tech LLC | 4208 Six Forks Road Suite 1000 Raleigh NC 27609 | Ph: +1 919-521-4343 (O) | Fax: +1 919-825-4801|USA I UK I INDIA I AUSTRALIA | Email: bhargav@eappstech.com| Visit us: www.eappstech.com |