Skip to main content

DBA

Technology
Toronto, Canada1 month ago
Full time

Job description

Job Requirements

Senior Database Administrator (DBA)

Location: PCS CA~TORONTO

Years of Experience: 10-15 Years

Job Summary: We are seeking an experienced Senior Database Administrator (DBA) to manage, optimize, and modernize our production databases. The ideal candidate will be a go-to expert for performance tuning, troubleshooting, cloud migrations, and ensuring our SQL Server, Sybase, and Oracle systems maintain top-notch uptime.

Responsibilities

  • Database Admin &

    • Support: Maintain multi-engine production databases (SQL Server, Sybase, Oracle, cloud) with 24/7 support for critical banking and trading systems, ensuring they are healthy, patched, and performing optimally.

  • Tuning &

    • Optimization: Identify and fix bottlenecks, optimize slow queries and indexes, and enhance batch jobs and reporting processes.

  • High Availability &

    • DR: Set up and test high availability/disaster recovery (HA/DR) solutions (Always On, Data Guard, RAC) and ensure robust backup and disaster recovery plans are in place.

  • Cloud &

    • Automation: Lead migrations to cloud platforms (AWS/Azure) and automate routine DBA tasks using PowerShell, Python, Shell, and CI/CD pipelines.

Mandatory Skills

  • Advanced proficiency in SQL Server, SAP Sybase ASE/IQ, Oracle RAC/Data Guard, PostgreSQL, MySQL, Azure SQL, and Snowflake.
  • Advanced knowledge of HA/DR tools such as Always On, Data Guard, Qlik Replication, NetBackup, and Veeam.
  • Expertise in cloud technologies including AWS, Azure, Terraform, Ansible, Jenkins, and GitHub.
  • Strong scripting skills in PowerShell, Python, Bash/Ksh, and T-SQL.
  • Experience with database security practices including TDE, CyberArk, Qualys, TLS, RBAC, and data masking.

Preferred Skills

  • Experience with database performance monitoring tools.
  • Familiarity with containerization technologies (Docker, Kubernetes).
  • Knowledge of data warehousing concepts and practices.

Qualifications

Bachelor's degree in Computer Science, Information Technology, or a related field. Relevant certifications in database management and cloud technologies are a plus.

Work Experience

10-15Years

Keywords
monthsOfExperience: 120Data maskingNetBackupOracle DatabaseMysqlPostgresqlPowershellPythonSqlCI / CDReplicationAlgorithmic tradingShell scriptAWSAnsibleDockerGithubJenkinsKubernetesTerraform

Interested in this role?