Database Administrator

**About Cognition+**

Cognition+ is a team of talented and dedicated people on a mission to deliver transformative digital solutions to insurance companies of all sizes. In addition to a fully customizable Enterprise Insurance Management Platform, Cognition+ offers on-demand support, connectivity, cybersecurity, and development services. Founded in 1993, we have gained a deep understanding of our client’s business needs and challenges and have invested in R&D to build the next-generation of insurance technology solutions.

With a focus on teamwork, commitment, and trust, we know it takes people with diverse perspectives, ideas, and cultures to make a company succeed. We believe that hiring the best talent will lead to the creation of better products and services to keep our clients on the leading edge. If you are looking for a challenging opportunity for your work to make a lasting impact and your career to grow then we want to meet YOU

**Why Choose Cognition+**
- Competitive compensation package;
- Flexible work hours that offer work/life balance;
- Opportunity to learn, grow and innovate;
- Friendly and supportive team environment; and,
- Opportunity to provide your input into making this organization successful.

**The Role**

We are looking for a highly motivated and results-oriented individual to join our Database Team. The Database Administrator (DBA) will be responsible for providing operational database services to internal and external clients, optimizing our enterprise software solution, and supporting our migration to the cloud. This role requires a service-oriented mentality, high sense of ownership of the tasks assigned and requests received, and a focus on managing and resolving issues within a team-based environment.

This position can be performed from our office in London, Ontario or remotely within Canada. Remote-based employees may occasionally be asked to travel to our office for meetings or team building events.

**Role Responsibilities**
- Install, configure and deploy new databases;
- Design and optimize database architecture;
- Support and develop solutions in both on premise and cloud environments;
- Design, implement and maintain security measures, and backup and disaster procedures;
- Manage, monitor, maintain, upgrade and patch Oracle databases;
- Design, develop and maintain Data Fabric solutions;
- Plan and manage deployment DML and DDL for existing production databases;
- Efficiently perform the following tasks:

- Linux shell scripting;
- SQL and PL/SQL scripting;
- Performance Tuning;
- Database capacity planning and monitoring; and
- Relational data modeling.
- Collaborate with senior team members to design migration solutions, including development of specifications to ensure quality;
- Provide database support to cross-functional teams across the company;
- Create and maintain related documentation; and
- Perform other job-related duties as assigned.

**Required Qualifications & Skills**
- A Bachelor’s Degree or Diploma in Computer Science, Math, Computer Engineering, Network Engineering, or equivalent education, and/or related work experience;
- Four years experience as an Oracle DBA, including experience in developing, supporting and optimizing databases for deployment and/or migration/conversion purposes, preferably in the insurance or a related industry;
- Backup and Recovery Experience;
- SQL and PL/SQL experience;
- Advanced knowledge of systems design and analysis techniques;
- Advanced knowledge of database design and data access methods;
- Skills in database performance tuning, diagnostic tools and techniques;
- A demonstrated familiarity with current software industry trends and technologies (particularly around Database Management);
- Ability to work well with clients, both internal and external to the company;
- Ability to work independently to establish priorities and proceed with objectives;
- Proven diagnostic, analytical and problem solving skills;
- Strong interpersonal skills and attention to detail; and
- Strong written and verbal communication skills.

**Nice To Have**
- Advanced professional certification, such as Oracle DBA, CMA, CGA, P.Eng., etc.;
- Oracle Cloud (OCI) experience;
- Data Fabric experience;
- Data transformation ETL, ELT;
- Experience with the following technologies:

- Redis and Solr;
- Git;
- Oracle APEX, container database, and Oracle RAC;
- PostgreSQL Relational Database Management System (RDBMS);
- Linux/Unix scripting;
- Docker; and
- Operating Systems (Windows/Red Hat).
- Data Warehousing;
- Persistence frameworks;
- Understanding of Quality Assurance (QA) methodologies; and
- Insurance business knowledge.

**APPLY NOW**

**Equal Employment Opportunities