Energy Impact Partners
Energy Impact Partners

Lead Database Engineer - WorkWave

Clevest Solutions

Clevest Solutions

Colombo, Sri Lanka
Posted on Thursday, June 27, 2024

Company Description

IFS is a billion-dollar revenue company with 6000+ employees on all continents. Our leading AI technology is the backbone of our award-winning enterprise software solutions, enabling our customers to be their best when it really matters–at the Moment of Service™. Our commitment to internal AI adoption has allowed us to stay at the forefront of technological advancements, ensuring our colleagues can unlock their creativity and productivity, and our solutions are always cutting-edge.

At IFS, we’re flexible, we’re innovative, and we’re focused not only on how we can engage with our customers but on how we can make a real change and have a worldwide impact. We help solve some of society’s greatest challenges, fostering a better future through our agility, collaboration, and trust.

We celebrate diversity and understand our responsibility to reflect the diverse world we work in. We are committed to promoting an inclusive workforce that fully represents the many different cultures, backgrounds, and viewpoints of our customers, our partners, and our communities. As a truly international company serving people from around the globe, we realize that our success is tantamount to the respect we have for those different points of view.

By joining our team, you will have the opportunity to be part of a global, diverse environment; you will be joining a winning team with a commitment to sustainability; and a company where we get things done so that you can make a positive impact on the world.

We’re looking for innovative and original thinkers to work in an environment where you can #MakeYourMoment so that we can help others make theirs. With the power of our AI-driven solutions, we empower our team to change the status quo and make a real difference.

If you want to change the status quo, we’ll help you make your moment. Join Team Purple. Join IFS.

Job Description

WorkWave is a field service management software that provides SaaS solutions for businesses in the service industry (HVAC, Plumbing & Electrical, Cleaning, Lawn & Landscape, Home Delivery, Logistics & Distribution). We empower these businesses to deliver exceptional customer experiences and grow their customer base on our efficient and easy-to-use platform.

As a Lead Database Engineer, you will be at the forefront of our data management initiatives. Your role will involve not only developing and optimizing data systems but also operationally managing and leading a team of Database Engineers to ensure excellence in our data services.


  • Operationally manage and lead a team of Data Services Engineers, fostering a collaborative environment that encourages innovation and professional growth.
  • Direct the development and maintenance of database migration solutions, focusing on data integrity and performance.
  • Drive strategic initiatives to improve the efficiency and scalability of our data migration and retrieval systems.
  • Design and oversee ETL processes, leveraging tools like Microsoft SSIS, to support continuous integration and deployment workflows.
  • Handle a variety of data-related requests, ensuring prompt and effective resolution of database optimization, and data access issues.
  • Champion the team’s growth and development, including recruitment and mentorship of top-tier talent.
  • Manage incident response related to data systems, aiming for swift resolution and minimal disruption to services.
  • Monitor and report on key performance indicators (KPIs) to evaluate the effectiveness of the data management strategies.
  • Create and maintain documentation to streamline problem-solving and promote knowledge sharing within the team.


  • Bachelor’s degree in Computer Science, Information Systems, or a related field. Relevant work experience is also acceptable.
  • 5-8 years of experience in building databases, data migration, and transformation.
  • Advanced SQL coding and querying capabilities, especially with Microsoft SQL Server
  • Expertise in T-SQL, stored procedures, functions, triggers, and indexes.
  • Experience with ETL tools such as Microsoft SSIS.
  • Knowledge of various RDBMS products like Microsoft SQL Server, Oracle, MySQL, Postgres, FoxPro, and Microsoft Access.
  • Proven ability to operationally manage and lead a team, with a focus on delivering results and professional development.
  • Excellent communication skills, capable of effective interaction and requirement gathering with onshore peers.
  • Strong analytical and problem-solving abilities, thriving in a dynamic and fast-paced environment.

Additional Information

We believe that coming together as a community, in person, is important for innovation, connection and fostering a sense of belonging. Our roles have the right balance of remote and in-office working to enable flexibility for managing your life along with ensuring a real connection with your colleagues and the broader IFS community.