Database Administrator

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!

Website:?www.gocognition.com 

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;
• Enterprise application experience;
• Persistence frameworks;
• Understanding of Quality Assurance (QA) methodologies; and
• Insurance business knowledge.

APPLY NOW

Interested candidates are encouraged to apply online at www.gocognition.com/join-us/

Equal Employment Opportunities

Cognition+ is committed to employment equity and welcomes diversity. We encourage applications from qualified individuals from all backgrounds.

Cognition+ provides accommodations to applicants with disabilities throughout the hiring process. If you require accommodation, please contact Human Resources at hr@gocognition.com or call 519-432- 8553 ext. 362.

We thank all applicants for their interest in this position, however, only qualified candidates will be contacted for the next steps in the process.

APPLY