Job Title: RQ10554 - Database Administrator - Senior
About the role
I would like to present to you a new job opportunity and I think you may find it interesting.
If you are interested kindly send the following documents to hrsmss@smsoftconsulting.com by Monday, July 6, 10:00 AM EST if that interests you and matches your profile.
Updated Resume in word format (Mandatory) References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory)
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 40 St Clair Avenue, Toronto, Ontario, Onsite
Estimated Start Date: 2026-07-13
Estimated End Date: 2027-03-31
#Business Days: 190.00
Extension: Probable after the initial mandate
Hours per day or Week: 7.25 hours per day
Security Level: No Clearance Required
Must Haves
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
RoleOverview
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
General Skills
10 + years’ experience in one or more operating systems one or more database technologies In the use of information retrieval packages and proficiency with query languages In monitoring and enforcing database rules Incident, Problem, Change, Configuration and capacity planning Management procedures Experience in Cloud migration Experience with one or more communications protocols 3) Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills A team player with a track record for meeting deadlines
Desirable Skills
Experience with distributed data systems Experience with middleware technologies such Web logic, OEM middleware, etc. Experience with researching and implementing cyber security vulnerability remediations Awareness of emerging IT trends and directions Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in Database Administration, Maintenance and Optimization and vendor support services. Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism Knowledge and understanding of object-oriented analysis and design techniques. Experience in developing enterprise architecture deliverables (e.g. models) Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases Experience in technical design, planning and implementation of specific technology or suite
Experience And Skill Set Requirements
Database Administration Expertise - 50%
10+ years proven experience in database administration, including database design, implementation, maintenance and support Hands-on experience with DBMS operations such as installation, configuration, migration, and upgrades Experience with RAC, Golden Gate, Data Guard Technologies. Experience with performance tuning, optimization, and capacity planning Experience with backup, recovery, and disaster recovery strategies Experience monitoring and enforcing database rules, policies, and standards Knowledge of Incident, Problem, Change, and Configuration Management processes (e.g., ITIL practices) Experience with database security, access control, and data integrity management Basic understanding of communication protocols and networking concepts relevant to databases Ability to support database connectivity and integration across systems
Technical Proficiency - 35%
Experience with one or more database technologies (e.g., Oracle 12c and above, SQL Server, MySQL, PostgreSQL) in large multi-tenant environments Proficiency in PL/SQL, creating data ETL procedures and Packages, and query optimization techniques Experience working with On-Prem and Cloud Technologies such as Azure and OCI Platforms. Experience working with multiple operating system such as Linux, Unix, and Windows Working knowledge of one or more programming/scripting languages (e.g., Python, Shell) Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan Experience coordinating implementation of technically advanced complex systems resources to lower non-production environment
Soft Skills -15%
Strong ability to troubleshoot complex database issues and optimize system performance Ability to document processes, designs, and operational procedures clearly Experience in providing complex/specialized systems analysis and design for success Communicates effectively to drive technical outcomes with technical staff/teammates Demonstrated critical thinking and decision-making capabilities Excellent verbal and written communication skills for technical and non-technical audiences Strong interpersonal skills with a collaborative mindset
Note
“This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location”.
Not the right fit? Search for Job Title: RQ10554 jobs in Toronto, Ontario, Canada
About S M Software Solutions Inc
SMSS Inc. is the best solution company specialized in providing Information Technology and Management Consulting. We provide value for money to our clients by delivering the best quality technical services and solutions at reasonable rates. We also provide the best working environment for our staff and consultants. It is a growing IT services provider having wide array of solutions from Business Strategy Analysis to implementation and execution of Information Technology as well as management aspects of a business entity.
Similar Jobs
Job Title: RQ10554 - Database Administrator - Senior
About the role
I would like to present to you a new job opportunity and I think you may find it interesting.
If you are interested kindly send the following documents to hrsmss@smsoftconsulting.com by Monday, July 6, 10:00 AM EST if that interests you and matches your profile.
Updated Resume in word format (Mandatory) References (Mandatory) Expected hourly rate (Mandatory) Visa Status (Mandatory) LinkedIn ID (Mandatory)
Client: Ministry of Public and Business Service Delivery and Procurement
Work Location: 40 St Clair Avenue, Toronto, Ontario, Onsite
Estimated Start Date: 2026-07-13
Estimated End Date: 2027-03-31
#Business Days: 190.00
Extension: Probable after the initial mandate
Hours per day or Week: 7.25 hours per day
Security Level: No Clearance Required
Must Haves
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
RoleOverview
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
General Skills
10 + years’ experience in one or more operating systems one or more database technologies In the use of information retrieval packages and proficiency with query languages In monitoring and enforcing database rules Incident, Problem, Change, Configuration and capacity planning Management procedures Experience in Cloud migration Experience with one or more communications protocols 3) Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills A team player with a track record for meeting deadlines
Desirable Skills
Experience with distributed data systems Experience with middleware technologies such Web logic, OEM middleware, etc. Experience with researching and implementing cyber security vulnerability remediations Awareness of emerging IT trends and directions Knowledge and understanding of Information Management principles, concepts, policies and practices Experience in Database Administration, Maintenance and Optimization and vendor support services. Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning Additional Skills for Case Management and ERP Experience in designing/developing an automated data distribution mechanism Knowledge and understanding of object-oriented analysis and design techniques. Experience in developing enterprise architecture deliverables (e.g. models) Knowledge and understanding of Ontario Government Enterprise Architecture processes and practice Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases Experience in technical design, planning and implementation of specific technology or suite
Experience And Skill Set Requirements
Database Administration Expertise - 50%
10+ years proven experience in database administration, including database design, implementation, maintenance and support Hands-on experience with DBMS operations such as installation, configuration, migration, and upgrades Experience with RAC, Golden Gate, Data Guard Technologies. Experience with performance tuning, optimization, and capacity planning Experience with backup, recovery, and disaster recovery strategies Experience monitoring and enforcing database rules, policies, and standards Knowledge of Incident, Problem, Change, and Configuration Management processes (e.g., ITIL practices) Experience with database security, access control, and data integrity management Basic understanding of communication protocols and networking concepts relevant to databases Ability to support database connectivity and integration across systems
Technical Proficiency - 35%
Experience with one or more database technologies (e.g., Oracle 12c and above, SQL Server, MySQL, PostgreSQL) in large multi-tenant environments Proficiency in PL/SQL, creating data ETL procedures and Packages, and query optimization techniques Experience working with On-Prem and Cloud Technologies such as Azure and OCI Platforms. Experience working with multiple operating system such as Linux, Unix, and Windows Working knowledge of one or more programming/scripting languages (e.g., Python, Shell) Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan Experience coordinating implementation of technically advanced complex systems resources to lower non-production environment
Soft Skills -15%
Strong ability to troubleshoot complex database issues and optimize system performance Ability to document processes, designs, and operational procedures clearly Experience in providing complex/specialized systems analysis and design for success Communicates effectively to drive technical outcomes with technical staff/teammates Demonstrated critical thinking and decision-making capabilities Excellent verbal and written communication skills for technical and non-technical audiences Strong interpersonal skills with a collaborative mindset
Note
“This position is listed as "Onsite"; the resource is expected to work 7.25 hours per calendar day between the standard working hours of 8:00-5:00 PM (excluding lunch breaks) every Monday to Friday inclusive at the identified OPS office location”.
Not the right fit? Search for Job Title: RQ10554 jobs in Toronto, Ontario, Canada
About S M Software Solutions Inc
SMSS Inc. is the best solution company specialized in providing Information Technology and Management Consulting. We provide value for money to our clients by delivering the best quality technical services and solutions at reasonable rates. We also provide the best working environment for our staff and consultants. It is a growing IT services provider having wide array of solutions from Business Strategy Analysis to implementation and execution of Information Technology as well as management aspects of a business entity.