Share this Job

Senior DBA - DB2 LUW

Date Posted: Nov 20, 2018

Location: Cary, NC, US, 27513

Company: MetLife

Job Location:     Cary NC

 

Role Value Proposition: 

The DB2/LUW Database Administrator will be responsible for the end-to-end implementation of the DB2/LUW database systems.  The DBA will be responsible for the build and testing of new database environments and the enhancement, administration, backup and implementation support for 10.1 and 10.5 database systems on AIX and RedHat Linux.

    

Key Responsibilities:

  • Physical database design for all new development efforts for the supported application portfolio
  • Performance and tuning of application developed SQL and procedures
  • Implementation of all utility processing for supported databases
  • Creation and Implementation of backup, recovery and DR strategies within supported application portfolio
  • Implementation of application driven schema changes

 

Essential Business Experience and Technical Skills:

Required:

 

  • Experience in the creation and configuration of new Unix and Linux database server environments and creation of new 10.5 database environments; Technical knowledge and experience with database environments, tools, utilities, configurations, backup and recovery, job scheduling, release management, change management and compliance.
  • Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints.
  • Knowledge of all key DB2/LUW utilities such as HADR, Reorg, Runstats, Load
  • Strong collaboration with application development teams on database security, query optimization and performance.
  • Creation and management of the database maintenance processes and jobs (such as backups, weekly DBA maintenance trails, statistics, reorgs).
  • Document database maintenance processing flows per standards.
  • SQL & Perl, Korn and other scripting skills are a plus.

 

Preferred:

 

  • Working knowledge of Netezza and/or Informex
  • Administration skills in Linux and/or AIX
  • DB2/LUW DPF experience / UDB EEE

 

Business Category

Global Infrastructure Technology Operations

 

Number of Openings

1

 

At MetLife, we’re leading the global transformation of an industry we’ve long defined. United in purpose, diverse in perspective, we’re dedicated to making a difference in the lives of our customers.

 

 

MetLife is a proud equal opportunity/affirmative action employer committed to attracting, retaining, and maximizing the performance of a diverse and inclusive workforce. It is MetLife's policy to ensure equal employment opportunity without discrimination or harassment based on race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity or expression, age, disability, national origin, marital or domestic/civil partnership status, genetic information, citizenship status, uniformed service member or veteran status, or any other characteristic protected by law.

MetLife maintains a drug-free workplace.

For immediate consideration, click the Apply Now button. You will be directed to complete an on-line profile. Upon completion, you will receive an automated confirmation email verifying you have successfully applied to the job.

Requisition #: 104689 


Nearest Major Market: Raleigh