RQ10554 Database Administrator Senior

Job Location:

Toronto - Canada

Monthly Salary: Not Disclosed

Experience Required: 7-10years

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

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:

1) 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

2) Experience with one or more communications protocols

3) Excellent analytical problem-solving and decision-making skills; verbal and written communication skills; and interpersonal skills

4) 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

Database Administration Expertise-50%

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 -35%

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-15%

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

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

Must Have:

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.