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.

ORGANIZATIONAL RELATIONSHIPS

• Reports to Manager, Data Warehouse/Big Data
• No Direct Reports
• Provides direction to less experienced DBAs for ongoing skill improvement as required.
• Under general direction, functions independently within broad scope of established departmental policies and practices;
• Generally refers specific problems to supervisor only where clarification of departmental operating policies and procedures may be required

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

ADDITIONAL RESPONSIBILITIES

• Weekly time card reporting
• Updating Remedy Force and Jira daily with status of tickets worked
• Presenting on-call issues in weekly Production Support Meeting
• Participate in Daily Scrum Meetings
• Written documentation describing process
• Change Control Management
• Communication across teams

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

GENERAL

• Analytical and problem solving skills
• Must have excellent verbal and written communication skills
  

Key Skills: