PL/SQL Developer

<h2>Job Description:</h2><ul>
<li>
<strong>Database Development:</strong>Design and write efficient PL/SQL code, including<strong>stored procedures, packages, functions, views, and database triggers</strong>.</li>
<li>
<strong>Performance Tuning:</strong>Analyze complex queries, build strategic indexes, use optimizer hints, and utilize tools like<strong>AWR (Automatic Workload Repository), Explain Plan, and Profiler</strong>to eliminate database bottlenecks.</li>
<li>
<strong>Data Architecture &amp; Modeling:</strong>Manage and design database schemas, tablespaces, entity-relationship diagrams (ERDs), and overall data structures to maintain data integrity.</li>
<li>
<strong>ETL and Data Migration:</strong>Build automated batch jobs using data transformation routines to extract, transform, and load (ETL) data from external flat files or legacy systems into target databases.</li>
<li>
<strong>Collaboration:</strong>Work alongside data analysts, software engineering teams, and business stakeholders in an<strong>Agile environment</strong>to map business requirements into technical SQL logic.</li>
</ul><h2>Requirements</h2><h2>Qualifications:</h2><ul>
<li>
<strong>Core Languages:</strong>Mastery of advanced SQL (joins, subqueries, window functions) and expert-level PL/SQL programming.</li>
<li>
<strong>Database Management Systems:</strong>Strong knowledge of<strong>Oracle Database Architecture</strong>. Familiarity with alternate relational databases (e.g., Microsoft SQL Server, PostgreSQL, MySQL) is often a plus.</li>
<li>
<strong>Development Tools:</strong>Proficiency using Integrated Development Environments (IDEs) like<strong>Oracle SQL Developer, TOAD</strong>, or ERwin for data modeling.</li>
<li>
<strong>Automation &amp; Build Tools:</strong>Experience with Unix/Linux shell scripting, scheduler tools (like Autosys), and ETL frameworks (like Informatica).</li>
<li>
<strong>Methodologies:</strong>Practical understanding of Agile delivery frameworks, automated testing for database code, and CI/CD pipelines.</li>
</ul>