Design, develop, and maintain complex PL/SQL stored procedures, functions, and packages.
Create and manage Oracle database objects, including tables, materialized views, triggers, synonyms, user-defined types, nested tables, and collections.
Write and optimize high-performance SQL queries for large-scale data retrieval and manipulation.
Conduct performance tuning and troubleshooting for PL/SQL code.
Collaborate closely with developers, business analysts, and project managers to implement and improve functionality.
Translate technical specifications into clear, accurate data reports using tools such as Crystal Reports.
Contribute to business process evaluations, system design efforts, and the development of standardized conversion routines for increased efficiency.
Ensure compliance with database best practices, standards, and security protocols.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent work experience.
Minimum of 3 years of experience working with Oracle databases and PL/SQL programming.
Familiarity with database development tools such as Oracle SQL Developer and/or TOAD.
Ability to develop and maintain efficient and secure database objects and queries.
Strong analytical, troubleshooting, and communication skills.

Benefits

Generous and flexible time-off policy
Flexible work schedules and telework options, including remote work availability for eligible projects
Career development opportunities including a mentorship program, technical and management training through Dev University, hands-on learning through DevLab, tuition reimbursement, and paid training opportunities
Industry-leading benefits including a choice of two health plans that include dental and vision, flexible spending account, commuter benefits, life insurance, and more
401K matching with a 5% matching contribution
Regular team and company social events including our annual party, happy hours, fitness challenges, and more
A focus on community engagement including company wide support activities, employer match for donations, and time off for volunteer efforts

Applicant Tracking System Keywords

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

PL/SQLSQLOracle databasestored proceduresfunctionspackagesperformance tuningdata retrievaldata manipulationdatabase objects

analytical skillstroubleshooting skillscommunication skills