Database Administrator
smartTrade Technologies is a software publisher specializing in the trading and finance sector. Its clients primarily include investment banks, stock exchanges, brokers, and pension funds. smartTrade enables real-time computerized management of financial flows among these different stakeholders.
Joining smartTrade means becoming a part of an innovative and international company with offices in Aix-en-Provence, London, Geneva, New York, Toronto, and Tokyo.
Skill development and career progression are top priorities at smartTrade, offering employees numerous opportunities for learning, advancement, and mobility. Sports and their values of teamwork, performance, and dynamism are integral to the company's culture.
Additionally, smartTrade is highly committed to continuously supporting various charitable and environmental initiatives.
Job Purpose
We are seeking a skilled and detail-oriented Database Administrator (DBA) with 2-3 years of hands-on experience managing and maintaining databases. The ideal candidate will have expertise in MySQL, PostgreSQL, and Oracle databases, with additional experience using Liquibase and Flyway for database version control and migration. The DBA will be responsible for ensuring the performance, availability, and security of databases, as well as optimizing and troubleshooting them as needed
Duties and Responsibilitie
- Administer and maintain MySQL, PostgreSQL, and Oracle databases, ensuring optimal performance, security, and availability.
Oversee the installation, configuration, and upgrading of database software and tools.
Proactively monitor database performance, identifying and resolving issues related to query optimization, indexing, and resource utilization.
Maintain robust backup and recovery procedures, ensuring effective disaster recovery strategies.
Utilize Liquibase and Flyway to manage database schema changes, version control, and automated migrations across development, testing, and production environments.
Collaborate with development and operations teams to design and implement database solutions that support business applications and ensure seamless integration across platforms.
Create and maintain comprehensive documentation of database architecture, configuration, procedures, and best practices.
Qualifications
University Degree in Computer Science Engineering or equivalent combination of education and experience.
2-3 years of hands-on experience in database administration across MySQL, PostgreSQL, and Oracle.
Knowledge in database schema management and version control using Liquibase and Flyway.
Experience with database backup, restoration, and disaster recovery planning and implementation.
Ability to troubleshoot and resolve complex database issues, ensuring minimal downtime and optimal system performance.
Excellent written and verbal communication skills, with a focus on documentation and cross-functional collaboration.
Experience with reviewing, testing, implementing and executing database changes as submitted by the development team.
Preferred Qualifications:
Experience with cloud-based database services such as AWS RDS or Google Cloud SQL.
Familiarity with automation and scripting languages such as Python and Shell scripting.
Exposure to DevOps practices, including the integration of databases within CI/CD pipelines.
Knowledge of high-availability, replication, and clustering technologies for databases.
Experience in Java development or familiarity with Java applications is a plus
- Department
- Commercial Banking - R&D
- Locations
- Toronto
- Remote status
- Hybrid Remote
Database Administrator
Loading application form
Already working at SmartTrade?
Let’s recruit together and find your next colleague.