Role - Oracle DBA
Location - Toronto, ON (Hybrid)
Experience - 8+ years
Type - Full Time Permanent
Role and Responsibilities
Collaborate with application development teams on data modeling, schema design, and deployment of complex PL/SQL packages, procedures, triggers, and views.
Analyze execution plans, perform SQL query tuning, and optimize index structures to eliminate bottlenecks in high-throughput transactional environments.
Lead database release automation, code reviews, and schema migrations across development, staging, and production environments.
Monitor database application health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
Partner with infrastructure and cloud teams to design, test, and execute on-premises to AWS cloud database migrations.
Participate in database capacity planning, failover drills, and disaster recovery design.
Support production deployment and other maintenance activities over weekend and "after office" hours on weekdays as needed.
Mandatory" Skills:
8-10 years of experience in Oracle Database Administration
Oracle Application DBA Expertise: 8+ years specializing in Oracle Database (12c/19c+) application support, advanced PL/SQL programming, execution plan analysis, and performance diagnostics (AWR, ASH, ADDM).
AWS & Cloud Databases: Practical experience administering managed database services including Amazon RDS (Oracle/PostgreSQL) and Amazon Aurora.
PostgreSQL: Hands-on working knowledge of PostgreSQL architecture, schema design, and performance optimization.
Cloud Migration Experience: Strong, proven track record of migrating on-premises databases to AWS environments (using tools such as AWS DMS, SCT, or native utilities).
Collaboration & Release Management: Solid background in CI/CD integration for database deployments and working alongside Agile engineering teams.
Ability to work with offshore teams for maintenance and production support activities
"NICE TO HAVE" skills
Experience with Oracle Exadata administration and performance tuning features (Smart Scan, Hybrid Columnar Compression).
Proficiency in shell scripting (Bash) and automation using Python.
Relevant AWS (e.g., AWS Certified Database Specialty) or Oracle certifications
...Office application such as Excel/Power point/Word ~ Bachelors Degree preferred~ Ability to travel up to 10 %~ Bilingual English/Korean is a plus Additional Information All your information will be kept confidential according to EEO guidelines. ***...
...Community School, a large private school located in sunny North Miami Beach, Florida, is accepting resumes for a high school computer Science teacher. Scheck Hillel is a nationally recognized college preparatory and Jewish community school located in North Miami Beach,...
...Overview Employer: TLC Nursing Associates, Inc. Responsibilities TLC Nursing Associates, Inc. is seeking a Travel RN Postpartum to provide compassionate and specialized care to mothers and newborns after childbirth. The ideal candidate will monitor the...
...Build a Career That Works From Anywhere Were expanding our virtual team and looking for motivated individuals who are ready to... ...who want to build something long termnot simply take on another temporary position. As you develop your skills and gain experience, youll...
...Requisition No:878443 Agency: Department of Corrections Working Title: CORRECTIONAL OFFICER CAPTAIN - 70036464Pay Plan: Career Service Position Number:70036464 Salary: $65,585.26 (MINIMAL ANNUALLY) Posting Closing Date: 09/29/2026 Total Compensation...