Job Description

About Us
Diligent is the global leader in modern governance, providing SaaS solutions across governance, risk, compliance, audit and ESG. Empowering more than 1 million users and 700,000 board members and leaders with a holistic view of their organization’s GRC practices so they can make better decisions, faster. No matter the challenge.

At Diligent, you are an agent of positive change. You are joining a team of passionate, smart, creative people who not only want to help build the software company of the future, but who want to make the world a more sustainable, equitable and better place. Be a part of a global community on a mission to make a real impact.

Learn more at diligent.com.

Position Overview:
We are seeking a highly experienced Principal Database Engineer to join our global team to design and optimize critical database systems. Our team is distributed across various geographical regions and is responsible for PostgreSQL, MS SQL Server, MySQL/MariaDB, Cassandra, and Couchbase, both on-premises and in the cloud. This role is perfect for a seasoned database professional with deep expertise in database optimization and performance tuning.

As the Principal Database Engineer, you will work with multiple teams across the company to design and implement robust storage solutions for various relational and non-relational databases. You will play a crucial role in transforming our database architecture, optimizing performance, and building platform-wide solutions. If you are an expert in database technologies and passionate about driving efficiency and scalability, we want you on our team.

Key Responsibilities

• Lead the organization in database optimization and performance tuning.
• Identify common performance bottlenecks across teams and implement comprehensive solutions.
• Stay current with the latest database technologies and define the organization's database strategy.
• Understand the high-level architecture and functionality of multiple products.
• Serve as a recognized expert in database technologies, providing technical guidance to senior management.
• Demonstrate strong leadership skills to engage, motivate, and align engineers towards achieving our goals.

Required Experience/Skills

• 15+ years of hands-on experience working with database technologies.
• Expertise in at least two database technologies in our portfolio: MS SQL Server, PostgreSQL, MariaDB, Cassandra, and Couchbase.
• Proven experience in migrating on-premises databases to the cloud (AWS/Azure/GCP).
• Proficiency in sharding to ensure data distribution and scalability.
• Expertise in setting up and managing database replication for high availability and disaster recovery.
• Skilled in tuning stored procedures for performance, ensuring efficient query execution.
• Strong knowledge of indexing strategies to enhance database performance.
• Proficiency in query optimization to improve execution time and resource utilization.
• Experience in capacity planning to ensure databases can handle growth and peak loads.
• Implementation of database security best practices to protect data integrity and confidentiality.
• Ability to work under pressure and tight timeframes. Flexibility to work outside business hours when necessary to meet service level agreements.
• Experience supporting all phases of the system development life cycle, including development, testing, QA, and production.
• Proficiency in automating administrative tasks using Python, Shell, and Terraform.
• Experience with Data Warehousing, on the reporting and ETL sides.
• Strong Linux/Unix administration skills.
• Knowledge of DevOps tools and practices.