Data Warehouse DBA

  • Full-time

Company Description

Health Care

Job Description

We are looking for a Data Warehouse DBA.  Working in collaboration with cross-functional teams to design, build, upgrade, modify and operationally administer new or existing Oracle and IBM Netezza databases in support of critical enterprise applications.

Responsibilities

  • Acts as a database technology subject matter expert, providing technical leadership within the DBA team. Working with cross functional teams in building, scalable enterprise solutions.
    Establish and maintain performance baselines, troubleshoot performance issues and provide recommendations/fixes for identified issues.
  • Provides architectural guidelines to build and maintain scalable multi-terabyte database environments.
  • Creates supports and administers relational databases.
  • Oversees administration and performs hands-on administration of databases, related tools, processes and operations in large data warehouse, oltp and batch environments.
  • Recommends solutions that require definition of the physical structure and functional capabilities of databases and required data security and data backup/recovery specifications.
  • Ensures proper design, implementation, performance, availability, security, auditing and capacity management of related database systems.
  • Develops and implements standards and best practice

Qualifications

Must have prior experience in and deep knowledge of the following:

  • Experience working in an environment that utilizes BI tools, including SAS, Informatica IDE/IDQ/PowerExchange, BOXi and Crystal desired.
  • Practical experience in pro-active and reactive database performance tuning.
    Database capacity forecasting
  • Administering large data warehouse and hybrid environments with OLTP and Batch processing loads.
  • Oracle Database Architecture
  • Supporting large scale Oracle databases on unix based systems, preferably Linux, AIX and Solaris
  • Supporting large scale IBM Netezza databases
  • Databases hosted on virtualized platforms (AIX LPARs, VMware)
  • Extensive experience with different backup/restore and disaster recovery solutions
  • Excellent knowledge of Netezza Architecture and system internals, including updates and features on new versions
  • Excellent understanding and practical experience with Oracle performance views, OEM, ASM, backup and recovery concepts (RMAN) and operating system concepts. 

Additional Information

Skills:

Oracle DBA, Netezza DBA, Data Warehouse DBA, Netezza Appliance Administration, Business Inttelligence