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 hands‑on 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 pre‑production environments
- Provide database support during incidents (major and normal)
- Execute ad‑hoc 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 DB‑related topics during projects and releases
- Participate in DB2 LUW database migration activities to AWS
- Work closely with:
- Application Owners
- Project Managers
- Application Support teams
- External partners
In Scope:
- DB2 database administration and support
- Application‑level 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 non‑mainframe DB2 architecture
- Practical experience with DB2 LUW database migration to AWS
- AWS Certification required:
- AWS Certified Cloud Practitioner (minimum), or
- AWS Certified Database – Specialty (preferred)
- 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 (BKK)
- Dynamic, flexible, and service oriented
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
- Multi-national company with flexible working hours, but professional company culture
- Work from Home Policy
Top Skills
What We Do
EFFICIENCY IN MOTION Driving Banking Innovation ATA IT, a subsidiary of the National Bank of Canada, was established in 2016. We deliver world-class IT services to NBC and its subsidiaries, setting the standard for banking technology and supporting its global reach. We achieve this through innovative banking services and uncompromising security, adhering to the highest standards to ensure our group's trust and satisfaction. Our expertise includes: · IT Banking Solutions: From enterprise architecture and infrastructure implementation to seamless integration services and fully managed, high-availability data center hosting. · 24/7 End-to-End Support: Ensuring continuous operational excellence with round-the-clock monitoring and maintenance. · Business Services & Applications: From secure brokerage platforms and corporate banking portals to solutions for institutional trusts, securities lending, and syndicated loans, we are aligned to the financial landscape. ATA IT’s strength lies in encouraging our employees to drive innovation, and our team is a vibrant mix from various cultural backgrounds & industries, collaborating to create a thriving work environment.
