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

Please refer the Job description for details