Consulting/Principal Software Engineer

RELX•Alpharetta, GA

19h

About The Position

LexisNexis Risk Solutions is the essential partner in the assessment of risk. Within our Business Services vertical, we deliver a wide range of solutions that help businesses drive revenue growth, maximize operational efficiency, and improve customer experience. Our offerings address critical challenges across Anti‑Money Laundering / Counter‑Terrorist Financing, Identity Authentication & Verification, Fraud and Credit Risk Mitigation, and Customer Data Management. 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. You will partner with cross-functional stakeholders to deliver scalable, high-performance data solutions and provide technical leadership across critical initiatives.

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

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

Benefits

Comprehensive, multi-carrier program for medical, dental and vision benefits
401(k) with match
Employee Share Purchase Plan
Wellness platform with incentives
Headspace app subscription
Employee Assistance and Time-off Programs
Short-and-Long Term Disability, Life and Accidental Death Insurance, Critical Illness, and Hospital Indemnity
Family benefits, including bonding and family care leaves, adoption and surrogacy benefits
Health Savings, Health Care, Dependent Care and Commuter Spending Accounts
In addition to annual Paid Time Off, we offer up to two days of paid leave each to participate in Employee Resource Groups and to volunteer with your charity of choice