Jobs
>
New York City

    senior oracle pl/sql developer - New York, United States - City of New York

    Default job background
    Description

    Company Description

    Job Description


    The Department of Social Services (DSS) is comprised of the administrative units of the New York City Human Resources Administration (HRA) and the Department of Homeless Services (DHS).

    HRA is dedicated to fighting poverty and income inequality by providing New Yorkers in need with essential benefits such as Food Assistance and Emergency Rental Assistance.

    DHS is committed to preventing and addressing homelessness in New York City by employing a variety of innovative strategies to help families and individuals successfully exit shelter and return to self-sufficiency as quickly as possible.

    Information Technology Services (ITS) is DSS's technology services organization. ITS mission is to support the daily, emergent, and long-term needs of both agencies.

    ITS creates and enhances the technology infrastructure and computer applications that support HRA and DHS and develops applications, including a variety of client eligibility and recertification systems, case management systems, housing systems, employment/work engagement services, revenue producing computer matches, claiming systems, and personnel systems.

    The Office of Enterprise Solutions Engineering within ITS consists of five divisions - HRA Technology, DSS Technology, DHS Technology, External Agency Technology, and Quality Assurance - that supports the analysis, design, development, testing, and implementation of hundreds of web and mobile applications, which run on Unix and Windows Servers and are hosted in a virtual environment in on premises data center.

    Additionally, this office maintains agency-wide Imaging repository containing over a billion client-related documents.


    The HRA Eligibility Systems -POS Application Development unit within the Office of Business Solutions is responsible for developing, maintaining and enhancing web and mobile applications required to support the agency's mission of preventing and addressing hunger, poverty and homelessness.

    The unit is also dedicated to the testing of administrative systems that it either develops or purchases, as well triaging and responding to data and analytics request necessary to monitor and report on key performance indicators such as capacity, census, and critical incidents occurring in the SNAP and CA eligibility systems.

    Many of the applications from the HRA Eligibility Systems unit, communicate with both internal and external systems and platforms like the NY State Welfare Management System (WMS), New York City - Work Accountability and You (NYCWAY) and other diverse data sources.

    Under executive direction of the Assistant Deputy Commissioner for HRA Technology, with wide latitude for the exercise of independent judgment, and decision-making, the Senior Oracle PL/SQL Developer for HRA Eligibility Systems - POS Application Development uses expertise/experience in three distinct sets of technologies and frameworks that are all being coupled together including experience in front/ back end Oracle database to design, build, test and support 3-tier systems that are critical for HRA operations.

    Some of the systems include those used to create reports on Key Performance Indicators, inspect SNAP and CA client's applications, recertification's and change requests.


    Information Technology Services (ITS) / Office of Enterprise Solutions Engineering is recruiting for one (1)

    IT Project Specialist, to function as a Senior Oracle PL/SQL Developer, who will:


    • Oversee development, configuration, and security of systems/programs/applications, as well as
    upgrades and enhancements to existing case management, rehousing and business intelligence
    systems, using HRA technology group's standard Oracle PL/SQL and associated Development
    tools using TOAD and/or SQL Developer. Plan, manage and promote system/program/application
    efficiency and security by integrating performance metrics and encryption. Manage system/
    program/application responsiveness and cross-platform optimization for mobile. Utilize best
    practices and employ Agile development processes/procedures and implementation plans to
    drive standards, and support value delivery across the development lifecycle.


    • Ensure integrity, quality, and timeliness of technical deliverables related to development, through
    regular monitoring, testing and management of code, and functionalities.


    • Stay abreast of industry trends in design and developments of Oracle Database Objects
    Development techniques to ensure that those new advancements in the field of system and
    enterprise architecture can be applied to various areas within HRA technology.


    • Collaborate with the appropriate groups and divisions to assess, recommend, and build new
    technology Coordinate efforts on technical design considering capacity, performance, and high
    availability for systems/programs/applications. Provide support for and participate in the
    maintenance of HRA systems, applications, programs.


    • Write clear technical design deliverables to document technical and nontechnical functionalities
    and features of systems/programs/applications.


    • Lead teams responsible for a variety of technical design, development, testing and ontime delivery
    of mission and business critical web applications in a 24/7 environment.


    Hours/Shift:
    Normal Business Hours


    Qualifications


    • A baccalaureate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and four years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or
    • An associate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and six years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or
    • A baccalaureate degree from an accredited college, and eight years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or
    • Education and/or experience which is equivalent to "1", "2", or "3" above.

    Additional Information


    The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.


  • Reyk Tech Inc.

    Pl/SQL Developer

    1 day ago


    Reyk Tech Inc. New York, United States

    **Job Brief**: · **Job Details**: · - Solid understanding of relational databases. · - Requires the ability to write complex queries, PL/SQL blocks including the use of cursors, exception handling and develop reports to support business needs. · - Diagnose and resolve database ac ...

  • Infosys

    PL/SQL Developer

    4 weeks ago


    Infosys New York, United States

    Basic Qualifications: · Bachelor's degree or foreign equivalent from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education. · At least 2 years of industry experience · At least 2 years of experience ...


  • Precision Technologies Corp New York, United States

    Key Responsibilities: · Develop, test, debug, and maintain stored procedures, functions, packages, triggers, and cursors using PL/SQL. · Write efficient and maintainable code that adheres to coding standards and best practices. · Collaborate with database administrators, software ...

  • Saxon Global

    Sr PL/SQL Developer

    2 weeks ago


    Saxon Global New York, United States

    Role: Senior SQL Developer · Client: NY State Office of Information Technology · Visa: All Visa Except H1B · Required to work 100 % on site 40 North Pearl Street Albany NY 12207 · Duration : 48-month contract · Mandatory Skills :Two or more years in a team lead · Seven years ...


  • The Dignify Solutions LLC New York, United States

    Technical/Functional Skills · Oracle PL/SQL development - Packages, Procedure, Functions, Triggers · ORacle supplied packages · Oracle database structures such as tales, views, materialized views and write procedures against that · Oracle tools such as Toads or SQL-Developer. ...

  • Volto Consulting

    SQL Developer

    1 week ago


    Volto Consulting New York, United States

    **Position: SQL Database Developer** · **Location: NYC ( Face to face required)** · **Job Type**: Contract · Pay: $ $50.00 per hour · Expected hours: 40 per week · **Benefits**: · - 401(k) · - Dental insurance · - Health insurance · Experience level: · - 5 years · Schedule: · - 8 ...


  • New England Institute of Technology East Greenwich, United States

    Overview: · **Duties**: · - Program using SQL in multiple environments. SQL server and Oracle PL/SQL. · - Program and administer permission control in Unix/AIX/LINUX platform and UNIX shell programming. · - Develop, test and document Oracle packages, functions, triggers, and proc ...


  • Pyramid Consulting, Inc Jersey City, United States

    Immediate need for a talented Oracle PL/SQL Developer. This is a 12+ Months Contract opportunity with long-term potential and is located in Jersey City, NJ(Onsite). Please review the job description below and contact me ASAP if you are interested. · Job ID: · Pay Range: $65 - $7 ...


  • Nutech Information Systems Jersey City, United States

    One of our financial clients is looking for an Oracle PL/SQL DEVELOPER · Location : Jersey City , NJ , hybrid · Oracle Database PL/SQL Developer to work in the Oracle Application & Database Support department. · Position Responsibilities/Duties · Support reporting of business ap ...


  • Pyramid Consulting Jersey City, United States

    Immediate need for a talented Oracle PL/SQL Developer. This is a 12+ Months Contract opportunity with long-term potential and is located in Jersey City, NJ(Onsite). Please review the job description below and contact me ASAP if you are interested. · Find out more about the daily ...

  • TWO95 International

    PL/SQL Developer

    2 weeks ago


    TWO95 International Englewood, United States

    Title – PL/SQL Developer · Location – Englewood, NJ · Rate - $Open · Duration – 6+ Months Contract · Requirements · Job Description:. · • Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL. · • Involved in creation of Conceptual Modeling covering al ...


  • Volto Consulting New York, United States

    **Position: SQL Database Developer** · **Location: NYC ( Face to face required), (only local resource)** · **Skill Required: Very strong in SQL Database Development** · **Expertise in Linux administration** · **Shell Scripting** · **Python Scripting** · **Job Type**: Contract · P ...


  • BSL consulting LLC New York, United States

    **Job Role: SQL Developer with Python** · **Location: New York, NY(Hybrid, 3 days onsite/Week)** · **Job Type: Full Time(Permanent)** · **Experience level**:6 Years · **Qualifications**: · - BE/B Tech/MCA · - Should have Python core backend development experience. · - Strong MS S ...


  • City of New York New York, United States

    Job Description · The Department of Social Services (DSS) is comprised of the administrative units of the New York City Human Resources Administration (HRA) and the Department of Homeless Services (DHS). HRA is dedicated to fighting poverty and income inequality by providing New ...


  • HarveyNash New York, United States

    Bachelor's degree in Computer Science or equivalent degree or experience · - Strong experience in Microsoft SQL database development experience with at least 4 years of operational experience in an enterprise database environment and 4 years of programming experience · - Experien ...


  • Qbtech New York, United States

    Hi, · Hope you are doing good · **Job Title · - SQL Developer with Python** · **Location: NYC, NY (Day1 onsite / Hybrid)** · **Type: : Long Term Contract** · **Interview: Video followed by F2F** · We are seeking a talented individual for a hybrid role, combining in-person intervi ...


  • Franklin Templeton Investments New York, United States

    Royce Investment Partners, an affiliate of Franklin Templeton, is hiring a VBA/SQL Programmer. In this position, you will work on a small team which maintains and supports in-house software used by portfolio managers, traders, and others at the firm. You will also do support for ...


  • AXA Professionals Manhattan, United States

    **ROLE RESPONSIBILITIES**: · - SQL/SSIS · - 10+ Years of experience as ETL developer with proficiency is the following technicalskillset · - Strong experience with ETL tools SSIS · - Strong SQL, PL/SQL experience · - Well organized with the ability to manage multiple priorities · ...


  • ICONMA Jersey City, United States

    7-10 years' experience in Oracle Exadata, SQL, PL/SQL · Implement ETL solutions for large volume of data by applying various data warehouse modeling techniques like Star Schema, Data partitioning, Data compression, Direct path loads etc. and that maximizes re-usable components an ...


  • Tanisha Systems New York, United States

    · My name is Sumit, and I am Delivery Manager at. Tanisha Systems Inc is a global contingency staffing firm servicing. We have an excellent job opportunity with one of our clients. · Role: Oracle DBA with PL/SQL · Location: Houston, TX(3 day onsite in a week) · JOB SUMMARY: · Th ...