The Role
Senior Database Administrator responsible for physical database design, administration, optimization, capacity planning, migrations, performance tuning, backup and recovery. The role manages Oracle, SQL Server, cloud, hybrid, and legacy databases; implements security controls, disaster recovery, version upgrades, data integration, automation, and enterprise architecture. Requires expertise in SQL, cloud platforms, scripting, data modeling, database security, high availability, and large-scale government applications.
Summary Generated by Built In
Responsibilities:
- Creates
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:
- Experience
with one or more operating systems
- Experience
with one or more database technologies
- Experience
in one or more programming languages
- Experience
in the use of information retrieval packages and proficiency with query
languages
- Experience
in monitoring and enforcing database rules
- Experience
in Incident, Change and Configuration Management procedures
- Experience
with one or more communications protocols
- 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 and gateways
- Experience
with researching and implementing cyber security vulnerability
remediations
- Awareness
of emerging IT trends and directions
- Experience
with Computer Aided Software Engineering (CASE) tools
- Knowledge
and understanding of Information Management principles, concepts, policies
and practices
- Experience
in Database Administration, Maintenance Optimization
Additional Responsibilities/Skills for Data Warehouse
including Oracle OBIEE:
- Subject
matter expert in database design of the data warehouse or data marts.
- Skills:
- 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) based
- Knowledge
and understanding of Ontario Government Enterprise Architecture processes
and practice
- Knowledge
and understanding of Information Management principles, concepts, policies
and practices
- 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
with database administration and vendor support services
Additional Skills for Cloud Database Administrator:
- Expertise
and experience in Cloud DB Administration, Data Development
(DevOps/DataOps) & Operations, Data Integration, Automation tools and
technologies. Further research suggested on a potential need for a role of
a Senior DevOps/Cloud DBA at a rate similar to a Senior DevOps/Could
Engineer
Additional Skills for Oracle Database Administrator:
- Experience
in e-Business Suite Applications R12.2 and Oracle Data Guard application
(installation, configuration, maintenance, patching, upgrade, and cloning)
- Knowledge
and experience in configuring the latest version of WebLogic, OEM Grid
Control
- Expert
level knowledge of migrating Oracle technologies from Unix (Solaris) to
Oracle Enterprise Linux / Red Hat Enterprise Linux 5.x/6.x/7.x
- Expert
level knowledge of Advanced Compression, Data partitioning processes
- High
level knowledge of data masking using Oracle patches and database scripts
- Performance
tuning of e-Business Suite R12.2/19c in multi-node RAC
- Developing
database backup and restore strategy utilizing Flash Recovery Area (FRA)
for RMAN and ASM.
- Expert
level knowledge of Oracle 12c/19c database administration, maintenance,
security implementation, upgrade and patching, database performance
tuning, sizing and capacity planning, database backup and recovery using
RMAN
- Knowledge
of Configuring Oracle E-Business Suite Release 12.2 using Logical Host
- Knowledge
of Online patching
- Knowledge
of UNIX OS (Operating System) and Linux OS, utilities, shell scripting
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Experience
with major database management systems (DBMS) such as Oracle, Microsoft
SQL Server, PostgreSQL, MySQL, and IBM DB2
- Experience
managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS,
Google Cloud SQL) alongside legacy on-premises mainframes and enterprise
servers
- Experience
Cloud (Azure or AWS), Cyber Security, Enterprise and Solution
Architecture, Java, Microsoft .Net,
- Experience
with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL
MI, Azure Blob, Cosmos DB etc.)
Skill Set Requirements:
Technical Skills:
- Experience
with major database management systems (DBMS) such as Oracle, Microsoft
SQL Server, PostgreSQL, MySQL, and IBM DB2
- Experience
managing cloud-hosted or hybrid databases (e.g., Azure SQL, Amazon RDS,
Google Cloud SQL) alongside legacy on-premises mainframes and enterprise
servers
- Experience
with Agile methodologies
- Experience
with conceptual, logical, and physical data modeling, schema design, and
enterprise data architecture to support large-scale public applications
- Experience
with onPrem and Cloud connections using Mulesoft or similar tools
- Experience
Cloud (Azure or AWS), Cyber Security, Enterprise and Solution
Architecture, Java, Microsoft .Net,
- Experience
with SQL Server, Oracle, Cloud Databases (Structured and Unstructured, SQL
MI, Azure Blob, Cosmos DB etc.)
- Experience
with Rest APIs & Integrations, Web/Lite Apps
Experience:
- Experience
with cloud platforms such as Azure, Dynamics 365, Power Platform
- Experience
Implementing strict role-based access control (RBAC), data masking,
row-level security, and transparent data encryption (TDE) at rest and in
transit
- Ensuring
adherence to provincial data privacy and security mandates
- Designing,
testing, and executing enterprise backup strategies, point-in-time
recovery, geo-replication, and business continuity failover drills
- Experience
with Agile methodologies including using kanban/task boards
- Hands-on
experience leading major database version upgrades, cross-platform
migrations, and consolidation projects without disrupting agency services
- Experience
with SQL, PL/SQL, T-SQL, and shell scripting (Bash, PowerShell, Python)
for automation, stored procedures, and triggers
- Experience
with large government applications
Communication Skills:
- Strong
communication skills to prepare documentation, including but not limited
to; reports, reviews, assessments
- Ability
to present ideas and suggestions clearly and effectively and in a user
friendly manner; maintain a high level of customer service to both
internal and external clients
- Ability
to communicate designs and development in clear and understandable manner
Skills Required
- Experience with major database management systems, including Oracle, Microsoft SQL Server, PostgreSQL, MySQL, or IBM DB2
- Experience managing cloud-hosted or hybrid databases alongside on-premises mainframes and enterprise servers
- Experience with Azure or AWS cloud platforms
- Experience with cybersecurity, enterprise architecture, and solution architecture
- Experience with Java and Microsoft .NET
- Experience with SQL Server, Oracle, and structured and unstructured cloud databases
- Experience with Agile methodologies
- Experience with conceptual, logical, and physical data modeling, schema design, and enterprise data architecture
- Experience with on-premises and cloud connections using Mulesoft or similar tools
- Experience with REST APIs and integrations
- Experience with Azure, Dynamics 365, and Power Platform
- Experience implementing RBAC, data masking, row-level security, and transparent data encryption
- Experience designing and executing backup, point-in-time recovery, geo-replication, and business continuity strategies
- Experience leading database version upgrades, cross-platform migrations, and consolidation projects
- Experience with SQL, PL/SQL, T-SQL, Bash, PowerShell, and Python
- Experience with large government applications
- Strong written and verbal communication skills, documentation ability, and customer service skills
- Experience with distributed data systems
- Experience with middleware and gateways
- Experience researching and implementing cybersecurity vulnerability remediations
- Experience with CASE tools
- Experience with Oracle E-Business Suite R12.2, Oracle Data Guard, WebLogic, OEM Grid Control, RAC, RMAN, and ASM
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Maarut Inc. is a Canadian company specializing in IT services, technology staffing, and software development, dedicated to assisting businesses with digital transformation and solving business challenges through technology.
