Administration

• Lead and manage migrations of IBM DB2 Warehouse Edition databases from current vendor AWS to the State Managed AWS ECS, ensuring data integrity, minimal downtime, and compliance with security standards.
• Administer and optimize IBM DB2 Warehouse Edition for performance, scalability, and high availability in a containerized ECS environment.
• Monitor and analyze database performance metrics (CPU, I/O, memory, workload distribution, query response) and implement tuning strategies for ongoing optimization.
• Develop automation scripts for health checks, backup/recovery, scaling, and failover management.
• Collaborate with existing project team to, deploy, scale and secure DB2 clusters and supporting AWS infrastructure.
• Implement and manage backup, recovery for the DB2 environments.
• Support ETL optimization and data warehouse performance improvements, working closely with data engineering teams.
• Maintain detailed documentation, including migration plans, validation procedures, and system architecture diagrams.
• Provide ongoing DBA support including patching, upgrades, performance diagnostics, and incident resolution.

DB2 Warehouse Administrator – AWS

Virtual Platform Administrator

Enterprise Program Administrator

Learning Management System Administrator

Regional Site Administrator

Administrator