Talent.com

Sql programmer Jobs in Pickering, ON

Create a job alert for this search

Sql programmer • pickering on

Last updated: 3 days ago
Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Astra North Infoteck Inc.Scarborough, ON, ca
Full-time
Quick Apply
Detailed Job Description: Experienced Oracle DBA to ensure the reliability, performance, and security of mission-critical Oracle databases, along with an AWS-focused DBA to manage and optimize Amaz...Show moreLast updated: 3 days ago
Senior Analyst, Identity Lifecycle Management

Senior Analyst, Identity Lifecycle Management

LancesoftScarborough, ON, CA
Full-time
Quick Apply
Location Address: Hybrid (two days in the office with potential increase in the future) –888 Birchmount Road.Contract Duration: ASAP - Oct 31st.Start day: Jan 20th to Feb 1, 2026.Scheduled Hours: M...Show moreLast updated: 16 days ago
Data Quality Engineer-Cards Engineering, Transactional Services and Data Services Engineering

Data Quality Engineer-Cards Engineering, Transactional Services and Data Services Engineering

ScotiabankScarborough, ON, CA
Full-time
Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.Scotiabank continues to be an industry leader for Payment’s technology and innovation.We have a...Show moreLast updated: 10 days ago
Remote Senior SQL Engineer - AI Trainer

Remote Senior SQL Engineer - AI Trainer

SuperAnnotatePickering, Ontario, CA
Remote
Full-time
As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show moreLast updated: 30+ days ago
Remote Senior SQL Engineer - AI Trainer

Remote Senior SQL Engineer - AI Trainer

SuperAnnotateAjax, Ontario, CA
Remote
Full-time
As a Senior SQL Engineer, you will work remotely on an hourly paid basis to review AI-generated SQL queries, database designs, and data-processing logic, as well as generate high-quality reference ...Show moreLast updated: 30+ days ago
Junior Systems Optimization Analyst

Junior Systems Optimization Analyst

Warehousing & DistributionScarborough, ON, CA
Full-time
Quick Apply
Role Summary We are looking for a Junior Systems Optimization Analyst who is early in their career but ready to take on high ownership and real impact.This role sits at the intersection of systems,...Show moreLast updated: 7 days ago
Business Programs and Solutions Specialist (Full Stack Software Specialist)

Business Programs and Solutions Specialist (Full Stack Software Specialist)

City of TorontoScarborough, Ontario
Full-time +1
Business Programs and Solutions Specialist (Full Stack Software Specialist) .Metro Hall, 55 John Street, Toronto.Full-time, 1 Permanent, 2 Temporary (12 month) vacancies.Monday to Friday, 35 hours ...Show moreLast updated: 30+ days ago
  • Promoted
Finance Manager

Finance Manager

Vaco by HighspringPickering, ON, CA
Permanent
Our client is a Real Estate development company.They are looking for a Finance Manager to join their team!.Direct exposure to ownership through enhanced reporting and analytics.Work closely with a ...Show moreLast updated: 3 days ago
People also ask
Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Oracle DBA - RAC, Data Guard, AWS RDS, Redshift

Astra North Infoteck Inc.Scarborough, ON, ca
3 days ago
Job type
  • Full-time
  • Quick Apply
Job description
Job Description
Detailed Job Description: Experienced Oracle DBA to ensure the reliability, performance, and security of mission-critical Oracle databases, along with an AWS-focused DBA to manage and optimize Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift clusters, with a strong focus on Infrastructure as Code using AWS CDK.


Job Description:
1. Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM.
2. Expert-level performance tuning (SQL & instance), AWR/ASH analysis, wait events.
3. Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups).
4. Govern backup/restore (automated backups, snapshots), encryption (KMS), patching, and minor/major version upgrades.
5. Implement monitoring/alerting via CloudWatch, Performance Insights, Enhanced Monitoring; tune connections/queries.
6. Cost management: right-sizing, storage management, Reserved/Compute Savings Plans advisory.
7. Design and operate Redshift clusters; configure WLM, concurrency scaling, queue management.
8. Optimize schema (distribution/sort keys), VACUUM/ANALYZE, query tuning; workload isolation.
9. Build CI/CD pipelines (CodePipeline/GitHub Actions) to deploy CDK apps; manage environments (dev/qa/uat/prod).
10. Implement high availability (Multi-AZ for RDS, cross-region snapshots as needed).



Qualifications (Required):
1. 4–7+ years as a Oracle DBA with 3+ years on AWS data services.
2. Hands-on with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration.
3. Expertise in monitoring (CloudWatch, Performance Insights), performance tuning, and cost optimization.
4. At least one certification in Oracle (OCP) and one in AWS.
5. Proficiency with AWS CDK (TypeScript or Python), CloudFormation, and CI/CD pipelines.


Top 3 Required Skills:
1. Strong hands-on with Oracle 19c, RAC, Data Guard, RMAN, ASM, OEM.
2. Hands-on with Amazon RDS (Oracle/PostgreSQL/MSSQL) and Amazon Redshift administration) 3. Provision and manage RDS instances/clusters (instance classes, storage autoscaling, Multi-AZ, parameter/subnet groups).

Top 3 Preferred Skills:
1. Oracle 19C, 26i
2. AWS RDS
3. Dataguard, RMAN, RAC


Requirements
Oracle DBA