Work In Tech

Explore opportunities in Waterloo Region and beyond

Database Administrator

Kognitiv

Kognitiv

Software Engineering, IT
Bengaluru, Karnataka, India
Posted on Tuesday, April 25, 2023

What We do:

Kognitiv empowers global brands to redefine loyalty through advanced data activation and multi-enterprise collaboration.

Founded in 2008, Kognitiv is challenging brands to redefine how they engage with their customers and deliver meaningful experiences that earn their lifetime loyalty. In June 2020, Kognitiv and Aimia’s Loyalty Solutions came together to create a data and technology-led business, employing people across 20 countries worldwide. With 200+ clients and partners in more than 50 markets globally, Kognitiv is removing the complexity of cultivating loyalty, data, and partnerships, so brands can deliver enhanced value, personalization, and experiences to today’s consumers, right where they are.

About the opportunity:

The Database Administrator (DBA) role is to design, implement, manage, and maintain the Kognitiv application databases.

You will work with engineering and services teams developing industry leading analytical and loyalty management solutions. You will be working closely with engineering teams developing software and supporting the infrastructure and database code rollout to various clients.

You will proactively monitor database performance to ensure the highest levels of availability and use your knowledge to ensure performance tuning and capacity management is in place. This includes the installation, upgrading, repairing and configuration of system and software components to keep the database environment current, secure and running efficiently.

You are required to provide estimates for IT projects and changes to deliver work with a commitment to the highest standards of quality and within budget constraints. As part of our IT Service Delivery team, you will utilise your organisational and troubleshooting skills to ensure problems are resolved efficiently with minimum impact to the business or its clients.

The DBA is also expected to function as a subject matter expert across the Kognitiv product ecosystem and takes an indirect accountability for promoting consistency, best practice, and effective use of data to increase confidence in the IT Service Delivery function for our business clients across all regions.

Areas of key responsibilities:

Database Administration (75%)

  • Installation, deployment, repairing and upgrading of database in cloud environments
  • Review functional requirements, technical design and operational documents
  • Develop and maintain secure databases in-line with best practice
  • Managing database changes by following the change management process to ensure that the live environment is protected
  • Monitoring of production database for performance, utilisation and capacity
  • Review daily operational system checks and work directly with support engineers, development and operations as needed to resolve issues
  • Managing the database environment capacity and recommend cost effective solutions
  • Troubleshooting and optimizing the performance of databases
  • Assist with troubleshooting of application performance issues and incidents and support with root cause analysis
  • Reporting on projects, task and incidents using Kognitiv tracking tools JIRA and ServiceNow
  • Ensure database environments adhere to Kognitiv policies
  • Liaise with third parties and clients on technical queries
  • Interpret written functional requirements and technical design documents.
  • Participate in software design activities.
  • Perform coding to written design specifications.
  • Perform unit and function testing of all code written.
  • Investigate, analyze, document and correct reported defects.
  • Create, document, and implement unit test plans, scripts.
  • Participate in code reviews.
  • Work with Development Leads to provide estimates for design, development and unit testing work.

Communications (20%)

  • Collaborate with IT peers to seek and share ideas and ways of working
  • Manage database related documentation
  • Develop, distribute and communicate FAQ and general use materials
  • Provide clear and timely updates on task progress and completion
  • Collaborate with your peers on new features and changes
  • Contribute to the application knowledge base as subject matter expert

Required for all team members:

  • Other duties as reasonably directed
  • Adhere to all Kognitiv policies
  • Take all reasonable care to ensure that your actions or omissions do not impact on the health and safety of yourself and others in the workplace
  • Recognize the dignity and respect of every team member and actively contribute and maintain a work environment which is free from harassment, sexual harassment and discrimination.

Background and Experience:

  • Undergraduate degree in a related field (e.g. BSc in Computer Science)
  • Proven commercial experience developing and working with RDMS – MySQL, MongoDB, MS SQL Server
  • Expert knowledge of one or more RDMS - MySQL/MariaDB/Percona, PostgreSQL
  • Expert knowledge of administrating NoSQL databases - MongoDB, Cassandra
  • Working Knowledge of Cloud Database technologies like AWS RDS, AWS Aurora, AWS Redshift.
  • Experience working with distributed systems and architecture

Skills and abilities:

  • Ability to understand and interpret new requirements
  • High level of conscientiousness with strong attention to detail and focus on delivering results
  • Very good time management skills and ability to work to deadlines
  • Team player with service-oriented attitude
  • Very good communication skills, both written and spoken English
  • Demonstrates troubleshooting ability and capacity to guide clients through a complex resolution process in a timely and professional manner.
  • Adept at learning and mastering new technologies
  • An interest in getting involved and making things happen
  • Ability to work in a team environment with the demand of short deadlines and high-pressure situations (SLAs to manage)
  • Ability to plan and prioritise activity based on impact to the business

We are a passionate, innovative organization with team members globally and we are looking for exceptional people to come and join us. This is an exciting opportunity to work for an international business, in a high energy environment with a collaborative, smart and passionate team. If you like the sound of us and the role: get in touch!

Here at Kognitiv, we don’t just accept difference - we celebrate it! Greater diversity means greater variation in ways of thinking, perspectives, and approach. And we thrive on it for the benefit of our employees and our clients. Kognitiv are committed to creating an inclusive environment and all employment is decided on the basis of qualifications, merit, fit and business need.