DB2 DBA

Job Description

Required Technical and Professional Expertise :

Minimum 6-8 relevant years of experience as DB2 Database Administrator for large organization
Experience in DB2 DBA with strong data analysis and SQL writing and tuning experience on Linux/Windows/Unix platform
Demonstrated expertise in interpreting DB2 Administration and diagnostic logs and enable DB2 health, performance, and configuration monitoring
Hands-on knowledge in performance management and application tuning using DB2 performance tools, EXPLAIN PLAN, translating logical data model into physical data model.
Proficient in database sizing and partitioning based on application usage along with performance tuning of SQL to support development
Ability to prepare install scripts and code promotion using shell scripting (KSH, bash, Python
Expertise to perform database structure analysis, software maintenance, implementation and provide administrative support for DB2 databases and related applications Preferred Technical And Professional Expertise
Ability to identify possible performance issues and solve problems
Experience in Linux operating system - Linux and Red Hat Linux
Working knowledge of configurable online parameters, snapshots and event monitoring, and in examining system catalogs
Familiarity with DB2 Control Center DB2 informational tools
Solid understanding of storage options (SMS, DMS, automatic), tablespaces, indexes, partitioning (table partitioning, hash partitioning, multi-dimensional clustering) and in calculating volumetrics to determine DASD