Senior Oracle DBA
- Toronto, ON, Canada
$48 to $58 USD / hour
Applications open in a new tab.
Job details
- Pay
- $48 to $58 USD / hour
- Apply by
- Experience
- 8-10 years of experience in database administration.
- Posting language
- English
- Posted
Original job description
Description
Join a dynamic team in a hybrid role based in Toronto, ON. This contract position spans 12 months and requires expertise in database administration and cloud technologies. The role involves collaborating with development teams, optimizing database performance, and leading migration projects.
Key Responsibilities
- Collaborate with application development teams on data modeling, schema design, and deployment of complex database packages, procedures, triggers, and views.
- Analyze execution plans, perform query tuning, and optimize index structures to eliminate bottlenecks in high-throughput environments.
- Lead database release automation, code reviews, and schema migrations across various environments.
- Monitor database health, identify lock contention, resolve deadlocks, and troubleshoot latency issues.
- Partner with infrastructure teams to design, test, and execute cloud database migrations.
- 8-10 years of experience in database administration.
- Expertise in advanced programming and performance diagnostics.
- Practical experience administering managed database services and cloud databases.
- Hands-on working knowledge of database architecture, schema design, and performance optimization.
- Proven track record of migrating on-premises databases to cloud environments.
Oracle Database | Cloud Databases | PostgreSQL | Cloud Migration | CICD Integration
Contact Authorization
By applying for this job, you agree to receive AI-generated calls, text messages, and/or emails from Mitchell Martin Inc and its affiliates and contracted partners at various frequency through traditional and automated methods. Message and data rates may apply for texts. Carriers are not liable for delayed or undelivered messages. You can access our privacy policy on our web site or here (https://www.mitchellmartin.com/privacy-policy).
Benefits
Learn more about our benefits offerings on our web site or here (https://www.mitchellmartin.com/careers/benefits-perks)
Onboarding Expectations
Learn more about our Onboarding Process on our web site or here (https://youtu.be/rjV_NFYjyY4)
EEO Statement
Learn more about our EEO policy on our web site or here (https://www.mitchellmartin.com/eoe-statement)
26-28039
More about this job
Responsibilities
Collaborate with application development teams on data modeling, schema design, and deployment of database objects, while tuning queries and indexes to improve performance. Lead database release automation and schema migrations, monitor database health and resolve performance issues, and partner with infrastructure teams on cloud database migrations.
Requirements
Requires 8–10 years of database administration experience, advanced programming and performance diagnostics expertise, and hands-on knowledge of database architecture, schema design, and optimization. Candidates should have experience administering managed and cloud databases and a proven record of migrating on-premises databases to cloud environments.
Skills
- Oracle Database Administration
- Database Performance Optimization
- Query Tuning
- Execution Plan Analysis
- Index Optimization
- Schema Design
- Data Modeling
- Database Architecture
- Database Release Automation
- Code Reviews
- Schema Migrations
- Deadlock Troubleshooting
- Cloud Database Administration
- Cloud Migration
- PostgreSQL
- CI/CD Integration
Visa sponsorship
Not detected in the job text
Categories
- Technology
- Data & Analytics
- Software
Keywords
- Oracle Database
- PostgreSQL
- Cloud Databases
- Cloud Migration
- Database Administration
- Database Architecture
- Data Modeling
- Schema Design
- Database Packages
- Stored Procedures
- Triggers
- Views
- Execution Plans
- Query Tuning
- Index Optimization
- Performance Diagnostics
- High-Throughput Environments
- Database Release Automation
- Code Reviews
- Schema Migrations
- Database Health Monitoring
- Lock Contention
- Deadlocks
- Latency Troubleshooting
- Managed Database Services
- CI/CD Integration
- Application Development
- Financial Services