Description

You will design, develop, and optimize complex database structures and cloud-integrated data pipelines.

Responsibilities

• Build and maintain database objects including stored procedures, functions, packages, triggers, views, and materialized views.
• Implement advanced PL/SQL techniques using collections, table partitioning, and dynamic SQL.
• Develop data extraction and loading processes using UTL_FILE, DBMS_SQL, DBMS_JOB, and SQL/JSON functions.
• Manage Snowflake utilities such as SnowSQL, SnowPipe, Tasks, Streams, and Time Travel.
• Execute code tuning and performance optimization using bulk binds, in-line queries, and subquery factoring.
• Integrate AWS services to conduct data analysis and automate business rules.

Required Skills

• 5+ years of experience in database development.
• Expertise in PL/SQL and PostgreSQL.
• Hands-on experience with AWS services: EC2, S3, SES, Lambda, and IAM.
• Proficiency with Snowflake: SnowPipe, Tasks, Streams, and Metadata Manager.
• Experience using AWS Athena, Event Bridge, Step Functions, and Cloud9.
• Ability to develop scripts connecting PostgreSQL through Amazon Lambda.
• Knowledge of database tuning via Analytics and Subquery factoring.
• Bachelor's degree in Technology, Computer Science, or a related field.

Key Skills

Education

Bachelor's degree