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.

How Can We Help You?

Contact us at info@aretove.com to see how we can help you accelerate your data engineering and business intelligence initiatives.

Interested in this Job?