Netezza Data Warehouse Sr. DBA Location:Tampa/St. Petersburg, Fl
Netezza Data Warehouse Sr. DBA Location:Tampa/St. Petersburg, Fl
Posted on : 09-08-2023
Job Type : Full Time only
Salary : 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.
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)