RQ- Database Administrator - Senior

RQ10554 - Database Administrator - Senior Job Description

Creating physical database designs and operating and administering 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.
• Monitoring and enforcing database rules, incident, problem, change, configuration and capacity planning management procedures, including cloud migration.
• Experience with one or more communications protocols.
• Excellent analytical, problem‑solving, decision‑making, verbal and written communication skills, and interpersonal skills.
• A team player with a track record for meeting deadlines.
• Experience with distributed data systems, middleware technologies such as Web Logic, OEM, etc.
• 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, vendor support services.
• Expert knowledge in technology and/or application required, including installation, configuration, maintenance, upgrade and cloning.
• Case‑management and ERP experience: designing/developing an automated data distribution mechanism.
• Knowledge and understanding of object‑oriented analysis and design techniques, Ontario Government Enterprise Architecture processes and practice.
• Impact analysis, implementation planning and implementation of technology or suite‑specific patches, maintenance packs and releases, technology stack patch sets and releases.
• Technical design, planning and implementation of specific technology or suite.

Experience and Skill Set Requirements

• 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 and Data Guard technologies.
• Experience with performance tuning, optimization and capacity planning.
• Experience with backup, recovery and disaster recovery strategies.
• Monitoring and enforcing database rules, policies and standards.
• Knowledge of incident, problem, change and configuration management processes (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 (Oracle 12c+, 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 with multiple operating systems such as Linux, Unix and Windows.
• Working knowledge of one or more programming/scripting languages (Python, Shell).
• Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan.
• Coordinating implementation of technically advanced complex systems resources to lower non‑production environments.

Soft Skills

• Strong ability to troubleshoot complex database issues and optimize system performance.
• Ability to document processes, designs and operational procedures clearly.
• Providing complex/specialized systems analysis and design for success.
• Communication effectiveness to drive technical outcomes with technical staff and 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.

Must Haves

• 10+ years proven experience in database administration, including database design, implementation, maintenance and support.
• 5+ years experience in PL/SQL, creating data ETL procedures 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 Oracle and SQL Server.
• Experience working with on‑prem and cloud technologies such as Azure and OCI platforms.
• Experience with RAC, Golden Gate and Data Guard technologies.
• Experience with information retrieval tools and query languages such as TOAD, OEM and DB Artisan.