Consulting/Principal Software Engineer

LexisNexis Risk Solutions Inc. Company; Alpharetta (GA); On-site; USD 115,000 - 192,000; Full time

Benefits offered by this job

Health Benefits

Retirement Benefits

Wellbeing programs

Disability and life insurance

Paid time off and volunteering

Job summary

LexisNexis Risk Solutions Inc. in Alpharetta, GA seeks an experienced 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 development, partnering with stakeholders to deliver scalable data solutions. Responsibilities include designing schemas, writing complex SQL, developing JDBC/Hibernate data access layers, building ETL pipelines, and automating DB

Qualifications

• 8+ years of software engineering with strong DB focus.
• Expertise in relational DBs and data modeling.
• Advanced SQL development and performance tuning.
• Java backend development with JDBC and ORM experience.

Responsibilities

• Design and optimize database schemas, tables, indexes and constraints.
• Write and optimize complex SQL queries for OLTP/OLAP.
• Develop stored procedures, triggers, and functions.
• Debug production issues like slow queries and deadlocks.
• Implement Java data access layers using JDBC and Hibernate/JPA.
• Build ETL pipelines for large datasets.
• Analyze data quality and support business needs.
• Automate DB ops with Bash scripts on Linux/Unix.

Skills

Java

SQL development

Database design

Production issues troubleshooting

Unix/Linux scripting

Tools

JDBC

Hibernate/JPA

MySQL

Job description

About the Business

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. Learn more at: https://risk.lexisnexis.com

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. You will partner with cross‑functional stakeholders to deliver scalable, high‑performance data solutions and provide technical leadership across critical initiatives.

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

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

Working for you

We know that your wellbeing and happiness are key to a long and successful career. These are some of the benefits we are delighted to offer:

• Health Benefits: Comprehensive, multi-carrier program for medical, dental and vision benefits
• Retirement Benefits: 401(k) with match and an Employee Share Purchase Plan
• Wellbeing: 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

U.S. National Base Pay Range: $115,400 - $192,300. Geographic differentials may apply in some locations to better reflect local market rates. This job is eligible for an annual incentive bonus.

We know your well‑being and happiness are key to a long and successful career. We are delighted to offer country specific benefits. Click here to access benefits specific to your location.

We are committed to providing a fair and accessible hiring process. If you have a disability or other need that requires accommodation or adjustment, please let us know by completing our Applicant Request Support Form or please contact 1-855-833-5120.

We are an equal opportunity employer: qualified applicants are considered for and treated during employment without regard to race, color, creed, religion, sex, national origin, citizenship status, disability status, protected veteran status, age, marital status, sexual orientation, gender identity, genetic information, or any other characteristic protected by law.

USA Job Seekers: EEO Know Your Rights.

LexisNexis Legal & Professional is a leading global provider of legal, regulatory and business information and analytics that help customers increase productivity, improve decision‑making and outcomes, and advance the rule of law around the world. We help lawyers win cases, manage their work more efficiently, serve their clients better and grow their practices. We assist corporations in better understanding their markets and preventing bribery and corruption within their supply chains. We partner with leading global associations and customers to help collect evidence against war criminals and provide tools to combat human trafficking. We endeavour to advance the rule of law across the world. Our teams are combining unparalleled legal and business information with analytics and technology to advance what’s possible for the way our customers work and to advance what’s possible in the world by strengthening the rule of law.

Please read our Candidate Privacy Policy.