Senior Data & Backend Architect (Java/DB)

LexisNexis Legal & Professional

Alpharetta (GA)

On-site

USD 115,000 - 192,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Health benefits
401(k) with match
Wellbeing programs
Disability & life insurance
Family benefits
Commuter benefits

Job summary

LexisNexis Risk Solutions seeks a Consulting / Principal Software Engineer to lead design and optimization of large-scale database systems and backend platforms. You will guide data architecture, performance tuning, and Java-based data access, partnering with stakeholders to deliver scalable solutions.

Responsibilities include OLTP/OLAP data modeling, complex SQL optimization, ETL pipelines, and Unix/Linux scripting.

Qualifications

  • 8+ years of 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).
  • Experience diagnosing and resolving complex production issues.
  • Unix/Linux environments and shell scripting experience.

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
  • Actively debug and resolve production issues, including slow queries, deadlocks, locking problems, and high CPU, memory, or I/O utilization
  • 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
  • Perform hands‑on data analysis, validation, and reporting to ensure data accuracy and support business needs
  • 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

Skills

SQL development
Java
Database architecture
Performance tuning
Unix/Linux scripting
ETL pipelines
Data modeling

Tools

Hibernate/JPA
MySQL
JDBC

Job description

LexisNexis Risk Solutions seeks a Consulting / Principal Software Engineer to lead design and optimization of large-scale database systems and backend platforms. You will guide data architecture, performance tuning, and Java-based data access, partnering with stakeholders to deliver scalable solutions.

Responsibilities include OLTP/OLAP data modeling, complex SQL optimization, ETL pipelines, and Unix/Linux scripting.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Principal Software Engineer – Platform & Data Systems
Senior Principal Software Engineer – Platform & Data Systems

Lexis Nexis • Boca Raton (FL)

On-site
USD 120,000 - 180,000
Senior Consulting Software Architect
Senior Consulting Software Architect

Brightmine • Evanston (IL)

On-site
USD 140,000 - 180,000
Principal Software Engineer & Technical Leader (Consulting)
Principal Software Engineer & Technical Leader (Consulting)

LexisNexis Risk Solutions FL Inc. Company • Evanston (IL)

On-site
USD 120,000 - 180,000
Principal Software Engineer: Lead Architect & Mentor
Principal Software Engineer: Lead Architect & Mentor

Nextens • Boca Raton (FL)

On-site
USD 130,000 - 190,000
Senior Data Platform Engineer - Cloud-Native & Scalable
Senior Data Platform Engineer - Cloud-Native & Scalable

LexisNexis Risk Solutions • Miamisburg (OH)

On-site
USD 95,000 - 159,000
Annual incentive bonus
Senior DBA II: Lead Performance & Architecture
Senior DBA II: Lead Performance & Architecture

Lexis Nexis • Boca Raton (FL)

On-site
USD 95,000 - 159,000
Annual incentive bonus
Consulting/Principal Software Engineer
Consulting/Principal Software Engineer

LexisNexis Legal & Professional • Alpharetta (GA)

On-site
USD 115,000 - 192,000
Health benefits
401(k) with match
Wellbeing programs
+3
Senior DBA Lead: Performance, Architecture & Mentoring
Senior DBA Lead: Performance, Architecture & Mentoring

LexisNexis Risk Solutions FL Inc. Company • Boca Raton (FL)

On-site
USD 95,000 - 159,000
Annual incentive bonus
Country-specific benefits
Disability accommodation
DBA Lead: Architecture, Reliability & Mentorship
DBA Lead: Architecture, Reliability & Mentorship

Nextens • Alpharetta (GA)

On-site
USD 115,000 - 192,000
Principal DBA & Cloud Architect (MySQL/Oracle)
Principal DBA & Cloud Architect (MySQL/Oracle)

Relx Plc • New York (NY)

On-site
USD 105,000 - 175,000
Annual incentive bonus
Country-specific benefits