Job Description
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
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)
