Job Title: Snowflake Developer
Location: Plano, TX (On-site)
Snowflake Developer, Oracle, Python(Great Plus)
- 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.