Location: Hybrid in Mississauga, ON - Availability during Eastern or Central business hours is required.
Language: Advanced written and spoken English communication skills
Background Check Requirement: Background check may be required
About the Opportunity We are seeking a Senior DB2 for i Operations DBA to support a large, enterprise-scale IBM i environment. In this hands-on role, you will help maintain the availability, stability, security, recoverability, and performance of mission-critical business applications.
You will work closely with application, infrastructure, and database operations teams to diagnose complex issues, strengthen operational practices, and improve database performance. This is an chance to act as a trusted technical advisor while helping teams adopt sustainable IBM i and DB2 best practices.
Whats In It for You You will join a collaborative environment where deep technical expertise is valued and your recommendations can have a meaningful operational impact. The role offers exposure to enterprise systems, high availability technologies, complex performance challenges, and opportunities to share knowledge across technical teams.
Your Responsibilities Youll administer and support DB2 for i databases across production and non-production environments.
Youll monitor database health, capacity, availability, performance, and resource utilization.
Youll diagnose SQL, indexing, locking, CPU, memory, buffer pool, I/O, and workload management issues.
Youll administer IBM i journaling, replication, high availability, and disaster recovery environments.
Youll troubleshoot replication latency, synchronization failures, journal receiver issues, and recovery concerns.
Youll establish performance baselines, complete root cause analysis,



and provide actionable tuning recommendations.
Youll maintain runbooks, operational standards, technical documentation, and knowledge transfer materials.
Skills and Qualifications 7+ years of progressive experience supporting DB2 for i, IBM i, iSeries, or AS400 environments.
Advanced experience with SQL analysis, execution plans, Visual Explain, SQL Plan Cache, Index Advisor, PDI, IBM Navigator for i, ACS, STRSQL, and STRDBG.
Strong knowledge of radix indexes, Encoded Vector Indexes, access paths, commitment control, and journal receiver management.
Hands-on experience with MIMIX, PowerHA, iTera, Quick-EDD, or similar replication technologies.
Experience with backup, recovery, HA/DR testing, capacity planning, and workload forecasting.
Familiarity with CDC technologies, ITIL processes, and ServiceNow is preferred.
Strong communication, troubleshooting, documentation, and cross-functional collaboration skills.
We appreciate the time and effort all applicants invest in their submissions. Please note that only candidates shortlisted for this role will be contacted directly. However, your profile will remain under consideration for future opportunities that align with your experience and career goals.All qualified applicants will receive fair consideration for employment. We welcome individuals of all backgrounds, experiences, and identities including those who identify as women, members of racialized groups, Indigenous Peoples, persons with disabilities, and 2SLGBTQIA+ communities. If you require an accommodation, please review our accessibility policy and reach out to our accessibility officer with any questions. Our human recruiters review all applications and always make the final hiring decision. On occasion, we also use AI-assisted tools to help review applications.

#J-18808-Ljbffr

📌 Database Administrator (Ontario)
🏢 Altis Technology
📍 Ontario