18 Aug
|
S M Software Solutions
|
Winnipeg
18 Aug
S M Software Solutions
Winnipeg
Senior Database Administrator – RQ10554 Client:
Ministry of Public and Business Service Delivery and Procurement
Location:
40 St Clair Avenue, Toronto, Ontario –
Onsite
Estimated Start Date:
July 13, 2026
Estimated End Date:
March 31, 2027
Business Days:
190
Extension:
Probable after the initial mandate
Hours:
7.25 hours per day
Security Level:
CRJMC
Role Overview We are seeking a highly experienced
Senior Database Administrator
to support enterprise database administration, design, implementation, optimization, maintenance, migration, and operational support. The successful candidate will have strong expertise in
Oracle and SQL Server environments , PL/SQL, ETL procedures, performance tuning, backup and recovery, disaster recovery, and cloud technologies including
Microsoft Azure and Oracle Cloud Infrastructure (OCI) .
The role requires extensive experience supporting complex database environments, implementing database security and governance standards, troubleshooting critical database issues, and coordinating technical implementations across on-premises and cloud platforms.
Role Snapshot Requisition:
RQ10554 – Database Administrator – Senior
Client:
Ministry of Public and Business Service Delivery and Procurement
Work Location:
40 St Clair Avenue, Toronto, Ontario – Onsite
Contract Duration:
July 13, 2026 – March 31, 2027
Extension:
Probable
Hours:
7.25 hours/day
Security Clearance:
CRJMC
Key Responsibilities
Database Administration & Operations – 50%
Design, implement, maintain, and administer enterprise database environments.
Create physical database designs and support database architecture and implementation.
Perform database installation, configuration, migration, upgrades, cloning, and maintenance.
Conduct database performance tuning, optimization, and capacity planning.
Develop and implement backup, recovery, and disaster recovery strategies.
Monitor database environments and enforce database policies, standards, rules, and controls.
Manage database security, access controls, and data integrity.
Support Incident, Problem, Change, Configuration, and Capacity Management processes in accordance with ITIL practices.
Troubleshoot complex database issues and provide timely resolution.
Support database connectivity and integration across enterprise systems.
Coordinate with technical teams and vendors to maintain reliable database operations.
Technical Proficiency – 35%
Provide advanced administration and support for database technologies including Oracle 12c+ and SQL Server.
Develop and optimize PL/SQL procedures, packages, ETL processes, and complex queries.
Apply advanced query optimization and database performance-tuning techniques.
Support database environments across on-premises and cloud platforms, including Azure and OCI.
Work with multiple operating systems, including Linux, Unix, and Windows.
Support Oracle technologies including RAC, GoldenGate, and Data Guard.
Utilize database administration and information retrieval tools such as TOAD, Oracle Enterprise Manager (OEM), and DB Artisan.
Use scripting/programming technologies such as Python and Shell scripting where required.
Coordinate the implementation and deployment of technically complex systems and database resources into lower/non-production environments.
Support cloud migration initiatives and database modernization activities.
Assist with technology-stack installation, configuration, maintenance, upgrades, patching, and cloning.
Technical Analysis, Documentation & Collaboration – 15%
Troubleshoot complex database and systems issues and recommend effective solutions.
Document database designs, processes, technical procedures, and operational standards.
Provide specialized systems analysis and technical design support.
Communicate effectively with technical teams, stakeholders, and project resources.
Apply critical thinking and sound decision-making to resolve technical challenges.
Collaborate with cross-functional teams to achieve technical and operational objectives.
Meet deadlines while maintaining quality, reliability, and adherence to established standards.
Required Skills & Experience Skill / Experience Requirement Database administration, design, implementation, maintenance, and support
10+ years
Database technologies and operating systems
10+ years
Information retrieval tools and query languages
10+ years
PL/SQL, ETL procedures/packages, and query optimization
5+ years
Database performance tuning, optimization, and capacity planning
Strong experience
Oracle and SQL Server administration
Required
On-premises and cloud database technologies
Required
Azure and Oracle Cloud Infrastructure (OCI)
Required
Oracle RAC, GoldenGate, and Data Guard
Required
DBMS installation, configuration, migration, and upgrades
Required
TOAD, OEM, and DB Artisan
Required
Backup, recovery, and disaster recovery
Required
Cloud migration experience
Required
Linux, Unix, and Windows
Required
Python and/or Shell scripting
Working knowledge
Database security, access control, and data integrity
Required
Incident, Problem, Change, Configuration & Capacity Management
Required
General Skills
Robust analytical, problem-solving, and decision-making abilities.
Excellent verbal and written communication skills.
Strong interpersonal and collaboration skills.
Ability to work effectively within a team and meet established deadlines.
Experience working with communications protocols and networking concepts relevant to database environments.
Strong ability to document technical processes, designs, and operational procedures.
Ability to communicate technical concepts effectively to both technical and non-technical audiences.
Desirable / Nice-to-Have Skills
Experience with distributed data systems.
Experience with middleware technologies such as WebLogic and OEM Middleware.
Experience researching and implementing cybersecurity vulnerability remediation.
Awareness of emerging IT technologies, trends, and directions.
Knowledge of Information Management principles, concepts, policies, and practices.
Experience with database administration, maintenance, optimization, and vendor support services.
Experience supporting enterprise technology/application stacks, including installation, configuration, maintenance, upgrades, patching, and cloning.
Experience designing and developing automated data distribution mechanisms, particularly for Case Management and ERP environments.
Knowledge of object-oriented analysis and design techniques.
Experience developing enterprise architecture deliverables and models.
Knowledge of Ontario Government Enterprise Architecture processes and practices.
Experience performing impact analysis, implementation planning, and implementation of technology/application patches, maintenance packs, releases, and technology-stack patch sets.
Experience with technical design, planning, and implementation of specific technologies or enterprise application suites.
#J-18808-Ljbffr
📌 Database Administrator - Senior (Winnipeg)
🏢 S M Software Solutions
📍 Winnipeg