RQ10554 Database Administrator Senior

RQ10554 - Database Administrator - Senior

10-month contract (190 business days) possible extension

ONSOITE 5 days - 40 St Clair Avenue Toronto

Security Level: CRJMC

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

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

Responsibilities:

• Creates and implements 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.
• Database optimization capacity planning installation and migration database design performance tuning backup and recovery.
• Maintain and monitor a number of Oracle 12c and above databases in large multi-tenant environments including database administration maintenance optimization migration and fine tuning of databases
• Design build and configure Oracle Database Servers on Windows Solaris Linux
• Ensure existing databases meet performance requirements including but not limited to SIEBEL ARCGIS APEX databases on Oracle
• Ensure that all deployed databases are secure and that appropriate security and auditing controls are in place to meet security and privacy requirements
• Provide database administration technical expertise during design and architecture phases of new solutions
• Lead and design solutions for enterprise Oracle migration project to migrate to 19c
• Plan manage and coordinate implementation of technically advanced complex systems and assist in Data refreshes to lower non-production environment
• Provide regular support to resolve complex and unique database management issues
• Provide expert support and guidance to production database systems and clients by overseeing the deployment and evaluation of complex Oracle databases
• Provide support and maintenance of databases in GoCloud and on premise-based environments
• Carry out complex/specialized systems analysis and design for success of Oracle migration
• Implement and Configure TDE Dataguard RAC OMS OEM 13c and Oracle Golden Gate
• Provide assistance with replicated database management and migration
• Documentation of your technical work such that knowledge can be transferred to you colleagues
• Identifies analyses prioritizes and communicates technical risks for decision makers
• Provides recommendations and mitigation strategies based on a detailed evaluation of technical risks and issues
• Communicates effectively to identify needs and evaluate solutions to complex business and technical issues
• Work with Siebel Application developers collaboratively and deploy SIEBEL solution patches and upgrades.
• Develop Maintain and Support ETL process to facilitate transfer of data from SIEBEL database to other staging databases for consumption.

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

AI Disclaimer: Source Code may use artificial intelligence (AI) tools to assist in certain aspects of its recruiting and business operations.

Note: The higher end of the range is intended for absolutely exceptional candidates who meet all must-have requirements and most or all nice-to-have qualifications. The client will evaluate candidates based on both rate expectations and overall skill set when shortlisting.

INCORPORATED RATE RANGE (7.25 billable hours per day)

• $75.60/hr - $90.75/hr Inc.

T4 RATE RANGE (7.25 billable hours per day)

• $60.48/hr - $72.60/hr T4