We are seeking an experienced DB2 Specialist to lead the migration of IBM DB2 (version 11.5.9) databases to AWS RDS (DB2). In this role, you will focus on assessing migration feasibility, identifying feature gaps, mitigating risks, and optimizing database performance in AWS. You will be responsible for the full lifecycle of migration, from planning and execution to post-migration performance optimization.

Key Responsibilities:

1. Migration Assessment: Conduct an in-depth analysis of existing DB2 database schemas, stored procedures, triggers, indexes, and the compatibility of DB2 11.5.9 with AWS RDS.
2. POC Migration Strategy: Develop a Proof of Concept (POC) migration strategy, identifying feature gaps, risks, and limitations in AWS RDS DB2.
3. Migration Execution: Design and execute migration strategies using AWS Database Migration Service (DMS), Schema Conversion Tool (SCT), and custom scripts, ensuring minimal downtime and data integrity.
4. Rollback Strategies: Develop rollback strategies and contingency plans in case of migration failures.
5. Performance Optimization: Analyze and optimize DB2 database performance before, during, and after migration. Perform SQL tuning, query optimization, and index analysis to meet AWS RDS performance requirements.
6. Resource Scaling: Identify performance bottlenecks, recommend best practices for RDS scaling, and allocate resources effectively.
7. AWS Configurations: Evaluate the need for read replicas, Multi-AZ deployments, and backup strategies.
8. Automation: Automate the provisioning of AWS EC2 instances and migration workflows using tools like Terraform or similar.
9. Collaboration: Work closely with Cloud Engineers to configure networking, security, and storage solutions for RDS DB2. Collaborate with application teams to ensure compatibility and minimize business application impact.
10. Documentation & Training: Document migration steps, troubleshooting procedures, and performance benchmarks. Provide knowledge transfer and training to internal teams on AWS database management.

Required Qualifications:

1. Experience: 5+ years of experience with IBM DB2 (version 11.5.9 preferred) administration and migrations.
2. Migration Tools: Hands-on experience with AWS Database Migration Service (DMS) and Schema Conversion Tool (SCT).
3. Database Migration: Proven experience in schema migrations, stored procedures, triggers, and index conversions.
4. Migration Strategies: Experience with online (CDC) and offline migration strategies.
5. SQL & Performance Tuning: Strong understanding of SQL tuning, indexing strategies, and partitioning.
6. AWS RDS Knowledge: Knowledge of AWS RDS performance tuning and scaling strategies. Experience with RDS for DB2, Postgres, SQL Server, or other RDS engines.
7. EC2 Experience: Experience configuring AWS EC2 instances for RDS deployments (preferred).
8. Cross-functional Collaboration: Proven experience working with cross-functional teams, including DBAs, cloud engineers, and application teams.
9. Documentation Skills: Strong documentation skills for creating migration plans, risk assessments, and post-migration support.
10. Troubleshooting: Ability to troubleshoot migration issues and provide clear, actionable solutions.

Preferred Qualifications:

1. Infrastructure Automation: Proficiency in Terraform, CloudFormation, or similar tools for automating infrastructure provisioning.
2. AWS Networking Knowledge: Understanding of AWS networking (VPC, security groups, IAM policies) for database security.
3. Containerization & CI/CD: Familiarity with containerized DB2 deployments (Docker, Kubernetes) and CI/CD pipelines.

Certifications (if any):

IBM Certified Database Administrator.

AWS Certified Solutions Architect or other relevant certifications.