RQ10554 - Database Administrator - Senior
This senior database administrator role involves managing, optimizing, and migrating complex Oracle and SQL Server database environments in both on-premise and cloud settings. The position requires extensive experience with PL/SQL, ETL processes, and enterprise-level database tools to support critical business applications.
- Compensation
- CA$60–CA$91 / hr
- Location
- Toronto, ON, Canada
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Contract
- Experience
- 5+ years
- Category
- Devops
- Posted
Skills
Must have
- 10+ years of experience in database administration
- 5+ years of experience in PL/SQL, ETL procedures, and query optimization
- Experience with Oracle and SQL Server
- Experience with On-Prem and Cloud Technologies (Azure, OCI)
- Experience with RAC, Golden Gate, and Data Guard
- Experience with TOAD, OEM, and DB Artisan
Full description
**RQ10554 - Database Administrator - Senior10-month contract (190 business days) possible extensionONSOITE 5 days - 40 St Clair Avenue, Toronto
Security Level: CRJMCMust Have:**
- 10+ years of proven experience in database administration, including database design, implementation, maintenance and support
- 5+ years of experience in PL/SQL, creating data ETL procedures (very strong) and packages, and query optimization techniques
- Hands-on experience with DBMS operations such as installation, configuration, migration, and upgrades
- Strong knowledge of performance tuning, optimization, and capacity planning
- Experience with one Oracle and SQL Server
- Experience working with On-Prem and Cloud Technologies such as Azure and OCI Platforms.
- Experience with RAC, Golden Gate, Data Guard Technologies.
- Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan
Description: Creating physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery
Responsibilities:
- Creates and implements physical database designs and operates and administers the database management system (DBMS) including database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Database optimization, capacity planning, installation and migration, database design, performance tuning, backup and recovery.
- Maintain and monitor a number of Oracle 12c and above databases in large multi-tenant environments including database administration, maintenance, optimization, migration, and fine tuning of databases
- Design, build and configure Oracle Database Servers on Windows, Solaris, Linux
- Ensure existing databases meet performance requirements including but not limited to SIEBEL, ARCGIS, APEX databases on Oracle
- Ensure that all deployed databases are secure and that appropriate security and auditing controls are in place to meet security and privacy requirements
- Provide database administration technical expertise during design and architecture phases of new solutions
- Lead and design solutions for enterprise Oracle migration project to migrate to 19c
- Plan, manage and coordinate implementation of technically advanced complex systems and assist in Data refreshes to lower non-production environment
- Provide regular support to resolve complex and unique database management issues
- Provide expert support and guidance to production database systems and clients by overseeing the deployment and evaluation of complex Oracle databases