What are the responsibilities and job description for the PL/SQL Developer position at Carita Tech Inc?
Title : PL / SQL Developer
Duration : 12 months
Location : Plano / Austin, TX, Raleigh, NC, Mountain view, CA
Relocation is ok
Requirements :
Oracle database full life cycle development including data modeling, database architecture, SQL and PL / SQL development, unit testing and support.
Required Skills in designing, coding and supporting using Oracle SQL and PL / SQL
Develop software for web-based applications, create fast, easy-to-use, high volume production code, and develop prototypes quickly.
Create and improve existing reusable database objects.
Required Unit Testing
Required Agile
Optimize and tune SQL queries to maximize speed and scale.
Strong experience with Datawarehousing relational and / or dimensional data modeling
Strong experience with performance tuning and optimization (PTO)
Expertise in PL / SQL Programming including Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, SQL built in functions, joins, aggregate functions, Collections.
