SAS​/Oracle Developer

Location: 110 Williams Street, Downtown NYC (Hybrid – Onsite at least 3 days per week)
Work Schedule:
Monday – Friday, 9:00 AM – 5:00 PM (35 hours/week, includes 1-hour unpaid lunch)
Pay rate: $50 to $55 per hour

Position Overview

ACS OIT is seeking a seasoned SAS/Oracle Developer responsible for converting existing SAS code into optimized Oracle PL/SQL database structures (tables, views, procedures, packages, and functions). The developer will also design new database objects, optimize queries, and ensure high performance while maintaining functional equivalence of the original SAS code.

Scope of Work

• Redevelop existing SAS-based backend processes into Oracle PL/SQL codebase.
• Integrate multiple data sources, cleanse and transform data, and implement business rules for reporting.
• Ensure converted code meets or exceeds original SAS code functionality and performance.
• Conduct unit testing, QA testing, and support UAT with business users.
• Optimize database queries for efficiency and scalability.
• Collaborate with stakeholders to ensure accurate and effective database solutions.

Qualifications

Experience & Expertise

• 7+ years of Oracle PL/SQL development experience.
• 4+ years of SAS development experience.
• Proven experience converting SAS code to Oracle PL/SQL.
• expertise in performance tuning and database optimization.
• Familiarity with data warehousing, ETL processes, and database management.
• Strong problem-solving and troubleshooting skills.
• Experience collaborating with business users for testing and remediation.

Technical Skills

• Proficiency in SAS programming and Oracle PL/SQL development.
• Expertise in SQL and relational database concepts.
• Knowledge of data modeling, database design, and schema creation.
• Hands-on experience with Oracle tools (e.g., TOAD, SQL Developer) and SAS editors.

Compensation: $55.00 per hour

Priority Cares Home Services is a New York-based agency dedicated to providing compassionate care to communities across Queens, Brooklyn, Bronx, Westchester, and Staten Island. We offer coordination services for various Medicaid waiver programs, including NHTD, TBI, and PCA. Our experienced team ensures that clients receive top-quality care from their designated caregivers, with ongoing support and information available as needed. We prioritize the comfort and well-being of both clients and caregivers, ensuring that aid/caregivers are paid on time and without hassle.

MISSION

We are dedicated to delivering compassionate and reliable home care services that empower individuals to live with dignity and independence. Through CDPAP, NHTD, and TBI services, we ensure our clients receive personalized care that promotes well-being and enhances quality of life.

VISION

To lead the home care industry in providing comprehensive, person-centered services that enable individuals to thrive in their own homes while fostering greater community support and involvement.

VALUES

• Compassion
  :
  We put the well-being of our clients first, ensuring their comfort and care are at the heart of everything we do.
• Independence
  :
  We support individuals in maintaining control over their lives and decisions through personalized care.
• Respect
  :
  Every individual is treated with dignity, ensuring that their needs and preferences are prioritized.
• Integrity
  :
  We uphold the highest ethical standards in care provision, ensuring transparency and accountability.
• Inclusivity
  :
  We are committed to serving diverse populations and making our services accessible to all.

I was referred to this position by a current employee