Description

Manage and maintain multiple DB2 LUW environments across development, QA, training, and production tiers. You will plan, document, and execute database upgrades and migrations, including fallback procedures and milestone checklists.

Responsibilities

• Develop moderate to complex SQL statements for ETL and data migration processes.
• Support application developers by designing, implementing, and testing database changes.
• Review SQL statements for performance and provide index recommendations to optimize efficiency.
• Collaborate with system administrators on operating system and database patching.
• Document entity relationships using Erwin Entity Relationship Diagrams.

Required Skills

• 5 years of experience as a Database Administrator.
• 5 years of experience with Structured Query Language (SQL).
• 3 years of experience managing DB2 LUW environments.
• 3 years of experience with Red Hat Enterprise Linux (RHEL).
• 1 year of experience with Relational Data Modeling.
• 1 year of experience using Erwin.
• Ability to work non-business hours, including weekends and holidays, as needed.

Preferred Skills

• Experience with Quest Toad for DB2 LUW, IBM DataQuant, or QMF.
• Experience with Unix shell scripting (ksh, csh, bash, or sh) and COBOL.
• Experience with SQL Server, MySQL, or Teradata.

Key Skills

Education

Any Graduate