Principal Software Engineer Database

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

What Diligent Offers You

Creativity is ingrained in our culture

We are innovative collaborators by nature

We thrive in exploring how things can be differently both in our internal processes and to help our clients

We care about our people

Diligent offers a flexible work environment, global days of service, comprehensive health benefits, meeting free days, generous time off policy and wellness programs to name a few

We have teams all over the world

We may be headquartered in New York City, but we have office hubs in Washington DC, Vancouver, London, Galway, Budapest, Munich, Bengaluru, Singapore, and Sydney

Diversity is important to us

Growing, maintaining and promoting a diverse team is a top priority for us

We foster and encourage diversity through our Employee Resource Groups and provide access to resources and education to support the education of our team, facilitate dialogue, and foster understanding

Diligent created the modern governance movement

Our world-changing idea is to empower leaders with the technology, insights and connections they need to drive greater impact and accountability to lead with purpose

Our employees are passionate, smart, and 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

Headquartered in New York, Diligent has offices in Washington D

C, Baltimore, London, Galway, Budapest, Vancouver, Bengaluru, Munich, and Sydney

We are a drug free workplace

Diligent is proud to be an equal opportunity employer

We do not discriminate based on race, color, religious creed, sex, national origin, ancestry, citizenship status, pregnancy, childbirth, physical disability, mental disability, age, military status, protected veteran status, marital status, registered domestic partner or civil union status, gender (including sex stereotyping and gender identity or expression), medical condition (including, but not limited to, cancer related or HIV/AIDS related), genetic information, or sexual orientation in accordance with applicable federal, state and local laws

We also consider qualified applicants regardless of criminal histories, consistent with legal requirements