EXPERIENCE (YEARS):

• 6–8

Essential Skills:

• Minimum of 7 years of experience as a NoSQL Database Administrator, specifically with Cassandra
• In-depth knowledge of NoSQL database design, operation, and implementation best practices
• Proficiency in writing and optimizing complex SQL and NoSQL queries
• Strong problem-solving skills and the ability to work collaboratively in a cross-functional team environment
• Certification in Cassandra (DataStax Certified Administrator) is a plus
• Experience with setup, deployment, and management of Cassandra OpsCenter
• Solid understanding of Cassandra configuration and management
• Installing and configuring Cassandra on servers including VMs, GCP, and AWS-based EC2VMs
• Analyzing and optimizing Cassandra based on transactional volume, data flow, query/report requirements to perform to expectations
• Identifying and providing resolution for shortcomings or issues identified to include design, implementation, security, performance, or architecture
• Significant working knowledge of distributed database deployment, monitoring, and management
• Working with development teams in an Agile scrum environment
• Backup and Disaster recovery expertise for Cloud-Based Cassandra deployments
• Minimum 3-5 years experience in building and administering Oracle/Oracle RAC environments (12c, 19c) as well as:
• Working knowledge of Cloud Computing and Azure/VMWare Technologies, OCAC, GCP
• Demonstrated experience utilizing Database-centric solutions to deliver High Availability and Disaster Recovery. Awareness of non-Database-centric capabilities (HACMP, VCS, TrueCopy, AAG)
• Working knowledge with storage subsystems
• Clear understanding of ITIL framework
• 5 years of project-based work as well as operational support-related experience
• 5 years management of 100+ servers
• Must be able to effectively represent DBA team on escalated incident management calls from operations
• Provide management escalation for support calls including on-call afterhours support
• Ability to maintain a positive attitude while working with high demands and tight deadlines
• Demonstrates experience involving strong communications skills (written and verbal), proven ability to effectively interact with individuals across business units and at various levels within the Bank (technical, business, including Management)
• Highly organized and possessing strong analytical skills
• Open-minded and highly adaptable with ability to work in a fast-paced demanding environment
• Must be team-oriented with ability to work well with multiple teams in a cross-functional setup. Self-motivated, with strong sense of ownership and urgency to deliver projects/tasks in a timely fashion

Other Qualifications/Skills/Experience:

• Financial Services IT experience
• Broad experience with IP networking concepts - routers, firewalls, etc
• Teamwork - strong relationships with developers and business analysts, architecture & operations
• Excellent communication and presentation abilities
• Effective time management skills and ability to work under deadlines and operational pressures

Skills:

• Cassandra Expert
• SQL and NoSQL Query Optimization Expert
• Problem-Solving Expert
• Team Collaboration Expert
• NoSQL Database Design Best Practices Advanced
• Data Backup and Restoration Advanced
• Performance Monitoring Advanced
• Automation Tools (e.g., Ansible) Intermediate
• Linux/Unix Systems Advanced

Job Types: Full-time, Fixed term contract
Work Location: Hybrid remote in Toronto, O

• Consult, engineer, install, configure, and maintain NoSQL database systems that are consistent with project objectives, client requirements, technology architecture standards and departmental best practices
• Monitor and optimize database performance, ensuring high availability and responsiveness
• Collaborate with application and development teams to design and implement database structures and schemas
• Regularly backup, restore, and test database data to prevent data loss and ensure robustness
• Stay up-to-date with the latest database trends, technologies, and best practices to continuously optimize database systems
• Utilize NoSQL subject matter expertise to design or re-use, configure, and implement database solutions/processes that maximize system availability, efficiency, effectiveness, integrity, security, recoverability, and supportability, all while minimizing costs
• Provide 3rd level on-call support on a rotational basis
• Job may contain afterhours support for project-related work as well as scheduled changes