Netezza Database Administrator-----------------Need GC and USC
Job Description
Title: Netezza Database Administrator
Location: Cincinnati, OH
Duration: 12 months+ (Potential for extension)
Need GC and USC
Job Description:
The Netezza Database Administrator is responsible for the design, development, installation and performance of our Netezza appliances. Experience with Multi-Rack Netezza Administration is required. The successful candidate will be part of a team responsible for all appliance support, monitoring, performance, and documentation of all Netezza databases. Data management tasks including: User/Group/Permissions maintenance; Work Load Management; Database/Schema/Table design and maintenance; monitoring and performance; installs and upgrades of all related appliance software; collaboration with IBM Netezza support. You will support primarily Netezza appliance environment that will include configuration, administration and maintenance of business-critical 24x7 non-production and production environments.
The DBA will work with project teams and collaborate with the Database Team to deliver successful implementations. A general understanding of underlying operating system, storage technologies, memory management, disk arrays, NAS/SAN, networking is needed to perform the job functions.
Strong analytical and troubleshooting skillset required. Ability to work within a cross functional team environment required. Ability to self-prioritize workload and manage deadlines effectively required. Strong communication skills, both written and verbal required.
JOB FUNCTIONS:
• Perform database performance analysis, capacity planning, system sizing and ongoing maintenance/tuning to ensure maximum performance on Netezza systems.
• Recommend and implement a detailed security design for the appliance to meet Kroger security and application needs.
• Create, test, implement and monitor an automated set of procedures for database and server backups as well as necessary maintenance procedures including performing backup and restore activities.
• Responsible for managing and supporting high performance, highly available and mission critical database platforms along with DR platforms.
• Assist development teams with planning and implementing database changes and query optimization.
• Supporting QA and DEV environments with refresh tasks.
• Use the NzAdmin/NZMigrate tool for typical administrative tasks which include genstats, groom.
• Review and Patch of Netezza including OS and Server firmware.
• Work closely with IBM support to manage hardware/software failures, appliance upgrades and install patches.
DESIRED EXPERIENCE:
• Bachelor's degree, preferably in Computer Science/Technology or Engineering, or equivalent relevant work experience
• At least 3 years of experience in Netezza
• Extensive experience with different backup/restore and disaster recovery solutions.
• Expert level experience in administering large databases in mission critical environment.
• Must have Netezza Hardware and Network component knowledge.
• Develop and define administrative and operational standard practices using Netezza utilities (Groom, Distribution, statistics, Zone Maps).
• Solid experience in Netezza system configuration and setup with its utilities and tool sets.
• Strong knowledge and experience with computer hardware including Servers, Network, SAN technologies, I/O subsystems.
• Strong communication, organizational, and time-management skills.
• Self-starter, positive attitude, problem solving skills and self-initiative are must qualities.
If you are interested in the below position please forward your profile to preethib@usmsystems(dot)com or call me on 703 468 0398