Work In Tech

Find your next role at Canada's fastest-growing tech companies

Senior, SQL Server DBA



Colombo, Sri Lanka
Posted on Monday, March 18, 2024
Role: SQL Server DBA

Location: Colombo, Sri Lanka

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 Senior SQL Server and Postgres DBA purpose is the delivery of sustainable, performant, robust database cloud infrastructure. Continuously strive to meet client SLAs, DR and costs savings for a multi-tenant, multi-regional global SaaS platform.

  • Production DBA of SQL Server and Postgres for the underlying SaaS Platform Infrastructure for all regions 24/7.
  • Databases hosted within cloud environments Azure and AWS – performance, scalability, security, backups, updates, disaster recovery and cost controls, storage, VMs.
  • Responsibilities include database best practices and assessment, automating monitoring performance, database backups, maintenance, documenting configuration changes, tracking and resolving database requests within SLAs.

Areas of key responsibilities:

  • Ensure 24x7 continuous database service availability via automated monitoring, redundancy and resilience, and service protection.
  • Strong experience with high transactional 24-7 Database Administration of SQL Server 2022, Postgres and Azure SQL
  • Perform assessment and analysis showing current versus best practice gaps and recommended remediation.
  • Experience with of AlwaysOn High Availability, Failover Cluster Instance, Log Shipping
  • Experience in troubleshooting and resolving performance issues, blocking, parallelism, CPU, resource contention, query optimization, index optimization, SQL Profiler, Query Store, Change Data Capture.
  • NoSQL experience good to have such as MongoDB, Redis, Cosmos DB, Cassandra
  • Understands best practice access and security controls how implement / manage / improve
  • Experience in managing high volume transactional traffic with experience in building shared databases to horizontally scale and advising application developers on how to work across distributed views, etc.
  • Knowledge of reporting, query tools and practices
  • Cloud experience with SQL Server, deployment to Azure, AWS on VMs as well as Azure SQL
  • Database maintenance, DBCC, table and index statistics, index fragmentation
  • Working knowledge of Windows Server, SQL Server configuration, maintenance plans, connection monitoring, storage considerations, Filestream, SQL Trace, Database Tuning Advisor, Database alerts, XEvents and performance, tempdb performance.
  • Work collaboratively in an open environment using version control and Azure DevOps

Background and Experience:

  • 5+ years commercial software support as a Database Administrator
  • A Bachelor’s degree in Computer Science or similar discipline
  • Azure and/or AWS experience
  • High Transactional Database Tuning and Management
  • Has experience as a DBA within Azure/Cloud/AWS environments / solutions
  • Experience with SQL Server and ideally Postgres, large databases (>1TB), HA and DR.
  • Experience in ecommerce or similar high “transactional” industry
  • Demonstrated success applying best practice performance tuning technologies and techniques to both database structures, as well as database queries and procedures.
  • Working knowledge of the following skills is good to have:
    • Knowledge of database architecture, partitioning, creating and optimizing database tables
    • Requirements analysis, data normalization, data modeling in Erwin, Visio or SSMS
    • Data visualization, BI and reporting tools such as Tableau, SSRS, SSAS, SSIS, R
    • Service Broker deployment and optimization
    • Microsoft SQL Server (2016, 2017, 2019, 2022, Azure SQL) T-SQL, functions, procedures
  • High technical ability, attention to detail, ability to identify and resolve issues, work effectively in a team.

Skills and abilities:

  • Highly effective team player
  • Demonstrates modesty and humility
  • High levels of conscientiousness
  • Achievement orientated
  • Data driven
  • Extremely curious
  • An excellent communicator, with an ability and confidence to build both outstanding customer relationships and gain internal support.
  • Time management

We are a passionate and innovative organization 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 based on qualifications, merit, fit and business need.