SQL Data Analyst

Job Overview

This position involves comprehending business needs to design, develop, and sustain Oracle database applications proficiently. The role requires strong expertise in PL/SQL development, including creating and enhancing procedures, functions, and packages.

Key Responsibilities

• Develop and maintain Oracle database applications based on business requirements.
• Utilize PL/SQL to write and optimize database procedures, functions, and packages.
• Conduct SQL performance tuning and optimization to improve system efficiency.
• Apply Agile methodologies throughout the development lifecycle.
• Design and model databases effectively to meet application needs.
• Utilize Oracle tools such as SQL Developer and Toad for development and maintenance tasks.
• Implement security measures adhering to Oracle data protection standards.
• Analyze and troubleshoot production issues, identify root causes, and apply appropriate fixes.
• Manage code migrations and schedule jobs using relevant tools.

Skills and Qualifications

• Strong knowledge in PL/SQL development and Oracle database applications.
• Experience with SQL tuning and performance optimization techniques.
• Familiarity with Agile development practices.
• Proficient with Oracle database design and data modeling concepts.
• Hands-on experience with Oracle tools like SQL Developer and Toad.
• Understanding of Oracle data security mechanisms.
• Ability to troubleshoot production issues and manage code deployment processes effectively.