RQ11860 - Database Administrator - Senior
Posted 101
views
Description
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
Sign in to read and join the discussion.