PL/SQL Developer
We are looking for talented PL/SQL developers to join our Enterprise Application Integration Practice. If you are passionate about developing and maintaining PL/SQL based triggers, stored procedures and packages then send in your resume to careers@aretove.com
Department: Engineering
Project Location(s): New York City & Remote
Compensation: $80,000 - $100,000
Responsibilities
- Design, build, test and maintain PL/SQL based data pipelines that collect, transform, load and curate data.
- Develop and maintain PL/SQL functions, triggers, stored procedures, packages etc. Review existing PL/SQL based stored procedures for business rules and perform updates for enhancements.
- Optimize and tune SQL queries and PL/SQL stored procedures.
- Design and modify automation scripts.
- Support production environment and address issues.
- Perform root cause analysis (RCA) for P1/P2/P3 severity incidents and keep relevant stakeholders informed.
Skills/Experience
- Bachelor’s degree in Computer Science, Information Technology or relevant work experience with 2+ yrs of experience.
1-2 years experience with Oracle 8 and 10g. - 1-2 years experience as a database developer with PL/SQL including but not limited to triggers, functions, stored procedures, packages, cursors, dynamic queries, exception handling, collections, performance tuning.
- 1+ years of hands-on experience in writing complex, optimized SQL queries across large data sets.
- Demonstrated strength in ETL development, and data warehousing.
- Experience with iPaaS solutions like Boomi, Celigo and MuleSoft, is a plus.
Benefits we offer:
Comprehensive health benefits, including health, vision, and dental care to suit your needs.
401K
2 weeks PTO.
Flexible work timings.
Team outings and company sponsored events.
An intelligent, experienced, and diverse leadership team that is open to new ideas.
Collaborative, fast-paced, data driven culture.
A fun, creative and mission-driven work environment with opportunities for development, both personally and professionally.