DB2 DBA

Create / Update application DB objects (tables, function, index, procedures, etc.)

• 5+ years of experience in being a DB2 database administrator
• Application specific SQL tuning, diagnostics, recommended changes
• Data repairs SQL verification
• SQL code implementation for Production and test environments
• Health checks
• Manage / monitors database events (batch jobs)
• Database growth tracking
• Batch execution support (Production and test environments)
• Support of Customer Service System (CSS) production push support
• Database backups and restores (Production and test environments)
• Index, partition recommendations and implementation
• Archival Strategy recommendations and implementation
• Manage database event monitors
• Application Database growth tracking and management
• Data provisioning and management of SOX controls
• Manage application data auditing
• Manage application database links
• Support System Administrator Physical DBA
• Support installation, upgrade and patching of DB2 database environment
• Maintain DB2 database environments, ensuring optimal performance and data integrity
• Work with Physical DB2 DBA on capacity planning and management
• Respond to requests and incidents related to the logical environment quickly and efficiently
• Writing database documentation, including data standards, procedures and definitions for the data dictionary
• Testing and modifying databases to ensure they operate reliably
• Manage database access accurately and within SOX regulations
• Ability to analyze and solve complex database issues using exceptional problem-solving skill quickly and efficiently
• Recovery and restoration in case of any data loss