**Keywords**:
- NoSQL DBA
• *Role Description**:
- 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
- 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
- Provide 3rd level on-call support on a rotational basis
- Job may contain afterhours support for project-related work as well as scheduled changes
• *Competencies**:
- Digital: Cassandra
- Digital: NoSQL
• *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, ON
