Senior Oracle DBA
- Toronto, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 8–10 years of Oracle Database Administration experience.
- Posting language
- English
- Posted
Original job description
Required Skills:
- 8–10 years of Oracle Database Administration experience.
- Strong expertise in Oracle Database 12c/19c+ and Oracle Application DBA.
- Advanced PL/SQL development, schema design, execution plan analysis, and performance tuning (AWR, ASH, ADDM).
- Experience with AWS RDS (Oracle/PostgreSQL) and Amazon Aurora.
- Hands-on experience with PostgreSQL architecture, schema design, and performance optimization.
- Proven experience migrating on-premises databases to AWS using AWS DMS, SCT, or native migration tools.
- CI/CD integration for database deployments and Agile environments.
- Production support, troubleshooting, capacity planning, disaster recovery, and offshore team collaboration.
Preferred Skills:
- Oracle Exadata administration and performance tuning.
- Bash and Python scripting for automation.
- AWS Database Specialty or Oracle certifications.
Top 3 Must-Have Skills:
- Oracle Database Administration (12c/19c+) with advanced PL/SQL and performance tuning.
- AWS cloud database administration and on-premises to AWS migration experience.
- Hands-on PostgreSQL administration and performance optimization.
More about this job
Responsibilities
Administer and optimize Oracle and PostgreSQL databases, including performance tuning, production troubleshooting, capacity planning, and disaster recovery. Migrate on-premises databases to AWS, support CI/CD database deployments, and collaborate with offshore teams in Agile environments.
Requirements
Requires 8–10 years of Oracle database administration experience, advanced PL/SQL and performance-tuning expertise, and hands-on PostgreSQL administration. Candidates should also have AWS database administration and migration experience; Oracle Exadata, scripting, and relevant AWS or Oracle certifications are preferred.
Skills
- Oracle Database Administration
- Oracle Database 12c/19c+
- Oracle Application DBA
- PL/SQL
- Schema Design
- Performance Tuning
- AWR, ASH, and ADDM
- AWS RDS
- Amazon Aurora
- PostgreSQL Administration
- AWS Database Migration
- AWS DMS
- AWS SCT
- CI/CD
- Production Support
- Disaster Recovery
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
Keywords
- Oracle Database Administration
- Oracle Database 12c
- Oracle Database 19c
- Oracle Application DBA
- PL/SQL
- Schema Design
- Execution Plan Analysis
- Performance Tuning
- AWR
- ASH
- ADDM
- AWS RDS
- Amazon Aurora
- PostgreSQL
- AWS DMS
- AWS SCT
- Database Migration
- CI/CD
- Agile
- Production Support
- Capacity Planning
- Disaster Recovery
- Oracle Exadata
- Bash
- Python
- AWS Database Specialty
- Oracle Certifications
- Offshore Team Collaboration