Junior DevOps Engineer

Black Kite•Boston, MA

109d•$85,000 - $100,000

About The Position

Black Kite is seeking a motivated Junior DevOps Engineer with hands-on experience in PostgreSQL and Microsoft SQL Server and an interest in Google Cloud Platform (GCP). The engineer will manage and optimize databases hosted on GCP, particularly Cloud SQL, and collaborate with engineering teams to help ensure database performance, reliability, and scalability.

Requirements

Bachelor’s degree in Computer Science, IT, or a related field.
1–2 years of database engineering experience.
Basic hands-on experience with PostgreSQL and Microsoft SQL Server.
Ability to write clean, efficient, optimized SQL queries.
Understanding of query execution plans, query optimization techniques, and indexing strategies.
Familiarity with joins, subqueries, CTEs, and window functions.
Basic knowledge of data modeling, including normalization and relationships.
Hands-on GCP experience or strong foundational knowledge, especially Cloud SQL.
Knowledge of basic cloud concepts, including compute, networking, and IAM.
Understanding of high availability and replication concepts in cloud environments.
Experience with database maintenance and monitoring.
Ability to work in Linux and/or Windows environments.
Strong analytical thinking and problem-solving skills.

Nice To Haves

Experience with other GCP services, including BigQuery, Pub/Sub, Cloud Storage, or Monitoring.
Experience with non-relational databases such as MongoDB, Elasticsearch, or Redis.
Familiarity with query profiling and performance tools.
Basic scripting skills in Python, Bash, or PowerShell.
Exposure to CI/CD pipelines and DevOps practices.
Knowledge of database security and access control.

Responsibilities

Write, analyze, and optimize SQL queries for performance and scalability.
Manage and maintain PostgreSQL and Microsoft SQL Server databases on GCP using Cloud SQL.
Tune queries and optimize performance using execution plans.
Design, implement, and maintain indexes.
Support and maintain high-availability and disaster-recovery setups in cloud environments.
Perform routine database maintenance, including index rebuilds or reorganizations, statistics updates, and backup and restore operations.
Monitor and troubleshoot database performance issues in GCP environments.
Work with GCP services and infrastructure, including Cloud SQL, Compute Engine, basic IAM, and networking concepts.
Collaborate with other teams to improve database usage and efficiency.