Job Description

About the Role:

Citco seeks a Database Administrator within the Database Team. The successful candidate will work with a team of database engineers and is primarily tasked with supporting the entire database footprint both on-prem and in the cloud. The position is responsible for ensuring the team operates effectively and efficiently, is properly motivated and ensures customer expectations are managed. This role interacts with most functions across the Citco IT group. The ideal candidate will have a proven track record of building large, scalable infrastructure, and is a creative thinker, problem solver, teacher and learner. This is a hands-on technical role with experience of Oracle databases essential, with additional knowledge of SQL Server or PostgreSQL being a plus. The focus of this role is to ensure optimal database performance, security, and reliability across our organization.

Responsibilities

Your Role:

Database Architecture & Design

• You will design and implement database architectures
• Establish database standards and best practices
• Ensure database security, performance, and reliability

Team Engagement

• Lead and mentor junior database administrations
• Coordinate with other IT teams and stakeholders
• Participate in major incidents and their resolution
• Foster a culture of continuous improvement and knowledge sharing

Technical Expertise

• Oversee database maintenance, backup, and recovery procedures
• Optimize database performance and troubleshoot complex issues
• Implement high-availability and disaster recovery solutions

Strategic Planning

• Plan database capacity and scalability requirements
• Evaluate and recommend new database technologies
• Develop long-term database strategies aligned with business goals

Qualifications

About You:

• You must have 5-8 years of database administration experience
• Extensive experience with major database platforms (e.g., Oracle, SQL Server, PostgreSQL, MySQL)
• Proficiency in: Oracle Exadata Database Appliance, Oracle Database Appliance (ODA), Oracle Real Application Clusters (RAC), Oracle Grid Infrastructure, Oracle Data Guard, Oracle Automatic Storage Management (ASM), Oracle Enterprise Manager Cloud Control (OEM)
• Installation, upgrade, monitoring, and support of Oracle Databases 19c and newer versions
• Knowledge of Oracle GoldenGate implementation and maintenance
• Linux/UNIX scripting proficiency
• Autosys, Stonebranch or other workload scheduling tool expertise required
• Working knowledge of modern automation tools (Ansible, Rundeck)
• Strong knowledge of database security and compliance
• Experience with data modelling and database design
• Problem-solving and analytical abilities
• Performance tuning and optimization expertise
• Excellent knowledge of SQL and PL/SQL programming.
• Experience with database backup and recovery strategies, including disaster recovery planning.
• Strong understanding of database security best practices and compliance requirements.

Education:

• Bachelor's degree or technical qualification prevalent to the position
• Certifications such as Oracle Certified Professional (OCP), Microsoft Certified: Azure Database Administrator Associate, or PostgreSQL Certified Associate.
• AWS Cloud Practitioner or Associate Level certification [or ability to obtain within 6 months] with proficiency in: RDS databases (Oracle, PostgreSQL, Aurora), CloudWatch monitoring, CloudFormation, Lambda functions, AWS DMS and DirectConnect, Python, JSON, YAML programming experience, Oracle Cloud Services expertise, and experience with multi-cloud environments

Salary Range: CAD $85,000 to CAD $105,000

• This posting is for not an existing vacancy; we are building a candidate pool for future opportunities

Our Benefits

Your well-being is of paramount importance to us, and central to our success. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We embrace diversity, prioritizing the hiring of people from diverse backgrounds. Our inclusive culture is a source of pride and strength, fostering innovation and mutual respect.