Database Administrator

Description

About Citco

Since the 1940s Citco has provided specialist financial services to alternative investment funds investors multinationals and private clients worldwide. With over 13000 employees in 45 countries we pioneer innovative solutions that meet our clients evolving needs and deliver exceptional service.

Our continuous investment in learning means our people are among the best in the industry. And our corporate social responsibility programs provide meaningful and fulfilling work in the community.

A career at Citco isnt just a job its an opportunity to excel in an environment that genuinely supports your personal and professional development. For more information about Citco please visit.

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:

• Bachelors 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 $85000 to CAD $105000

• 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.

Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.

Required Experience:

Unclear Seniority

Employment Type : Full-Time
Experience: years
Vacancy: 1