Database Administration Oracle GIS

Position Description:

Job Summary
A Database Specialist (DBA) manages CNs data. A DBA has three core responsibilities: supporting the operations delivering new functionalities and projects and collaborating both within its team and with others. The level of accountability will differ based on seniority and the required competencies will depend on the database technology. At CN the DBA is responsible for the implementation design configuration maintenance performance integrity security and availability of the database systems.
The Database Specialist must have an indepth understanding of the technology and of the applications and business processes. A Database Specialist (DBA) acts as a mentor and establishes policies and procedures with the application and development teams to improve availability and protect the operations. The Database Specialist (DBA) role provides solution engineering support and administration for database systems and infrastructure.
Database Specialist at CN specializes in Oracle database Oracle RAC & Dataguard Oracle Spatial and Oracle Exadata.
Considered as an asset experience with Versant CockroachDB GCP Terraform Ansible Python Prometheus and Grafana.
Main responsibilities
Operational Support
In its daytoday core operations the Database Specialist (DBA) will safeguard the systems but also innovate and improve support efficiency by:
Define documents communicate and enforce monitoring observability and automation guidelines standards and best practices.
Participate to all initiatives related to monitoring automation optimization efficiency capacity planning emergency response change management and process improvements.
Ensure all components of a DBMS including storage archiving capacity management high availability backup and recovery procedures are built configured and monitored correctly.
Maintain data integrity and security (manage roles and permissions of database users).
Manage Production UAT and Development database environments.
Manage backups restorations and replications
Review and approve change controls
Optimize support tasks
Perform preventive maintenance tasks
Quality review of infrastructure changes and implementations
Works with other team members to develop and implement process improvement
Takes ownership in defining key performance indicators (KPIs) related to:
Capacity and performance
Services
Ensure database access is provided in a responsive and reliable manner.
Respond to production incidents.
Participate in various projects intended to continuously improve/upgrade infrastructure.
Handle escalation issues.
Prepare and document root cause analysis of productionrelated database issues
Supporting the team and the business in resolving complex issues
Performance monitoring and tuning
Expertise with configuring implementing and supporting large high availability clustered environments.
Test validate and implement performance and resource optimization improvements
Monitor and maintain database security
Execute system admin tasks such as daily routine and operational reports analysis
Handling capacity planning
Maintaining archived data
Installing and upgrading the database server and application tools
24 x 7 on call Support on rotation (TBC)
Create detailed documentation including diagrams of database infrastructure.
Able to prepare and present job related topics to upper management
Monitor and maintain database security.
Monitoring maintenance and administration of production QA and development database environments and familiar with change request process

Delivery
Participate to Business projects to design install and configure new database installations
The DBA must understand the particular security model that the database product uses and how to use it effectively to control access to the data
Minimise database downtime and manage parameters to provide fast query responses
Perform tests and evaluations regularly to ensure data security privacy and integrity
The Database Specialist (DBA) will also coach and mentor more junior DBAs.
Monitor database performance implement changes and apply new patches and versions when required
Adhere to all documented standards guidelines and procedures.
Modifying the database structure as necessary from information given by application developers
Planning how much disk storage will be required and monitoring available disk space
Learn relevant business processes and understand the data flow criticality and dependencies.
Will act as a SME and go to person to handle most complex problems.
Practice Evolution
Provide mentoring and technical guidance to other members of the team
Will act as a SME and go to person to handle most complex problems.
Engage with team to define design and implement suitable automated processes solutions to optimise the day to day support activities;
Works with other team members to develop and implement process improvement

Decision Making & Impacts
The Database Specialist (DBA) has a high level of autonomy; his manager can delegate him/her tasks or initiatives.

Level of Interaction/Influence
This position works closely with business application data owners and Technology Infrastructure to understand and forecast business needs optimize services and implement database technologies that will meet those needs. They are also responsible for ensuring database services are monitored maintained and all changes are fully tested prior to release.
Employees supervised/Org Structure
The individual will be part of a team of 5 10 people.
Education/Certification/Designation
Bachelor in Computer Science and 5 years in a similar role or College degree in Computer Science and 10 years in a similar role
A database certification is an asset
GCP certification is an asset
At least 2years of experience in the field of cloud computing and monitoring operation with handson experience with Infrastructure as code technology such as Terraform and Ansible

Skills/Knowledge
Excellent knowledge of Oracle RDBMS RAC Dataguard and Exadata.
Excellent knowledge of Oracle Spatial.
Knowledge of more than one RDBMS is an asset
Excellent knowledge of the highavailability technologies and best practices
Indepth knowledge of the PL SQL function and proceduree with ability to write or optimize very complex queries
Data modeling knowledge is an asset
Strong Programming language skill
Familiar with Linux environments and knowledge of programming languages such as Korn Perl or Python
Ability to work independently with minimal supervision.
Ability to collaborate with other team members
Strong infrastructure knowledge (such as Storage Network OS and Hypervisors)
Experience
710 years of experience in database management
Proficiency in MS Office Suite
Strong analytical and problem solving skills
Excellent written and oral communication skills
Ability to troubleshoot software and hardware issues

Bilingualism (French and English) is required for this position due to the nature of the role requiring interaction with national and global clients.

Skills:

• English
• French
• Ansible
• Oracle
• Oracle Exadata
• Terraform

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and wellbeing and provide you with opportunities to deepen your skills and broaden your horizons.

At CGI we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equalopportunity employer we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process please let us know. We will be happy to assist.

Come join our teamone of the largest IT and business consulting services firms in the world.