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. Robust troubleshooting, analytical, and performance optimization skills. Preferred Qualifications

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

#J-18808-Ljbffr

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