Netezza Data Warehouse Sr. DBA Location:

Netezza Data Warehouse Sr. DBA Location:

  • 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.
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


  • Latest Jobs
    Featured Jobs
    Trending Jobs
    Share Job: