What are the responsibilities and job description for the Oracle PL/SQL Developer position at Ztek Consulting?
Job Role: Oracle PL/SQL Developer
Location: Jersey City, NJ
Job Description:
Responsibilities
- Design, code, and maintain PL/SQL stored procedures, packages, functions, and triggers.
- Collaborate with application developers to create optimized applications.
- Perform code reviews and provide feedback to ensure best practices.
- Monitor and optimize database performance.
- Develop and implement database backup, recovery, and security protocols.
- Troubleshoot and resolve complex technical issues related to database systems.
- Assist in data migration and data integration activities.
- Document technical specifications and design workflows.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 3 years of experience in Oracle PL/SQL development.
- Proficiency in writing complex SQL queries and PL/SQL programs.
- Strong understanding of database architecture and data modeling.
- Experience with performance tuning and database optimization techniques.
- Excellent problem-solving and analytical skills.
- Ability to work independently and in a team environment.
- Effective communication skills to collaborate with technical and non-technical stakeholders.
Skills
- Oracle Database
- PL/SQL
- SQL
- Database Performance Tuning
- Data Modeling
- Unix/Linux Shell Scripting
- Version Control (e.g., Git, Bitbucket)
- Data Migration
- Data Integration
- Database Security
Salary : $100,000 - $120,000