Job Summary
We are seeking an experienced Lead Database Administrator with strong expertise in IBM DB2 and proven experience in migrating on-premises databases to AWS RDS Aurora PostgreSQL. The role will be responsible for leading database modernization initiatives, ensuring high performance, reliability, and scalability of enterprise database environments while supporting cloud transformation efforts.
Mandatory Skills & Experience
Database Management
- Minimum 7+ years of experience in database administration and development
- Strong hands-on experience with IBM DB2 architecture, administration, and performance tuning
- Solid experience with PostgreSQL development, including stored procedures, functions, indexing, and query optimization
Cloud Migration Expertise
- Proven experience in migrating IBM DB2 databases to AWS RDS Aurora PostgreSQL
- Hands-on experience with AWS database services, including:
- AWS Database Migration Service (DMS)
- AWS Schema Conversion Tool (SCT)
- Amazon RDS and Aurora PostgreSQL
Data Engineering & Automation
- Experience with ETL processes and data transformation
- Proficiency in scripting languages such as Python or Shell scripting
Database Design & Optimization
- Strong understanding of data modeling, normalization, and database optimization techniques
- Experience in performance monitoring, query tuning, and indexing strategies
Preferred Qualifications
- AWS Certifications, such as:
- AWS Certified Database Specialty
- AWS Certified Solutions Architect
- Experience with CI/CD pipelines and Infrastructure as Code
- Terraform
- AWS CloudFormation
- Familiarity with DevOps tools and practices, including Git, Jenkins, and Ansible
