RQ10554 - Database Administrator - Senior

Responsibilities:

• 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

• 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

Requirements

Experience and Skill Set Requirements:

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

Skill Set Requirements:

Database Administration Expertise:

• 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:

• 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:

• 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