We are seeking a Senior DB2 Database Administrator with strong expertise in DB2 LUW (Linux, Unix, Windows) to support standard banking applications and participate in DB2 database migration projects to AWS. This role is strictly DB2 LUW (Linux / Unix / Windows). Mainframe DB2 (z/OS / DB2 Central) experience is not applicable to this position.
This is a handson operational role, requiring strong DB2 expertise, solid incident support experience, and the ability to work directly with application owners and project managers during Montreal business hours.
Key Responsibilities:
- Operate and support DB2 LUW databases across production and preproduction environments
- Provide database support during incidents (major and normal)
- Execute adhoc SQL queries and data corrections when required
- Perform database refresh, restore, and backup operations
- Manage DB2 users, roles, and access
- Maintain and troubleshoot stored procedures
- Support database deployments and structural changes (tables, indexes, partitions)
- Assist application teams on DBrelated topics during projects and releases
- Participate in DB2 LUW database migration activities to AWS
- Work closely with: Application Owners, Project Managers, Application Support teams, and External partners
In Scope:
- DB2 database administration and support
- Applicationlevel database operations
- Incident management and deployments
- AWS migration support for DB2 databases
Out of Scope:
- DB2 z/OS (Mainframe)
- Infrastructure, OS, or cloud platform administration
Qualifications:
- 5-7+ years of experience as a DBA with DB2 LUW (Linux / Unix / Windows)
- Solid experience in:
- DB2 LUW administration in production environments
- Backup and recovery
- Performance troubleshooting
- SQL scripting and utilities
- Experience supporting multiple applications simultaneously
- Clear understanding of nonmainframe DB2 architecture
- Practical experience with DB2 LUW database migration to AWS
- Good/Advanced English (spoken and written)
- Comfortable working directly with international stakeholders
- Strong incident and support mindset
- Able to work independently during night hours: 7:00 PM 4:00 AM or 8:00 PM 5:00 AM (Bangkok time)
- Dynamic, flexible, and service oriented
AWS Certification required:
- AWS Certified Cloud Practitioner (minimum), or
- AWS Certified Database Specialty (preferred)
What you will get from ATA IT :
- 14 days vacation in first year
- Health insurance for staff & families
- Life insurance
- Dental fee for staff & families
- Provident fund
- Monetary Assistance (Childbirth, Funeral, Basket Visit)
- Annual Party
- Monthly Activities- Staff Birthday & Company Activities
- Annual Health Check
- Work from Home Policy