Database Developer

Responsibilities:Use database objects: Stored procedures, Stored functions, Packages , TYPE Objects, Indexes, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections, Table Partitioning, Dynamic SQL for my daily activities, Work on Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, Time travel, Optimizer, Metadata Manager, data sharing, Develop codes using UTL_FILE, DBMS_SQL, DBMS_JOB,RETURN TABLE packages and SQL/JSON functions to extract and load data from/to operational database. Work on Amazon services like EC2, S3, SES, Lambda, IAM, Step functions, Athena, Event Bridge,Cloud9 used to conduct data analysis and report on results, Develop scripts on connecting to PostgreSQL through Amazon lambda and fetching configurations to implement business rules on files in S3. Conduct code tuning to improve performance of the application, use Bulk binds, in-line queries, Dynamic SQL, Analytics and Subquery factoring. Bachelor Degree In Technology or Computer Science or Related Field with Relevant Industry Experiences