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)
