- Collaborate with application teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.
- Analyze execution plans, tune SQL queries, and optimize indexes for high-throughput transactional environments.
- Lead database release automation, code reviews, and schema migrations across Development, Staging, and Production.
- Monitor database health and troubleshoot lock contention, deadlocks, latency, and performance issues.
- Partner with infrastructure and cloud teams to design and execute on-premises to AWS database migrations.
- Support Oracle and PostgreSQL databases within AWS environments.
- Participate in database capacity planning, failover testing, and disaster recovery design.
- Integrate database deployments with CI/CD pipelines and Agile delivery processes.
- Collaborate with offshore teams for maintenance and production support.
- Provide occasional weekend and after-hours support for deployments and maintenance activities.

Core Qualifications





- 8-10 years of Oracle Database Administration experience.
- Strong expertise with Oracle Database 12c/19c+.
- Advanced experience with:
- PL/SQL
- SQL Performance Tuning
- AWR
- ASH
- ADDM
- Hands-on experience administering AWS database services, including:
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Aurora
- Hands-on knowledge of PostgreSQL architecture, schema design, and performance optimization.
- Experience with AWS migration tools such as:
- AWS DMS
- AWS SCT
- Native Database Migration Utilities
- Strong experience with database release management and CI/CD integration.
- Experience supporting high-availability and disaster recovery environments.
- Solid troubleshooting, analytical, and performance optimization skills.

Preferred Qualifications

- Knowledge of Exadata performance features including Smart Scan and Hybrid Columnar Compression.

📌 Senior Oracle DBA (Toronto)
🏢 Flexstaf I.T.
📍 Toronto