USM Business Systems · Cincinnati
Software Engineeringposted 120mo ago
Businesses face challenges every day building responsive and agile IT capabilities to grow and stay ahead. Since everyone has access to the same tools, your competitive advantage directly depends on how you apply technology – on the people leading, supporting and optimizing your IT initiatives. USM Business Systems, established in 1999, is an industry-leading private talent management firm, specializing in providing unique IT turnkey solutions, IT staffing solutions, and Talent management insights, enabling you to sustain a truly competitive advantage in this fast-moving environment. USM has offices throughout the US and offshore delivery centers in India. USM is a certified Minority Business Enterprise and is a CMMi Level 3 Organization.
USM is recognized as one of the fastest growing IT Temporary Staffing firms in the US and most recently was ranked #3 on the list of the Top Temporary Staffing firms in the DC Metro Area – Washington Business Journal (2016).
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