Job description

POSITION SUMMARY

• Responsible for enterprise-wide database administration of one or several of the Data Base Management Systems (DBMSs) including, but not limited to: Netezza and Hadoop.
• Responsibilities include data management, security management, batch job management, backup/purge management, retailer rollouts, and basic development tasks for Data Warehouse or Hadoop support throughout the SDLC life cycle.

SCOPE OF RESPONSIBILITY

• Data repairs
• New retailer rollouts
• Database backup and purge
• Database connectivity and security
• Retailer file management
• Disk space management
• Manual task automation
• Data issue resolution
• Data mart replication/synchronization
• Develop, test, and monitor batch jobs in support of tasks above

ESSENTIAL FUNCTIONS

• 7x24 On call Rotation for Production Support of Big Data environment
• Database Management
• Security Management
• Batch Job Management
• Backup/Purge Management

SPECIAL KNOWLEDGE, SKILLS AND ABILITIES REQUIRED

• Bachelors degree or equivalent experience
• At least 5 years of IT experience with 3 - 5 yearsâ?? experience in Netezza.

EXPERIENCE/WORKING KNOWLEDGE

• Korn Shell scripting
• vi editor
• UNIX/Linux operating system
• Database SQL in accessing and manipulating data
• Relational database technology including data modeling (logical and physical)
• All aspects of the software development lifecycle including: requirements gathering, design, coding, testing and production support

DESIRED/PREFERRED

• Experience with the following desired: Hadoop, Hive, Java Development on Hadoop
• Experience with Aginity AMP preferred
• Experience with the following software desired: AutoSys Job Scheduling Tool, Jira, Remedy Force, Sync Sort for Unix
• Exposure to Business Intelligence tools (MicroStrategy, Tableau, Hyperion IRS query and reporting tool)
• Application Development experience preferred

Key Skills: