Sr Software Engineer - Database Systems

UKG; Lowell (MA); On-site; USD 110,000 - 150,000; Full time

Job summary

UKG in Lowell, MA is seeking a Software Engineer / Database Engineer to design, implement, and maintain PostgreSQL-based infrastructure and related SQL/scripts for multiple applications. You will collaborate with engineering teams on reviews, drive performance optimization, and contribute to observability and reliability across database environments.

You will lead or participate in architectural discussions, oversee CI/CD for database workflows, mentor junior engineers, and develop comprehensive

Qualifications

• 4+ years of experience as a Software Engineer or Database Engineer working with Postgres SQL and PPAS.
• Experience with scripting languages such as Python or Shell.
• Experience with cloud platforms, preferably Google Cloud Platform (GCP).
• Knowledge of Git, CI/CD, IaC, and observability tools.

Responsibilities

• Design, develop, and maintain PostgreSQL-based infrastructure and related SQL/scripts.
• Oversee CI/CD pipelines for database workflows and perform version upgrades.
• Perform performance tuning, monitoring, and root-cause analysis to prevent recurrences.
• Mentor junior engineers and contribute to technical documentation.

Skills

PostgreSQL

SQL

Python

Shell

Cloud platforms

DevOps

Observability

Code reviews

Education

Bachelor's degree in computer science or engineering

Master's degree in computer science or engineering

Tools

GitHub

Jenkins

GitHub Actions

Terraform

Ansible

JIRA

Splunk

Grafana

Tomcat

Apache

Job description

Software Development

Write clean, maintainable, and efficient code or various software applications and specializing in database systems.

Database Development

Design, develop, and deliver PostgreSQL-based infrastructure to support various applications and services, writing clean, maintainable, and efficient SQL and scripting code.

Technical Collaboration

Work closely with Engineering teams to perform SQL code reviews, define, and document best practices and guidelines, and drive performance tuning and optimization efforts.

Code Review

Diligent about reviewing code developed by other developers, providing feedback and maintain a high bar of technical excellence to make sure code is adhering to industry standard best practices like coding guidelines, elegant, efficient and maintainable code, with observability built from ground up, unit tests etc.

Architectural Design

Participate or lead in design reviews with peers and stakeholders and in the architectural design of new features and systems, ensuring scalability, reliability, and maintainability.

Service Health and Quality

Maintain the availability, reliability, and health of engineering database environments. Proactively identify and address issues using monitoring and observability tools and conduct thorough root cause analysis to prevent future recurrences.

Engineering Excellence Practices

Build and maintain SOPs, runbooks, and recommended actions. Advocate for and implement database best practices, holding a high bar for performance, reliability, and operational excellence.

DevOps Model

Oversee CI/CD pipelines for database workflows, ensuring efficient build, test, and deployment phases. version upgrades including PostgreSQL major, minor, in-place upgrades.

Incident Response

Participate in incident response activities including on-call rotations. Lead root cause analysis and implement preventive measures to ensure continuous system stability.

Mentorship

Provide technical mentorship and guidance to junior engineers, fostering a culture of learning and growth mindset.

Documentation

Develop and maintain comprehensive technical documentation, including SOPs, runbooks, best practice guides, and architectural decision records.

Innovation

Stay current with emerging database technologies and cloud-managed database services, advocating for their adoption where appropriate to drive innovation and productivity within the team. 4+ years of experience as a Software Engineer, Database Engineer working with Postgres SQL and EDB Postgres Advanced Server (PPAS). Experience in scripting languages such as Python or Shell. Experience with cloud platforms, preferably Google Cloud Platform (GCP). Experience with version control systems like GitHub, automation tools like Jenkins, GitHub Actions, configuration management tools like Terraform, Ansible and bug/work tracking systems like JIRA. Understanding of cloud technologies and DevOps principles. Experience with monitoring and observability tools such as Splunk or Grafana. Bachelor's degree in computer science, Engineering, or a related technical field, or equivalent practical experience. This position requires working onsite 3 days a week out of the UKG Lowell, MA office location Master's degree in computer science, Engineering, or a related technical field. Relevant certifications such as Google Cloud or EDB Postgres, are a plus Familiarity with Google Managed DB services including AlloyDB, Bigtable, BigQuery, and Cloud SQL. Knowledge of Java platforms and middleware (e.g., Apache, Tomcat).

Dedicated to diversity and inclusion initiatives.

Ability to apply best practices to improve products, processes, or services. Demonstrated ability to mentor and guide junior engineers. Commitment to continuous learning and professional development. Excellent communication and interpersonal skills, with the ability to work effectively in a collaborative team environment.