Database Administrator
About Citco
Since the 1940s Citco has provided specialist financial services to alternative investment funds, investors, multinationals and private clients worldwide. With over 13,000 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 isn’t just a job – it’s an opportunity to excel in an environment that genuinely supports your personal and professional development. For more information about Citco, please visit www.citco.com.
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.
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
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.
Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.