040912-03 TWSS - Netezza DBA @ Denver, CO PDF  | Print |  E-mail
Written by Harish   
Monday, 09 April 2012 16:40

Dear partner,

Please go through the below requirement and send me the suitable profiles with best rate and contact details to -- This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Submit Resume
First Name (*)
Invalid Input
Last Name
Invalid Input
Email (*)
Invalid Input
Job Position (*)
Invalid Input
Contact Number (*)
Invalid Input
Submit Resume (*)
Invalid Input
Submit

Job Title: Netezza DBA

Location: Denver, CO 

Duration: 3 - 6 months CTH 

Rate: Open 

Detailed Description:

The Operations DBA will be responsible for enterprise database operations on Data Warehouse Databases including:

  • Build/setup databases for identified projects/business needs in a consistent and well structure manner per the defined organizational standards.
  • Manage day to day operations of the database including monitoring of high usage procs and queries, ensuring backups and log management are working effectively, session management, and configuration changes as required.
  • Manage migration of tables/schemas/DBs to alternate locations per defined project/business needs.
  • Gather statistics and create indexes on databases to ensure optimal performance and provide feedback to Application Admins, Developers and Architecture on appropriate change
  • Refresh development and test databases to facilitate better development and application delivery processes
  • Manage the database security needs through roles and profiles
  • Manage the creation of database partitioning and ongoing usage
  • Facilitate upgrade and patching process.
  • Support/execute the defined server and database maintenance process
  • Conform to the change process to ensure compliance and usage of best practices.
  • Support and ensure work done conforms with the SDLC process
  • Tier2/3 technical support for database and application issues.
  • Participate in the Technical support on-call rotation
  • Work closely with the Database Architecture to continually refine and improve on operational and design issues.
  • Provide upkeep for documentation for all environments under their review and make readily available these artifacts to all Architecture and Development counterparts

Netezza Specific Required Skills:

  • The position requires 2+ years of Netezza DBA support experiences. Knowledge of Teradata is a plus.
  • Netezza internals, structures and system tables.
  • Data distribution as it pertains to the performance.
  • Administration of the appliance for optimal performance of the appliance.
  • User provisioning and associated data access.
  • Netezza Administration (primarily on backup, restore, nzload, genstats, sql tuning, etc)

Responsibilities:

  • The Operations DBAs will work effectively with System Administrators, Project Managers, Architects, Developers and management to provide timely execution and support for business systems, planning, implementation and increased system uptimes.
  • The Operations DBAs must assist in ensuring consistent management of the environment and execution of defined SDLC and ITIL processes.
  • The Operations DBAs must demonstrate appropriate technical knowledge, interpersonal skills, business knowledge, organizational skills and professionalism.

Thanks,


Mike Smith - Resource Manager

Thoughtwave Software & Solutions, Inc.

E-mail | Web URL| Linked-in 

Ph: 630-448-6681 Ext # 112 | Fax: 630-689-5746