Essential Functions and Responsibilities:
This position requires a beginning, intermediate, or semi-advanced level of technical knowledge and skills of an Application DBA using IBM DB2 Linux/Windows. This position is responsible for understanding business needs, database design and modifications, writing and maintaining stored procedures, maintaining and executing ETL packages, performance tuning and indexing, SQL script creation, review, and tuning, and database documentation.
Job Knowledge, Skills, and Abilities:
Comprehensive knowledge of IBM DB2 DBMS, Operational Data Store (DB2 Advance), IBM Data Studio, DB2 tools, Toad, SQuirreL, Embarcadaro, SQL, Database Monitoring (Splunk), with core competencies in data modeling, normalization vs. de-normalization, SQL coding, testing, and tuning, use of performance monitoring tools, extract, transform, load (ETL), stored procedures, triggers, functions, source code management, and impact analysis.