Closed listing
Oracle Database Administrator
- Toronto, ON, Canada
Full-time
This opening has closed.
The original listing is kept below for reference.
Job details
- Job type
- Full-time
- Closing date
- Experience
- 8–10 years of experience in Oracle Database Administration.
- Posting language
- English
- Posted
Similar jobs hiring now
Search current openingsOriginal job description
Archived listing. The details below describe a past opening.
Job Description :
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.
More about this job
Responsibilities
Administer and support Oracle and PostgreSQL databases, including performance diagnostics and optimization across on-premises and AWS-managed environments. Migrate databases to AWS, support database deployment through CI/CD, and collaborate with Agile and offshore teams on maintenance and production support.
Requirements
Requires 8–10 years of Oracle Database Administration experience, including at least 8 years of Oracle application database support, advanced PL/SQL, and performance analysis. Candidates should have practical experience with AWS database services, PostgreSQL, cloud migrations, CI/CD, and Agile teams; Exadata, scripting, automation, and relevant certifications are desirable.
Skills
- Oracle Database Administration
- Oracle Application DBA
- Oracle 12c/19c+
- PL/SQL
- Execution Plan Analysis
- Performance Diagnostics
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS Database Migration
- AWS DMS
- AWS SCT
- CI/CD
- Agile
- Oracle Exadata
- Bash and Python Automation
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Transportation
Keywords
- Oracle Database Administration
- Oracle Application DBA
- Oracle 12c
- Oracle 19c
- PL/SQL
- Execution Plan Analysis
- AWR
- ASH
- ADDM
- Amazon RDS
- Amazon Aurora
- PostgreSQL
- AWS
- AWS DMS
- AWS SCT
- Cloud Database Migration
- CI/CD
- Agile
- Offshore Production Support
- Oracle Exadata
- Smart Scan
- Hybrid Columnar Compression
- Bash
- Python
- AWS Certified Database – Specialty
- Oracle Certifications