Previous Job
Previous
Senior DB2 LUW DBA
Ref No.: 18-03143
Location: Pleasant Prairie, Wisconsin
Title: Senior Database Administrator (DB2)
Location: Pleasant Prairie, WI (must be onsite, no remote)
Duration: 6 Month Contract-2-Perm
Restrictions: W2 or Grenn Card Holders ONLY (Sponsorship not avail.)

SUMMARY:

Our Client seeks a Senior DB2 LUW DBA at its Corporate Headquarters in Pleasant Prairie, WI.

POSITION RESPONSIBILITIES
  • Design and execute overall database architecture strategy, standards and practices as part of a team.
  • Work closely with project teams to develop data models that support business processes.
  • Work with the Application Development team to ensure database changes adhere to best practices and are properly prioritized and scheduled.
  • Support all areas of the enterprise to ensure all databases run at optimal performance.
  • Proactively identify and troubleshoot databases performance issues.
  • Ensure that industry-wide security standards are properly implemented.
  • Develop and optimize complex PL/SQL code.
  • Understand written business requirements and translate them into technical design.
  • Design and develop PL/SQL code and ETL processes based on provided requirements.
  • Respond to business requests in a professional manner with high sense of urgency.
  • Participate in on-call rotation and occasional off-hours activities (DR tests, DBMS upgrades, UAT refreshes, etc.)

MINIMUM REQUIREMENTS
  • Bachelor's degree in information technology or related field.
  • 10+ years experience in data integration, data movement and/or database administration preferred.
  • Advanced RDBMS knowledge in DB2 LUW 11.1 (purescale) with a focus on high volume OLTP production support.
    DB2 LUW HADR experience.
  • Proficient in PL/SQL development, troubleshooting and optimization.
  • ETL experience, including data exports, imports and transformation using miscellaneous tools.
  • Proficient in OLTP performance troubleshooting.
  • Experience in DB2 LUW 11.1 purescale installation and configuration, including upgrading and patching.
  • RHEL 6.5-7.5 and AIX proficiency at a level required to support RDBMS.
  • Excellent verbal and written communication skills.
  • Ability to produce quality work on tight schedules as part of a large team of senior DBAs.
  • Willingness to work onsite in a professional business environment and offsite for after-hour, on-call activities.