DBA

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