Description
Position Description:
Job Summary
A Database Specialist (DBA) manages CN’s 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 in-depth 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 day-to-day 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 back-ups, 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 production-related 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 hands-on 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 high-availability technologies and best practices
-In-depth 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
-7-10+ 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, let’s turn meaningful insights into action.
Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you’ll 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. That’s why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company’s strategy and direction.
Your work creates value. You’ll 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.
You’ll shape your career by joining a company built to grow and last. You’ll be supported by leaders who care about your health and well-being 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 equal-opportunity 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 team—one of the largest IT and business consulting services firms in the world.
