Description

Requirements:
• Snowflake Developer, Oracle, Python
• Develop, maintain, and optimize data pipelines and workflows using Snowflake and Oracle databases to ensure reliable data availability in production.
• Write and optimize advanced SQL and PL/SQL queries and stored procedures for efficient data processing and transformation.
• Automate data ingestion, validation, and monitoring tasks using Python scripting and orchestration tools like Apache Airflow or Prefect.
• Monitor database health, query performance, and resource utilization using Snowflake Resource Monitors, Oracle Enterprise Manager, and cloud monitoring tools.
• Troubleshoot and resolve production incidents related to data inconsistencies, pipeline failures, or performance degradation.
• Implement security best practices including role-based access control, data masking, and encryption in Snowflake and Oracle environments.
• Collaborate with DevOps teams to integrate database changes into CI/CD pipelines using Git, Jenkins, or Azure DevOps.
• Perform root cause analysis for recurring issues and implement automation to reduce manual intervention.
• Manage cloud resource costs by tuning Snowflake warehouse sizes and Oracle instance configurations.
• Document operational procedures, runbooks, and system architecture for knowledge sharing and compliance

Key Skills

Education

Bachelor's degree