Netezza Data Warehouse Sr. DBA Location:Tampa/St. Petersburg, Fl
100,000 - 200,000
Job Description:
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.
- 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
- 7x24 On call Rotation for Production Support of Big Data environment
- Database Management
- Security Management
- Batch Job Management
- Backup/Purge Management
- Bachelors degree or equivalent experience
- At least 5 years of IT experience with 3 - 5 yearsâ?? experience in Netezza.
- 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
- 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