Kanak Elite Services
Overview
Oracle PL/SQL Developer role at Kanak Elite Services in Albany, NY on a hybrid schedule 2-3 days onsite per week. Responsibilities
Develop, optimize, and maintain complex PL/SQL procedures, functions, packages, and triggers. Write efficient SQL queries for data extraction, transformation, and reporting. Collaborate with business analysts, data architects, and application developers to gather requirements and implement database solutions. Conduct performance tuning and troubleshoot database code and queries. Assist with data migration, transformation, and integration tasks. Ensure code quality through unit testing and adherence to coding standards. Participate in code reviews and documentation of solutions. Support existing applications by diagnosing and fixing bugs or performance issues. Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field. 5+ years of hands‑on experience with Oracle PL/SQL development. Strong understanding of relational database concepts and Oracle architecture. Proven experience writing stored procedures, packages, triggers, and views. Proficient in performance tuning, query optimization, and debugging. Familiarity with data modeling and schema design. Experience working in hybrid/on‑site environments. Excellent analytical and problem‑solving skills. Good communication and interpersonal skills. Preferred Qualifications
Experience with Oracle versions 12c or above. Experience with tools such as TOAD, SQL Developer, or similar. Exposure to ETL processes or data warehousing environments. Understanding of version control tools (e.g., Git). Experience in government or large enterprise environments. Location
Albany, NY (Locals only) Type
Hybrid (2-3 days onsite per week) Seniority Level
Mid–Senior Employment Type
Full‑time Job Function
Engineering and Information Technology Industries
Software Development
#J-18808-Ljbffr
Oracle PL/SQL Developer role at Kanak Elite Services in Albany, NY on a hybrid schedule 2-3 days onsite per week. Responsibilities
Develop, optimize, and maintain complex PL/SQL procedures, functions, packages, and triggers. Write efficient SQL queries for data extraction, transformation, and reporting. Collaborate with business analysts, data architects, and application developers to gather requirements and implement database solutions. Conduct performance tuning and troubleshoot database code and queries. Assist with data migration, transformation, and integration tasks. Ensure code quality through unit testing and adherence to coding standards. Participate in code reviews and documentation of solutions. Support existing applications by diagnosing and fixing bugs or performance issues. Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field. 5+ years of hands‑on experience with Oracle PL/SQL development. Strong understanding of relational database concepts and Oracle architecture. Proven experience writing stored procedures, packages, triggers, and views. Proficient in performance tuning, query optimization, and debugging. Familiarity with data modeling and schema design. Experience working in hybrid/on‑site environments. Excellent analytical and problem‑solving skills. Good communication and interpersonal skills. Preferred Qualifications
Experience with Oracle versions 12c or above. Experience with tools such as TOAD, SQL Developer, or similar. Exposure to ETL processes or data warehousing environments. Understanding of version control tools (e.g., Git). Experience in government or large enterprise environments. Location
Albany, NY (Locals only) Type
Hybrid (2-3 days onsite per week) Seniority Level
Mid–Senior Employment Type
Full‑time Job Function
Engineering and Information Technology Industries
Software Development
#J-18808-Ljbffr