Principal Software Engineer - Database & Backend Architect

LexisNexis

Alpharetta (GA)

On-site

USD 115,400 - 192,300

Full time

14 days+

Application generator

Turn this role into an interview — a resume and cover letter built around what this employer wants.

Get past ATS filters

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.