S M Software Solutions Inc
Hybrid - Senior Database Administrator - Toronto, Ontario
Be an Early Applicant
The role involves creating physical database designs, administering the DBMS, optimizing databases, and overseeing onboarding for new client applications. Requires significant experience in Oracle technologies.
Job Title: Database Administrator - Senior
Work Location: 222 Jarvis St, Toronto, Ontario, Hybrid
#Business Days: 168.00
Extension: 90.00
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must haves:
Work Location: 222 Jarvis St, Toronto, Ontario, Hybrid
#Business Days: 168.00
Extension: 90.00
Hours per day or Week: 7.25 hours per day
Security Level: CRJMC
Must haves:
- More than 10 yrs Oracle DBA experience
- Approved experience of Oracle 12c & 19c using multi-tenant architecture
- Oracle 19c RAC – Grid infrastructure/ASM
- RMAN backup and Restore
- Data Encryption using ASO/TDE
- Oracle Dataguard Physical/Logical Configuration & Administration
- Oracle Enterprise Manager configuration & Management for alerting & reporting
- UNIX shell scripting
- SQL optimization, tuning and performance experience
- Oracle Database hosting on public cloud services
- Shared Utility Service / Middleware team is looking for a database administrator to:
- Create physical database designs, operate and administer the database management system (DBMS) including database optimization, performance tuning, backup and recovery Manage database requirements for new client application onboarding the Shared Utility Service hosting. The consultant will be responsible for creating physical database designs, and operating and administering the database management system (DBMS) including database optimization, performance tuning, backup and recovery.
- Experience in database administration at the specified experience level
- Experience of managing Oracle 11g/12c ETL/Data warehouse Experience with UNIX operating system Experience with Oracle database technologies
- Experience in one or more programming language
- Experience in the use of information retrieval packages and proficiency with query language Experience with one or more communications protocol
- Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skill
- A team player with a track record for meeting deadline
- Experience in monitoring and enforcing database rule
- Experience in Incident, Change and Configuration Management procedures
- More than 10 yrs Oracle DBA experience
- Approved experience of Oracle 12c & 19c using multi-tenant architecture
- Oracle 12c RAC – Grid infrastructure/ASM
- RMAN backup and Restore
- Data Encryption using ASO/TDE
- Oracle Dataguard Physical/Logical Configuration & Administration
- Oracle Enterprise Manager configuration & Management for alerting & reporting
- UNIX shell scripting
- SQL optimization, tuning and performance experience
- MS SQL Server installation, Configuration, and database management
- Oracle certification - OCP
- Oracle Partitioning
- Oracle Advanced Compression
- Oracle Golden Gate Experience with distributed data system
- Experience with DB2 database technologies
- Data Conversion from DB2 to Oracle
- Building of Oracle RAC on conventional Solaris server
- Oracle Engineered solution
- Experience of DB web search service
- Oracle DB data integration and evaluation
- Experience with middleware and gateways
- Awareness of emerging IT trends and direction
- Experience with infrastructure services within the Ontario government (e.g. Internal Infrastructure Hosting policies and Provisioning practices)
- Knowledge of the GSIC support organization and ITSM processes adopted in OPS including
- Oracle Database on Public Cloud Services - 20%
- Dataguard - 20%
- Experience designing, installing, configuring, and maintaining an Oracle Dataguard environment Oracle Database Configuration - 15%
- Experience planning and designing a new database deployment. Experience installing and configuring an Oracle 19c RAC Database Oracle 19c Enterprise Manager - 20%
- Experience with designing, building, Installing, configuring, and administering OEM 19c Alerting and Reporting - 10%
- Experience installing, configuring and administering OEM 19c Alerting and Reporting Oracle Unified Auditing - 5%
- Experience installing, configuring and administering Oracle 19c Unified Auditing DB performance Tuning (5-7+ years’ experience perform ongoing monitoring and tuning of database ) - 5%
- OPS Experience - 5%
Top Skills
Aso
Ms Sql Server
Oracle 12C
Oracle 19C
Oracle Dataguard
Oracle Enterprise Manager
Oracle Rac
Rman
SQL
Tde
Unix
Similar Jobs
Financial Services
The position requires managing litigation, providing legal advice on financial products, and supporting senior management at JPMorgan Chase, demanding strong communication and organizational skills.
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
The Customer Quality Specialist ensures customer satisfaction by providing quality support, coordinating processes, conducting audits, and implementing improvements in automotive technologies.
Top Skills:
Asqc CertificationIpc Certification
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
The Supervisor oversees fabrication processes, ensuring requirements are met, supporting team leaders, managing employee relations, and driving continuous improvements in productivity and quality.
Top Skills:
Mp2Spreadsheet ProgramsWord Processor
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
