PL/SQL Developer

Summary

Join a collaborative team as a Senior Data Analytics Engineer and PL/SQL Developer to develop and optimize database components for critical business systems and reporting tools. You will design, develop, and maintain complex PL/SQL stored procedures, functions, and packages, creating and managing Oracle database objects. Responsibilities include writing and optimizing high-performance SQL queries, conducting performance tuning and troubleshooting, and collaborating with other developers and stakeholders. The ideal candidate will have a Bachelor’s degree in a related field or equivalent experience, along with experience working with Oracle databases and PL/SQL programming. This fully remote role offers a competitive salary and a comprehensive benefits package.

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field, or equivalent work experience
• 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

Responsibilities

• 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 development of standardized conversion routines for increased efficiency
• Ensure compliance with database best practices, standards, and security protocols

Preferred Qualifications

• Proven experience as a PL/SQL Developer in a production environment
• Experience with Crystal Reports or similar reporting tools
• Understanding of user-defined data types, nested tables, and complex Oracle structures
• Experience participating in business process improvement and data migration projects
• Exposure to Agile development environments and version control systems

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