Consulting​/Principal Software Engineer

## Consulting/Principal Software Engineer Apply locations:
Alpharetta, GAtime type:
Full time posted on:
Posted 9 Days Agojob requisition :
R112606
** About the Business
** Lexis Nexis 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:
** 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…