Principal Software Engineer - Database & Backend Architect

LexisNexis; Alpharetta (GA); On-site; USD 115,400 - 192,300; Full time

Benefits offered by this job

Health benefits

401(k) with match

Wellness program

Disability & life Insurance

Family benefits

Commuter benefits

PTO & volunteering

Job summary

LexisNexis Risk Solutions is seeking a Consulting / Principal Software Engineer to lead the design and optimization of large-scale database systems and backend platforms. The role requires deep expertise in database architecture, performance tuning, and Java-based application development, with guidance across data engineering and system design.

You will partner with cross-functional stakeholders to deliver scalable, high-performance data solutions and provide technical leadership on critical

Qualifications

• 8+ years of experience in software engineering with a strong database focus.
• 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.

Responsibilities

• Design and build database schemas, tables, indexes, and constraints for OLTP/OLAP.
• Write, troubleshoot, and optimize complex SQL queries with joins, CTEs, and window functions.
• Develop and maintain stored procedures, triggers, and functions with transactional control.
• Debug production issues such as slow queries, deadlocks, and high CPU/memory I/O utilization.
• Implement and optimize Java-based data access layers using JDBC and ORM frameworks.
• Build and support ETL pipelines for large datasets.

Skills

Java

SQL

Hibernate/JPA

Unix/Linux

Shell scripting

Tools

JDBC

Job description

LexisNexis Risk Solutions is seeking a Consulting / Principal Software Engineer to lead the design and optimization of large-scale database systems and backend platforms. The role requires deep expertise in database architecture, performance tuning, and Java-based application development, with guidance across data engineering and system design.

You will partner with cross-functional stakeholders to deliver scalable, high-performance data solutions and provide technical leadership on critical