Oracle Database Administrator

Senior Oracle DBA

Toronto, ON - Hybrid (3 Days WFO)

Contract Duration - 12 months

Oracle Database (12c/19c+), AWS & Cloud Databases, Hands-on working knowledge of PostgreSQL architecture, Cloud Migration experience

Responsibilities:

• Collaborate with application development teams on data modeling| schema design| and deployment of complex PLSQL 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.

Required Skills and Experience:

• 8-10 years of experience in Oracle Database Administration
• Oracle Application DBA Expertise, 8 years specializing in Oracle Database (12c19c) application support| advanced PLSQL programming| execution plan analysis| and performance diagnostics (AWR| ASH| ADDM).
• AWS Cloud Databases Practical experience administering managed database services including Amazon RDS (OraclePostgreSQL) 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).
• CollaborationRelease Management Solid background in CICD 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 :

• 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