What are the responsibilities and job description for the Oracle PL/SQL Developer position at AllianceIT Inc?
Job Title: Oracle PL/SQL Developer
Location: Jersey City NJ, New York City NY
Job Summary: We are seeking a skilled Oracle PL/SQL Developer to design, develop, and optimize database solutions for our enterprise applications. The ideal candidate will have strong expertise in PL/SQL programming, database performance tuning, and data modeling. You will work closely with business analysts, software developers, and database administrators to ensure efficient data processing and high-performance applications.
Key Responsibilities:
- Design, develop, and maintain complex PL/SQL procedures, functions, packages, and triggers.
- Optimize SQL queries and database performance tuning to enhance system efficiency.
- Develop and maintain data models, database objects, and ETL processes.
- Troubleshoot and resolve database-related issues in a timely manner.
- Work with application developers to integrate database functionality into enterprise applications.
- Ensure database security, integrity, and compliance with company policies.
- Create and maintain technical documentation for database solutions.
- Collaborate with cross-functional teams to support business requirements and project goals.
Required Skills & Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or a related field.
- 6 years of experience in Oracle PL/SQL development.
- Strong expertise in writing and optimizing complex SQL queries.
- Experience with database performance tuning, indexing, and query optimization.
- Familiarity with Oracle database architecture and data modeling.
- Experience with ETL tools and processes is a plus.
- Knowledge of version control systems (Git, SVN) and CI/CD pipelines.
- Strong problem-solving skills and attention to detail.
- Excellent communication and teamwork skills.
