Develop and maintain PL/SQL procedures, packages, and complex SQL queries within Oracle databases
Diagnose, analyze, and resolve data quality or data integrity issues within LGY systems
Design and execute complex database queries using analytic functions, Common Table Expressions (CTEs), and other advanced SQL constructs
Create and execute comprehensive test plans to validate database logic, data transformations, and system integrations
Analyze database performance and optimize queries for efficiency and scalability
Collaborate with developers, analysts, and stakeholders to troubleshoot issues and support application functionality
Document database processes, queries, and troubleshooting procedures to support maintainability and knowledge sharing

Requirements

Bachelor’s degree and 6 years of relevant experience
Strong experience writing complex SQL and PL/SQL in Oracle databases
Experience diagnosing and analyzing complex data issues in enterprise systems
Experience designing and executing complex test plans for database logic and data validation
Strong understanding of analytic SQL functions and when to apply Common Table Expressions (CTEs) in complex queries
Experience using database development tools such as TOAD or Oracle SQL Developer
Excellent verbal and written communication skills
Strong attention to detail with proven analytical and problem-solving skills

Benefits

Health insurance
401(k) matching
Paid time off
Flexible work arrangements
Professional development opportunities

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PL/SQLSQLOracle databasesdata quality analysisdata integrity resolutiondatabase performance optimizationanalytic SQL functionsCommon Table Expressions (CTEs)test plan designdata validation

Soft Skills

communication skillsattention to detailanalytical skillsproblem-solving skills

Certifications

Bachelor's degree