S M Software Solutions Inc.

Senior Database Administrator

S M Software Solutions Inc.

contract

Posted on:

Origin:  • 🇨🇦 Canada

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AssemblyAWSAzureCloudETLITSMMS SQL ServerOracleShell ScriptingSQLUnix

About the role

  • Create physical database designs and 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.
  • Configure, install, and administer Oracle 12c/19c RAC, Grid infrastructure, ASM and Dataguard environments.
  • Implement and manage RMAN backups and restore procedures and Data Encryption using ASO/TDE.
  • Configure and administer Oracle Enterprise Manager 19c for alerting and reporting and Oracle Unified Auditing.
  • Perform SQL optimization, tuning and ongoing database performance monitoring.
  • Write and maintain UNIX shell scripts to support database operations.
  • Support Oracle Database hosting on public cloud services and participate in migrations and cloud deployments.
  • Monitor and enforce database rules and participate in Incident, Change and Configuration Management procedures.
  • Collaborate with the Shared Utility Service / Middleware team, OPS infrastructure teams, and clients to onboard applications.

Requirements

  • 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
  • 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
  • MS SQL Server installation, Configuration, and database management
  • Oracle certification - OCP (Desirable)
  • Oracle Partitioning (Desirable)
  • Oracle Advanced Compression (Desirable)
  • Oracle Golden Gate (Desirable)
  • 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
  • Security Level: CRJMC