Senior Oracle Database Administrator (DBA)
Dawn InfoTek Inc. is a professional IT consulting firm that partners with major financial institutions, investment firms, and government organizations. We provide high-quality IT professionals to support our clients’ technology transformation and modernization initiatives.
We are seeking an experienced Oracle Database Administrator (DBA) to join our bank client’s project. The successful candidate will be primarily responsible for planning, executing, and supporting Oracle database version upgrades across enterprise environments.
Location: Downtown Toronto, ON (Hybrid – 2 days per week in the office)
Position Type: Contract
Key Responsibilities
- Plan and execute Oracle database version upgrades across non-production and production environments.
- Perform pre-upgrade assessments, compatibility checks, and post-upgrade validation.
- Develop upgrade strategies, implementation plans, and rollback procedures.
- Perform database installation, configuration, migration, patching, and performance tuning.
- Ensure database availability, security, data integrity, and minimal business disruption during upgrades.
- Troubleshoot and resolve database upgrade and performance-related issues.
- Collaborate with application, infrastructure, and production support teams to ensure successful upgrade implementation.
- Prepare and maintain technical documentation and operational procedures.
Required Skills
- 10+ years of hands-on experience as an Oracle DBA in enterprise environments.
- 5+ years of experience with Oracle database version upgrades, migrations, and patching.
- Proven hands-on experience executing major Oracle database version upgrades.
- Strong knowledge of Oracle database architecture, upgrade methodologies, tools, and utilities.
- Strong experience with Oracle RAC, ASM, Data Guard, RMAN, and Multitenant Architecture (CDB/PDB).
- Experience with database backup and recovery, performance tuning, and disaster recovery.
- Strong knowledge of SQL, PL/SQL, Linux/Unix, and Shell scripting.
- Strong troubleshooting and problem-solving skills, with the ability to work independently with minimal supervision.
- Excellent communication, collaboration, and task management skills.
Nice-to-Have Skills
- Previous experience in banking or financial services.
- Experience with large-scale Oracle database modernization projects.
- Experience with Oracle Exadata, GoldenGate, or Oracle Cloud Infrastructure (OCI).
- Experience with database automation and near-zero-downtime migration strategies.
- Oracle Certified Professional (OCP) certification.
Education
- Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related discipline, or equivalent practical experience.