We are looking for Senior DB2 LUW Application DBA for our client in Toronto, ON
Job Title: Senior DB2 LUW Application DBA
Job Location: Toronto, ON
Job Type: Contract
Job Overview:
Requirement/Must Have:
- 7+ years of experience in Database Administration.
- Strong Python and Shell scripting skills for automation.
- Working knowledge of JIRA, Bitbucket, Git, and Autosys.
- Experience with DB2 LUW and DB2 DPF clusters.
- Experience with Snowflake database administration.
- Knowledge of data migration from on-premises to Snowflake.
- Ability to perform basic Sybase database monitoring for on-call rotation.
- Experience managing large-scale data archival pipelines.
- Familiarity with AI-assisted development tools like VS Code or Copilot is a plus.
Responsibilities:
- Provide production Application DBA support to meet high-demand regulatory and reporting requirements.
- Perform performance monitoring and tuning across DPF clusters.
- Design and execute data purging strategies.
- Implement space reclamation strategies for very large tables post-purge.
- Manage backup, recovery, upgrade, and disaster recovery planning.
- Execute data migrations from DB2 and Greenplum to Snowflake for very large datasets.
- Maintain continuous data archival pipelines via SparkSQL-based tooling.
- Manage over 700 scheduled jobs per environment using Autosys.
- Participate in an on-call rotation approximately one week every 2-3 months.
- Operate independently to define and act on tasks based on evolving regulatory needs.
Nice to Have:
- AI-assisted development knowledge (VS Code, Copilot).
Skills:
- DB2 LUW.
- DB2 DPF.
- Snowflake.
- Database Administration (DBA).
- Database Performance Tuning.
- Python.
- Shell Scripting.
- Data Migration/Archival.
- Autosys.
- JIRA.
- Bitbucket.
- Git.
- SparkSQL.
- Sybase.
Qualification And Education:
- 7-12 years of relevant experience in database administration and engineering.
====
Benefits
Our Benefits Include:
- Medical, Dental, and Vision Insurance
- 401(k) Retirement Plan
- Health Savings Account (HSA)
- Disability Insurance (Short-Term and Long-Term)
- Life and AD&D Insurance
- Paid Sick Leave (where required by applicable state or local law)
- Supplemental Insurance Plans
- Identity Theft Protection
- Pet Insurance
- Employee Wellness Programs
- Employee Assistance Program (EAP)
- Career Growth and Professional Development Opportunities
Disclaimer: Benefits eligibility, accrual rates, and usage limits may vary based on employment status, length of service, and work location. Paid Sick Leave is provided in strict accordance with applicable state and municipal mandates. Cynet Systems Inc. reserves the right to modify, amend, or terminate any benefit plans at any time in accordance with applicable laws.
About Cynet Systems
Founded in 2010 and headquartered in the Washington, DC metro area, Cynet Systems Inc. is a leading technology staffing and workforce solutions company serving Fortune 500 companies, government agencies, and enterprise organizations across the United States and Canada. We deliver agile, scalable talent solutions across IT, engineering, life sciences, clinical, and professional staffing, powered by a high-performing recruitment engine operating across North America and Asia.
As a nationally and locally certified Minority Business Enterprise (MBE), Cynet Systems is committed to helping organizations build high-performing teams while empowering professionals to grow rewarding careers. Our organization is certified to ISO 9001, ISO 14001, ISO 27001, and SOC 2 Type II standards, reflecting our commitment to quality, security, operational excellence, and customer success.
Never miss an opportunity! Create an alert based on the job you applied for.