The company is seeking an Oracle PL/SQL Developer to join their team in Albany, NY, to focus on backend database programming, optimization, and complex data manipulation.
Requirements
- 5+ years of hands-on experience with Oracle PL/SQL development
- Strong understanding of relational database concepts and Oracle architecture.
- Proven experience in writing stored procedures, packages, triggers, and views.
- Proficient in performance tuning, query optimization, and debugging.
- Familiarity with data modeling and schema design.
- Experience with Oracle versions 12c or above.
- Experience with tools such as TOAD, SQL Developer, or similar.
Responsibilities
- Develop, optimize, and maintain complex PL/SQL procedures, functions, packages, and triggers.
- Write efficient SQL queries for data extraction, transformation, and reporting.
- Conduct performance tuning and troubleshooting of 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.
Other
- Hybrid – 2–3 days onsite per week
- Collaborate with business analysts, data architects, and application developers to gather requirements and implement database solutions.
- Work in an Agile or waterfall SDLC environment, depending on project requirements.
- Excellent analytical and problem-solving skills.
- Good communication and interpersonal skills.
