6 months ago
Alpharetta, GA, USAStaff+
Base Salary
$115k - $192k/yr
Responsibilities
- Design and build database schemas, tables, indexes, and constraints 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 while managing transactions and concurrency.
- 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 or JPA.
- Build and support ETL pipelines for data extraction, transformation, migration, and batch processing.
- Perform data analysis, validation, and reporting to support data accuracy and business needs.
- Write and maintain Bash or shell scripts to automate database operations, backups, cron scheduling, data processing, and monitoring in Linux or Unix environments.
- Provide technical leadership and advise cross-functional stakeholders on data engineering and system design best practices.
Requirements
- 8+ years of software engineering experience with a strong database focus.
- Expertise in relational databases, with MySQL preferred, and data modeling.
- Advanced SQL development and performance-tuning skills.
- Strong experience with Java, JDBC, and ORM frameworks including Hibernate or JPA.
- Proven ability to diagnose and resolve complex production issues.
- 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 matching 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.
- Geographic differentials may apply, and accommodation support is available during the hiring process.
About RELX
RELX provides information-based analytics, research content, and decision tools for scientists, legal and risk professionals, insurers, and governments. Through segments including Elsevier (STM), LexisNexis (legal and risk), and RX (exhibitions), it sells subscriptions, data services, and software platforms used in 180+ countries. Headquartered in London, it is a public company listed in London and Amsterdam.