Senior Oracle DBA
- Toronto, ON, Canada
Hybrid
$73 to $75 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $73 to $75 CAD / hour
- Job type
- Contract
- Workplace
- Hybrid
- Apply by
- Experience
- 8-10 years of Oracle Database Administration experience.
- Posting language
- English
- Posted
Original job description
Tech Talent International (TTI) supplies technical talent to a variety of clients ranging from Fortune 100/500/1000 companies to startups, small and mid-sized organizations in Canada/US. We are currently hiring a Senior Oracle DBA for our global consulting client.
Role: Security Senior Oracle DBA
Rate Range: $73 -75/hr C2C (40 hrs /week)
Duration: 12 months
Location: Hybrid,3 days in office, Toronto, ON, Canada
Role Overview
Job Description: Senior Oracle DBA responsible for administering, optimizing, and supporting Oracle databases while leading performance tuning, database releases, AWS cloud migrations, PostgreSQL environments, and production database operations.
Key Responsibilities
- 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
- Execution Plan Analysis
- 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.
- Proven experience migrating on-premises databases to AWS.
- 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.
- Strong troubleshooting, analytical, and performance optimization skills.
Preferred Qualifications
- Oracle Exadata administration experience.
- Knowledge of Exadata performance features including Smart Scan and Hybrid Columnar Compression.
- Bash/Shell scripting experience.
- Python automation experience.
- AWS database-related certifications.
- Oracle database certifications.
Key Skills
- Oracle Database 12c/19c+
- Oracle DBA
- PL/SQL
- SQL Performance Tuning
- AWR / ASH / ADDM
- PostgreSQL
- AWS
- Amazon RDS
- Amazon Aurora
- AWS DMS
- AWS SCT
- Database Migration
- Oracle Exadata
- CI/CD
- Database Automation
- Disaster Recovery
- High Availability
- Bash
- Python
- Agile
More about this job
Responsibilities
Administer, optimize, and support Oracle and PostgreSQL databases, including performance tuning, production operations, and database release automation. Lead on-premises-to-AWS migrations and contribute to capacity planning, high availability, disaster recovery, and CI/CD-integrated database deployments.
Requirements
Requires 8–10 years of Oracle database administration experience, strong Oracle 12c/19c+ and PL/SQL expertise, and hands-on experience with PostgreSQL and AWS database services. Candidates should have experience with database migrations, performance tuning, release management, CI/CD, and high-availability or disaster-recovery environments; Exadata, scripting, and relevant certifications are preferred.
Skills
- Oracle Database Administration
- Oracle Database 12c/19c+
- PL/SQL
- SQL Performance Tuning
- Execution Plan Analysis
- AWR/ASH/ADDM
- PostgreSQL
- AWS
- Amazon RDS
- Amazon Aurora
- AWS DMS
- AWS SCT
- Database Migration
- CI/CD
- Oracle Exadata
- Disaster Recovery
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Software
- Data & Analytics
- Consulting
Keywords
- Oracle Database Administration
- Oracle 12c
- Oracle 19c
- PL/SQL
- Execution Plan Analysis
- SQL Performance Tuning
- AWR
- ASH
- ADDM
- PostgreSQL
- Amazon RDS for Oracle
- Amazon RDS for PostgreSQL
- Amazon Aurora
- AWS DMS
- AWS SCT
- AWS Database Migration
- Oracle Exadata
- Smart Scan
- Hybrid Columnar Compression
- Database Release Management
- CI/CD
- Database Automation
- High Availability
- Disaster Recovery
- Bash
- Python
- Agile
- Schema Design
- Capacity Planning
- Production Support