What are the responsibilities and job description for the Oracle PL/SQL position at Smart IT Frame LLC?
An Oracle PL/SQL Developer is responsible for designing, developing, testing, and implementing software applications using Oracle's Procedural Language/Structured Query Language (PL/SQL). This role involves creating well-written code, troubleshooting and resolving technical issues, and optimizing database performance. Key Responsibilities: 1. Design, code, and implement software solutions using Oracle PL/SQL. 2. Conduct performance tuning, improvement, balancing, and usability test automation. 3. Develop and execute database queries and conduct analyses. 4. Design and develop Oracle database schemas, tables, procedures, and permissions. 5. Debug and optimize SQL scripts. 6. Collaborate with developers, business analysts, and other team members to identify and resolve technical issues. 7. Maintain data integrity, security, and privacy in database systems. 8. Prepare documentation for database applications and procedures. 9. Participate in the entire application lifecycle, focusing on coding and debugging. 10. Keep up-to-date with the latest industry trends and technologies to ensure applications are current and competitive
