DirectJobHub
Jobs · Engineering · Georgia

Consulting/Principal Software Engineer

hackajob · Alpharetta, GA · 1 wk ago
On-siteEngineering$115k–$192k/yrFull-time

About The Role

We are seeking a highly experienced Consulting / Principal Software Engineer to lead the design, optimization, and management of large-scale database systems and backend platforms. This role requires deep expertise in database architecture, performance tuning, and Java-based application development, along with the ability to advise on best practices across data engineering and system design.

Responsibilities

  • Design and build database schemas, tables, indexes, and constraints while ensuring efficient data modeling across both OLTP and OLAP environments
  • Write, troubleshoot, and optimize complex SQL queries using joins, subqueries, CTEs, and window functions to improve performance and reliability
  • Perform hands-on database programming by developing and maintaining stored procedures, triggers, and functions, with strong ownership of transaction management and concurrency control
  • Implement and enhance Java-based data access layers using JDBC and ORM frameworks such as Hibernate or JPA to ensure efficient and scalable database interaction
  • Build and support ETL pipelines, handling data extraction, transformation, migration, and batch processing for large datasets
  • Write and maintain Bash or shell scripts to automate database operations, including backups, job scheduling (cron), data processing, and monitoring within Linux or Unix environments
  • Perform hands-on data analysis, validation, and reporting to ensure data accuracy and support business needs

Requirements

  • 8+ years of experience in software engineering with a strong database focus
  • Expertise in relational databases (MySQL preferred) and data modeling
  • Advanced proficiency in SQL development and performance tuning
  • Strong experience with Java, JDBC, and ORM frameworks (Hibernate/JPA)
  • Proven experience diagnosing and resolving complex production issues
  • Solid understanding of transaction management, concurrency, and system performance
  • Hands-on experience with Unix/Linux environments and shell scripting

Qualifications

Learn more about the qualifications required for this role.

Skills

Learn more about the skills required for this role.

Benefits

We are delighted to offer a comprehensive benefits package including health benefits, retirement benefits, and more. Click here to learn more about the benefits offered in your location.

Pay

The U.S. National Base Pay Range for this role is $115,400 - $192,300. Geographic differentials may apply in some locations to better reflect local market rates.

Schedule

This job is eligible for an annual incentive bonus.

Similar jobs