Senior Netezza DBA Full Time-Tampa, Florida

The Senior Netezza Database Administrator is responsible for enterprise-wide administration of several Netezza appliances and databases. Responsibilities include database administration, architectural design, ETL development and administration, and strategic direction for Data Warehouse support.  Guidance to less experienced DBAs for ongoing process improvement is also emphasized.  
The candidate must have excellent verbal and written communication skills.

Responsibilities:

  • Data modeling, design & implementation based on established standards
  • Software installation and configuration
  • Database backup and recovery
  • Database connectivity and security
  • Performance monitoring and tuning
  • Disk space management
  • Software patches and upgrades 
  • Automate manual tasks
  • Conduct database training 
  • Provide on-call support & troubleshoot technical issues
  • Develop, test, and monitor batch jobs
  • Perform ETL functions, applying business rules

Education and Experience Required

  • Bachelors’ degree or equivalent experience
  • 5+ years DBA experience with multi-gigabyte OLTP and multi-terabyte Data Warehouse databases
  • Database design and data modeling background required 
  • Experience in database performance tuning required
  • Experience in database upgrades required
  • SQL skills (including analytical functions) required
  • Strong experience in UNIX required, including command line editors, scripting (shell, Python, Perl, etc.)
  • Experience in all aspects of the software development lifecycle including:  requirements gathering, design, coding, testing and production support

Knowledge and Skills Required

  • Experience in relational database technology including data modeling (logical and physical) 
  • Strong understanding of SQL in accessing and manipulating data
  • Strong understanding of system architecture
  • Understanding of Unix, DOS and Windows operating systems
  • Strong understanding of general programming concepts
  • Advanced analytical and problem solving skills
  • Experience with the following software required:
  • Unix shell scripting
  • Netezza/IBM Pure Data, Oracle, MS SQL Server, and MySQL
  • Experience with the following software desired:
  • ER/Studio 
  • BMC’s Recovery Manager for Databases (aka SQL BackTrack)
  • AutoSys Job Scheduling Tool
  • SAS and SAS DIS for ETL