Consulting/Principal Software Engineer
LexisNexis6 months ago
Base Salary
$115k - $192k/yr
Responsibilities
- Design and build database schemas, tables, indexes, constraints, and data models for OLTP and OLAP environments.
- Write, troubleshoot, and optimize complex SQL queries using joins, subqueries, CTEs, and window functions.
- Develop and maintain stored procedures, triggers, and functions with ownership of transaction management and concurrency control.
- Debug and resolve production issues involving slow queries, deadlocks, locking, and high CPU, memory, or I/O utilization.
- Implement and enhance Java-based data-access layers using JDBC and ORM frameworks such as Hibernate and JPA.
- Build and support ETL pipelines for data extraction, transformation, migration, and batch processing.
- Perform data analysis, validation, and reporting to ensure data accuracy and support business needs.
- Write and maintain Bash or shell scripts to automate database backups, cron scheduling, data processing, and monitoring in Linux or Unix environments.
- Provide technical leadership and advise cross-functional stakeholders on database architecture, data engineering, and system design.
Requirements
- 8+ years of software engineering experience with a strong database focus.
- Expertise in relational databases, preferably MySQL, and data modeling.
- Advanced proficiency in SQL development and performance tuning.
- Strong experience with Java, JDBC, and ORM frameworks including Hibernate or JPA.
- Proven experience diagnosing and resolving complex production issues.
- Solid understanding of transaction management, concurrency, and system performance.
- Hands-on experience with Unix or Linux environments and shell scripting.
Benefits
- Comprehensive medical, dental, and vision benefits through a multi-carrier program.
- 401(k) with match and an Employee Share Purchase Plan.
- Wellness platform with incentives, Headspace subscription, Employee Assistance, and time-off programs.
- Short- and long-term disability, life and accidental death insurance, critical illness, and hospital indemnity coverage.
- Family benefits including bonding and family care leave, adoption, and surrogacy benefits.
- Health Savings, Health Care, Dependent Care, and Commuter Spending Accounts.
- Annual paid time off plus up to two paid days each for Employee Resource Group participation and volunteering.
- The role is eligible for an annual incentive bonus, with a U.S. national base-pay range of $115,400 to $192,300.
About LexisNexis
LexisNexis builds research, content, and workflow software for legal, regulatory, and business professionals, including the Lexis+ platform and AI‑assisted drafting and analytics tools. It sells subscriptions and licenses to primary law, news, and practical guidance, plus SaaS products for litigation, compliance, and practice management used by law firms, corporate legal, governments, and universities. Founded in 1970 and headquartered in New York City, it is part of RELX and serves customers in 150+ countries.